Predicate 条件查询，分页，排序

@RequestMapping(value = "all", method = RequestMethod.GET, produces = "application/json")
    @ResponseBody
    public  List<SysUser> sus1(String s,String d) {
        Pageable pageable = new PageRequest(0,2);
        List<Predicate> list = new ArrayList<>();
        Page<SysUser> all = sysUserRepository.findAll(new Specification<SysUser>() {
            @Override
            public Predicate toPredicate(Root<SysUser> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
                if (StringUtils.isNotBlank(s)) {
                    Predicate names = cb.like(root.get("loginName").as(String.class), "%" + s + "%");
                    list.add(names);
                }
                if (StringUtils.isNotBlank(d)) {
                    Predicate named = cb.equal(root.get("displayName").as(String.class), d);
                    list.add(named);
                }
                Predicate [] predicate = new Predicate[list.size()];
                query.where(cb.and(list.toArray(predicate)));
                query.orderBy(cb.desc(root.get("loginName").as(String.class)));
                return query.getRestriction();
            };
        },pageable);
        return  all.getContent();
    }