jdbc连接数据库mysql8.0.18 与 mysql5.1.47区别

一、mysql8.0.18 

1、环境：

1、jdk1.8

2、mysql-8.0.18-winx64

3、mysql-connector-java-8.0.18.jar

资源下载：mysql-connector-java-8.0.18.jar 

2、代码实现 

package cn.itcast.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class test {

    public static final String URL = "jdbc:mysql://localhost:3306/homework";
    public static final String USER = "root";
    public static final String PASSWORD = "admin";

    public static void main(String[] args) throws Exception {
        //1.加载驱动程序
        Class.forName("com.mysql.cj.jdbc.Driver");
        //2. 获得数据库连接
        Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
        //3.操作数据库，实现增删改查
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT depart_id, depart_name FROM department");
        //如果有数据，rs.next()返回true
        while(rs.next()){
            System.out.println(rs.getInt("depart_id")+" 姓名："+rs.getString("depart_name"));
        }
    }
}

3、结果： 

二、mysql5.1.47

1、环境

 1、jdk1.8

2、mysql-5.7.34-winx64

3、mysql-connector-java-5.1.37.jar

资源下载：1、mysql-5.7.34-winx64

                  2、mysql-connector-java-5.1.37.jar

 2、代码实现

package cn.itcast.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class test {

    public static final String URL = "jdbc:mysql://localhost:3306/homework";
    public static final String USER = "root";
    public static final String PASSWORD = "admin";

    public static void main(String[] args) throws Exception {
        //1.加载驱动程序
        Class.forName("com.mysql.jdbc.Driver");
        //2. 获得数据库连接
        Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
        //3.操作数据库，实现增删改查
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT depart_id, depart_name FROM department");
        //如果有数据，rs.next()返回true
        while(rs.next()){
            System.out.println(rs.getInt("depart_id")+" 姓名："+rs.getString("depart_name"));
        }
    }
}

三、区别

1、libs（右键add as library）下的jar包

2、驱动程序

Class.forName("com.mysql.cj.jdbc.Driver");    //mysql8

Class.forName("com.mysql.jdbc.Driver");   //mysql5

 3、数据库时区异常

参考：https://www.cnblogs.com/godwithus/p/9788790.html