JPA--Specification的使用

最新推荐文章于 2024-04-06 14:34:23 发布

烟雨平生ing

最新推荐文章于 2024-04-06 14:34:23 发布

阅读量1.1k

点赞数

分类专栏：工作文章标签： java

本文链接：https://blog.youkuaiyun.com/qq_44058265/article/details/124375066

版权

工作专栏收录该内容

5 篇文章

订阅专栏

Specification<RetMtrlSpare> specification = (root, criteriaQuery, criteriaBuilder) -> {
            List<Predicate> predicates = new ArrayList<>();
            if (CollectionUtils.isNotEmpty(mtrlStatList)) {
                predicates.add(root.get("mtrlStat").in(mtrlStatList));
            }
            if (StringUtils.isNotBlank(iary.getMtrlProdId())) {
                predicates.add(criteriaBuilder.equal(root.get("mtrlProdId"), iary.getMtrlProdId()));
            }
            if (StringUtils.isNotBlank(iary.getMtrlDsc())) {
                predicates.add(criteriaBuilder.equal(root.get("mtrlDsc"), iary.getMtrlDsc()));
            }
            if (StringUtils.isNotBlank(iary.getMtrlType())) {
                predicates.add(criteriaBuilder.equal(root.get("mtrlTyp"), iary.getMtrlType()));
            }
            if (StringUtils.isNotBlank(iary.getMtrlSeqId())) {
                predicates.add(criteriaBuilder.equal(root.get("mtrlSeqId"), iary.getMtrlSeqId()));
            }
            if (CollectionUtils.isNotEmpty(toolIdList)) {
                predicates.add(root.get("toolId").in(toolIdList));
            }
            if (CollectionUtils.isNotEmpty(actToolList)) {
                predicates.add(root.get("actToolId").in(actToolList));
            }
            if (CollectionUtils.isNotEmpty(deptList)) {
                predicates.add(root.get("dept").in(deptList));
            }
            if (CollectionUtils.isNotEmpty(actDeptList)) {
                predicates.add(root.get("actDept").in(actDeptList));
            }
            if (StringUtils.isNotBlank(iary.getMtrlCate())) {
                predicates.add(criteriaBuilder.equal(root.get("mtrlCate"), iary.getMtrlCate()));
            }
            Predicate[] p = predicates.toArray(new Predicate[0]);
            return criteriaBuilder.and(p);
        };
        Sort sort = Sort.by(Sort.Direction.DESC, "moveinTimestamp");

        List<RetMtrlSpare> retMtrlSpareList;
        long tblCnt = 0l;
        //判断分页
        if (com.totainfo.common.util.Util.shouldPage(inTrx)) {
        //按分页和排序查询
            Page<RetMtrlSpare> retMtrlSparePage = retMtrlSpareDao.findAll(specification, com.totainfo.common.util.Util.getPageable(inTrx, sort));
            retMtrlSpareList = retMtrlSparePage.getContent();
            tblCnt = retMtrlSparePage.getTotalElements();
        } else {
            retMtrlSpareList = retMtrlSpareDao.findAll(specification, sort);
        }