Java JDBC 连接 MySQL8.0

---

使用的软件及版本：

MySQL 8.0
SQLyog
IDEA 2019
JDK 1.8

---

一、创建测试数据

创建数据库school:

create database school; 

创建表student:

CREATE TABLE student(
	stu_id		INT   		NOT NULL AUTO_INCREMENT,
	stu_name 	VARCHAR(20)	NOT NULL,
	stu_age		INT		NOT NULL,
	PRIMARY KEY(stu_id)
)ENGINE=INNODB DEFAULT CHARSET=utf8mb4;

插入数据：

INSERT INTO student 
VALUES('1001', '张三', 20),
('1002', '李四', 22),
('1009', '王五', 23);

此时查询数据：

select *
from student;

二、Java连接数据库

下载Java连接MySQL8.0所需要的驱动包：mysql-connector-java-8.0.16.jar

1.IDEA导入jar包：

创建项目后，右击项目，打开Open Module Settings:

如图所示，添加Library:

选择下载好的jar包：

Apply:

导入成功：

2. 编写代码进行连接

import java.sql.*;

public class MySQLConnect {

    static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/school?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";

    // 数据库的用户名与密码，需要根据自己的设置
    static final String USER = "root";
    static final String PASS = "123456";

    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;

        try {
            // 注册 JDBC 驱动
            Class.forName(JDBC_DRIVER);

            //打开链接
            System.out.println("正在连接数据库...");
            conn = DriverManager.getConnection(DB_URL, USER, PASS);

            // 查询
            System.out.println("实例化Statement对象...");
            stmt = conn.createStatement();
            String sql;
            sql = "SELECT * FROM student";
            ResultSet rs = stmt.executeQuery(sql);

            // 展开结果数据集
            while (rs.next()){
                int stu_id = rs.getInt("stu_id");
                String stu_name = rs.getString("stu_name");
                int stu_age = rs.getInt("stu_age");

                System.out.println("ID: " + stu_id + ", name: " + stu_name + ", age:" + stu_age);
            }

            rs.close();
            stmt.close();
            conn.close();
        } catch(Exception se){
            se.printStackTrace();
        }
        finally {
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }

        System.out.println("Over.....");

    }

}

运行结果：

---

参考

java JDBC连接mysql及IDEA配置

Java MySQL 连接