如何让JPA生成的student_has_subject表拥有复合主键

默认使用@ManyToMany注解时，JPA自动生成的中间表不会将两个外键字段设为复合主键。要实现这个需求，需要放弃直接使用@ManyToMany，转而通过显式定义中间关联实体类，配合双向一对多/多对一关系来配置，具体步骤如下：

1. 创建复合主键类 #

首先定义一个复合主键类，用于标识中间表的主键，需要实现Serializable接口，并重写equals()和hashCode()方法：

import java.io.Serializable;
import java.util.Objects;

public class StudentSubjectId implements Serializable {
    private Integer student; // 与Student实体的主键字段名对应
    private Integer subject; // 与Subject实体的主键字段名对应

    // 无参构造器（JPA要求）
    public StudentSubjectId() {}

    // 含参构造器
    public StudentSubjectId(Integer student, Integer subject) {
        this.student = student;
        this.subject = subject;
    }

    // 重写equals和hashCode
    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        StudentSubjectId that = (StudentSubjectId) o;
        return Objects.equals(student, that.student) && Objects.equals(subject, that.subject);
    }

    @Override
    public int hashCode() {
        return Objects.hash(student, subject);
    }

    // Getter和Setter
    public Integer getStudent() {
        return student;
    }

    public void setStudent(Integer student) {
        this.student = student;
    }

    public Integer getSubject() {
        return subject;
    }

    public void setSubject(Integer subject) {
        this.subject = subject;
    }
}

2. 创建中间关联实体类 #

定义中间表对应的实体类，使用@IdClass指定复合主键类，然后通过@ManyToOne关联Student和Subject，同时设置外键字段：

import jakarta.persistence.*;

@Entity
@Getter
@Setter
@Table(name = "student_has_subject")
@IdClass(StudentSubjectId.class) // 指定复合主键类
public class StudentSubject {
    @Id
    @Column(name = "student_student_id")
    private Integer student; // 对应复合主键类中的student字段

    @Id
    @Column(name = "student_subject_id")
    private Integer subject; // 对应复合主键类中的subject字段

    // 关联Student实体
    @ManyToOne(fetch = FetchType.LAZY)
    @MapsId("student") // 将此关联映射到复合主键的student字段
    @JoinColumn(name = "student_student_id", insertable = false, updatable = false)
    private Student studentEntity;

    // 关联Subject实体
    @ManyToOne(fetch = FetchType.LAZY)
    @MapsId("subject") // 将此关联映射到复合主键的subject字段
    @JoinColumn(name = "student_subject_id", insertable = false, updatable = false)
    private Subject subjectEntity;

    // 无参构造器（JPA要求）
    public StudentSubject() {}

    // 含参构造器，用于快速创建关联
    public StudentSubject(Student student, Subject subject) {
        this.studentEntity = student;
        this.subjectEntity = subject;
        this.student = student.getId();
        this.subject = subject.getId();
    }
}

3. 修改Student实体类 #

将原来的@ManyToMany换成@OneToMany，关联中间实体StudentSubject：

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

@Entity
@Getter
@Setter
@Table(name = "student")
public class Student {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "student_id", nullable = false)
    private Integer id;

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

    // 关联中间实体，级联操作可根据实际需求调整
    @OneToMany(mappedBy = "studentEntity", cascade = CascadeType.ALL, orphanRemoval = true)
    private List<StudentSubject> studentSubjects = new ArrayList<>();

    // 新增辅助方法，方便添加关联的Subject
    public void addSubject(Subject subject) {
        StudentSubject studentSubject = new StudentSubject(this, subject);
        studentSubjects.add(studentSubject);
        subject.getStudentSubjects().add(studentSubject);
    }

    // 新增辅助方法，方便移除关联的Subject
    public void removeSubject(Subject subject) {
        studentSubjects.removeIf(ss -> ss.getSubjectEntity().equals(subject));
        subject.getStudentSubjects().removeIf(ss -> ss.getStudentEntity().equals(this));
    }
}

4. 修改Subject实体类 #

同样将原来的@ManyToMany换成@OneToMany，关联中间实体StudentSubject：

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

@Entity
@Getter
@Setter
@Table(name = "subject")
public class Subject {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "subject_id", nullable = false)
    private Integer id;

    @Column(name = "subject_name", nullable = false)
    private String name;

    // 关联中间实体
    @OneToMany(mappedBy = "subjectEntity", cascade = CascadeType.ALL, orphanRemoval = true)
    private List<StudentSubject> studentSubjects = new ArrayList<>();
}

说明 #

• 这种方式通过显式定义中间实体，完全控制了中间表的结构，两个外键字段会被设为复合主键，避免重复关联。
• 如果不需要中间表有额外字段，这种配置也能满足复合主键的需求；后续如果要给中间表加字段（比如关联时间、成绩等），直接在StudentSubject类中添加字段即可。

内容的提问来源于stack exchange，提问作者Zar E Ahmer