mysql中文乱码怎么解决

-- 查看数据库字符集
SHOW CREATE DATABASE your_database_name;

-- 查看表字符集
SHOW CREATE TABLE your_table_name;

-- 修改数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 修改表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 在连接字符串中指定字符集
jdbc:mysql://localhost:3306/your_database_name?useUnicode=yes&characterEncoding=UTF-8

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

System.setProperty("file.encoding", "UTF-8");

SET NAMES utf8mb4;

ResultSet rs = statement.executeQuery("SELECT * FROM your_table_name");
while (rs.next()) {
    String data = rs.getString("your_column_name");
    System.out.println(data);
}