Criteria使用

iteye_6506

于 2009-12-14 15:00:22 发布

阅读量100

点赞数

分类专栏： Spring 文章标签： C C++ C#

本文链接：https://blog.csdn.net/iteye_6506/article/details/81799620

版权

Spring 专栏收录该内容

5 篇文章

订阅专栏

     public List<Item> findDateByPage(Pagination pagination, long cid){
         CriteriaProvider c = CriteriaProvider.getInstance();
         //建立关系...
         c.addAssociations(c.new Association("categories", "categories"));
         c.addAssociations(c.new Association("systemInfo", "systemInfo"));
         c.addAssociations(c.new Association("defaultCategory", "defaultCategory"));
          //Criteria多对多查询...
         c.addCriterion(Restrictions.or(Restrictions.eq("categories.objectId", cid), Restrictions.eq("defaultCategory.objectId", cid)));
         c.addCriterion(Restrictions.eq("enable", Boolean.TRUE));
         c.addOrder(Order.desc("systemInfo.createDate"));
         c.setDistinctRootEntity(true);//去重.
         
         return itemRepository.findFrontByPage(pagination, c);
     }