struts中文乱码问题解决

1、SQL Server：JNDI    jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=data
      容器：默认安装Tomcat5.0
      IDE：使用UTF-8编码,jsp,java文件都为UTF-8

      Properties文件：转为GBK
           native2ascii -encoding GBK ApplicationResources_GBK.properties ApplicationResources_zh-cn.properties

      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>

      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;
//import javax.servlet.ServletContext;
//import javax.servlet.http.HttpSession;
//import javax.servlet.http.HttpServletResponse;

/**
 * <p>Title: MusicWeb</p>
 * <p>Description: MusicWeb site</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: VFrankSoft</p>
 * @author 乌小龙
 * @version 1.0
 */

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);
 }

}

2、MySQL：JNDI   jdbc:mysql://localhost:3306/data?useUnicode=true&characterEncoding=UTF-8
           重要，mysql建立数据库时 CREATE DATABASE 表名
                                                            DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
      容器：同上
      IDE：同上
      Properties：同上
      web.xml：同上