public static void main(String[] args) {
Configuration cfg = null;
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session= sf.openSession();
ts = session.beginTransaction();
Query query = session.createQuery("from user");
List<user> users = query.list();
int page;
if(users.size()/5!=0)
page= users.size()/5+1;
else
page = users.size()/5;
for (int i = 0; i <page ; i++) {
query.setFirstResult(i*5);
query.setMaxResults(5);
List result = query.list();
System.out.println("第"+(i+1) +"页");
for (int j = 0; j < result.size(); j++) {
user user = (user) result.get(j);
System.out.println(user.toString());
}
}
ts.commit();
} catch (HibernateException e) {
e.printStackTrace();
if(ts !=null){
ts.rollback();
}
}finally {
session.close();
sf.close();
}
}
结果