package com.habernat.dao;
import java.util.List;
public class QueryResult<T> {
private List<T> list;
private Long count;
public QueryResult(List<T> list, Long count) {
super();
this.list = list;
this.count = count;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
public Long getCount() {
return count;
}
public void setCount(Long count) {
this.count = count;
}
}<pre name="code" class="java">package com.habernat.dao;
import java.util.List;
import javax.jms.Session;
import javax.management.Query;
import javax.security.auth.login.Configuration;
import javax.transaction.Transaction;
public class UserDao {
private static sessionFactory sessionFactory;
static{
//读取配置文件并生成session工厂
Configuration cfg=new Configuration();
cfg.configure("haberbate.cfg.xml");
sessionFactory=cfg.buildSessionFactory();
}
public QueryResult<User> findAll(int firstResult,int maxResult){
Session session=sessionFactory.opensession();
Transaction ts=null;
try {
ts=session.beginTransaction();
Long count=(Long) session.createQuery(
"select count(*) from user")
。uniqueResult();
Query query=session.creatQuery();
query.setFisrtResult(firstResult);
query.setMaxResults(maxResult);
List<User> list=query.list();
ts.commit();
return new QueryResult<User>(list, count);
} catch (Exception e) {
// TODO: handle exception
}finally{
session.close();
}
}
}
habernate分页显示信息列表
最新推荐文章于 2021-06-16 17:19:33 发布