问题
使用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.
问题,出问题的地方应该是我们连接的URL或DRIVER写的有问题,对应如下:
解决方法
若我们使用的mysql版本是5.0x,对应的连接语句应该写成这样:
private static final String URL = "jdbc:mysql://localhost:3306/park?useUnicode=true&characterEncoding=utf-8&useSSL=true";
private static final String DRIVER = "com.mysql.jdbc.Driver";
//写你自己的账号密码
private static final String USER_NAME = "root";
private static final String PWD = "";
若我们使用的mysql版本是8.0x,对应的连接语句应该写成这样:
private static final String URL = "jdbc:mysql://localhost:3306/park?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8";
private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
//写你自己的账号密码
private static final String USER_NAME = "root";
private static final String PWD = "";
PS:URL中的park是mysql中的数据库对应的名称。