//此类可返回一个数据库连接
package cn.lyl.test;
import java.sql.Connection;
import java.sql.DriverManager;
public class GetMySQLConnection {
private static Connection dbConn = null;
private static final String DBDRIVER = "com.mysql.jdbc.Driver";//mysql数据库驱动类
private static final String DBUSER = "root";//数据库用户名
private static final String DBPASS = "1234";//数据库密码
private static final String DBURL = "jdbc:mysql://localhost:3306/chengjiguanli?characterEncoding=UTF-8";
public Connection getLink(){
try{
Class.forName(DBDRIVER);
dbConn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
System.out.println("数据库连接成功");
return dbConn;
}catch(Exception e){
System.out.println("数据库连接失败");
e.printStackTrace();
}
return dbConn;
}
}
//测试程序
package cn.lyl.test;
import java.sql.Connection;
public class testLinkToMySql {
public static void main(String[] args) {
Connection con = new GetMySQLConnection().getLink();
}
}
