如何在Oracle与JPA中实现House-Door-Handle的持久化关联关系？

一、数据库表结构设计（Oracle） #

通过三张表的外键级联约束，实现基础的关联删除逻辑：

1. HOUSE表（父表，存储房屋核心信息）

CREATE TABLE HOUSE (
    HOUSE_ID NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    ADDRESS VARCHAR2(255), -- 示例字段：房屋地址
    AREA NUMBER -- 示例字段：房屋面积
);

2. DOOR表（关联房屋，删除房屋时自动删除所有关联门）

CREATE TABLE DOOR (
    DOOR_ID NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    HOUSE_ID NUMBER NOT NULL,
    DOOR_TYPE VARCHAR2(20) NOT NULL CHECK (DOOR_TYPE IN ('MAIN', 'BACK', 'SLIDING')), -- 标识门类型
    MATERIAL VARCHAR2(50), -- 示例字段：门材质
    FOREIGN KEY (HOUSE_ID) REFERENCES HOUSE(HOUSE_ID) ON DELETE CASCADE
);

3. HANDLE表（关联门，删除门时自动删除对应把手）

CREATE TABLE HANDLE (
    HANDLE_ID NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    DOOR_ID NUMBER NOT NULL,
    STYLE VARCHAR2(50), -- 示例字段：把手样式
    COLOR VARCHAR2(50), -- 示例字段：把手颜色
    FOREIGN KEY (DOOR_ID) REFERENCES DOOR(DOOR_ID) ON DELETE CASCADE
);

二、JPA实体类配置 #

通过JPA注解绑定实体关联，与数据库约束配合实现业务逻辑：

1. Handle实体 #

import jakarta.persistence.*;

@Entity
@Table(name = "HANDLE")
public class Handle {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "HANDLE_ID")
    private Long id;

    @Column(name = "STYLE")
    private String style;

    @Column(name = "COLOR")
    private String color;

    // 构造器、getter/setter 省略
}

2. Door实体 #

维护与House、Handle的关联，明确依赖关系：

import jakarta.persistence.*;

@Entity
@Table(name = "DOOR")
public class Door {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "DOOR_ID")
    private Long id;

    @Column(name = "DOOR_TYPE", nullable = false)
    private String doorType; // 取值：MAIN/BACK/SLIDING

    @Column(name = "MATERIAL")
    private String material;

    // 关联House，门必须属于某一房屋
    @ManyToOne(optional = false)
    @JoinColumn(name = "HOUSE_ID")
    private House house;

    // 关联Handle，级联所有操作（删除门时同步删把手）
    @OneToOne(cascade = CascadeType.ALL, orphanRemoval = true, optional = false)
    @JoinColumn(name = "DOOR_ID")
    private Handle handle;

    // 构造器、getter/setter 省略
}

3. House实体 #

关联各类门，配置级联删除确保删除房屋时清理所有关联资源：

import jakarta.persistence.*;
import java.util.List;

@Entity
@Table(name = "HOUSE")
public class House {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "HOUSE_ID")
    private Long id;

    @Column(name = "ADDRESS")
    private String address;

    @Column(name = "AREA")
    private Double area;

    // 关联主门，级联删除
    @OneToOne(mappedBy = "house", cascade = CascadeType.ALL, orphanRemoval = true)
    private Door mainDoor;

    // 关联后门，级联删除
    @OneToOne(mappedBy = "house", cascade = CascadeType.ALL, orphanRemoval = true)
    private Door backDoor;

    // 关联滑动门列表，级联删除
    @OneToMany(mappedBy = "house", cascade = CascadeType.ALL, orphanRemoval = true)
    private List<Door> slidingDoors;

    // 构造器、getter/setter 省略
}

核心逻辑说明 #

• 删除House场景：数据库层面，HOUSE表的删除触发DOOR表的ON DELETE CASCADE，删除所有关联门；DOOR表的删除又触发HANDLE表的ON DELETE CASCADE，删除对应把手。JPA的cascade = CascadeType.ALL同步保证实体对象层面的级联删除，与数据库约束一致。
• 删除Door场景：直接删除Door实体时，JPA的级联配置会自动删除关联的Handle；数据库外键约束也会同步清理HANDLE表记录。由于Door是关联维护方，删除操作不会影响House的存在。
• 关联一致性：所有关联由Door实体维护（mappedBy指定），避免双向关联的冗余操作，保证数据一致性。

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