JSP插入MySQL数据库中文乱码问题解决

通过JSP页面向MySQL数据库插入中文数据时乱码问题

 

刚开始插入数据时，mysql数据库表内显示？？？，读取时同样也是？？？

对此查找了相关资料，首先注意保持服务器、数据库、项目、以及前端编码一致。

 

具体做法是：

 

一、项目编码，Eclipse设置。

Eclipse Java EE IDE for Web Developers ->右键项目 -> Properties -> Resource -> Text file encoding ->other utf-8 ->apply and close

 

二、tomcat服务器编码设置（conf\server.xml）

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

<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8"/> 

三、数据库mysql的my.ini配置文件

[client]  
port = 3306   
default-character-set=utf8 

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
; Remove the next comment character if you are not familiar with SQL
;safe-updates
default-character-set=utf8 

[isamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer_size = 2M
write_buffer_size = 2M

[myisamchk]
key_buffer_size = 20M
sort_buffer_size_size = 20M
read_buffer_size = 2M
write_buffer_size = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld]
port = 3306

character-set-server = utf8

 

  修改文件后需要使用net stop mysql/net start mysql关闭开启mysql服务重启mysql服务

 

四、项目

检查项目中有前端编码的地方

a. JSP页面

<%@ page language="java" contentType="text/html; charset=utf-8"  
    pageEncoding="utf-8"%>  

 b. Servlet服务器端

 response.setCharacterEncoding("UTF-8");  

 c. 其它有编码的地方。

把所有的编码设置一致。本例是为UTF-8.

 

 

通过以上步骤还款解决的话，可以在项目中加一个Filter:

package com.kh.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;

	
	public void destroy() {

		this.encoding = null;
		this.filterConfig = null;

	}

	public void doFilter(ServletRequest request, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {

		// Conditionally select and set the character encoding to be used
		if (ignore || (request.getCharacterEncoding() == null)) {
			String encoding = selectEncoding(request);
			if (encoding != null)
				request.setCharacterEncoding(encoding);
		}

		// Pass control on to the next filter
		chain.doFilter(request, response);

	}

	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>encodingFilter</filter-name>
		<filter-class>com.kh.utils.SetCharacterEncodingFilter</filter-class>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>UTF-8</param-value>
		</init-param>
		<init-param>
			<param-name>ignore</param-name>
			<param-value>true</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>encodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>