JDBC连接MYSQL数据库失败，Loading class `com.mysql.jdbc.Driver'. This is deprecated.

JDK9以后连接MYSQL数据库会报错，是因为sql语句改变了。

报错信息如下;

Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’.

解决办法;

（1）把com.mysql.jdbc.Driver 替换成com.mysql.cj.jdbc.Driver

（2）另外，给JDBC的URL指定时区。

（3）指定SSL是true或者false。

jdbc.DriverClassName=com.mysql.cj.jdbc.Driver
jdbc.url =jdbc:mysql://localhost:3306/student?serverTimezone=UTC&useSSL=false
jdbc.username=root
jdbc.password=root
According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set.For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification

报错信息说了，从MySQL 5.5.45+, 5.6.26+ and 5.7.6+ 这些个版本以后就必须指定SSL 的值true或者false。

下面附上入门案例：JDBC 连接MYSQL数据库；

package com;
 
 
import java.sql.*;
 
/**
 * @auther SyntacticSugar
 * @data 2018/9/7 0007下午 9:32
 * <p>
 * 3、JDBC编程步骤
 * 步骤一 装载驱动 DriverManager.registerDriver(new Driver());//建议使用反射注册驱动
 * 步骤二 建立连接 Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day04", "root", "abc");
 * 步骤三 操作数据SQL 对于结果集处理
 * Statement statement = conn.createStatement();
 * ResultSet rs = statement.executeQuery(sql);
 * while (rs.next()) {
 * System.out.println(rs.getString("username"));
 * System.out.println(rs.getString("email"));
 * }
 * <p>
 * 步骤四 释放资源
 * rs.close();
 * statement.close();
 * conn.close();
 */
public class JdbcDemo {
    public static void main(String[] args) {
        //注册 连接 执行 关闭
        try {
//            DriverManager.registerDriver(new Driver());
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection connection = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/reba?serverTimezone" +
                            "=UTC&characterEncoding=utf-8&useSSL=false", "root", "root");
            Statement statement = connection.createStatement();
            String sql="select  * from user ";
            ResultSet set = statement.executeQuery(sql);//执行
 
            while (set.next()){
                System.out.println(set.getString("id") + set.getString("name"));
            }
            //关闭资源
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
 
    }
}

运行结果如下；