回答編集履歴

追記

2019/12/17 11:32

投稿

rubytomato

スコア1752

test CHANGED Viewed

@@ -47,3 +47,521 @@
 1) MeisaiのGoalSeq型プロパティ名を`goalSeq`にリネームする。
 2) MeisaiRepositoryのメソッド名を`findByGoalseqid`にリネームする。
+**追記**
+質問内容から分かる範囲で再現した、双方のエンティティクラスでOneToOneアノテーションを付与した、双方向の関連を持つコードです。
+下記の環境で動作確認できています。
+* OpenJDK 11.0
+* Spring Boot 2.2.1
+* Hibernate Core 5.1.0
+* MySQL 8.0.17
+```Java
+import java.util.Date;
+import javax.persistence.CascadeType;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
+import javax.persistence.Id;
+import javax.persistence.OneToOne;
+import javax.persistence.Table;
+@Entity
+@Table(name = "goals_seq")
+public class GoalSeq {
+	@Id
+	@GeneratedValue(strategy = GenerationType.IDENTITY)
+	private Long id;
+	@Column
+	private Long userId;
+	@Column
+	private Long goalId;
+	@Column
+	private String goalTitle;
+	@Column
+	private String goalDetail;
+	@Column
+	private String goalWeight;
+	@Column
+	private Date updatedAt;
+	@OneToOne(mappedBy = "goalSeq", cascade = CascadeType.ALL)
+    private Meisai meisai;
+	public Long getId() {
+		return id;
+	}
+	public void setId(Long id) {
+		this.id = id;
+	}
+	public Long getUserId() {
+		return userId;
+	}
+	public void setUserId(Long userId) {
+		this.userId = userId;
+	}
+	public Long getGoalId() {
+		return goalId;
+	}
+	public void setGoalId(Long goalId) {
+		this.goalId = goalId;
+	}
+	public String getGoalTitle() {
+		return goalTitle;
+	}
+	public void setGoalTitle(String goalTitle) {
+		this.goalTitle = goalTitle;
+	}
+	public String getGoalDetail() {
+		return goalDetail;
+	}
+	public void setGoalDetail(String goalDetail) {
+		this.goalDetail = goalDetail;
+	}
+	public String getGoalWeight() {
+		return goalWeight;
+	}
+	public void setGoalWeight(String goalWeight) {
+		this.goalWeight = goalWeight;
+	}
+	public Date getUpdatedAt() {
+		return updatedAt;
+	}
+	public void setUpdatedAt(Date updatedAt) {
+		this.updatedAt = updatedAt;
+	}
+	public Meisai getMeisai() {
+		return meisai;
+	}
+	public void setMeisai(Meisai meisai) {
+		this.meisai = meisai;
+	}
+	@Override
+	public String toString() {
+		return "GoalSeq [id=" + id + ", userId=" + userId + ", goalId=" + goalId + ", goalTitle=" + goalTitle
+				+ ", goalDetail=" + goalDetail + ", goalWeight=" + goalWeight + ", updatedAt=" + updatedAt + "]";
+	}
+}
+```
+```java
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.OneToOne;
+import javax.persistence.Table;
+@Entity
+@Table(name = "meisai_tbl")
+public class Meisai {
+	@Id
+	@Column(name = "meisai_id")
+	@GeneratedValue(strategy = GenerationType.IDENTITY)
+	private Long meisaiId;
+	@Column
+	private String selfMidCmt;
+	@Column
+	private String bossMidCmt;
+	@Column
+	private String selfEndCmt;
+	@Column
+	private String bossEndCmt;
+	@OneToOne
+    @JoinColumn(name = "goalseq_id")
+    private GoalSeq goalSeq;
+	public Long getMeisaiId() {
+		return meisaiId;
+	}
+	public void setMeisaiId(Long meisaiId) {
+		this.meisaiId = meisaiId;
+	}
+	public String getSelfMidCmt() {
+		return selfMidCmt;
+	}
+	public void setSelfMidCmt(String selfMidCmt) {
+		this.selfMidCmt = selfMidCmt;
+	}
+	public String getBossMidCmt() {
+		return bossMidCmt;
+	}
+	public void setBossMidCmt(String bossMidCmt) {
+		this.bossMidCmt = bossMidCmt;
+	}
+	public String getSelfEndCmt() {
+		return selfEndCmt;
+	}
+	public void setSelfEndCmt(String selfEndCmt) {
+		this.selfEndCmt = selfEndCmt;
+	}
+	public String getBossEndCmt() {
+		return bossEndCmt;
+	}
+	public void setBossEndCmt(String bossEndCmt) {
+		this.bossEndCmt = bossEndCmt;
+	}
+	public GoalSeq getGoalSeq() {
+		return goalSeq;
+	}
+	public void setGoalSeq(GoalSeq goalSeq) {
+		this.goalSeq = goalSeq;
+	}
+	@Override
+	public String toString() {
+		return "Meisai [meisaiId=" + meisaiId + ", selfMidCmt=" + selfMidCmt + ", bossMidCmt=" + bossMidCmt
+				+ ", selfEndCmt=" + selfEndCmt + ", bossEndCmt=" + bossEndCmt + "]";
+	}
+}
+```
+リポジトリ
+```Java
+import org.springframework.data.jpa.repository.JpaRepository;
+import com.example.demo.entity.GoalSeq;
+import com.example.demo.entity.Meisai;
+public interface MeisaiRepository extends JpaRepository<Meisai, Long> {
+	public Meisai findByGoalSeq(GoalSeq goalseq);
+}
+```
+DDL
+```SQL
+CREATE TABLE goals_seq (
+  id BIGINT AUTO_INCREMENT,
+  user_id BIGINT NOT NULL DEFAULT 0,
+  goal_id BIGINT NOT NULL DEFAULT 0,
+  goal_title VARCHAR(255) NULL,
+  goal_detail VARCHAR(255) NULL,
+  goal_weight VARCHAR(10) NULL,
+  updated_at DATE NOT NULL,
+  PRIMARY KEY (id)
+)
+ENGINE = INNODB
+DEFAULT CHARSET = UTF8MB4;
+CREATE TABLE meisai_tbl (
+  meisai_id BIGINT AUTO_INCREMENT,
+  goalseq_id BIGINT NOT NULL DEFAULT 0,
+  self_mid_cmt VARCHAR(255) NULL,
+  boss_mid_cmt VARCHAR(255) NULL,
+  self_end_cmt VARCHAR(255) NULL,
+  boss_end_cmt VARCHAR(255) NULL,
+  PRIMARY KEY (meisai_id)
+)
+ENGINE = INNODB
+DEFAULT CHARSET = UTF8MB4;
+```