Hibernater HqlHibernater分页查询失败,查询结果为所有,原因:package com.tenni.test;import java.util.List;import org.hibernate.Query;import org.hibernate.Sessi ...
Hibernater分页查询失败,查询结果为所有,原因:
package com.tenni.test;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.Transaction;import org.junit.Test;import com.tenni.entity.Account;import com.tenni.entity.Service;import com.tenni.util.HibernateUtil;public class testHql { private Session session = HibernateUtil.getSession(); private Transaction ts = session.getTransaction(); @Test //分页查询 public void testPaging(){ int page=1, pageSize = 3,totalRows,from; String hql = "select count(*) from Service"; Query qry = session.createQuery(hql); totalRows =Integer.valueOf(qry.uniqueResult().toString()); System.err.println("所有的 数量 totalRows==="+totalRows); hql = "from Service order by id"; qry = session.createQuery(hql);//必须在设置起始和容量之前 from = (page-1)*pageSize; qry.setFirstResult(from);//设置起点,从0开始 qry.setMaxResults(pageSize);// 设置页容量 List<Service> list = qry.list(); for(Service a:list){ System.out.println(a.getId()+" "+a.getOsUserName()+" "+a.getLoginPassword()); } }}
原标题:Hibernate 学习笔记
关键词:Hibernate
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。