jdbc连接失败

java连接mysql数据库失败

Loading class `com.mysql.jdbc.Driver’.

这个意思是‘com.mysql.jdbc.Driver’已经过时
jdk9以上应修改以下代码
解决方案：
①：应该改为‘com.mysql.cj.jdbc.Driver’；

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

②：将原来的jdbc连接数据库名后面添加‘?serverTimezone"+
"=UTC&characterEncoding=utf-8&useSSL=false’语句

具体代码如下:

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/user?serverTimezone"+"=UTC&characterEncoding=utf-8&useSSL=false","root","admin");

连接数据库具体代码:

package demo;

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

public class jdbc {
	public static void main(String[] args) {
		try {
			//加载驱动
			Class.forName("com.mysql.cj.jdbc.Driver");
			//连接数据库
			Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/user?serverTimezone"+
                    "=UTC&characterEncoding=utf-8&useSSL=false","root","admin");
			//执行SQl语句
			Statement sta = conn.createStatement();
			int a = sta.executeUpdate("insert into s(gdcode,gdprice) values (13,98)");
			
			if(a>0) {
				System.out.println("创建成功");
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}