hibernate+struts2分页查询的问题,永远都是第一页,为什么第一条sql语句对,第二条变样了
首先sql语句第1条select top 3 people0_.ID_ as ID1_0_, people0_.uname as uname0_, people0_.password as password0_, people0_.repassword as repassword0_ from People people0_
第2条select top 6 people0_.ID_ as ID1_2_, people0_.uname as uname2_, people0_.password as password2_, people0_.repassword as repassword2_ from People people0_为什么第2条sql语句是查询6条,而不是3条呢
也就是说为什么我的pageSize增加了一倍,我是要排除(pageNow-1)*pageSize条,查询pageSize条,求解啊
private pageNow=1;
private pageSize=3;(set和get方法默认)
public List find(int pageNow,int pageSize){
Configuration c=new Configuration();
c.configure();
SessionFactory f=c.buildSessionFactory();
Session session=f.getCurrentSession();
@SuppressWarnings("unused")
Transaction r=session.beginTransaction();
Query query= session.createQuery("from People");
query.setFirstResult(pageSize*(pageNow-1));
query.setMaxResults(pageSize);
List list=query.list();
session.close();
return list;
首先sql语句第1条select top 3 people0_.ID_ as ID1_0_, people0_.uname as uname0_, people0_.password as password0_, people0_.repassword as repassword0_ from People people0_
第2条select top 6 people0_.ID_ as ID1_2_, people0_.uname as uname2_, people0_.password as password2_, people0_.repassword as repassword2_ from People people0_为什么第2条sql语句是查询6条,而不是3条呢
也就是说为什么我的pageSize增加了一倍,我是要排除(pageNow-1)*pageSize条,查询pageSize条,求解啊
private pageNow=1;
private pageSize=3;(set和get方法默认)
public List find(int pageNow,int pageSize){
Configuration c=new Configuration();
c.configure();
SessionFactory f=c.buildSessionFactory();
Session session=f.getCurrentSession();
@SuppressWarnings("unused")
Transaction r=session.beginTransaction();
Query query= session.createQuery("from People");
query.setFirstResult(pageSize*(pageNow-1));
query.setMaxResults(pageSize);
List list=query.list();
session.close();
return list;
解决方案 »
- hibernate 同一个字段关联多个表的问题
- 关于dwr的一简单问题
- ejb3---关于实体作为数据传输对象
- jsp c:forEach 不同步的问题
- 请问struts2中如何读取cookie?急
- hibernate保存500个汉字以上就会报错?
- 急急急!!!!weblogic workshop里面自带的crystal report 可以在unix平台上用吗?
- ★(百分求解)applet能否调用web service★
- struts页面校验问题
- 上)各位有一份java assignment 不會做, 我連它的題目也看不懂, 各位java 高手可不可以幫幫忙.......
- 跪求quartz + spring + hibernate 详细完整配置教程
- spring真的那么有用吗,spring都能干些什么,(一个菜鸟的问题)
一般最好把你自己定好的pageSize作为常量定义在接口中
people0_.ID_ as ID1_0_,
people0_.uname as uname0_,
people0_.password as password0_,
people0_.repassword as repassword0_
from People people0_
where people0_id not in (select top 页大小 * (页数 - 1) id
from People people0_
order by people0_id)
这貌似才是分页语句的写法吧