关于数据库中文乱码问题-适用于jsp、Java

1，Java
加characterEncoding=UTF-8

Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/java?characterEncoding=UTF-8","root","密码");

2，jsp
（1）加个过滤器拦截所有的request和response请求

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CharacterFilter implements Filter {
	public void init(FilterConfig filterConfig) throws ServletException {
	}
	public void doFilter(ServletRequest req, ServletResponse resp,
			FilterChain chain) throws IOException, ServletException {
		HttpServletRequest request = (HttpServletRequest) req;
		HttpServletResponse response = (HttpServletResponse) resp;
		// 拦截所有的请求 解决全站中文乱码
		// 指定 request 和 response 的编码
		request.setCharacterEncoding("utf-8"); // 只对消息体有效
		response.setContentType("text/html;charset=utf-8");
		// 在放行时 应该给目标资源一个request对象 让目标资源调用 
         // getParameter时调到我们写的getParameter
		// 对request进行包装
		CharacterRequest characterRequest = new CharacterRequest(request);
		//放行
		chain.doFilter(characterRequest, response);
	}
	public void destroy() {
	}
}
// 针对 request 对象进行包装
// 继承 默认包装类HttpServletRequestWrapper
class CharacterRequest extends HttpServletRequestWrapper {
	public CharacterRequest(HttpServletRequest request) {
		super(request);
	}
	// 子类继承父类一定会覆写一些方法，此处用于重写getParamter()方法
	public String getParameter(String name) {
		// 调用 被包装对象的getParameter()方法 获得请求参数
		String value = super.getParameter(name);
		if (value == null)
			return null;
		// 判断请求方式
		String method = super.getMethod();
		if ("get".equalsIgnoreCase(method)) {
			try {
			     value = new String(value.getBytes("iso-8859-1"), "utf-8");
			} catch (UnsupportedEncodingException e) {
				throw new RuntimeException(e);
			}
		}
		// 解决乱码后返回结果
		return value;
	}
}

（2）修改web.xml

<filter>
        <filter-name>CharacterFilter</filter-name>
        <filter-class>com.filter.CharacterFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>CharacterFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

注意，过滤器只对post请求起作用，要用post请求才行