问题描述: 在本地数据库插入带重音字符时,可能会遇到以下问题:
解决方法:
String url = "jdbc:mysql://localhost:3306/db_name?useUnicode=true&characterEncoding=UTF-8";
Connection connection = DriverManager.getConnection(url, username, password);
CREATE TABLE table_name (
column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);
String value = "é";
String insertSql = "INSERT INTO table_name (column_name) VALUES ('\\u00e9')";
或者使用PreparedStatement来插入,例如:
String value = "é";
String insertSql = "INSERT INTO table_name (column_name) VALUES (?)";
PreparedStatement statement = connection.prepareStatement(insertSql);
statement.setString(1, value);
statement.executeUpdate();
通过以上方法,可以解决本地数据库插入带重音字符时可能遇到的问题。