hql查询 给定默认值 控制台打印sql语句出现乱码例如:hql ="from TservercameraUtil where cameraname like '类型%'"";getHibernateTemplate().find(hql);控制台打印 sql语句查询出现乱码
select tservercam0_.CAMERAID as CAMERAID, tservercam0_.CAMERANAME as CAMERANAME54_, tservercam0_.LOGICID as LOGICID54_, tservercam0_.MAPID as MAPID54_, tservercam0_.MAPNAME as MAPNAME54_, tservercam0_.PARENTID as PARENTID54_, tservercam0_.AREAID as AREAID54_, tservercam0_.AREANAME as AREANAME54_ from TSERVERCAMERA tservercam0_ where tservercam0_.CAMERANAME like '?à??%'spring配置文件 配置
<prop key="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>这句就没事了
但会影响其它查询 出现乱码 不知道有没其它解决方法 在此谢谢了!!!!!!
select tservercam0_.CAMERAID as CAMERAID, tservercam0_.CAMERANAME as CAMERANAME54_, tservercam0_.LOGICID as LOGICID54_, tservercam0_.MAPID as MAPID54_, tservercam0_.MAPNAME as MAPNAME54_, tservercam0_.PARENTID as PARENTID54_, tservercam0_.AREAID as AREAID54_, tservercam0_.AREANAME as AREANAME54_ from TSERVERCAMERA tservercam0_ where tservercam0_.CAMERANAME like '?à??%'spring配置文件 配置
<prop key="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>这句就没事了
但会影响其它查询 出现乱码 不知道有没其它解决方法 在此谢谢了!!!!!!
解决方案 »
- quartz持久化问题
- 已经郁闷两天了 hibernate 报Duplicate collection role mapping错误
- 类似MonitorTomcat是用什么开发的
- where字句的问题!
- form中的action属性与struts-config.xml文件中的path如何对应 ?
- 如何将字符串1990-11-20转化成日期型1990-11-20?
- JSP 页面中,如何使用户输入时,表格能够在末行再增加新的空行
- 我只想配置一个运行 jsp 的工作平台?(我下载了j2sdk-1_4_0-win.exe),我该如何来配置呢?
- 请问:mybatis 将日期类型字段插入到mysql数据库日期类型的字段中报错,怎么解决?急求
- 为什么css里的ul没反应?其它都有反应。
- ss和ibatis框架,连接oracle的配置文件该怎么配呢?
- 如何将serversocket服务器收集的信息保存到文件中
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>com.common.SetEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>gbk</param-value>
</init-param>
</filter>package com.common;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 SetEncodingFilter
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 {
if (ignore || (request.getCharacterEncoding() == null)) {
request.setCharacterEncoding(selectEncoding(request));
}
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") || value.equalsIgnoreCase("yes"))
this.ignore = true;
else
this.ignore = false;
} protected String selectEncoding(ServletRequest request) {
return (this.encoding);
} public FilterConfig getFilterConfig() {
return filterConfig;
} public void setFilterConfig(FilterConfig filterConfig) {
this.filterConfig = filterConfig;
}}
按这样就没事了
<filter-name>Set Character Encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
不是页面的原因 已经给定默认值 好像是hibernate的事
恩 先谢谢了 但我是用dwr传的值 况且我先已测试给定默认值查询 控制台打印sql语句出现乱码。
跟过滤器没关系 我已给定默认值 是hibernate的事
<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-name>encodingFilter</filter-name>
<url-pattern>*.html,*.jsp,*.do,*.action,*.*</url-pattern>
</filter-mapping>
应该不是Hibernate的问题。
不行的 还是乱码
首先 我已给定默认值 执行hibernate 查询 控制台打印sql语句是乱码
百度说 HSQL语句中中文不能使用是Hibernate3.01的一个BUG
<prop key="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>
其它查询语句没事我的hql语句就是乱码
是用svn提交到服务器
配置
<prop key="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>
查询语句没事其它查询出现乱码
String word = new String(patternWord.getBtye("ISO-8859-1"),"GBK/UTF-8");
我已给定默认值的 值是定位的 hql ="from TservercameraUtil where cameraname like '类型%'"";
我用的hibernate3.jar 没问题
跟数据库没关系 hibernate的事
用的是oracle 跟数据库没关系的
hql ="from TservercameraUtil where cameraname like :param";
Query query = getSession().createQuery(hql);
query.setString("param", "%" + str + "%");
query.list();这样应该能解决。