JDBC连接时出现的两个错误

这两个错误都是因为版本的更新导致的;

错误代码:

package FirstTest;import java.sql.*;public class FirstJDBC {    public static void main(String[] args) throws SQLException {        try {            //加载驱动类            Class.forName("com.mysql.jdbc.Driver");       //建立连接            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test.jdbc","root","123456");            System.out.println(con);        } catch (ClassNotFoundException e) {            e.printStackTrace();        }    }}

错误一:

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'

错误二:

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.

该错误为由系统时间错误引起,只需要在访问数据库时在Url后面加上以下的语句即可:

OLD_URL = "jdbc:mysql://localhost:3306/test.jdbc";NEW_URL = "jdbc:mysql://localhost:3306/test.jdbc?serverTimezone=GMT%2B8";
(0)

相关推荐