jap多表动态条件分页toPredicate

注意：实体内需注明表关系@OneToMany,@ManyToOne,@ManyToMany,@OneToOne

public Page<DeviceEntity> findPage(LocalDateTime begin, LocalDateTime end, int page, int pageSize) {
    Page<DeviceEntity> deviceEntityPage = deviceRepository.findAll(new Specification<DeviceEntity>() {
        @Override
        public Predicate toPredicate(Root<DeviceEntity> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
            List<Predicate> predicateList = Lists.newArrayList();

            Join<DeviceEntity,RegionDeviceEntity> drJoin = root.join("regions",JoinType.LEFT);
            Join<RegionDeviceEntity,RegionEntity> rrJoin = drJoin.join("region",JoinType.LEFT);
            Join<RegionEntity,ParkEntity> rpJoin = rrJoin.join("park",JoinType.LEFT);

            if (begin != null) {
                predicateList.add(criteriaBuilder.greaterThanOrEqualTo(root.get("operatedAt"),begin));
            }
            if (end != null) {
            predicateList.add(criteriaBuilder.lessThanOrEqualTo(root.get("operatedAt"),end));
            }            
            return criteriaBuilder.and(predicateList.toArray(new Predicate[predicateList.size()]));
        }
    },PageRequest.of(page,pageSize, new Sort(Sort.Direction.DESC, "id")));
    return deviceEntityPage;
}

看的时候需要对jpa分页有一定了解的，如有需要可直接留言。