Struts+hibernate+Mysql5.0之中文乱码解决方案

最近在学习Struts+hibernate+Mysql5.0的Web程序开发，遇到最头疼的问题自然是MySQL的中文乱码问题了。现将解决方法介绍如下：
1.首先，JSP页面里<%@ page contentType="text/html; charset=UTF-8"%>
很关键！切记。
2.MySQL：JNDI jdbc:mysql://localhost:3306/data?useUnicode=true&characterEncoding=UTF-8
3.mysql建立数据库时：
CREATE DATABASE 表名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
4.建立EncodingFilter类：

package com.vfrankmusic.sysinfo;

import javax.servlet.ServletException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;



public class EncodingFilter implements Filter {
private FilterConfig config = null;
// default to ASCII
private String targetEncoding = "ASCII";

public void init(FilterConfig config) throws ServletException {
this.config = config;
this.targetEncoding = config.getInitParameter("encoding");
}

public void destroy() {
config = null;
targetEncoding = null;
}

public void doFilter(ServletRequest srequest, ServletResponse sresponse,
FilterChain chain) throws IOException, ServletException {
HttpServletRequest request = (HttpServletRequest) srequest;
request.setCharacterEncoding(targetEncoding);
// move on to the next
chain.doFilter(srequest, sresponse);
}

}


5.web.xml文件：UTF-8

<filter>
<filter-name>EncodingFilter</filter-name>
<display-name>EncodingFilter</display-name>
<description>EncodingFilter</description>
<filter-class>com.vfrankmusic.sysinfo.EncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>EncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

经过测试，中文乱码问题解决！


总结：1.在做SSH+mysql5.0+eclipse开发时，一般将C:\Program Files\MySQL\MySQL Server 5.0\my.ini 中的设置为：default-character-set=gbk
2.JSP页面里，设置charset=utf-8。
3.使用过滤类过滤中文字符。
4. web.xml里注册过滤类。