问题描述
我对HQL查询和hibernate有疑问。
I have a question with HQL query and hibernate.
我有一个用户类和一个角色类。用户可以拥有许多角色。所以我有这样的ManyToMany版本:
I have a user class and a role class. A user can have many roles. So I have a ManyToMany relatation like this:
在用户类中:
@ManyToMany(fetch = FetchType.LAZY)
@oinTable(name = "PORTAIL_USERROLE", joinColumns = { @JoinColumn(name = "USERID", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "ROLE", nullable = false, updatable = false) })
public Set<Portailrole> getPortailroles() {
return this.portailroles;
}
在角色等级中:
@ManyToMany(fetch = FetchType.LAZY)
@JoinTable(name = "PORTAIL_USERROLE", joinColumns = { @JoinColumn(name = "ROLE", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "USERID", nullable = false, updatable = false) })
public Set<Portailuser> getPortailusers() {
return this.portailusers;
}
此映射创建了第3个表(PORTAIL_USERROLE),其中存储了关系。
所有工作都很好。当我有一个用户时,我会检索角色。
This mapping has created a 3rd table (PORTAIL_USERROLE) where relations are stocked.All work fine like this. When I have a user, I retrieve roles.
但是,我的问题是:在HQL查询中,我如何获得具有特定角色的所有用户?任何类代表PORTAIL_USERROLE表,所以我不知道如何进行我的HQL查询。
But, my question is: in a HQL query, how can I get all users which have a specific role ? Any class represents PORTAIL_USERROLE table so I don't know how to make my HQL query.
推荐答案
这应该这样做:
from Portailuser u join u.portailroles r where r.name=:roleName
这篇关于HQL:使用ManyToMany进行Hibernate查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!