java如何在Hibernate jpa中正确选择具有多个关系的实体
我有两个表(实体):
@Entity
@Table(name = "users")
@NamedQuery(name = "User.getAll", query = "SELECT c from User c")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id")
private Long id;
@NotNull
@Column(name = "LOGIN")
private String login;
@Column(name = "PASSWORD", length = 64)
private String password;
@Column(name = "SALT", length = 80)
private String salt;
@ManyToMany(cascade = CascadeType.PERSIST, fetch = FetchType.EAGER)
private Set<Role> roles;
@OneToMany(mappedBy = "user", fetch = FetchType.EAGER, cascade = CascadeType.ALL)
private Set<Permission> permissions;
及
@Entity
@Table(name = "roles")
@NamedQuery(name = "Role.getAll", query = "SELECT c from Role c")
public class Role {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id")
private Long id;
@Column(name = "ROLE_NAME", length = 100)
private String roleName;
@ManyToMany(mappedBy = "roles")
private Set<User> users;
和选择用户的方法:
@Override
public List<User> getUsersList() {
Criteria criteria = getSession().createCriteria(User.class);
return (List<User>)criteria.list();
}
我有2个用户。第一个用户有2个角色,第二个用户有1个角色。 但是这个方法返回我3个用户。具有2个角色的用户是dublicate
Itriedcriteria.createCriteria("", JoinType.NONE);
但这没有帮助
# 1 楼答案
您需要使用
criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
,请检查: criteria-distinct-root-entity-vs-projections-distinct