一、MySQL5.XX得驱动

mysql-connector-java-5.XX.jar以上的驱动报名就更改了

例如:mysql-connector-java-6.0.5.jar

二、MySQL8.XX得驱动

com.mysql.cj.jdbc.Driver
#mysql8一下
com.mysql.jdbc.Driver
maven配置
<properties>
	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
	<!--<mysql-version>5.1.44</mysql-version>-->
	<mysql-version>8.0.12</mysql-version>
</properties>		

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>${mysql-version}</version>
</dependency>

三、jdbc连接配置

jdbcUrl=jdbc:mysql://127.0.0.1:3306/dbName?characterEncoding=utf8&useSSL=false&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai

 

最后修改于 2019-12-21 13:40:45
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付
上一篇