Specification使用notin

废话不多说直接贴代码

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

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

                //role_type 角色 为员工
                Predicate roleTypePredicate = criteriaBuilder.equal(root.get("roleType"),Constants.ROLE_TYPE_EMPLOYEE);
                predicateList.add(roleTypePredicate);

                //departmentId
                if(departmentId!=null){
                    Predicate departmentPredicate = criteriaBuilder.equal(root.get("department").get("id"),departmentId);
                    predicateList.add(departmentPredicate);
                }

                //去除已参加会议的人员 not in
                if(joinMeetingEmpIdList!=null&&!joinMeetingEmpIdList.isEmpty()){
                    Predicate joinMeetingEmpIdListInPredicate =  criteriaBuilder.not(root.get("id").in(joinMeetingEmpIdList));
                    predicateList.add(joinMeetingEmpIdListInPredicate);
                }

                return criteriaQuery.where(predicateList.toArray(new Predicate[predicateList.size()])).getRestriction();
            }
        };
        Pageable pageable = PageUtils.getPageable(pageIndex, pageSize);

        Page<Employee> page = this.employeeRespository.findAll(employeeSpecification, pageable);

个人微信公众，经常更新一些实用的干货: