2019-02-26

                            spring JPA 查询-分页方法以及模糊查询的一些记录

                      1：简单的分页查询

                        Sort sorts =new Sort( Sort.Direction.DESC, "createTime");

    Sort sorts =new Sort( Sort.Direction.DESC, "createTime");

Pageable pageable = PageRequest.of(pageNum -1, pageSize, sorts);

Page pages=merchantOrderRepository.findAll((Specification) (root, query, cb) -> {

List list =new ArrayList<>();

    if (null !=serviceType) {

Expression exp = root.get("serviceType");

        List serviceTypeList =new ArrayList<>();

        if(serviceType ==1){

serviceTypeList.add("0");

            serviceTypeList.add("1");

        }else if(serviceType ==2){

serviceTypeList.add("2");

        }

list.add(exp.in(serviceTypeList));

    }

if (null !=orderStatus) {

list.add(cb.equal(root.get("status"), orderStatus));

    }

if (!ObjectUtils.isEmpty(technician.getId())) {

list.add(cb.equal(root.get("technicianId"), technician.getId()));

    }

Predicate[] p =new Predicate[list.size()];

    return cb.and(list.toArray(p));

}, pageable);

2:自带模糊查询

Sort sorts =new Sort(Sort.Direction.DESC, "createTime");

PageRequest pageRequest =new PageRequest(page -1, pageSize, sorts);

//分页查询

Page merchants =merchantReposotory.findAll(new Specification() {

@Override

    public PredicatetoPredicate(Root root, CriteriaQuery criteriaQuery, CriteriaBuilder cb) {

Predicate predicate = cb.conjunction();

        if (merchant !=null){

if (!StringUtils.isEmpty(merchant.getName())){

predicate.getExpressions().add(cb.like(root.get("name"),"%"+merchant.getName()+"%"));

            }

if (null !=merchant.getStatus()) {

predicate.getExpressions().add(cb.equal(root.get("status"), merchant.getStatus()));

            }

if (null !=merchant.getBusinessStatus()) {

predicate.getExpressions().add((cb.equal(root.get("businessStatus"), merchant.getBusinessStatus())));

            }

if (!StringUtils.isEmpty(merchant.getProvinceId())) {

predicate.getExpressions().add((cb.equal(root.get("provinceId"), merchant.getProvinceId())));

            }

if (!StringUtils.isEmpty(merchant.getCityId())) {

predicate.getExpressions().add(cb.equal(root.get("cityId"), merchant.getCityId()));

            }

}

return predicate;

    }

}, pageRequest);