“in subselect"的休眠标准 [英] Hibernate Criteria for "in subselect"
问题描述
我正在尝试做这样的事情,但使用 Criteria
而不是 HQL
:
I'm trying to do something like this, but using Criteria
instead of HQL
:
select user from User where user in (
select user from UserDomain where domain.id = "XXX"
)
User 是与连接表 UserDomain 具有 一对多
关系的实体.这里的重点只是找到链接到具有 id = "XXX" 的 Domain
的用户.
User being an entity having a one-to-many
relationship to the join table UserDomain.
The point here is simply to find Users that are linked to a Domain
having id = "XXX".
这看起来应该很简单……但到目前为止我还没有找到任何有用的文档.
This seems like it should be very simple... but I'm having no luck so far turning up any useful docs.
推荐答案
我终于找到了.事实证明这毕竟不是那么难......一旦你知道!
I finally found it. Turns out it wasn't so hard after all... once you know!
criteria = criteria.createCriteria(User.USER_DOMAINS).add(Restrictions.eq(UserDomain.DOMAIN, domain));
是的,有一个,在 Javadoc 中正盯着我的脸:http://www.dil.univ-mrs.fr/~massat/docs/hibernate-3.1/api/org/hibernate/Criteria.html
Yep, there is was, staring me right in the face in the Javadoc: http://www.dil.univ-mrs.fr/~massat/docs/hibernate-3.1/api/org/hibernate/Criteria.html
这篇关于“in subselect"的休眠标准的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!