解决数据库录入中文数据乱码问题

如题，测试JSP代码时在SQL SERVER2000数据库中录入数据时，发现录入的数据全部是乱码，后查询资料解决。
很简单，加上  <%request.setCharacterEncoding("gb2312");%>就OK了。

或者是设置一个Filter

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package jdbcbook.pub.filters;

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;

/**
 * 设置Tomcat的正确编码格式
 * @author Administrator
 */
public class SetCharacterEncodingFilter implements Filter {

    protected String encoding=null;
    protected FilterConfig filterConfig=null;
    protected boolean ignore=true;

    //初始化方法，通过配置的参数设置标识变量
    public void init(FilterConfig filterConfig) throws ServletException {
        this.filterConfig=filterConfig;
        this.encoding=filterConfig.getInitParameter("encoding");
        String value=filterConfig.getInitParameter("ignore");
        if(value==null)
            this.ignore=false;
        else if (value.equalsIgnoreCase("false"))
            this.ignore=true;
        else if (value.equalsIgnoreCase("no"))
            this.ignore=true;
        else
            this.ignore=false;
    }

    public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
        //判断是否需要进行编码的设置
        if(!ignore || (request.getCharacterEncoding()==null))
        {
        //得到配置文件中的编码类型
            String encoding =selectEncoding(request);
            if(encoding!=null)
                request.setCharacterEncoding(encoding);
        }
        chain.doFilter(request, response);
    }

    public void destroy() {
        this.encoding=null;
        this.filterConfig=null;
    }

    //得到配置的编码类型
    protected String selectEncoding(ServletRequest request)
    {
        return this.encoding;
    }
}

在web.xml中进行相应的配置

    <filter>
        <filter-name>Set Character Encoding</filter-name>
        <filter-class>jdbcbook.pub.filters.SetCharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>GBK</param-value>
        </init-param>
        </filter>
    <filter-mapping>
        <filter-name>Set Character Encoding</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>