我在学用struts1.2+spring1.2+hibernate3.1做项目
一直没用过中文做为hql的查询条件
今天就碰到如题的问题了,如下:
from Members where 1=1 and memSex ='男'
Hibernate: select count(*) as col_0_0_ from MEMBERS members0_ where 1=1 and members0_.MEM_SEX='??'
Hibernate: select * from ( select members0_.MEM_ID as MEM1_, members0_.MEM_STATE as MEM2_1_, members0_.MEM_ACCOUNT as MEM3_1_, members0_.MEM_PASSWORD as MEM4_1_, members0_.MEM_NAME as MEM5_1_, members0_.MEM_SEX as MEM6_1_, members0_.MEM_BIRTHDAY as MEM7_1_, members0_.MEM_PHONE as MEM8_1_, members0_.MEM_ADDRESS as MEM9_1_, members0_.MEM_DATE as MEM10_1_, members0_.MEM_INFO as MEM11_1_, members0_.MEM_PHOTO as MEM12_1_ from MEMBERS members0_ where 1=1 and members0_.MEM_SEX='??' ) where rownum <= ?高手帮解决一下吧
谢谢
一直没用过中文做为hql的查询条件
今天就碰到如题的问题了,如下:
from Members where 1=1 and memSex ='男'
Hibernate: select count(*) as col_0_0_ from MEMBERS members0_ where 1=1 and members0_.MEM_SEX='??'
Hibernate: select * from ( select members0_.MEM_ID as MEM1_, members0_.MEM_STATE as MEM2_1_, members0_.MEM_ACCOUNT as MEM3_1_, members0_.MEM_PASSWORD as MEM4_1_, members0_.MEM_NAME as MEM5_1_, members0_.MEM_SEX as MEM6_1_, members0_.MEM_BIRTHDAY as MEM7_1_, members0_.MEM_PHONE as MEM8_1_, members0_.MEM_ADDRESS as MEM9_1_, members0_.MEM_DATE as MEM10_1_, members0_.MEM_INFO as MEM11_1_, members0_.MEM_PHOTO as MEM12_1_ from MEMBERS members0_ where 1=1 and members0_.MEM_SEX='??' ) where rownum <= ?高手帮解决一下吧
谢谢
解决方案 »
- 在TOMCAT6.0中布署jsf工程时出异常(急求解决方案)
- 请问resin和tomcat服务器那个好,各有什么优点,怎么配置??
- jsp用jspsmart上传文件重命名后再把新的文件名存入数据库 有点问题
- 我想从asp转jsp,请各位推荐一些书给我!谢谢!
- 请问在JAVABEAN中如何得到虚拟目录路径?
- 请大家帮忙!看看这个问题!
- ■■看了那个用javabean上传文件的例程,有以下看法,不知对否,请教,参与有分!■■
- 我的连接池怎么找不到oracle驱动程序?
- 大虾们,帮帮我----怎样在两个Servlet之间通信?
- 我想用servlet來在ie里打開excel文件,但我一調用此servlet時,它就讓我下載此文件,何解呀,
- 如何关闭myeclipse悬浮提示
- 树形结构相关代码
我查了点资料
发现这道先可能是hibernate 的jar包引起的
将3.0的换成3.1的可以解决
若不行
还可能带参的hql来管理而不用拼接的hql
可以解决
二楼的思路是比较好的一种方法