HQL：使用ManyToMany进行Hibernate查询 [英] HQL: Hibernate query with ManyToMany

问题描述

我对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查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！