公众号:架构师与哈苏
关注公众号进入it交流群! 公众号:架构师与哈苏 不定时都会推送一些实用的干货。。。

废话不多说直接贴代码


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

            }
        };

posted on 2020-09-21 10:57  公众号/架构师与哈苏  阅读(1434)  评论(0)    收藏  举报