Hibernate特定字段带条件自定义映射：替代已废弃的@Where注解

问题背景 #

我有两个实体类：Course和CourseRelationship，结构如下：

Course实体类

@Id
Long id;

@OneToMany(mappedBy = "course_id", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
List<CourseRelationship> preRequisiteCourses;

@OneToMany(mappedBy = "course_id", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
List<CourseRelationship> preCourses;

@OneToMany(mappedBy = "course_id", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
List<CourseRelationship> coreQuisiteCourses;

CourseRelationship实体类

@Id
Long id;

@Column(name = "course_id")
Long courseId;

@JsonIgnore
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "course_id", insertable = false, updatable = false)
Course course;

@Column(name = "course_constraint_id")
Long courseConstraintId;

@JsonIgnore
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "course_constraint_id", insertable = false, updatable = false)
Course courseConstraint;

@Enumerated(value = EnumType.STRING)
Relation relation;
public enum Relation {
    PREREQUISITE,
    PRECOURSE,
    COREQUISITECOURSE
}

原本打算用@Where(clause = "relation = 'PRECOURSE'")过滤出指定类型的关联关系，再转换成List<Course>，但@Where注解已被废弃，想找替代方案，比如@ManyToMany或@JoinTable。

替代方案 #

方案1：使用JPA的@Filter注解 #

@Filter是@Where的官方替代方案，步骤如下：

1. 在CourseRelationship实体类上定义过滤器：

@FilterDef(name = "filterByRelation", parameters = @ParamDef(name = "relation", type = "string"))
@Entity
public class CourseRelationship {
    // 原有字段...
}

2. 在Course的对应字段上启用过滤器：

@OneToMany(mappedBy = "course", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@Filter(name = "filterByRelation", condition = "relation = :relation")
List<CourseRelationship> preCourses;

3. 使用时在Service层手动启用过滤器：

EntityManager em = ...;
em.unwrap(Session.class).enableFilter("filterByRelation").setParameter("relation", Relation.PRECOURSE.name());
Course course = em.find(Course.class, courseId);
List<CourseRelationship> filteredPreCourses = course.getPreCourses();

方案2：用@ManyToMany直接映射为List #

跳过中间实体，直接通过@JoinTable添加过滤条件，直接获取目标课程列表：

@ManyToMany(fetch = FetchType.LAZY)
@JoinTable(
    name = "course_relationship", // 对应中间表名
    joinColumns = @JoinColumn(name = "course_id"),
    inverseJoinColumns = @JoinColumn(name = "course_constraint_id"),
    where = @JoinColumn(expression = "relation = 'PRECOURSE'") // 过滤指定关系类型
)
List<Course> preCourses;

注意：部分JPA实现（如Hibernate）支持@JoinTable的where属性，可直接完成过滤和映射。

方案3：自定义JPQL查询 #

在Repository层编写查询，直接返回指定关系的课程：

public interface CourseRepository extends JpaRepository<Course, Long> {
    @Query("SELECT cr.courseConstraint FROM CourseRelationship cr WHERE cr.course.id = :courseId AND cr.relation = :relation")
    List<Course> findPreCoursesByCourseId(@Param("courseId") Long courseId, @Param("relation") Relation relation);
}

使用时直接调用：

List<Course> preCourses = courseRepository.findPreCoursesByCourseId(courseId, Relation.PRECOURSE);

方案4：业务层过滤转换 #

如果不想修改实体映射，可在获取关联关系后，在业务层处理：

List<Course> preCourses = course.getPreCourses().stream()
    .filter(rel -> Relation.PRECOURSE.equals(rel.getRelation()))
    .map(CourseRelationship::getCourseConstraint)
    .collect(Collectors.toList());

注意：若关联关系是懒加载（LAZY），需确保在事务内执行此操作，避免懒加载异常。

内容的提问来源于stack exchange，提问作者Nguyen Manh Cuong