public Pager queryManagerMessageCombinationWithPager(
HttpServletRequest request) throws Exception {
Date[] currentDate = new Date[1];
currentDate[0] = DateOperation2.getCurrentDate();
KissHibernateArgs hibernateArgs = new KissHibernateArgs();
/* select conditioned car arrangement from the table */
hibernateArgs
.addHql(//(HQL, HQL里面的参数)
"FROM ManagerMessageCombination AS MMC WHERE MMC.isDeleted = 'N' AND MMC.managermessageEnddate >= ? ORDER BY MMC.managermessageID ",
currentDate);
PageInfo pageInfo = new PageInfo(3);
Pager pager = dbAccess.executeQueryWithPager(request, session,
hibernateArgs, pageInfo);
return pager;
}