mybatis版本是:3.4.1
mysql版本mysql-connection-java 6.0.2
原始config
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://localhost:3306/MyBatis" />
<property name="username" value="root" />
<property name="password" value="*****" />
</dataSource>
</environment>
</environments>
包如下错误:
按传统方式修改为:
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/MyBatis?serverTimezone=UTC&characterEncoding=utf-8" />
<property name="username" value="root" />
<property name="password" value="*****" />
</dataSource>
</environment>
</environments>
报如下错误:
后来又查了资料:修改为:
修改1:
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<!-- ?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8 -->
<property name="url" value="jdbc:mysql://localhost:3306/MyBatis?serverTimezone=UTC&characterEncoding=utf-8" />
<property name="username" value="root" />
<property name="password" value="gk090700bb" />
</dataSource>
</environment>
</environments>
修改2:
?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
这两种修改都是对的,但是具体原因我不知道为何还要加个"amp;",
那位大神知道吗?