JPA如何获取关联中间表T_BONUS_COND_LINK的priority列值？

这个场景太常见了——当你的关联表（T_BONUS_COND_LINK）带有额外字段时，原来用@OneToMany+@JoinTable的映射方式没法直接拿到这些字段，因为这种方式只处理纯粹的多对多关联，不会暴露中间表的属性。我们需要把中间表也映射成一个独立的JPA实体，具体步骤如下：

1. 创建中间表的实体类（含联合主键） #

首先，因为T_BONUS_COND_LINK的主键是bonus_id和cond_id的联合主键，我们先定义一个嵌入式主键类：

@Embeddable
public class BonusCondLinkId implements Serializable {
    @Column(name = "BONUS_ID")
    private Long bonusId;
    
    @Column(name = "COND_ID")
    private Long condId;

    // JPA要求必须提供无参构造函数
    public BonusCondLinkId() {}

    public BonusCondLinkId(Long bonusId, Long condId) {
        this.bonusId = bonusId;
        this.condId = condId;
    }

    // 重写equals和hashCode方法，JPA判断实体唯一性需要
    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        BonusCondLinkId that = (BonusCondLinkId) o;
        return Objects.equals(bonusId, that.bonusId) && Objects.equals(condId, that.condId);
    }

    @Override
    public int hashCode() {
        return Objects.hash(bonusId, condId);
    }

    // getter和setter方法
    public Long getBonusId() { return bonusId; }
    public void setBonusId(Long bonusId) { this.bonusId = bonusId; }
    public Long getCondId() { return condId; }
    public void setCondId(Long condId) { this.condId = condId; }
}

然后创建中间表的实体类BonusCondLink，映射到T_BONUS_COND_LINK，并关联BonusApplication和Condition：

@Entity(name = "BonusCondLink")
@Table(name = "T_BONUS_COND_LINK")
public class BonusCondLink {
    @EmbeddedId
    private BonusCondLinkId id;

    @ManyToOne(fetch = FetchType.LAZY)
    @MapsId("bonusId") // 关联主键中的bonusId字段
    @JoinColumn(name = "BONUS_ID")
    private BonusApplication bonus;

    @ManyToOne(fetch = FetchType.LAZY)
    @MapsId("condId") // 关联主键中的condId字段
    @JoinColumn(name = "COND_ID")
    private Condition condition;

    @Column(name = "PRIORITY")
    private Integer priority;

    // 无参构造函数
    public BonusCondLink() {}

    // 带参构造函数，简化实体创建
    public BonusCondLink(BonusApplication bonus, Condition condition, Integer priority) {
        this.bonus = bonus;
        this.condition = condition;
        this.priority = priority;
        this.id = new BonusCondLinkId(bonus.getId(), condition.getId());
    }

    // getter和setter方法
    public BonusCondLinkId getId() { return id; }
    public void setId(BonusCondLinkId id) { this.id = id; }
    public BonusApplication getBonus() { return bonus; }
    public void setBonus(BonusApplication bonus) { this.bonus = bonus; }
    public Condition getCondition() { return condition; }
    public void setCondition(Condition condition) { this.condition = condition; }
    public Integer getPriority() { return priority; }
    public void setPriority(Integer priority) { this.priority = priority; }
}

2. 修改BonusApplication实体的关联关系 #

把原来直接关联Condition的集合，改成关联BonusCondLink的集合：

@Entity(name = ENTITY_NAME)
@Table(name = "T_BONUS_TAB")
@Customizer(EclipseLinkIssuesFixer.class)
public class BonusApplication extends AbstractIdentifiableByLongEntity {
    // 其他原有字段保持不变
    
    @OneToMany(mappedBy = "bonus", cascade = CascadeType.ALL, orphanRemoval = true, fetch = FetchType.EAGER)
    private List<BonusCondLink> condLinks = new ArrayList<>();

    // 可选：添加辅助方法，快速获取按优先级排序的Condition列表
    public List<Condition> getCondsSortedByPriority() {
        return condLinks.stream()
                .sorted(Comparator.comparingInt(BonusCondLink::getPriority))
                .map(BonusCondLink::getCondition)
                .collect(Collectors.toList());
    }

    // getter和setter方法
    public List<BonusCondLink> getCondLinks() { return condLinks; }
    public void setCondLinks(List<BonusCondLink> condLinks) { this.condLinks = condLinks; }
}

3. 可选：修改Condition实体添加反向关联 #

如果需要从Condition端反向查询关联的BonusApplication，可以在Condition实体中添加：

@Entity(name = ENTITY_NAME)
@Table(name = "T_COND")
@Customizer(EclipseLinkIssuesFixer.class)
public class Condition extends AbstractIdentifiableByLongEntity {
    // 其他原有字段保持不变
    
    @OneToMany(mappedBy = "condition")
    private List<BonusCondLink> bonusLinks = new ArrayList<>();

    // getter和setter方法
    public List<BonusCondLink> getBonusLinks() { return bonusLinks; }
    public void setBonusLinks(List<BonusCondLink> bonusLinks) { this.bonusLinks = bonusLinks; }
}

如何获取priority值 #

现在你可以通过BonusApplication的condLinks集合，直接访问每个关联的priority字段了：

// 假设你已经从数据库获取到了一个bonusApplication实例
for (BonusCondLink link : bonusApplication.getCondLinks()) {
    Integer priority = link.getPriority();
    Condition condition = link.getCondition();
    // 在这里处理你的业务逻辑，比如根据优先级执行不同操作
}

关键说明 #

• 当关联表存在额外字段时，必须将其映射为独立实体，因为@JoinTable仅适用于无额外属性的纯多对多关联。
• 使用@EmbeddedId或@IdClass处理联合主键是JPA规范中处理这种复合主键场景的标准方式。
• 注意关联的fetch策略，根据业务需求选择EAGER或LAZY（通常推荐LAZY避免不必要的性能开销）。

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