eclipse+mysql-connector-java-8.0.11.jar连接数据库踩坑之路

①：驱动位置改变

报错：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.

②：时间问题报错，以及中文乱码

报错：You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more

解决：

1：加载位置改变：Class.forName("com.mysql.cj.jdbc.Driver").newInstance();

2：时间以及中文：String url="jdbc:mysql://192.168.0.2/pbrplatform?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC";

   private Connection con;
    //获得数据库连接。
    public Connection getConnection()
    {

         String url="jdbc:mysql://192.168.0.2/pbrplatform?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC";
        try
        {
            Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
            con = DriverManager.getConnection(url,"用户名","密码");
            if(con!=null)
            {
            	System.out.println("Success loading Mysql Driver!");
            }
         }
            
        catch(Exception e)
        {
        	System.out.print("Error loading Mysql Driver!");
        	e.printStackTrace();
        }
        return con;
    }