hibernate+sqlserver中文乱码的解决

首先要编写一个编码过滤器,起编码如下:

package com.Book.Page.Filter;
import javax.servlet.*;

import java.io.IOException;
public class SetCharacterEncodingFilter implements Filter {
protected String encoding = null;
protected boolean ignore = true;
protected FilterConfig filterConfig = null;
public void destroy() {

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

}
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);
}
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文件中加入如下过滤器的配置:

<!--start config of characterEncoding filter-->
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>com.Book.Page.Filter.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>Set Character Encoding</filter-name>
<servlet-name>webwork</servlet-name>
<url-pattern>*.action</url-pattern>
</filter-mapping>

<!--end config of characterEncoding -->

hibernate的配置文件也要加入如下配置:

<property name="generate_statistics">true</property>
<property name="useUnicode">true</property>
<property name="characterEncoding">UTF-8</property>

页面也要改成UTF-8编码:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

另外:

如使用了struts,用stu.setId(stuform.getId()),而无需使用stu.setId(new String(stuForm.getId().getBytes("ISO-8859-1"),"UTF-8"))

 

还有一点需要注意的是如果使用的数据库是mysql的话还要将mysql的默认编码设置为utf8格式.

 

参考博客(JSP乱码)http://blog.sina.com.cn/s/blog_3fdbc0780100d7x7.html