HQL：使用 ManyToMany 进行 Hibernate 查询

发布于 2024-09-13 20:18:55 字数 987 浏览 1 评论 0原文

我对 HQL 查询和 hibernate 有疑问。

我有一个用户类和一个角色类。一个用户可以拥有多个角色。所以我有一个像这样的多对多关系：

在用户类中：

@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;
}

该映射创建了第三个表（PORTAIL_USERROLE），其中存储了关系。像这样一切工作都很好。当我有用户时，我会检索角色。

但是，我的问题是：在 HQL 查询中，如何获取具有特定角色的所有用户？任何类都代表 PORTAIL_USERROLE 表，所以我不知道如何进行 HQL 查询。

原文

I have a question with HQL query and hibernate.

I have a user class and a role class. A user can have many roles. So I have a ManyToMany relatation like this:

In user class:

@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;
}

In role class:

@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;
}

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.

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.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

好久不见√ 2024-09-20 20:18:55

这应该可以做到：

from Portailuser u join u.portailroles r where r.name=:roleName

This should do it:

from Portailuser u join u.portailroles r where r.name=:roleName

回复收藏 0 原文

梦毁影碎の 2024-09-20 20:18:55

你可以使用
@WhereJoinTable
像这样：

 @JoinTable(name = "OFFICE_USER_POSITION", joinColumns = {
        @JoinColumn(name = "user_id", referencedColumnName = "id")}, inverseJoinColumns = {
        @JoinColumn(name = "POST_ID", referencedColumnName = "id")})
@WhereJoinTable(clause = "primary_flag='" + YES + "' and del_flag='" + DEL_FLAG_NORMAL + "'")

you can use
@WhereJoinTable
Like this:

 @JoinTable(name = "OFFICE_USER_POSITION", joinColumns = {
        @JoinColumn(name = "user_id", referencedColumnName = "id")}, inverseJoinColumns = {
        @JoinColumn(name = "POST_ID", referencedColumnName = "id")})
@WhereJoinTable(clause = "primary_flag='" + YES + "' and del_flag='" + DEL_FLAG_NORMAL + "'")

回复收藏 0 原文

他不在意 2024-09-20 20:18:55

您可以将这些功能用于一个或多个 @MoneyToMany 相关实体

List<User> findUsersByRoles_RoleIdIn(List<Integer> roles);

List<User> findUserByRoles_RoleIdInAndHoldings_HoldingId(List<Integer> roles, Integer holding);

You can use these features for one or more @MoneyToMany related entities

List<User> findUsersByRoles_RoleIdIn(List<Integer> roles);

List<User> findUserByRoles_RoleIdInAndHoldings_HoldingId(List<Integer> roles, Integer holding);

回复收藏 0 原文

~没有更多了~