带有谓词的条件构建器

问题描述

我有要从属性文件中读取的对象列表，然后将其与管道符号分开，然后需要使用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

推荐答案

这是因为 CriteriaQuery<T>.where(Predicate... restrictions) ，根据JavaDoc，这是您正在使用的方法

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

连接词表示一组和"谓词.为了获得或"，必须使用 CriteriaBuilder.or(Predicate... restrictions) :

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);

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