hibernate hql 分页查询

  public PageFetch listChargeReminderUsers(final String userId,
            final String domainIds, final String startTime,
            final String endTime, final PageFetch pf)
            throws DataAccessException {
        return (PageFetch) this.getHibernateTemplate().execute(
                new HibernateCallback() {
                    public Object doInHibernate(Session session)
                    throws HibernateException {
                Map<String, Object> hmp = new HashMap<String, Object>();
                int pageNo = pf.getCurrentPage();
                int recordsPerPage = pf.getPageSize();

                //分别获取原始SQL、获取总数SQL、分页SQL
                String sql = getSql(userId,domainIds,startTime,endTime);
                String countSql = Tools.getCountSql(sql);
                String pagedSql = Tools.generatePageDivSql(sql, pageNo,recordsPerPage);

                //获取总数
                List list = session.createSQLQuery(countSql).addScalar("countnum", Hibernate.LONG).list();
                Long count =  (Long) list.get(0);
                hmp.put("count", count);

                SQLQuery sqlQuery = session.createSQLQuery(pagedSql);
                sqlQuery.addScalar("USERID", Hibernate.STRING);
                sqlQuery.addScalar("CUSTOMERNAME", Hibernate.STRING);
                sqlQuery.addScalar("CUSTOMERADDRESS", Hibernate.STRING);
                sqlQuery.addScalar("TOTALAMOUNT", Hibernate.DOUBLE);
                sqlQuery.addScalar("OWEFEEAMOUNT", Hibernate.DOUBLE);
                sqlQuery.addScalar("USERCOUNT", Hibernate.LONG);

                List records = sqlQuery.list();
                List<Map> result = new ArrayList<Map>();

                for (int i = 0; i < records.size(); i++) {
                    Object[] fields = (Object[]) records.get(i);
                    Map<String, Object> spUserCount = new HashMap<String, Object>();
                    spUserCount.put("userId", (String) fields[0]);
                    spUserCount.put("customerName", (String) fields[1]);
                    spUserCount.put("customerAddress", (String) fields[2]);
                    spUserCount.put("totalAmount", (Double) fields[3]);
                    spUserCount.put("oweFeeAmount", (Double) fields[4]);
                    spUserCount.put("userCount", (Long) fields[5]);
                    result.add(spUserCount);
                }
                hmp.put("records", result);
               
                //构造分页对象
                int start = (pageNo - 1) * recordsPerPage + 1;
                PageFetch returnPf = new PageFetch(result,count.intValue(),recordsPerPage,start);
               
                return returnPf;
            }
        });
    }