spring boot 复杂多条件分页排序列表查询

Controller层就不写了，主要贴一下Service代码。

Service

import org.springframework.beans.factory.annotation.Autowired;import org.springframework.data.domain.Page;import org.springframework.data.domain.PageRequest;import org.springframework.data.domain.Pageable;import org.springframework.data.domain.Sort;import org.springframework.data.jpa.domain.Specification;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import javax.persistence.criteria.CriteriaBuilder;import javax.persistence.criteria.CriteriaQuery;import javax.persistence.criteria.Predicate;import javax.persistence.criteria.Root;@Service("operatingRecordService")@Transactionalpublic class OperatingRecordService { @Autowired private OperatingRecordRepository operatingRecordRepository;/** * 分页列表模糊 查询 *  * @param page * @param rows * @param operatingRecordVO * @return */public Page<OperatingRecordVO> findPageList(Integer page,Integer rows,OperatingRecordVO operatingRecordVO){page = (page == null) ? 1 : page;rows = (rows == null) ? 10 : rows;Pageable pageable = new PageRequest(page - 1, rows, Sort.Direction.DESC,"id");//id倒序排列return (Page<OperatingRecordVO>) operatingRecordRepository.findAll(new Specification() {@Overridepublic Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder cb) {//操作对象 模糊查询if (!StringUtil.isBlank(operatingRecordVO.getObjects())) {Predicate objects ;objects = cb.like(root.get("objects"), "%"+operatingRecordVO.getObjects()+"%");query.where(objects);}//操作类型  精确查询if (operatingRecordVO.getType()!= null && !"".equals(operatingRecordVO.getType())) {Predicate type ;type = cb.equal(root.get("type"), operatingRecordVO.getType());query.where(type);}//操作状态if (operatingRecordVO.getStatus()!= null && !"".equals(operatingRecordVO.getStatus())) {Predicate status ;status = cb.equal(root.get("status"), operatingRecordVO.getStatus());query.where(status);}return null;};}, pageable);};}

OperatingRecordRepository

import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.data.jpa.repository.JpaSpecificationExecutor;import org.springframework.stereotype.Repository;import org.springframework.transaction.annotation.Propagation;import org.springframework.transaction.annotation.Transactional;@Repository@Transactional(propagation = Propagation.NESTED)public interface OperatingRecordRepository extends JpaRepository<OperatingRecordVO, Integer> , JpaSpecificationExecutor<OperatingRecordVO> {}