jdbc mysql 连接admin管理员组文章数量:1642475
jdk 1.8.0_101 jre 1.8.0_101 mysql 5.7.13 mysql-connector-java-6.0.6-bin.jar
环境变量classpath 中加入mysql-connector-java-6.0.6-bin.jar
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ANSHANSHIFAN"
//使用com.mysql.cj.jdbc.Driver
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 SP
I and manual loading of the driver class is generally unnecessary.
//除非显示说明useSSL=false
Fri Mar 17 15:27:15 CST 2017 WARN: Establishing SSL connection without server's
identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ an
d 5.7.6+ requirements SSL connection must be established by default if explicit
option isn't set. For compliance with existing applications not using SSL the ve
rifyServerCertificate property is set to 'false'. You need either to explicitly
disable SSL by setting useSSL=false, or set useSSL=true and provide truststore f
or server certificate verification.
//通过url后面加上?serverTimezone=UTC解决
java.sql.SQLException: The server time zone value '?й???????' is unrecognized o
r represents more than one time zone. You must configure either the server or JD
BC driver (via the serverTimezone configuration property) to use a more specifc
time zone value if you want to utilize time zone support.
driver="com.mysql.cj.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ANSHANSHIFAN?serverTimezone=UTC&&useSSL=false"
所有话都消失了。。。
版权声明:本文标题:JDBC连接Mysql数据库中遇到的问题 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/xitong/1729340331a1197460.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论