Hhibernate分页查询
public void QueryByPage(int pageSize) {
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("select count(*) from User u ");
Number cnts = (Number) query.uniqueResult();
int UserCount = cnts.intValue();
int pageCount = 0;
pageCount = UserCount / pageSize;
if (UserCount % pageSize != 0) {
pageCount++;
}
Query query1 = session.createQuery("from User u");
for (int i = 0; i < pageCount; i++) {
System.out.println("第" + i + "页");
query1.setFirstResult(i * pageSize);
query1.setMaxResults(pageSize);
List<User> us = query1.list();
for (User u : us) {
System.out.println(u.toString());
}
}
ts.commit();
} catch (HibernateException e) {
e.printStackTrace();
if (ts != null) {
ts.rollback();
}
} finally {
}
}
结果图:![在这里插入图片描述](https://img-blog.csdnimg.cn/20210616171136526.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2p1aHVhaHVhbw==,size_16,color_FFFFFF,t_70)