SSH整合之中文乱码问题

SSH2+Mysql 中文乱码解决方法

 中文乱码,首先要区分是页面乱码、action乱码，还是数据库乱码。大致的原理是java使用unicode编码– >window使用gbk(gb2312的扩展集)– mysql默认使用utf-8(unicode的一种编码方法),这样转来转去就乱码了 ^_^。解决方法如下：

1. 在jsp里面，最好将所有字符都设成utf-8

 

<%@ page contentType=”text/html; charset=UTF-8″%> <%@ page pageEncoding=”UTF-8″ %>

2.配置struts.xml：

    <constant name="struts.i18n.encoding" value="UTF-8"/>

3. 在web.xml加个filter（注意要写在struts的filter的前面）

 3.1 自己编写一个过滤器，然后在web.xml中进行配置，代码如下：

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 FilterConfig filterConfig;

public void destroy(){}

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

	String encoding=filterConfig.getInitParameter("encoding");

	request.setCharacterEncoding(encoding);

	response.setCharacterEncoding(encoding);

	response.setContentType("text/html,charset=UTF-8");

	chain.doFilter(request, response);

}

public void init(FilterConfig filterConfig)throws ServletException{

	this.filterConfig=filterConfig;

}

}

在web.xml 中的配置如下：

<filter>

	<filter-name>encoding</filter-name>
	<filter-class>com.wuse.filter.EncodingFilter</filter-class>
	<init-param>
	<param-name>encoding</param-name>
	<param-value>UTF-8</param-value>
	</init-param>
	</filter>
	<filter-mapping>
	<filter-name>encoding</filter-name>
	<url-pattern>/*</url-pattern>
	</filter-mapping>
 3.2  使用spring的filter,在web.xml中配置

<filter>

<filter-name>encodingFilter </filter-name>

<filter-class>

org.springframework.web.filter.CharacterEncodingFilter

</filter-class>

<init-param>

<param-name>encoding </param-name>

<param-value>UTF-8 </param-value>

</init-param>

<init-param>

<param-name>forceEncoding </param-name>

<param-value>true </param-value>

</init-param>

</filter>

并将对应的后缀加入filter-mapping,例如

<filter-mapping>

<filter-name>encodingFilter </filter-name>

<url-pattern>*.do </url-pattern>

</filter-mapping>

4 手动转换

new String(old.getBytes("iso8859-1"),"UTF-8");

 public class ConvertCharacter{
public String Convert(String s){
String result;
byte[] temp ;
try{
temp = s.getBytes(”iso-8859-1″);
result =  new String(temp,”utf-8″);
}
return result;
}

5. 修改数据源的配置参数：
数据库链接方式：jdbc:mysql://localhost:3306/mysystem?characterEncoding=utf-8