JDBC连接数据库出现 Loading class `com.mysql.jdbc.Driver‘.This is deprecated 相关问题的解决方法

旧城等待， 2023-09-28 23:49 6阅读 0赞

### 问题 ###

**使用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中的数据库对应的名称。**