任何人都可以帮我获取下面提到的 JPA 查询的 JPA 标准查询。
SELECT p,l FROM Person p
LEFT JOIN Language l ON (p.language = l.language and l.locale like :locale)
AND p.name like :name
AND p.time BETWEEN :startDate
AND :endDate order by name asc
假设 Person 与 Language 有关系,您将在旧版 Hibernate 中执行以下操作:
Criteria criteria = entityManager.createCriteria(Person.class);
Criteria languageCriteria = criteria.createCriteria("language");
languageCriteria.add(Restrictions.like("locale", locale));
criteria.add(Restrictions.like("name", name));
criteria.add(Restrictions.between("time", startDate, endDate));
criteria.addOrder(Order.asc("name"));
我第一次尝试 JPA 2.0:
CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery<Person> criteria = builder.createCriteria(Person.class);
Root<Person> pRoot = criteria.from(Person.class);
Join<Person, Language> langJoin = criteria.join("language", JoinType.LEFT);
Predicate conjunction = builder.conjunction();
criteria.where(builder.and(
builder.like(langJoin.get(Language_.locale), locale),
builder.like(pRoot.get(Person_.name), name),
builder.between(pRoot.get(Person_.time), startDate, endDate));
criteria.orderBy(builder.asc(pRoot.get(Person_.name)));
请告诉我这是否适合您。
Edit:更新了查询以仅使用一个where
call.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)