jsp mysql解决中文乱码问题

最近在用struts1.x 和jsp开发web应用程序，后台数据库用的是mysql5，数据库编码是utf-8，jsp页面编码也使用了UTF-8，但是写入数据和读出来的中文总是乱码，很是困惑！参考了一些资料写了一个过滤器解决了问题

1.建立字符过滤器类SetCodeFilter,该类实现了javax.servlet.Filter接口

package com.sims.core;import java.io.IOException;import javax.servlet.Filter;import javax.servlet.FilterChain;import javax.servlet.FilterConfig;import javax.servlet.ServletException;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;import javax.servlet.http.HttpServletRequest;public class SetCodeFilter implements Filter {public void destroy() {}public void doFilter(ServletRequest request, ServletResponse response,FilterChain filterchain) throws IOException, ServletException {HttpServletRequest req = (HttpServletRequest)request;req.setCharacterEncoding("UTF-8");filterchain.doFilter(request, response);}public void init(FilterConfig arg0) throws ServletException {}}

2.在web.xml中配置过滤器

<filter> <filter-name>setCodeFilter</filter-name> <filter-class>com.sims.core.SetCodeFilter</filter-class> </filter> <filter-mapping> <filter-name>setCodeFilter</filter-name> <url-pattern>*.do</url-pattern> </filter-mapping> <filter-mapping> <filter-name>setCodeFilter</filter-name> <url-pattern>*.jsp</url-pattern> </filter-mapping>