JPA 动态查询

最新推荐文章于 2024-08-09 00:06:53 发布

新丨客

最新推荐文章于 2024-08-09 00:06:53 发布

阅读量1.1k

点赞数

分类专栏： JPA SpringBoot 文章标签： jpa

本文链接：https://blog.csdn.net/amberwangfeng/article/details/72820209

版权

SpringBoot 同时被 2 个专栏收录

10 篇文章 0 订阅

订阅专栏

JPA

8 篇文章 0 订阅

订阅专栏

JPA Repository 继承JpaSpecificationExecutor

public interface VwUserEstateRepository extends CrudRepository<VwUserEstate, Integer> , JpaSpecificationExecutor<VwUserEstate> {

写个方法处理动态查询

protected static Specification<VwUserEstate> queryNotSendByTerms(Integer projectId, Integer materialCodeId, Integer batchId, Integer estateTypeId, Integer estateSubTypeId, List<Integer> estateIds, Integer uid) {
        return new Specification<VwUserEstate>() {
            public Predicate toPredicate(Root<VwUserEstate> root, CriteriaQuery<?> query, CriteriaBuilder builder) {
                Predicate predicate = builder.conjunction();

                if (projectId != null) {
                    predicate.getExpressions().add(builder.equal(root.get(VwUserEstate_.projectId), projectId));
                }

                if (materialCodeId != null) {
                    predicate.getExpressions().add(builder.equal(root.get(VwUserEstate_.materialCodeId), materialCodeId));
                }

                if (batchId != null) {
                    predicate.getExpressions().add(builder.equal(root.get(VwUserEstate_.batchId), batchId));
                }

                if (estateTypeId != null) {
                    predicate.getExpressions().add(builder.equal(root.get(VwUserEstate_.estateTypeId), estateTypeId));
                }

                if (estateSubTypeId != null) {
                    predicate.getExpressions().add(builder.equal(root.get(VwUserEstate_.estateSubTypeId), estateSubTypeId));
                }

                Iterator iterator = estateIds.iterator();
                In in = builder.in(root.get(VwUserEstate_.id));
                while (iterator.hasNext()) {
                    in.value(iterator.next());
                }
                predicate.getExpressions().add(builder.not(in));


                predicate.getExpressions().add(builder.equal(root.get(VwUserEstate_.uid), uid));

                return predicate;
            }
        };
    }

调用动态查询

            Page<VwUserEstate> list = vwUserEstateRepository.findAll(where(queryNotSendByTerms(projectId, materialCodeId, batchId, estateTypeId, estateSubTypeId, estateIds, uid)), page);