eclipse 连接 mysql

连接时

报错：
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
原因：
提示信息表明数据库驱动com.mysql.jdbc.Driver'已经被弃用了、应当使用新的驱动com.mysql.cj.jdbc.Driver

报错：java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
原因：因为mysql默认的时区和本地时区不一致导致的

 

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


public class Test2 {
		public static void main(String[] args) throws Exception  {//加throws Exception的作用是抛出异常
			//mis：是要连接数据库的地址，就是我们在MySQL里创建的数据库
			//serverTimezone=GMT%2B8：是设置当前的系统时区
			
			String url = "jdbc:mysql:// localhost:3306/mis?serverTimezone=GMT%2B8";
	 
			//加载JDBC-MySQL数据库驱动
			try {
				Class.forName( "com.mysql.cj.jdbc.Driver");
			}catch(Exception e){}
			

			Connection con;
			
			try {
				//建立连接
				con = DriverManager.getConnection(url,"root","000000");
				System.out.println("数据库连接成功");
			}catch(SQLException e) {
				System.out.println("数据库连接失败");
				System.out.println(e);
			}
		}

}