index.jsp (GB2312) --POST表單--> mysql_insert.jsp (UTF-8) --> MySQL (utf8mb4)
現象:中文入庫變亂碼,頁面顯示亂碼,英文正常
瀏覽器編碼(GB2312) → HTTP Body (GB2312 URL編碼)
→ Tomcat解碼(默認ISO-8859-1/配置UTF-8) → Java字符串(UTF-16)
→ JDBC發送(連接串characterEncoding) → MySQL解碼(連接字符集)
→ 存儲(表字符集) → 查詢 → 反向鏈路 → 瀏覽器渲染
| 環節 | 原代碼設置 | 問題 |
|---|---|---|
| index.jsp | `contentType="text/html;charset=gb2312"` | 頁面編碼 GB2312,表單提交按 GB2312 編碼 |
| mysql_insert.jsp | `pageEncoding="UTF-8"` 但**無** `request.setCharacterEncoding("UTF-8")` | Tomcat 按默認 ISO-8859-1 解碼 GB2312 的字節流 → 亂碼 |
| JDBC 連接串 | `?user=root&password=123456` **缺少** `useUnicode=true&characterEncoding=utf8mb4` | 驅動默認 latin1,中文存入變 ??? |
| MySQL 會話 | `stmt.executeQuery("SET NAMES UTF8")` | UTF8 非 utf8mb4 (不支持 Emoji/生僻字),且執行時機晚於首條 SQL |
| web.xml / server.xml | 無字符編碼 Filter、Connector 無 URIEncoding | 全局無保障 |
<!-- 所有 JSP 統一 -->
<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html><head><meta charset="UTF-8"></head>...
棄用 GB2312/GBK**:不支持 Emoji、生僻字,國際化困難,UTF-8 為唯一標準。
<filter>
<filter-name>EncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param><param-name>encoding</param-name><param-value>UTF-8</param-value></init-param>
<init-param><param-name>forceEncoding</param-name><param-value>true</param-value></init-param>
</filter>
<filter-mapping>
<filter-name>EncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
無 Spring 環境自寫 Filter (參考文章 67882 代碼)。
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443"
URIEncoding="UTF-8"
useBodyEncodingForURI="true" />
jdbc:mysql://localhost:3306/html_db?
useUnicode=true&
characterEncoding=utf8mb4&
serverTimezone=Asia/Shanghai&
useSSL=false&
allowPublicKeyRetrieval=true&
rewriteBatchedStatements=true
characterEncoding=utf8mb4:驅動發送/接收數據使用 utf8mb4useUnicode=true:啟用 Unicode 支持-- 檢查
SHOW CREATE DATABASE html_db;
SHOW CREATE TABLE person_tb;
SHOW FULL COLUMNS FROM person_tb;
-- 修正 (若非 utf8mb4)
ALTER DATABASE html_db CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE person_tb CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- 或逐列修改
ALTER TABLE person_tb MODIFY name VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<%@ page import="java.sql.*,java.util.*" %>
<%
// Filter 已處理 request 編碼,此行可省略,保留為雙重保險
request.setCharacterEncoding("UTF-8");
String id = request.getParameter("id");
String name = request.getParameter("name"); // 此處已正確解碼
String sex = request.getParameter("sex");
String age = request.getParameter("age");
// 連接池模式 (生產必須),此處簡化為直連
String url = "jdbc:mysql://localhost/html_db?useUnicode=true&characterEncoding=utf8mb4&serverTimezone=Asia/Shanghai";
try (Connection conn = DriverManager.getConnection(url, "root", "123456");
PreparedStatement ps = conn.prepareStatement(
"INSERT INTO person_tb (id, name, sex, age) VALUES (?, ?, ?, ?)")) {
ps.setString(1, id);
ps.setString(2, name); // 參數化查詢,無編碼/注入問題
ps.setString(3, sex);
ps.setInt(4, Integer.parseInt(age));
ps.executeUpdate();
// 查詢回顯
try (ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM person_tb")) {
while (rs.next()) {
out.println("ID: " + rs.getString("id") + "<br/>");
out.println("姓名: " + rs.getString("name") + "<br/>");
// ...
}
}
} catch (Exception e) {
e.printStackTrace();
out.println("錯誤: " + e.getMessage());
}
%>
✅ 瀏覽器 → Network → Request Payload: username=%E4%B8%96%E7%95%8C%E6%9D%AF (UTF-8 URL編碼)
✅ Tomcat 訪問日志 / 遠程調試: request.getParameter("username") = "世界杯"
✅ MySQL 客戶端: SELECT * FROM person_tb; 顯示正確中文
✅ MySQL 變量: character_set_client/connection/results/database = utf8mb4
✅ 頁面顯示: 瀏覽器渲染正常,無亂碼