Cannot delete or update a parent row: a foreign key constraint fails (`db_exam`.`t_exam`, CONSTRAINT `FK_sl2v4qucyp0qe9yvnk6icka10` FOREIGN KEY (`studentId`) REFERENCES `t_student` (`id`))
主外键关联
解决办法,可以尝试级联删除
package model;
import java.util.ArrayList;
import java.util.List;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Transient;
import org.hibernate.annotations.Cascade;
import org.hibernate.annotations.CascadeType;
@Entity
@Table(name="t_student" )
public class Student {
private String id;
private String name;
private String password;
private String sex;
private String prefession;
private String cardNo;
private String flag="2" ;
private List<Exam> examList = new ArrayList<Exam>();
@Id
@Column(name= "id",unique=true,nullable=false,length=40)
public String getId() {
return id ;
}
public void setId(String id ) {
this.id = id;
}
@Column(name= "name",length=20)
public String getName() {
return name ;
}
public void setName(String name ) {
this.name = name;
}
@Column(name= "password",length=20)
public String getPassword() {
return password ;
}
public void setPassword(String password ) {
this.password = password;
}
@Column(name= "sex",length=5)
public String getSex() {
return sex ;
}
public void setSex(String sex ) {
this.sex = sex;
}
@Column(name= "prefession",length=40)
public String getPrefession() {
return prefession ;
}
public void setPrefession(String prefession ) {
this.prefession = prefession;
}
@Column(name= "cardNo",length=50)
public String getCardNo() {
return cardNo ;
}
public void setCardNo(String cardNo ) {
this.cardNo = cardNo;
}
@Transient
public String getFlag() {
return flag ;
}
public void setFlag(String flag ) {
this.flag = flag;
}
@OneToMany(mappedBy= "student")
@Cascade(CascadeType. DELETE)
public List<Exam> getExamList() {
return examList ;
}
public void setExamList(List<Exam> examList ) {
this.examList = examList;
}
}
@Cascade(CascadeType. DELETE)即可级联删除