使用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();

阅读更多
文章标签: hibernate mysql limit
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

使用hibernate实现mysql中limit的查询

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭