java hibernate从manytomany删除
我有以下两个POJO:
@Entity(name = "project")
@Table(name = "project")
public class Project {
@Column(name = "identifier")
@Id
@GeneratedValue
private Integer identifier;
@ManyToMany(cascade = CascadeType.ALL)
private Set<Member> members = new HashSet<Member>();
// --- constructors ---
public Project() {
}
// --- getters ---
public Integer getIdentifier() {
return identifier;
}
public Set<Member> getMembers() {
return members;
}
}
及
@Entity(name = "member")
@Table(name = "member")
public class Member {
@Column(name = "identifier")
@Id
@GeneratedValue
private Integer identifier;
@Column(name = "name", columnDefinition = "text")
private String name;
@ManyToMany(mappedBy = "members")
private Set<Project> projects = new HashSet<Project>();
// --- constructors ---
public Member() {
}
// --- getters ---
public Integer getIdentifier() {
return identifier;
}
public String getName() {
return name;
}
public Set<Project> getProjects() {
return projects;
}
}
从多对多关系中删除的常见做法是什么?下面的代码工作得很好,但会产生大量开销。首先,有一些疑问:
- 1个查询以获取项目,由
member.getProjects()
触发 - N查询以获取每个项目的所有成员,由
project.getMembers()
触发
其次,获取项目(查询1)和成员(查询2)的完整数据集,而不仅仅是标识符
final Member member = ...;
for (final Project project : member.getProjects()) {
project.getMembers().remove(member);
}
db.delete(member);
在不被迫编写特殊查询的情况下,是否可以更高效地执行此操作
# 1 楼答案
请看这里:
How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
此外,您还可以选择使用jpql语句删除数据:
http://docs.oracle.com/html/E24396_01/ejb3_overview_query.html#ejb3_overview_query_delete
但是我认为第一个链接就是你要找的