java - 如何将 EmbeddedId 中的外键设置为具有其他 EmbeddedId 的其他实体
问题描述
我有这个问题的核心类 SWEntity。我想要一组 SWEntityRow 类,它是 SWEntity 的详细信息(一个实体有很多行)。SWentity 在embeddedId Area 和Procedure 中有另外两个关键类。当我尝试使用 SWEntityRowId 将 SWEntity 与 SWEntityRow 映射时,我会遇到不同的错误。
一些想法如何将 SWEntityRowId 与 SWEntity 映射?
这是 ER 的简化图:https ://i.stack.imgur.com/pMJzh.png
这是我的简化课程:
SWentity
-----------
@Entity
public class SWEntity {
@EmbeddedId
private SWEntityId id;
[...]
}
SWEntityId
-------------
@Embeddable
public class SWEntityId implements Serializable{
private static final long serialVersionUID = 1L;
@NotNull
private String name;
@NotNull
private int version;
@ManyToOne
@JoinColumn(name = "areaName", nullable = false)
@JsonIgnore
private Area area;
@ManyToOne
@JoinColumn(name = "procedureName", nullable = false)
@JsonIgnore
private Procedure procedure;
}
SWEntityRow
---------------
@Entity
public class SWEntityRow{
@EmbeddedId
private SWEntityRowId sWEntityRowId;
}
SWEntityRowId
---------------
@Embeddable
public class SWEntityRowId implements Serializable {
private static final long serialVersionUID = 1L;
private String rowName;
//SWEntityId
@ManyToOne
@JoinColumns({
@JoinColumn(name="name_row", referencedColumnName="name"),
@JoinColumn(name="version_row", referencedColumnName="version"),
@JoinColumn(name="area_row", referencedColumnName="area_name"),
@JoinColumn(name="procedure_row", referencedColumnName="procedure_name"
})
}
解决方案
这解决了我的问题
@ JoinColumns({
@JoinColumn(name="entityname", referencedColumnName="name"),
@JoinColumn(name="entityversion", referencedColumnName="version"),
@JoinColumn(name="entityarea", referencedColumnName="AreaName"),
@JoinColumn(name="entityprocedure", referencedColumnName="ProcedureName")
})
区别在于 referencedColumnName="AreaName" 而不是 referencedColumnName="area_name" 和过程相同。
谢谢!