我有一堂運(yùn)動(dòng)和訓(xùn)練課。我想在每次培訓(xùn)中進(jìn)行一組練習(xí)。我的問題是——如何在數(shù)據(jù)庫和 Java 中表示？我想到的是根據(jù)表training_id中的外鍵在特定訓(xùn)練中添加一個(gè)練習(xí)exercise。但我想將每個(gè)練習(xí)存儲(chǔ)在一組訓(xùn)練中，或者只列出訓(xùn)練課程的一個(gè)領(lǐng)域——我認(rèn)為這是這樣做的好方法，但我可能是錯(cuò)的。@Entity@Table(name = "exercise")public class Exercise { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "exercise_id") private int id; @Column(name = "exercise_name") private String name; @Column(name = "weight") private double weight; @Column(name = "series") private int series; @Column(name = "training_id") private int trainingId;@Table(name = "training")public class Training { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "training_id") private int id; @Column(name = "training_name") private String trainingName; @Column(name = "date") private Date date; private Set<Exercise> exercises;也許我不明白它的概念。誰能告訴我正確的方法嗎？
1 回答
慕無忌1623718
TA貢獻(xiàn)1744條經(jīng)驗(yàn) 獲得超4個(gè)贊
試試這個(gè)：
@Table(name = "training")
public class Training {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "training_id")
private int id;
@Column(name = "training_name")
private String trainingName;
@Column(name = "date")
private Date date;
@OneToMany(mappedBy = "training")
private Set<Exercise> exercises = new HashSet<>();
@Entity
@Table(name = "exercise")
public class Exercise {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "exercise_id")
private int id;
@Column(name = "exercise_name")
private String name;
@Column(name = "weight")
private double weight;
@Column(name = "series")
private int series;
@Column(name = "training_id")
private int trainingId;
@ManyToOne
@JsonIgnoreProperties("exercises")
private Training training;
這將是外鍵引用的 2 個(gè)單獨(dú)的數(shù)據(jù)庫。
編輯：這將是外鍵引用的2 個(gè)單獨(dú)的表（不是數(shù)據(jù)庫）。
添加回答
舉報(bào)
0/150
提交
取消