JDBC报错信息

在学习视频的过程中视频比较老版本不一样会出现问题
这里记录一下
源代码

package cn.zkr.jdbc;

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

public class JdbcDmo1 {
    public static void main(String[] args) throws Exception {
        //1.导入jar包
        //2.注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //3.获取数据库连接对象
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/biao", "root", "123456");
        //4.定义sql
        String sql="update xin set id = 2";
        Statement stmt = conn.createStatement();
        int count = stmt.executeUpdate(sql);
        System.out.println(count);
        stmt.close();
        conn.close();
    }
}

这里的报错信息有两条
第一条

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.cj.jdbc.Driver

第二条错误信息

Exception in thread "main" 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.

意思是’serverTimezone’出错,我们需要设置一些东西来修改
将源代码中的

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/biao", "root", "123456");

改为

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/biao?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true", "root", "123456");

或者简短一些

DriverManager.getConnection("jdbc:mysql://localhost:3306/biao?serverTimezone=CTT", "root", "123456");