关于struts+hibernate+mysql5.0乱码问题

[e3002]

我在jsp页面中来获得值显示正确,但当执行紧接着的hibernate时却不能正常执行,程序大概如下
String name=new String(s.getBytes("iso-8859-1"),"gbk"),
//执行上步时name显示正常
Query query=session.createQuery("from customers c where c.name='"+name+"'");
//执行到该步时不能正常执行,中文也不能正常显示,
不知道是数据库的事还是hibernate本身的问题,按理说hibernate本身应该每问题,郁闷好几天了,请各位大虾帮忙解决以下,感激不仅!

[e3002]

up 高人指点以下

[xiaoxiao130130]

第一步：
在你的项目web.xml文件中加入
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>com.pengzeng.struts.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>GB2312</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>action</servlet-name>
</filter-mapping>
再加入这个类到你项目中
package com.pengzeng.struts;

import javax.servlet.*;
import java.io.IOException;

/**
* <p>Filter that sets the character encoding to be used in parsing the
* incoming request, either unconditionally or only if the client did not
* specify a character encoding. Configuration of this filter is based on
* the following initialization parameters:</p>
* <ul>
* <li><strong>encoding</strong> - The character encoding to be configured
* for this request, either conditionally or unconditionally based on
* the <code>ignore</code> initialization parameter. This parameter
* is required, so there is no default.</li>
* <li><strong>ignore</strong> - If set to "true", any character encoding
* specified by the client is ignored, and the value returned by the
* <code>selectEncoding()</code> method is set. If set to "false,
* <code>selectEncoding()</code> is called <strong>only</strong> if the
* client has not already specified an encoding. By default, this
* parameter is set to "true".</li>
* </ul>
*
* <p>Although this filter can be used unchanged, it is also easy to
* subclass it and make the <code>selectEncoding()</code> method more
* intelligent about what encoding to choose, based on characteristics of
* the incoming request (such as the values of the <code>Accept-Language</code>
* and <code>User-Agent</code> headers, or a value stashed in the current
* user's session.</p>
*
* @author <a href="mailto:[e-mail]">John Wong</a>
*
* @version $Id: SetCharacterEncodingFilter.java,v 1.1 2002/04/10 13:59:27 johnwong Exp $
*/
public class SetCharacterEncodingFilter implements Filter {

// ----------------------------------------------------- Instance Variables


/**
* The default character encoding to set for requests that pass through
* this filter.
*/
protected String encoding = null;


/**
* The filter configuration object we are associated with. If this value
* is null, this filter instance is not currently configured.
*/
protected FilterConfig filterConfig = null;


/**
* Should a character encoding specified by the client be ignored?
*/
protected boolean ignore = true;


// --------------------------------------------------------- Public Methods


/**
* Take this filter out of service.
*/
public void destroy() {

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

}


/**
* Select and set (if specified) the character encoding to be used to
* interpret request parameters for this request.
*
* @param request The servlet request we are processing
* @param result The servlet response we are creating
* @param chain The filter chain we are processing
*
* @exception IOException if an input/output error occurs
* @exception ServletException if a servlet error occurs
*/
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);

}


/**
* Place this filter into service.
*
* @param filterConfig The filter configuration object
*/
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 Methods


/**
* Select an appropriate character encoding to be used, based on the
* characteristics of the current request and/or filter initialization
* parameters. If no character encoding should be set, return
* <code>null</code>.
* <p>
* The default implementation unconditionally returns the value configured
* by the <strong>encoding</strong> initialization parameter for this
* filter.
*
* @param request The servlet request we are processing
*/
protected String selectEncoding(ServletRequest request) {

return (this.encoding);

}

}//EOC

[xiaoxiao130130]

以后在jsp文件中加入

<%@ page contentType="text/html; charset=GBK"%>
就可以了。

[Jineral]

to (阿真)
好人啊！

[keanfly]

我也碰到同样问题，正在寻求解决方案中。。。。

[keanfly]

Query query=session.createQuery("from UserManager where username=? and userpass=?");
query.setString(0,"xxx");
query.setString(1,"xxx");

没必要楼上那么复杂吧？看了人都晕。

通过参数动态绑定。这种方式具有很多优点，一、便于SQL语句的性能提升 二、代码具有更好的清晰度 三、防止了SQL字符串的攻击。

[whzhaha]

用了监听器，或改下struts也行，但千万不要转化两次哦 呵呵

[evilzydar]

安装数据库时将数据库默认编码设置为utf8,程序编码想设什么就设什么了,这也是一种解决办法,看看其它朋友的答案.

[hanhongmin]

解决中....顶了