Hibernate Hql 做查询和hibernateArgs 说明

      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;

      }