WEB乱码处理备查

(1)设置页面
为了编译和显示正常

xml 代码

<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>

(2)设置web.xml   

xml 代码

<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>
</filter>

<!-- filter mapping -->
<filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>*.do</url-pattern>
</filter-mapping>
<filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>*.jsp</url-pattern>
</filter-mapping>

(3)为了让post和get方式都统一，还要设置tomcat的server.xml
<connector port="8080" maxthreads="150" minsparethreads="25" maxsparethreads="75"> </connector>

xml 代码

<Connector port="8080" maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               debug="0" connectionTimeout="20000"
               disableUploadTimeout="true" URIEncoding="UTF-8"/>

(4)设置数据库链接URL
<property name="url" value="jdbc:mysql://localhost:3306/vtag?useUnicode=true&amp;amp;characterEncoding=&amp;lt;font color="> </property>

xml 代码

<property name="url" value="jdbc:mysql://localhost:3306/vtag?useUnicode=true&characterEncoding=GBK"/>

(5)设置数据库
在mysql数据库的my.ini找到并修改
（为了使用客户端查看方便）
[client]
default-character-set=GBK
[mysqld]
default-character-set=gbk

修改对应数据库下的db.opt
default-character-set=gbk
default-collation=gbk_chinese_ci