public final class DbUtil {
private static String driver;
private static String url;
private static String username;
private static String password;
static {
driver="com.mysql.cj.jdbc.Driver";
url="jdbc:mysql://localhost:3306/db_book?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC";
username="root";
password="123456";
}
/**
* 打开数据库
*/
public static Connection open(){
try {
Class.forName(driver);
return (Connection) DriverManager.getConnection(url,username, password);
} catch (Exception e) {
System.out.println("数据库连接失败!");
e.printStackTrace();
}
return null;
}
/**
* 关闭数据库
*/
public static void close(Connection conn){
if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
DbUtil —— jdbc连接
最新推荐文章于 2021-07-30 23:25:28 发布