import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DbUtil {
private String url=“jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC”;
private String user=“root”;
private String password="";
private String jdbcName=“com.mysql.cj.jdbc.Driver”;
//连接数据库
public Connection getCon() {
try {
Class.forName(jdbcName);
} catch (ClassNotFoundException e) {
// TODO 自动生成的 catch 块
e.printStackTrace(); }
Connection con = null;
try {
con=DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
return con;
}
//关闭数据库连接
public void closeCon(Connection con) throws Exception{
if(con!=null)
{
con.close();
}
}
public static void main(String[] args) {
DbUtil dnUtil = new DbUtil();
try {
dnUtil.getCon();
System.out.println("数据库连接成功");
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
}