解决JSP提交表单保存到Mysql中文乱码的有关问题

解决JSP提交表单保存到Mysql中文乱码的问题

JSP网页即使写成 

<%@ page contentType= “text/html; charset=UTF-8 ” language= “java ” import= “java.sql.* ” errorPage= “error.jsp ” %> 

Mysql里存取的数据库的charset也设成了UTF-8，可是通过JSP网页存取中文还是显示乱码 。解决的办法就是加一个过滤器：

package cn.cate.utils;

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;

public class SetCharacterEncodingFilter  implements Filter{

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

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

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

	@Override
	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 = true; 
	    } 
	    else if (value.equalsIgnoreCase("true")) { 
	      this.ignore = true; 
	    } 
	    else if (value.equalsIgnoreCase("yes")) { 
	      this.ignore = true; 
	    } 
	    else { 
	      this.ignore = false; 
	    } 
	}

	protected String selectEncoding(ServletRequest request) { 
	    return (this.encoding); 
	} 
}

 然后在web.xml作如下配置：

<filter> 
  <filter-name>Set Character Encoding</filter-name> 
  <filter-class>cn.cate.utils.SetCharacterEncodingFilter</filter-class> 
  <init-param> 
    <param-name>encoding</param-name> 
    <param-value>UTF-8</param-value> 
  </init-param> 
</filter> 
<filter-mapping> 
  <filter-name>Set Character Encoding</filter-name> 
  <url-pattern>/*</url-pattern> 
</filter-mapping>