在第一次运行我的jdbc程序时,遇到如下问题
Loading class `com.mysql.jdbc.Driver'. This is deprecated.
The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically
registered via the SPI and manual loading of the driver class is generally unnecessary.
分析错误原因:不推荐使用加载类“com.mysql.jdbc.Driver”,使用新的驱动程序“com.mysql.cj.jdbc.Driver”,这个驱动是通过SPJ自动驱动的。不需要手动载入。
解决办法:直接把载入驱动的程序代码注释掉(这句问题并不影响程序的运行)
原先代码
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接对象
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?serverTimezone=UTC", "root", "password");
//定义Sql语句
String sql = "update account set username='刘备' where id = 1";
//获取执行sql的对象 statement
Statement stmt = conn.createStatement();
//执行sql
int i = stmt.executeUpdate(sql);
//处理结果
System.out.println(i);
//释放资源
conn.close();
stmt.close();
修改代码
//获取数据库连接对象
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?serverTimezone=UTC", "root", "password");
//定义Sql语句
String sql = "update account set username='刘备' where id = 1";
//获取执行sql的对象 statement
Statement stmt = conn.createStatement();
//执行sql
int i = stmt.executeUpdate(sql);
//处理结果
System.out.println(i);
//释放资源
conn.close();
stmt.close();
持续更新中…