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;
}
});
}