删除Person时触发Referential integrity约束违反问题求助

一、核心问题分析 #

删除Person触发的外键约束违规，根源在于实体映射与数据库设计不匹配：

1. 数据库设计是Person对应多个Address（一对多），但代码中Person用@OneToOne关联单个Address，Address外键字段名与数据库不一致，导致双向关联逻辑混乱。
2. CascadeType.ALL配置在错误的关联端，且主地址fk_main_address的映射完全缺失。

二、分步修复方案 #

1. 修正实体关联映射（一对多双向关联） #

Person实体修改

将单个Address关联改为多个Address集合，同时添加主地址映射字段：

package com.apitest.api.model;

import java.util.Date;
import java.util.List;

import jakarta.persistence.CascadeType;
import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.JoinColumn;
import jakarta.persistence.OneToMany;
import jakarta.persistence.OneToOne;
import jakarta.persistence.Table;

@Entity
@Table(name = "pessoa")
public class Pessoa {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id;

    @Column(name = "nome")
    private String nome;

    @Column(name = "dataNascimento")
    private Date dataNascimento;

    // 一对多关联多个地址，级联操作+孤儿移除，确保删除Person时自动删除关联地址
    @OneToMany(mappedBy = "pessoa", cascade = CascadeType.ALL, orphanRemoval = true)
    private List<Endereco> enderecos;

    // 主地址映射，对应数据库fk_main_address字段
    @OneToOne
    @JoinColumn(name = "fk_main_address")
    private Endereco enderecoPrincipal;

    // 构造方法、getter/setter自行补充
}

Address实体修改

修正外键字段名（匹配数据库fk_id_pessoa），移除不必要的级联配置：

package com.apitest.api.model;

import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.JoinColumn;
import jakarta.persistence.ManyToOne;
import jakarta.persistence.Table;

@Entity
@Table(name = "endereco")
public class Endereco {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id_endereco;

    @Column(name = "logradouro")
    private String logradouro;

    @Column(name = "cep")
    private String cep;

    @Column(name = "numero")
    private String numero;

    @Column(name = "cidade")
    private String cidade;

    // 多对一关联Person，外键对应数据库fk_id_pessoa
    @ManyToOne
    @JoinColumn(name = "fk_id_pessoa")
    private Pessoa pessoa;

    // 构造方法、getter/setter自行补充
}

2. 修正Person删除逻辑 #

关联映射修正后，CascadeType.ALL和orphanRemoval=true会自动处理关联Address的删除，Service层方法可简化为：

@Override
public void deletePessoa(Integer idPessoa) {
    pessoaRepository.findById(idPessoa).ifPresent(pessoaRepository::delete);
}

3. 完善主地址设置方法 #

实现验证逻辑，确保设置的主地址属于当前Person：

@Override
public Pessoa setEnderecoPrinicpal(Integer idPessoa, Integer idEndereco) {
    return pessoaRepository.findById(idPessoa)
            .flatMap(pessoa -> enderecoRepository.findById(idEndereco)
                    .filter(endereco -> pessoa.equals(endereco.getPessoa()))
                    .map(endereco -> {
                        pessoa.setEnderecoPrincipal(endereco);
                        return pessoaRepository.save(pessoa);
                    }))
            .orElse(null);
}

三、关键注意点 #

• 关联主控端：一对多关联中，Person是主控端，mappedBy指定由Address的pessoa字段维护关联，避免生成冗余外键。
• 级联与孤儿移除：CascadeType.ALL需配置在主控端的@OneToMany上，orphanRemoval=true确保Person与Address解除关联时，Address被自动删除。
• 字段名匹配：@JoinColumn的name属性必须与数据库实际外键字段名完全一致。

内容的提问来源于stack exchange，提问作者Lemon_prog