idea软件连接mysql8.0_JavaIDEA下用连接MySQL8.0

2.idea上的基本配置

注意 &＃xff1a; 手动测试连接的时候需要注意 4 一定要配置&＃xff0c;负责会连接失败

3.出现jdbc驱动找不到的情况的情况 (Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver)

检查是否依赖了mysql-connector-java这个jar (特别注意改jar包的版本号)

在gradle文件下添加依赖

4.代码

public static void main(String[] args)throws SQLException, ClassNotFoundException {

Connection conn &＃61;null;

Statement stmt &＃61;null;

ResultSet rs &＃61;null;

try {

// 加载驱动类

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

long start &＃61;System.currentTimeMillis();

// 建立连接

//            conn &＃61; DriverManager.getConnection("jdbc:mysql://localhost:3306/zxdfirst",

conn &＃61; DriverManager.getConnection("jdbc:mysql://localhost:3306/zxdfirst?serverTimezone&＃61;GMT",

"root", "root");

long end &＃61; System.currentTimeMillis();

System.out.println(conn);

System.out.println("建立连接耗时&＃xff1a; " &＃43; (end - start) &＃43;"ms 毫秒");

// 创建Statement对象

stmt &＃61; conn.createStatement();

// 执行SQL语句

rs &＃61; stmt.executeQuery("select * from account");

System.out.println("id\tusername\tpwd\t\tregTime");

while (rs.next()) {

System.out.println("名字" &＃43; rs.getString("name"));

System.out.println(rs.getInt(1));

//                System.out.println(rs.getInt(1) &＃43; "\t" &＃43; rs.getString(2)

//                        &＃43; "\t\t" &＃43; rs.getString(3) &＃43; "\t\t" &＃43; rs.getString(4));

}

}catch (SQLException e) {

e.printStackTrace();

}finally {

try {

if (rs !&＃61;null) {

rs.close();

}

}catch (SQLException e) {

e.printStackTrace();

}

try {

if (stmt !&＃61;null) {

stmt.close();

}

}catch (SQLException e) {

e.printStackTrace();

}

try {

if (conn !&＃61;null) {

conn.close();

}

}catch (SQLException e) {

e.printStackTrace();

}

}

}

5.运行成功