- Cause: org.apache.ibatis.binding.BindingException: Parameter 'username' not found异常 mybatis传入多个参数的问题
连接MySql报错(时区错误)
连接MySql报错(时区错误)
https://www.jianshu.com/p/02f16bb0b9f1Mysql8 报错:ERROR 1193 (HY000): Unknown system variable 'tx_isolation'
通过提高mysql驱动版本来解决这个问题
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.14</version>
</dependency>
Unknown initial character set index '255' received from server
改成这句,就可以了
String url = "jdbc:mysql://localhost:3306/db_cjky?useUnicode=true&characterEncoding=utf8";
mybatis中xml中写法
1.将“&”改写为“&”
2.只写?characterEncoding=utf-8
具体解答:https://blog.csdn.net/q343509740/article/details/79505185