使用@IdClass保存实体会产生空行

Question

我想将行保存在一个简单的表中，该表包含另外两个实体的ID。经过一些尝试，我得到了以下配置。Spring Boot现在可以正确地创建表，列名称为task\u run\u id和project\u id。

但当我调用repo时。保存（参与者）创建了一行，但两列都包含0，而不是所需的ID。不会引发任何错误。

我做错了什么？此外，如果有一些声明对于实现简单的保存和以后的查询是不必要的，请告诉我。

@Entity
@IdClass(TaskRunParticipant.Id.class)
public class TaskRunParticipant implements Serializable {

   @javax.persistence.Id
   @Column(name = "run_id")
   private long runId;

   @javax.persistence.Id
   @Column(name = "project_id")
   private long projectId;

   @OneToOne
   @JoinColumn(name="project_id")
   @MapsId("project_id")
   private Project project;

   @OneToOne
   @JoinColumn(name="run_id")
   @MapsId("run_id")
   private TaskRun taskRun;

   protected TaskRunParticipant(){}
    
   public TaskRunParticipant(TaskRun run, Project project){
      this.taskRun = run;
      this.project = project;
   }
    
   public Project getProject() { return project; }
   public void setProject(Project project) { this.project = project; }
   public TaskRun getTaskRun() { return taskRun; }
   public void setTaskRun(TaskRun taskRun) { this.taskRun = taskRun; }
   protected long getRunId(){ return runId; }
   protected long getProjectId(){ return projectId; }
   protected void setRunId(long runId){ this.runId = runId; }
   protected void setProjectId(long projectId){ this.projectId = projectId; }

   public final static class Id implements Serializable {
       private long runId;
       private long projectId;

       public long getRunId() { return runId; }
       public void setRunId(long runId) { this.runId = runId; }
       public long getProjectId() { return projectId; }
       public void setProjectId(long projectId) { this.projectId = projectId; }

       @Override
       public boolean equals(Object o) {
           if (this == o) return true;
           if (o == null || getClass() != o.getClass()) return false;
           Id id = (Id) o;
           return runId == id.runId &&
           projectId == id.projectId;
       }
    
       @Override
       public int hashCode() {
           return Objects.hash(runId, projectId);
       }
   }
}

Answer 1

看起来您只能将MapsId注释与由@EmbeddedId注释映射的om的标识符一起使用。

根据MapsId注释的文档：

指定ManyToOne或OneToOne关系属性，该属性提供EmbeddedId主键、EmbeddedId主键中的属性或父实体的简单主键的映射。value元素指定关系属性对应的复合键中的属性。

因此，我建议您按照以下方式重写映射：

java prettyprint-override">@Embeddable
public class TaskRunParticipantId implements Serializable
{
   private Long runId;
   private Long projectId;
   
   public TaskRunParticipantId()
   {
   }
   
   public TaskRunParticipantId(Long runId, Long projectId)
   {
      this.runId = runId;
      this.projectId = projectId;
   }

   public Long getRunId()
   {
      return runId;
   }
   public void setRunId(Long runId)
   {
      this.runId = runId;
   }

   public Long getProjectId()
   {
      return projectId;
   }
   public void setProjectId(Long projectId)
   {
      this.projectId = projectId;
   }

   @Override
   public boolean equals(Object o)
   {
       if (this == o) return true;
       if (o == null || getClass() != o.getClass()) return false;
       TaskRunParticipantId id = (TaskRunParticipantId) o;
       return runId == id.runId &&
             projectId == id.projectId;
   }

   @Override
   public int hashCode()
   {
       return Objects.hash(baseModelId, otherEntityId);
   }
}

@Entity
public class TaskRunParticipant
{
   private TaskRunParticipantId id;
   private Project project;
   private TaskRun taskRun;
   
   public TaskRunParticipant()
   {
      id = new TaskRunParticipantId();
   }
   
   public TaskRunParticipant(Project project, TaskRun taskRun)
   {
      this();
      this.project = project;
      this.taskRun = taskRun;
   }
   
   @EmbeddedId
   public TaskRunParticipantId getId()
   {
      return id;
   }
   public void setId(TaskRunParticipantId id)
   {
      this.id = id;
   }

   @OneToOne
   @JoinColumn(name="project_id")
   @MapsId("projectId")
   public Project getProject()
   {
      return project;
   }
   public void setProject(Project project)
   {
      this.project = project;
   }

   @OneToOne
   @JoinColumn(name="run_id")
   @MapsId("runId")
   public TaskRun getTaskRun()
   {
      return taskRun;
   }
   public void setTaskRun(TaskRun taskRun)
   {
      this.taskRun = taskRun;
   }
}

请注意，MapsId中的值是TaskRunParticipanId类中相应字段的名称，而不是列名。