Mysql 8.0.34
mysql-connector-java-8.0.13.jar
package com.yun.db;
import com.yun.entity.WebUser;
import java.sql.*;
import java.util.ArrayList;
public class Database {
Connection conn = null;
public Database() throws ClassNotFoundException, SQLException {
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
this.conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/webtest001?serverTimezone=Asia/Shanghai","root","root");
}
public void showConn(){
if (conn == null) {
System.out.println("数据库连接失败");
}else {
System.out.println("数据库连接成功,地址:"+conn);
}
}
public void closeConn() throws SQLException {
conn.close();
}
在 Class.forName(Driver)出错了,报错信息java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
解决方式:
先看了下大神作品:https://blog.csdn.net/weixin_41500467/article/details/106176723
没解决成
我的解决方式:
pom.xml里加入合适的依赖:
<!--mysql 驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.31</version>
</dependency>