1.repository要继承JpaSpecificationExecutor<T>
如:public interface repository extends JpaRepository<T,Long>,JpaSpecificationExecutor<T>{
}
2.调用
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;
import javax.transaction.Transactional;
@Override
public Page<User> find(final String code,final int type) {
Specification<User> querySpec = new Specification<User>(){
@Override
public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
List<Predicate> predicates = new ArrayList<>();
try {
if(type>0){
//type code 是类的属性
predicates.add(cb.equal(root.get("type").as(Integer.class), type));
}
if(StringUtils.isNotEmpty(dcode)){
predicates.add(cb.like(root.get("code").as(String.class), "%"+code+"%"));
}
} catch (Exception e) {
e.printStackTrace();
}
return cb.and(predicates.toArray(new Predicate[predicates.size()]));
}
};
Sort sort = new Sort(Direction.DESC,"createTime");
Pageable pageable = new PageRequest(page, DEFAULT_PAGE_SIZE,sort);
Page<User> page = logRepository.findAll(querySpec,pageable);
return page;
}