springboot-jpa 条件分页

package com.example.service.impl; import java.util.ArrayList; import java.util.List; import javax.persistence.criteria.CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery; import javax.persistence.criteria.Path; import javax.persistence.criteria.Predicate; import javax.persistence.criteria.Root; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.cache.annotation.Cacheable; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.domain.Specification; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.example.dao.UserJpaRepository; import com.example.domain.User; import com.example.service.IUserService; @Service @Transactional public class UserServiceImpl implements IUserService { @Autowired private UserJpaRepository userJpaRepository; public List<User> findAll() { return userJpaRepository.findAll(); } public void saveUser(User book) { userJpaRepository.save(book); } @Cacheable("users") public User findOne(long id) { System.out.println("Cached Pages"); return userJpaRepository.findOne(id); } public void delete(long id) { userJpaRepository.delete(id); } @Transactional public Page<User> findAllComments(String problemId, PageRequest pageable) { Page<User> page = userJpaRepository.findAllCommentsByProblemId( problemId, pageable); // userJpaRepository.findAll(arg0) return page; } public Page<User> findAllByLikeName(String name, int page, int count) { Specification<User> specification = new Specification<User>() { @Override public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder criteriaBuilder) { Path<String> _name = root.get("name"); Predicate _key = criteriaBuilder.like(_name, "%" + name + "%"); return null; } }; // Sort sort = new Sort(Direction.DESC, "id"); Pageable pageable = new PageRequest(page - 1, count); return userJpaRepository.findAll(specification, pageable); } public Page<User> findAllBy(User user, int page, int count) { Pageable pageable = new PageRequest(page - 1, count); return userJpaRepository.findAll(new Specification<User>() { public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) { List<Predicate> predicates = new ArrayList<>(); if (null != user.getName()) { Path<String> namePath = root.get("address"); Path<String> nicknamePath = root.get("name"); /** * 连接查询条件, 不定参数，可以连接0..N个查询条件 */ query.where(cb.like(namePath, "%qq%"), cb.like(nicknamePath, "%3%")); // 这里可以设置任意条查询条件 } return null; } }, pageable); } public Page<User> findByCondition(User user, int page, int count) { Pageable pageable = new PageRequest(page - 1, count); Specification<User> querySpecifi = new Specification<User>() { @Override public Predicate toPredicate(Root<User> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) { List<Predicate> predicates = new ArrayList<>(); // if(null != user.getName()){ // predicates.add(criteriaBuilder.greaterThan(root.get("subscribeTime"), // minDate)); // } // if(null != maxDate){ // predicates.add(criteriaBuilder.lessThan(root.get("subscribeTime"), // maxDate)); // } if (null != user.getName()) { predicates.add(criteriaBuilder.like(root.get("name"), "%" + user.getName() + "%")); } return criteriaBuilder.and(predicates .toArray(new Predicate[predicates.size()])); } }; Page<User> resultList = userJpaRepository.findAll(querySpecifi, pageable); return resultList; } }