ER图如下:
这里只截取了部分,可见normalGoods表和user表中有关系。normalGoods和topGoods表有关系,
其中对应的表内容如下:
normalGOods
topGoods
user
其中对应的代码如下:
TopGoods.java
package com.it1995.demo.object;
import lombok.Data;
import javax.persistence.*;
@Data
@Entity
@Table(name = "topGoods")
public class TopGoods {
@Id
@Column(name = "id")
private Integer id;
// @Column(name = "goodsID")
// private Integer goodsID;
@OneToOne
@JoinColumn(name = "goodsID")
private NormalGoods good;
@Column(name = "sequence")
private Integer sequence;
}
NormalGoods.java
package com.it1995.demo.object;
import lombok.Data;
import javax.persistence.*;
import java.util.Date;
@Data
@Entity
@Table(name = "normalGoods")
public class NormalGoods {
@Id
@Column(name = "id")
private Integer id;
@ManyToOne
@JoinColumn(name = "userID")
private User userObject;
@Column(name = "name")
private String name;
@Column(name = "description")
private String description;
@Column(name = "picPath")
private String picPath;
@Column(name = "modiTime")
private Date modifyTime;
}
这里使用@ManyToOne或者@OneToOne,然后@JoinColumn把外键填写上去。
如果是@OneToMany
@OneToMany
private List<XXXXX> XXXXXX;
程序运行截图如下:
下面一个就不截取了!