java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
Class.forName("com.mysql.jdbc.Driver");
private static String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF8";
===客户数据库版本8.0,而测试例子5.0===
java.sql.SQLException: Unexpected exception encountered during query.
https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.20
https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.20/mysql-connector-java-8.0.20.jar
1)mysql-connector-java-8.0.20.jar放到目录下,把其他驱动程序拷贝到备份文件夹
PrjJsp\WebContent\WEB-INF\lib\mysql-connector-java-8.0.20.jar
Class.forName("com.mysql.cj.jdbc.Driver");
3)
private static String driver = "com.mysql.cj.jdbc.Driver";
private static String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF8";
private static String url = "jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true";