数据库乱码解决

Question

请各位大侠给一个良方：如何正确地在JSP中插入往SQLSERVER2000中插入中文，要求：
1：在SQLSERVER2000中看到的是乱码；
2：在ERP中能正确看到中文；
3：不能修改数据库及表的属性（SQL_LATIN1_GENERAL_CP437_BIN）；
如图的所示
注：
    查询出来的中文能正确显示（数据驱动用的是JTDS1.2）！！
    希望各位给各好的建议

Answer 1

对乱码问题的总结如下：1。首先加个过滤类。让所有请求的类都变成GBK编码。代码如下：web.xml<filter>
    <filter-name>EncodingFilter</filter-name>
    <filter-class>com.livechance.filter.EncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>GBK</param-value>
    </init-param>
  </filter>
   <filter-mapping>
    <filter-name>EncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping> filter 类如下：package com.livechance.filter;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.HttpServlet;public class EncodingFilter extends HttpServlet implements Filter
{
    private FilterConfig config = null;
    private String targetEncoding = "GBK";    public void init(FilterConfig filterConfig)
    {
        this.config = filterConfig;
        this.targetEncoding = config.getInitParameter("encoding");
    }    public void destroy()
    {
        config = null;
        targetEncoding = null;
    }    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse,
                         FilterChain filterChain)
    {
        ServletRequest request = (ServletRequest) servletRequest;
        try
        {
            request.setCharacterEncoding(targetEncoding);
            filterChain.doFilter(servletRequest, servletResponse);
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
    }}
 2.。页面有中文的时候：解决办法：servlet; response.setContentType("text/html;harset=GBK");JSP中：<%#@ page contentType="text/html;charset=gb2312"%>注意:一定要写在PrintWriter out=response.getWriter();之前