//JDK1.7环境下运行
import java.sql.*;
public class getConnection {
private static Connection con;
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("数据库加载包驱动异常!");
e.printStackTrace();
}
}
public static Connection GetConnection(){//创建连接
try {//根据自己数据库、用户名、密码进行修改
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/usermanager",
"root", "123456");
return con;
} catch (SQLException e) {
System.out.print("连接数据库发生异常");
e.printStackTrace();
}
return null;
}
//此方法用于关闭数据连接池
public static void closeConnect(Connection con){//关闭数据库try {
if(con!=null){
con.close();
}
} catch (SQLException e) {
System.out.println("数据库关闭异常!");
e.printStackTrace();
}
}
}