问题:
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.
2、第二个报错:java.sql.SQLException: Cannot create PoolableConnectionFactory (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.)
原因:
1、第一个报错:“com.mysql.jdbc.driver”。这个类已被弃用。新的驱动程序类是’com.mysql.cj.jdbc.driver’。
2、第二个报错:服务器时区无法识别或表示多个时区。
处理:(只需要解决第二个报错即可)打开配置文件
<?xml version="1.0" encoding="UTF-8"?>
<Context >
<Resource name="jdbc/test"
author="Container"
type="javax.sql.DataSource"
maxActive="10"
maxIdle="10"
maxWait="10000"
username="root"
password="123456"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf-8"/>
</Context>
在现有url中添加语句:&allowMultiQueries=true&serverTimezone=UTC