带有谓词的条件构建器 [英] Criteria Builder with predicate

问题描述

我有要从属性文件中读取的对象列表，然后将其与管道符号分开，然后需要使用or子句进行应用. 下面是代码. 当我尝试应用builder.or时，以下查询将被替换，而不是or子句.

I have list of object which I will read from property file and then I will split with pipe symbol and then I need to apply with or clause. Below is the code. When I try to apply builder.or the below query is getting genareted, instead of or clause.

    String coverageNames = env.getRequiredProperty(AmhiConstants.COVERAGE_NAME);
    String[] coverageName = coverageNames.split(Pattern.quote("|"));
    CriteriaBuilder builder = manager.getCriteriaBuilder();
    TypedQuery typedQuery;
    CriteriaQuery<Integer> criteriaQuery = builder.createQuery(Integer.class);
    Root<BenefitCounter> root = criteriaQuery.from(BenefitCounter.class);
    Join<BenefitCounter, BenefitCounterCoverageDetails> benefitCoverageJoin = root
            .join(BenefitCounter_.benefitCoverageDetails);
    Join<BenefitCounterCoverageDetails, CoverageMaster> coveJoin = benefitCoverageJoin
            .join(BenefitCounterCoverageDetails_.coverageType);
    List<Predicate> conditions = new ArrayList<>();

    conditions.add(builder.and(builder.equal(root.get(BenefitCounter_.isCompleted), 'N')));
    for (String coverage : coverageName) {
        Predicate predicate = builder.like(builder.lower(coveJoin.get(CoverageMaster_.coverageName)),
                AmhiConstants.PERCENTAGE_SYMBOL + coverage + AmhiConstants.PERCENTAGE_SYMBOL);
        conditions.add(conditions.add(builder.or(predicate));

    }

    criteriaQuery.multiselect(root.get(BenefitCounter_.benefitCounterId))
            .where(conditions.toArray(new Predicate[] {}));


    criteriaQuery.orderBy(builder.asc(root.get(BenefitCounter_.benefitCounterId)));
    criteriaQuery.distinct(true);
    typedQuery = manager.createQuery(criteriaQuery);
    List<Integer> list = typedQuery.getResultList();
    return list;

生成的查询:

select distinct benefitcou0_.utilization_dtl_id as col_0_0_ from claims.utilization_dtls benefitcou0_ inner join claims.utilization_coverage_dtls benefitcov1_ on benefitcou0_.utilization_dtl_id=benefitcov1_.utilization_dtl_id inner join claims.coverage_master coveragema2_ on benefitcov1_.coverage_id=coveragema2_.coverage_id where (lower(coveragema2_.coverage_name) like ?) and (lower(coveragema2_.coverage_name) like ?) and (lower(coveragema2_.coverage_name) like ?) and (lower(coveragema2_.coverage_name) like ?) and benefitcou0_.is_completed=? order by benefitcou0_.utilization_dtl_id asc

需要实际查询:

select distinct benefitcou0_.utilization_dtl_id as col_0_0_ from claims.utilization_dtls benefitcou0_ inner join claims.utilization_coverage_dtls benefitcov1_ on benefitcou0_.utilization_dtl_id=benefitcov1_.utilization_dtl_id inner join claims.coverage_master coveragema2_ on benefitcov1_.coverage_id=coveragema2_.coverage_id where (lower(coveragema2_.coverage_name) like ?) or (lower(coveragema2_.coverage_name) like ?) or(lower(coveragema2_.coverage_name) like ?) or (lower(coveragema2_.coverage_name) like ?) and benefitcou0_.is_completed=? order by benefitcou0_.utilization_dtl_id asc

推荐答案

这是因为

This is because CriteriaQuery<T>.where(Predicate... restrictions), which is the method you are using, according to JavaDoc,

...根据指定的限制谓词的并集修改查询以限制查询结果

...Modify the query to restrict the query result according to the conjunction of the specified restriction predicates

连接词表示一组和"谓词.为了获得或"，必须使用

Conjunction means a set of "and" predicates. In order to get the "or", you have to use use CriteriaBuilder.or(Predicate... restrictions):

Predicate andPredicate = builder.equal(root.get(BenefitCounter_.isCompleted), 'N');
for (String coverage : coverageName) {
    Predicate predicate = builder.like(builder.lower(coveJoin.get(CoverageMaster_.coverageName)),
            AmhiConstants.PERCENTAGE_SYMBOL + coverage + AmhiConstants.PERCENTAGE_SYMBOL);
    conditions.add(predicate);

}
Predicate orPredicate = builder.or(conditions.toArray(new Predicate[] {}));
Predicate andPredicate = builder.and(andPredicate, orPredicate);

criteriaQuery.multiselect(root.get(BenefitCounter_.benefitCounterId))
        .where(andPredicate);

这篇关于带有谓词的条件构建器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！