67,513
社区成员
发帖
与我相关
我的任务
分享
public class TbtagDAO extends DefaultDAO {
/**
*分页时:每页显示记录条数
*/
public Integer numPP = 20;
/**
* 当执行查询操作后,count将记录按当前查询条件查询到的结果的总条数
*/
private Long count = 0L;
/**
* 按页查询所有标签记录
* @param page - 页码
* @param numPP - 每页记录数
* @return
*/
public List findAll(Integer page,Integer numPP) {
log.debug("finding all Tbtag instances");
try {
if(page<0){
page = 1;
}
String queryString = "from Tbtag";
Session session = getSession();
String sql = "select count(tag_id) from Tbtag";
Query query = session.createSQLQuery(sql);
BigInteger c = (BigInteger)query.uniqueResult();
this.count = c.longValue();
Query queryObject = session.createQuery(queryString);
queryObject.setFirstResult((page-1)*numPP);
queryObject.setMaxResults(numPP);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}
}