JPA多条件查询

1.controller

/** * 获取查询任务列表 * <p>type为任务类型，1清点，2验收，3验收，4消毒 */ @PostMapping(value = "/listPage/{type}") public EasyUIPagination getPageStorageTaskList(@PathVariable("type") Integer type, SterilizeTaskVo sterilizeTaskVo, QueryTaskListVo params) throws Exception { Page<InventoryCheckTaskListVo> page = storageTaskService.getPageStorageTaskList(type,sterilizeTaskVo,params); return PageToPaginationUtil.toPagination(page); }

2.impl

@Override public Page<InventoryCheckTaskListVo> getPageStorageTaskList(Integer type, SterilizeTaskVo sterilizeTaskVo, QueryTaskListVo params) throws Exception { //分页 Pageable pageable = JpaUtil.getPagebleBySort(params.getOrder(), params.getSort(), params.getPage(), params.getRows()); //查询条件 Specification<InventoryCheckTask> spec = (root, query, cb) -> { List<Predicate> list = new ArrayList<>(); //任务类型 if (type != null) { Predicate typePre = cb.equal(root.get("taskType").as(Integer.class), type); list.add(typePre); } //所属客户 if (StringUtils.isNotBlank(sterilizeTaskVo.getCustomer())) { list.add(cb.equal(root.get("customer").get("id").as(String.class), sterilizeTaskVo.getCustomer())); } //所属机构模糊查询 if (StringUtils.isNotBlank(sterilizeTaskVo.getCustomerOrgName())) { list.add(cb.like(root.get("customerOrg").get("name").as(String.class), "%"+sterilizeTaskVo.getCustomerOrgName()+"%")); } //所属状态 if (StringUtils.isNotBlank(sterilizeTaskVo.getStatus())) { list.add(cb.equal(root.get("status").as(Integer.class), sterilizeTaskVo.getStatus())); } //开始日期 if (StringUtils.isNotBlank(sterilizeTaskVo.getSterilizeTimeStart())) { list.add(cb.greaterThanOrEqualTo(root.get("createDate").as(String.class), sterilizeTaskVo.getSterilizeTimeStart())); } //结束日期 if (StringUtils.isNotBlank(sterilizeTaskVo.getSterilizeTimeEnd())) { //日期加1 DateTimeFormatter timeDtf = DateTimeFormatter.ofPattern("yyyy-MM-dd"); LocalDate localDate = LocalDate.parse(sterilizeTaskVo.getSterilizeTimeEnd(), timeDtf); String tmp = localDate.plusDays(1).format(timeDtf); list.add(cb.lessThan(root.get("createDate").as(String.class), tmp)); } return cb.and(list.toArray(new Predicate[list.size()])); }; //查询结果 Page<InventoryCheckTask> page = inventoryCheckTaskRepository.findAll(spec, pageable); if(page==null || page.getTotalElements()<1) { return new PageImpl<>(new ArrayList<>(0), pageable, 0); } List<InventoryCheckTask> lists = page.getContent(); if(lists!=null && lists.size()>0) { List<InventoryCheckTaskListVo> arr = InventoryCheckTaskListVo.taskData2Vo(lists); return new PageImpl<>(arr, pageable, page.getTotalElements()); } return new PageImpl<>(new ArrayList<>(0), pageable, 0); }

3.JPAUtil

public class JpaUtil { /** * 获取排序分页查询条件 * @param order 升序降序 * @param sortStr 字段 * @param page 页数 * @param rows 条数 * @return */ public static Pageable getPagebleBySort(String order,String sortStr,Integer page,Integer rows) { Sort sort = null; Pageable pageable = null; if(sortStr!=null && !"".equals(sortStr)) { if(order==null || "".equals(order)){ sort = Sort.by(Sort.Direction.ASC, sortStr); }else{ sort = Sort.by(Sort.Direction.fromString(order), sortStr); } pageable = PageRequest.of(page - 1, rows,sort); }else { pageable = PageRequest.of(page - 1, rows); } return pageable; } /** * 获取排序分页查询条件 * @param pageParams 分页封装参数 * @return */ public static Pageable getPagebleByPageParams(EasyUIPagingationParam pageParams) { return getPagebleBySort( pageParams.getOrder(), pageParams.getSort(), pageParams.getPage(), pageParams.getRows()); } }