IDEA连接数据库报错

最新推荐文章于 2024-03-22 23:00:59 发布

科大小海苔

最新推荐文章于 2024-03-22 23:00:59 发布

阅读量376

点赞数

分类专栏： Java 文章标签： java idea mysql

本文链接：https://blog.csdn.net/zhangqing912219/article/details/125166254

版权

Java 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

错误1

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

Class.forName("com.mysql.cj.jdbc.Driver"); //固定写法，加载驱动

错误2

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.

解决方法：
在MySQL的URL后面加上“?serverTimezone=UTC”

		//2.用户信息和url
        //useUnicode=true&characterEncoding=utf8&useSSL=true
        String url="jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&useSSL=true&serverTimezone=UTC";
        String username="root";
        String password="123456";