i have a question about the hibernate many to many query.
@Entity
@Table(name = "ROLES")
public class Role implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@ManyToMany(mappedBy = "roleSet", fetch = FetchType.EAGER, cascade = CascadeType.MERGE)
@Fetch(FetchMode.SELECT)
private Set<Role> parentSet = new HashSet<Role>();
@ManyToMany(targetEntity = Role.class, cascade = {CascadeType.ALL}, fetch = FetchType.EAGER)
@Fetch(FetchMode.SELECT)
@JoinTable(name = "R_PARENT_ROLE", joinColumns = @JoinColumn(name = "parentId"), inverseJoinColumns = @JoinColumn(name = "ROLEID"))
private Set<Role> roleSet = new HashSet<Role>();
}我想通过parentSet为空查询角色列表,代码为:
public <T> List<T> gets(Class<T> clazz){
Session session = getSession();
Criteria criteria = session.createCriteria(clazz);
criteria.createAlias("parentSet","parentSet");
criteria.add(Restrictions.isNull("parentSet"));
return criteria.list();
}但结果并不是我想要的。怎么办?谁能告诉我?非常感谢!
发布于 2016-05-12 10:29:39
我测试以下代码:
public <T> List<T> gets(Class<T> clazz){
Session session = getSession();
Criteria criteria = session.createCriteria(clazz);
criteria.createAlias("roleSet","roleSet");
criteria.add(Restrictions.neProperty("roleSet.id", "id"));
return criteria.list();
}结果就是我想要的。我认为parentSet为空,因此表r_parent_role中的role.id仅用于父in,而不用于角色in。谢谢!
https://stackoverflow.com/questions/37162951
复制相似问题