hibernate 中的query的分頁查詢

標籤：資料   os   io   new   amp   res   

//方法描述：根據會員名稱和頁容量分頁查詢代理人
 public List<HbUser> findUserByPage(int page,int pageSize, String userName)
   throws Exception {
  Session session = sessionFactory.getCurrentSession();
  StringBuffer hql = new StringBuffer("from HbUser where isDelete = 0 and " +
    "auditStatus = 3  and postId in (1,2,3,4) ");//建立一個字元緩衝 隊列
  //如果userName不為空白 或者Null 字元串 就對StringBuffer進行拼接
  if(userName != null && userName.trim().length() != 0){
   hql.append(" and userName LIKE ‘%"+userName+"%‘");
  }
  Query query = session.createQuery(hql.toString());
  query.setFirstResult((page - 1) * pageSize);//從page頁第一條記錄開始
  query.setMaxResults(pageSize);//頁容量
  if(query.list().size() != 0){
   return query.list();
  }
  return null;
 }

查詢總的頁數

 public int findUserTotalPage(int pageSize, String userName) throws Exception {
  Session session = sessionFactory.getCurrentSession();
  StringBuffer hql = new StringBuffer("select count(userId) from HbUser where " +
    " isDelete = 0 and auditStatus = 3 and postId in (1,2,3,4) ");//建立一個字元緩衝 隊列
  //如果userName不為空白 或者Null 字元串 就對StringBuffer進行拼接
  if(userName != null && userName.trim().length() != 0){
   hql.append(" and userName LIKE ‘%"+userName+"%‘");
  }
  Query query = session.createQuery(hql.toString());
  Long num = (Long)query.uniqueResult();
  long numn = num;//把Long對象拆裝成long基本類型
  int totalPage = (int) numn;//把long類型的資料強制轉換成int類型
  return totalPage;
 }