关闭

使用hibernate实现mysql中limit的查询

标签: hibernatemysqllimit
129人阅读 评论(0) 收藏 举报


给大家分享个知识点,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();

1
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:43051次
    • 积分:777
    • 等级:
    • 排名:千里之外
    • 原创:21篇
    • 转载:93篇
    • 译文:0篇
    • 评论:5条
    文章分类
    最新评论