jsp插入中文到MySql乱码问题解决总结

Question

环境
TOMCAT5.5 + MyEcplise5.0+MsSql5.0
步骤
1）首先在MySql中将字符集配置成UTF8
Server characterset:    utf8
Db     characterset:    utf8
2）在tomcat中修改server.xml
 <Connector port="80" URIEncoding="UTF-8" maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               connectionTimeout="20000" disableUploadTimeout="true" />
3）在web.xml中增加filter
<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>
4）在jsp中设置
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">这样就实现了jsp页面中文插入到数据库之后在另外一个页面显示的问题，无论post还是get，也不用考虑那里用GBK，那里用UTF8，那里用GB2312了，
一个UTF8，全搞定。大家说呢？：）