我一直在尝试理解Hibernate映射,但我就是不明白。在spring项目中使用hibernate。mysql数据库工作台。
每个表格都有Id、优惠券和公司。当一家公司创建优惠券时,我希望优惠券ID和公司ID转到名为companyCoupon的第三个表中,并将其映射到那里:
一家公司可能有很多优惠券。一张优惠券可以与一家公司相关联。
公司id = 1;优惠券id = 1;
companycoupon - compid = 1;compid= 1;
我已经创建了第三个表和映射到其他表的forgein键。
有没有人?有什么想法吗?好文章值得一读?
编辑:
package com.example.CouponProjectCore.entity;
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.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
@Entity
@Table(name = "coupons")
public class Coupon {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="coupid")
private long coupid;
@Column(name="title")
private String title;
@Column(name="startd")
private String startd;
@Column(name="endd")
private String endd;
@Column(name="amount")
private int amount;
@Column(name="type")
private String type;
@Column(name="message")
private String message;
@Column(name="price")
private double price;
@Column(name="image")
private String image;
@ManyToOne()
private Company company;
public Coupon(String title, String startd, String endd, int amount, String type, String message, double price,
String image) {
super();
this.title = title;
this.startd = startd;
this.endd = endd;
this.amount = amount;
this.type = type;
this.message = message;
this.price = price;
this.image = image;
}
public Company getCompany() {
return company;
}
public void setCompany(Company company) {
this.company = company;
}
public long getCoupid() {
return coupid;
}
public void setCoupid(long coupid) {
this.coupid = coupid;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getStartd() {
return startd;
}
public void setStartd(String startd) {
this.startd = startd;
}
public String getEndd() {
return endd;
}
public void setEndd(String endd) {
this.endd = endd;
}
public int getAmount() {
return amount;
}
public void setAmount(int amount) {
this.amount = amount;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getMessage() {
return message;
}
public void setMessage(String message) {
this.message = message;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}
@Override
public String toString() {
return "Coupon [coupid=" + coupid + ", title=" + title + ", startd=" + startd + ", endd=" + endd + ", amount="
+ amount + ", type=" + type + ", message=" + message + ", price=" + price + ", image=" + image
+ "]";
}
}2:
package com.example.CouponProjectCore.entity;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.SecondaryTable;
import javax.persistence.Table;
@Entity
@Table(name = "company")
public class Company {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id")
private long id;
@Column(name = "comp_name")
private String comp_name;
@Column(name = "password")
private String password;
@Column(name = "email")
private String email;
@OneToMany()
@JoinColumn(name="id")
private List<Coupon> coupons;
@Column(name = "client_type")
@Enumerated(EnumType.STRING)
private ClientType client_type = ClientType.COMPANY;
public Company() {
}
public Company(String comp_name, String password, String email, List<Coupon> coupons, ClientType client_type) {
super();
this.comp_name = comp_name;
this.password = password;
this.email = email;
this.coupons = coupons;
this.client_type = client_type;
}
public void addCoupon(Coupon coupon) {
if (coupons == null) {
coupons = new ArrayList<Coupon>();
}
coupons.add(coupon);
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getComp_name() {
return comp_name;
}
public void setComp_name(String comp_name) {
this.comp_name = comp_name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public List<Coupon> getCoupons() {
return coupons;
}
public void setCoupons(List<Coupon> coupons) {
this.coupons = coupons;
}
public ClientType getClient_type() {
return client_type;
}
public void setClient_type(ClientType client_type) {
this.client_type = client_type;
}
@Override
public String toString() {
return "Company [id=" + id + ", comp_name=" + comp_name + ", password=" + password + ", email=" + email
+ ", coupons=" + coupons + ", client_type=" + client_type + "]";
}
}

发布于 2019-09-03 20:01:19
好的,那么你不需要添加第三个表,只需要用companyId添加优惠券列表
//add in Company Enitity
@OneToMany(cascade=CascadeType.ALL)
@JoinColumn(name="COMPANY_ID")
private List<CouponsEntity> coupons;
//add in Coupons Enitity
@ManyToOne
private CompanyEntity company;这是一个静态的例子,你可以理解
Company user= new Company();
user.setId(1);
user.setComp_name("qwqwq");
user.setEmail("dde@gmail.com");
user.setPassword("w1w");
Coupon c= new Coupon("wssw", "2019", "2201", 1, "1w1", "1w1w", 2.3, "w1w1w1", user);
Coupon c1= new Coupon("wssw", "2019", "2201", 1, "1w1", "1w1w", 2.3, "w1w1w1", user);
Coupon c2= new Coupon("wssw", "2019", "2201", 1, "1w1", "1w1w", 2.3, "w1w1w1", user);
Coupon c3= new Coupon("wssw", "2019", "2201", 1, "1w1", "1w1w", 2.3, "w1w1w1", user);
List<Coupon> coupons = new ArrayList<Coupon>();
coupons.add(c);
coupons.add(c1);
coupons.add(c2);
coupons.add(c3);
user.setCoupons(coupons);https://stackoverflow.com/questions/57771213
复制相似问题