JSP+ MySQL中文亂碼問(wèn)題post提交亂碼解決方案

%@page language="java" pageEncoding="UTF-8"%>
%@ page import="java.sql.*" %>
HTML>
HEAD>
TITLE>add message into table /TITLE>
/HEAD>
BODY>
%
String id=request.getParameter("id"); //從表單獲得
String name=request.getParameter("name"); //從表單獲得
String sex=request.getParameter("sex"); //從表單獲得
String age=request.getParameter("age"); //從表單獲得
try
{
/** 連接數(shù)據(jù)庫(kù)參數(shù) **/
String driverName = "com.mysql.jdbc.Driver"; //驅(qū)動(dòng)名稱
String DBUser = "root"; //mysql用戶名
String DBPasswd = "123456"; //mysql密碼
String DBName = "html_db"; //數(shù)據(jù)庫(kù)名

String connUrl = "jdbc:mysql://localhost/" + DBName + "?user=" + DBUser + "password=" + DBPasswd;
Class.forName(driverName).newInstance();
Connection conn = DriverManager.getConnection(connUrl);
Statement stmt = conn.createStatement();
stmt.executeQuery("SET NAMES UTF8");
String insert_sql = "insert into person_tb values('" + id + "','" + name + "','" + sex + "','" + age + "')";
String query_sql = "select * from person_tb";

try {
stmt.execute(insert_sql);
}catch(Exception e) {
e.printStackTrace();
}
try {
ResultSet rs = stmt.executeQuery(query_sql);
while(rs.next()) {
%>
ID：%=rs.getString("id")%> /br>
姓名：%=rs.getString("name")%> /br>
性別：%=rs.getString("sex")%> /br>
年齡：%=rs.getString("age")%> /br> /br>
%
}
}catch(Exception e) {
e.printStackTrace();
}
//rs.close();
stmt.close();
conn.close();
}catch (Exception e) {
e.printStackTrace();
}
%>
/body>
/html>

U>?xml version='1.0' encoding='utf-8'?>/U>
Server port="8005" shutdown="SHUTDOWN">
Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="on" />
Listener className="org.apache.catalina.core.JasperListener" />
Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" />
GlobalNamingResources>
Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
/GlobalNamingResources>
Service name="Catalina">
Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />

Engine name="Catalina" defaultHost="localhost">
Realm className="org.apache.catalina.realm.LockOutRealm">
Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
/Realm>
Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true">
Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"
prefix="localhost_access_log." suffix=".txt"
pattern="%h %l %u %t "%r" %s %b" />
/Host>
/Engine>
/Service>
/Server>

U>?xml version="1.0" encoding="UTF-8"?>/U>
web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0">
servlet>
servlet-name>default/servlet-name>
servlet-class>org.apache.catalina.servlets.DefaultServlet/servlet-class>
init-param>
param-name>debug/param-name>
param-value>0/param-value>
/init-param>
init-param>
param-name>listings/param-name>
param-value>false/param-value>
/init-param>
load-on-startup>1/load-on-startup>
/servlet>
servlet>
servlet-name>jsp/servlet-name>
servlet-class>org.apache.jasper.servlet.JspServlet/servlet-class>
init-param>
param-name>fork/param-name>
param-value>false/param-value>
/init-param>
init-param>
param-name>xpoweredBy/param-name>
param-value>false/param-value>
/init-param>
load-on-startup>3/load-on-startup>
/servlet>
servlet-mapping>
servlet-name>default/servlet-name>
url-pattern>//url-pattern>
/servlet-mapping>
!-- The mappings for the JSP servlet -->
servlet-mapping>
servlet-name>jsp/servlet-name>
url-pattern>*.jsp/url-pattern>
url-pattern>*.jspx/url-pattern>
/servlet-mapping>
session-config>
session-timeout>30/session-timeout>
/session-config>
此處省略了mime-mapping的內(nèi)容>
welcome-file-list>
welcome-file>index.html/welcome-file>
welcome-file>index.htm/welcome-file>
welcome-file>index.jsp/welcome-file>
/welcome-file-list>
/web-app>

%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
%@ page contentType="text/html;charset=utf-8"%>

... maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" URIEncoding="UTF-8" />

... maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" useBodyEncodingForURI="true" />
enableLookups="false" redirectPort="8443" protocol="AJP/1.3" useBodyEncodingForURI="true" />

%String username = "張某某" ;
username = URLEncoder.encode(username,"utf-8");
%>
a href="to.jsp?param=%=username %>">轉(zhuǎn)入/a>

%=URLDecoder.decode(request.getParameter("param"),"utf-8")%>

%@ page language="java" pageEncoding="utf-8"%>
%@ page contentType="text/html;charset=utf-8"%>
%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=utf-8");
%>
html>
head>
/head>
body>
form action="mysql_insert.jsp" method="post">
ID :input type = "text" name="id" value="0"/>
姓名 :input type = "text" name="name" value="aaa"/>
性別 :input type = "text" name="sex" value="female"/>
年齡:input type = "text" name="age" value="20"/>
/br>
input type = "submit" value="提交"/>
/form>
/body>
/html>