JPA CriteriaBuilder子查询方式

JPA CriteriaBuilder子查询方式

目录JPA CriteriaBuilder子查询Jpa 在CriteriaBuilder中添加where条件NotIn子查询

JPA CriteriaBuilder子查询

给自己做个备忘

/** 检索关键字 */

if (keyWord != null && !keyWord.trim().equals(""))

{

// 创建子查询对象

SdNjlFJPubquery subquery = criteriaQuery.subquery(Store.class);

root root2 = subquery.from(Store.class);

subhttp://query.select(root2. get("id"));

subquery.where(criteriaBuilder.like(root2. get("name"), "%" + keyWord + "%"));

// 给读者稍微解释一下，也给自己留个记忆

// 这里的意图是将关键做两个模糊检索，一个是在本表中检索title字段

// 就是criteriaBuilder.like(root. get("title"), "%" + keyWord + "%")

// 二是将字段与子表中的检索出来的id与本表中store字段做匹配

// crihttp://teriaBuilder.in(root.get("store")).value(subquery))

// 至于id怎么检索出来的，用子查询模糊检索出来的，参照上面的子查询

restrictions = criteriaBuilder.and(restrictions,criteriaBuilder.or(criteriaBuilder.like(root. get("title"), "%" + keyWord + "%"),criteriaBuilder.in(root.get("store")).value(subquery)));

}

Jpa 在CriteriaBuilder中添加where条件NotIn子查询

final CriteriaBuilder cb = entityManager.getCriteriaBuilder();

final CriteriaQuery cq = cb.createQuery(Person.class);

final Root root = cq.from(Person.class);

cq.select(root);

final Subquery subquery = cq.subquery(Integer.class);

final Root validityIDSQ = subquery.from(Person.class);

subquery.select(cb.max(validityIDSQ.get(Person_.validityID)));

subquery.groupBy(validityIDSQ.get(Person_.personID));

cq.where(cb.in(root.get(Person_.validityID)).value(subquery));

// 将生成

select

person0_.id as id1_0_,

person0_.personID as personID2_0_,

person0_.validityID as validity3_0_,

person0_.value as value4_0_

from

person person0_

where

person0_.validityID in (

select

max(person1_.validityID)

from

person person1_

group by

person1_.personID)

自身所需NotIn语法，所以是

Subquery manageUserSubquery = query.subquery(String.class);

Root relationUserManagePlateDomainRoot = manageUserSubquery.from(RelationUserManagePlateDomain.class);

Join relationUserManagePlateDomainUserDomainJoin = relationUserManagePlateDomainRoot.join(RelationUserManagePlateDomain_.user, JoinType.INNER);

Subquery subquery = manageUserSubquery.select(relationUserManagePlateDomainUserDomainJoin.get(UserDomain_.id));

Predicate predicate1 = criteriaBuilder.and(criteriaBuilder.not(criteriaBuilder.in(root.get(UserDomain_.id)).value(manageUserSubquery)));

predicate.getExpressions().add(predicate1);

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。