Specification排序orderby

最新推荐文章于 2023-01-11 19:57:54 发布

GoslingWu

最新推荐文章于 2023-01-11 19:57:54 发布

阅读量5.2k

点赞数 1

分类专栏： SpringBoot Java SpringDataJpa 文章标签： java spring

本文链接：https://blog.csdn.net/weixin_44204751/article/details/104234448

版权

SpringBoot 同时被 3 个专栏收录

33 篇文章 1 订阅

订阅专栏

Java

33 篇文章 0 订阅

订阅专栏

SpringDataJpa

2 篇文章 0 订阅

订阅专栏

废话不多说直接贴代码


        Specification<Course> sf = new Specification<Course>() {
            @Override
            public Predicate toPredicate(Root<Course> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
                List<Predicate> predicateList = Lists.newArrayList();

                //isDelete
                Predicate isDeletePredicate = criteriaBuilder.equal(root.get("isDelete"), Constant.NOT_DELETE);
                predicateList.add(isDeletePredicate);

                //isShelves
                Predicate isShelvesPredicate = criteriaBuilder.equal(root.get("isShelves"),Constant.COURSE_SHELVES_YES);
                predicateList.add(isShelvesPredicate);

                //categoryId
                if(categoryId!=null){
                    Predicate predicate = criteriaBuilder.equal(root.get("category").get("id"), categoryId);
                    predicateList.add(predicate);
                }

                //isRecommend
                if(isRecommend!=null){
                    Predicate predicate = criteriaBuilder.equal(root.get("isRecommend"), isRecommend);
                    predicateList.add(predicate);
                }

                /**
                 * order By
                 */
                Order weightOrder = criteriaBuilder.desc(root.get("weight"));
                Order createDateOrder = criteriaBuilder.desc(root.get("createDate"));

                return  criteriaQuery.orderBy(weightOrder, createDateOrder).where(predicateList.toArray(new Predicate[predicateList.size()])).getRestriction();

            }
        };