报错内容:
Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
分析:
数据库驱动包编码与页面不匹配
解决方法:
有两种解决方法, 根据自己项目选择
1、直接在连接数据库语句中的url变量中修改
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/t_user","root","root");//修改前
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/t_user?useUnicode=true&characterEncoding=utf8","root","root");//修改后
2、删除原有数据库驱动程序(报错前用的是"mysql-connector-java-5.1.6-bin.jar"),更新为"mysql-connector-java-8.0.13.jar"后解决(推荐)
官网地址 https://dev.mysql.com/downloads/connector/j/
选择"Platform Independent"后,选择"Platform Independent (Architecture Independent), ZIP Archive",可在压缩包根目录下找到mysql-connector-java-8.0.13.jar,复制粘贴到WEB-INF --lib下即可。