java - Ebean ManyToMany 与桥表查找所有查询

Question

我有三个表:用户(id，名称，登录名，密码)，角色(id，名称)，user_roles(id，user_id，role_id)

这是我的代码

@Entity
@Table(name = "users")
public class User extends Model {
    @Id
    public Long id;

    public String name;

    public String login;

    public String password;

    @ManyToMany
    @JoinTable(
            name = "user_roles",
            joinColumns = @JoinColumn(name = "user_id", referencedColumnName = "id"),
            inverseJoinColumns = @JoinColumn(name = "role_id", referencedColumnName = "id")
    )
    public Set<Role> roles;

    public static Finder<Integer, User> find = new Finder<>(User.class);
}

@Entity
@Table(name = "roles")
public class Role extends Model {
    @Id
    public Long id;

    public String name;

    @ManyToMany(mappedBy = "roles")
    public List<User> users;

    public static Finder<Integer, Role> find = new Finder<>(Role.class);
}

我想显示所有具有角色的用户，例如:{"id":1, "name":"我的名字", "login":"我的登录", "password":"我的密码", 角色: [{"name":"ADMIN"}, {"name":"USER"}]}我怎样才能做到这一点？我是 Ebean 和 ORM 的新手。感谢您的帮助。

更新

public Result all() {
    List<User> users = User.find.all();
    return ok(toJson(users));
}

但现在我收到 stackoverflow 错误无限递归。

Answer 1

使users.role = null然后返回Json