关于jsp页面向mysql数据库插入中文记录

1.数据库的编码设置为utf-8

2.编写字符编码集过滤器

EncodingFilter com.sw1.common.Filter.EncodingFilter EncodingFilter /* encoding utf-8 package com.sw1.common.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; public class EncodingFilter implements Filter{ private String encoding ; public void destroy() {} public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { request.setCharacterEncoding(encoding); chain.doFilter(request, response); } public void init(FilterConfig filterConfig) throws ServletException { //从xml文件里面获取当前web初始化的encoding 参数值 encoding = filterConfig.getServletContext().getInitParameter("encoding") ; System.out.println(encoding); } }

3.在mySQL配置文件中：jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=UTF8

4.若是从页面转到servlet里面发现乱码，例如模糊查询页面的分页效果保存查询名：修改Tomcat - conf - server.xml 里面的

 <Connector port="8080" protocol="HTTP/1.1"                 connectionTimeout="20000"                 redirectPort="8443" URIEncoding="utf-8"/>