這些是我打算在我的資料庫中擁有的表。
第一個表
第二張表
第三張表
uj5u.com熱心網友回復：
@Entity
@Table(name = "STATIONS")
public class Station {
@Id
private Long stnCode;
}
@Entity
@Table(name = "TRAINS")
public class Train {
@Id
private String trainNo;
}
@Entity
@Table(name = "STOPS")
public class Stop {
@EmbeddedId
private StopId stopId;
}
@Embeddable
class StopId implements Serializable {
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "TRAIN_NO")
private Train trainNo;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "STN_CODE")
private Station stnCode;
}
Hibernate: create table STATIONS (stnCode bigint not null, primary key (stnCode))
Hibernate: create table STOPS (STN_CODE bigint not null, TRAIN_NO varchar(255) not null, primary key (STN_CODE, TRAIN_NO))
Hibernate: create table TRAINS (trainNo varchar(255) not null, primary key (trainNo))
Hibernate: alter table STOPS add constraint FK1431wv4cp0qef8drx65we3m03 foreign key (STN_CODE) references STATIONS
Hibernate: alter table STOPS add constraint FK5omkrq9vt17i1w6qose6njvhw foreign key (TRAIN_NO) references TRAINS
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/477150.html