有没有一种方法可以创建一个用外键的对象，然后在Spring Boot JPA中将其设置为null？

Question

我在两个类之间有一对一的关系。我想创建阶段项目，而不必将候选ID插入它，因为之后我会得到候选人，因此基本上不存在。

现在，我遇到了错误：

无法执行语句； sql [n/a];约束[null];

因为我没有向候选人发送。

这是第一类：

public class PhaseItems {

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "phaseI_id")
private long id;

private String PhaseItem;

@ManyToMany(fetch = FetchType.LAZY,
        mappedBy = "items")
@JsonIgnore
private List<PhaseTemplate> template = new ArrayList<>();

 @OneToOne(fetch = FetchType.LAZY, optional = true)
 @JoinColumn(name = "candidate_id", nullable = true)
 private Candidate candidate;
 
 public PhaseItems() {
    super();
 }  



public PhaseItems(long id, String phaseItem) {
    super();
    this.id = id;
    PhaseItem = phaseItem;
}



public long getId() {
    return id;
}


public void setId(long id) {
    this.id = id;
}


public String getPhaseItem() {
    return PhaseItem;
}


public void setPhaseItem(String phaseItem) {
    PhaseItem = phaseItem;
}







public List<PhaseTemplate> getTemplate() {
    return template;
}



public void setTemplate(List<PhaseTemplate> template) {
    this.template = template;
}



public Candidate getCandidate() {
    return candidate;
}



public void setCandidate(Candidate candidate) {
    this.candidate = candidate;
}



@Override
public String toString() {
    return "PhaseItems [id=" + id + ", PhaseItem=" + PhaseItem + ", template=" + template + "]";
}

这是第二类：

@Entity
@Table(name= "candidats")
public class Candidate {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "candidate_id")
    private long id;
    
    private String fullname;
    
    private String username;
    
    @Column(nullable = false, unique = true, length = 45)
    private String email;
    
    private String adress;
    
    private String phoneNumber;
    
    private String password;
    
    @Column(name = "status")
    private String status;
    
    
      @OneToOne(fetch = FetchType.LAZY,
                cascade =  CascadeType.ALL,
                mappedBy = "candidate")
      private PhaseItems phases;
    
    public Candidate(){
        
    }

    public Candidate(String fullname,String username,String email, String adress, String phoneNumber, String password,
            List<JobApplication> appliedJobs) {
        super();
        this.fullname = fullname;
        this.username = username;
        this.email = email;
        this.adress = adress;
        this.phoneNumber = phoneNumber;
        this.password = password;
        this.appliedJobs = appliedJobs;
    }
    
    
    

    public Candidate(String fullname,String username, String email, String adress, String phoneNumber, String password) {
        super();
        this.fullname = fullname;
        this.username = username;
        this.email = email;
        this.adress = adress;
        this.phoneNumber = phoneNumber;
        this.password = password;
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

     

    
    public String getFullname() {
        return fullname;
    }

    public void setFullname(String fullname) {
        this.fullname = fullname;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getAdress() {
        return adress;
    }

    public void setAdress(String adress) {
        this.adress = adress;
    }

    public String getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(String phoneNumber) {
        this.phoneNumber = phoneNumber;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public List<JobApplication> getAppliedJobs() {
        return appliedJobs;
    }

    public void setAppliedJobs(List<JobApplication> appliedJobs) {
        this.appliedJobs = appliedJobs;
    }
    
    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

Answer 1

设置列cantidate_id在您的数据库中为无效。 java属性nullable = 的true @joincolumn注释被忽略。

Answer 2

是您的列«＆nbsp; candidate_id＆nbsp;»从表apeas_items在您的模式中无效？