jpa简单查询，and、or与分页排序的使用

传入分页参数pageable，和业务参数userId，查询用户id为空，创建时间为最近一个月的数据或用户id为userId的数据。

    @Override
    public Page<PushMessageDTO> findMessage(Pageable pageable,String userId) throws Exception {
        Page<PushMessage> page = PushMessageRepository.findAll(new Specification<PushMessage>() {
            @Override
            public Predicate toPredicate(Root<PushMessage> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder cb) {
                // 新发布制度标准的时间范围
                SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
                String begin = dateFormat.format(new Date());
                Calendar cl = Calendar.getInstance();
                cl.add(Calendar.MONTH, -1);            //一个月
                String end = dateFormat.format(cl.getTime());
                
                Path<Object> p_time = root.get("createTime");
                Path<Object> p_user = root.get("userId");
                
                Predicate p1 = cb.and(cb.isNull(p_user),cb.lessThanOrEqualTo(p_time.as(String.class), begin),cb.greaterThanOrEqualTo(p_time.as(String.class), end));
                Predicate p = cb.or(p1,cb.equal(p_user, userId));
                
                return p;
            }
        }, new PageRequest(pageable.getPageNumber()-1, pageable.getPageSize(),Sort.Direction.DESC,"createTime"));
        
        return page.map(new Converter<PushMessage, PushMessageDTO>() {
            @Override
            public PushMessageDTO convert(PushMessage PushMessage) {
                PushMessageDTO PushMessageDTO = new PushMessageDTO();
                BeanUtils.copyProperties(PushMessage, PushMessageDTO);
                return PushMessageDTO;
            }
        });
    }