一、使用命令行查看MySQL的版本
mysql -uroot -p123456
我这里是MySQL5.7.19;
二、在servlet中指定对应的版本,不同版本jdbc连接配置不同
1.MySQL5:
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取连接
String url = "jdbc:mysql://localhost:3306/wenjian";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url, user, password);
2.MySQL8:
//注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//获取连接
String url = "jdbc:mysql://localhost:3306/wenjian";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url, user, password);
三、连接数据库的jar包不同
1.MySQL5连接的jar包:mysql-connector-java-5.1.25.jar
2.MySQL8连接的jar包:mysql-connector-java-8.0.21.jar
jar包下载地址:https://repo1.maven.org/maven2/mysql/mysql-connector-java/