使用hibernate实现mysql中limit的查询



给大家分享个知识点，hibernate 的hql不支持limit的使用。以后大家如果有限制查询从第几条至第几条时。就用

         List<SiteInvestment> investments = new ArrayList<SiteInvestment>();

        Session session = this.getSession();

        String hql = "from SiteInvestment as s where 1=1 and (s.xiangMuBanBen is null or s.xiangMuBanBen = '')";
      
//          hql += " and s.shenHeZhuangTai = 2 and s.siteshow = 1 order by s.createdate desc limit 0,20";

//          investments = this.getHibernateTemplate().find(hql);

            hql += " and s.shenHeZhuangTai = 2 and s.siteshow = 1 order by s.createdate desc ";

            Query createQuery = session.createQuery(hql);

            createQuery.setFirstResult(0);

            createQuery.setMaxResults(20);

            investments = createQuery.list();