如何自定义关联查询：获取指定分类关联帖子及孤儿帖

你的需求是让Category的posts关联集合同时包含属于该分类的帖子，以及category为null的孤儿帖，以下是基于Hibernate特性的几种可行高级方案：

方案1：利用Hibernate @Filter 实现动态过滤 #

@Filter可以动态修改关联查询的条件，适合需要在不同场景切换查询逻辑的情况：

步骤1：在Post实体定义Filter规则 #

@Entity
@FilterDef(name = "includeOrphanPosts", parameters = @ParamDef(name = "targetCategoryId", type = "long"))
@Filter(
    name = "includeOrphanPosts",
    condition = "category_id = :targetCategoryId OR category_id IS NULL"
)
public class Post {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne
    @JoinColumn(name = "category_id")
    private Category category;

    // 其他字段和Getter/Setter
}

步骤2：在Category的关联上绑定Filter #

@Entity
public class Category {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @OneToMany(mappedBy = "category", cascade = CascadeType.ALL)
    @Filter(name = "includeOrphanPosts", condition = ":targetCategoryId = id")
    private List<Post> posts = new ArrayList<>();

    // Getter/Setter
}

步骤3：查询时激活Filter #

在获取Category之前，需要在Session中启用Filter并传入当前分类ID：

// 从EntityManager获取Session
Session session = entityManager.unwrap(Session.class);
// 启用Filter并设置参数
session.enableFilter("includeOrphanPosts")
       .setParameter("targetCategoryId", targetCategoryId);
// 获取Category，此时posts集合会包含目标分类的帖子 + 孤儿帖
Category category = session.get(Category.class, targetCategoryId);

方案2：使用@NamedQuery 自定义关联抓取逻辑 #

如果不需要动态切换查询规则，直接用命名查询定义带关联抓取的逻辑更直观：

步骤1：在Category实体定义命名查询 #

@Entity
@NamedQuery(
    name = "Category.getWithOrphanPosts",
    query = "SELECT c FROM Category c " +
            "LEFT JOIN FETCH c.posts p " +
            "WHERE c.id = :categoryId " +
            "OR p.category IS NULL"
)
public class Category {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @OneToMany(mappedBy = "category", cascade = CascadeType.ALL)
    private List<Post> posts = new ArrayList<>();

    // Getter/Setter
}

步骤2：执行命名查询 #

直接调用命名查询获取目标分类，关联集合会自动包含符合条件的帖子：

Category category = entityManager.createNamedQuery("Category.getWithOrphanPosts", Category.class)
                               .setParameter("categoryId", targetCategoryId)
                               .getSingleResult();

方案3：@JoinFormula 模拟虚拟关联（谨慎使用） #

这种方式通过自定义关联条件实现，但可能存在性能兼容性问题，适合特殊场景：

@Entity
public class Category {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    // 原始关联（可选保留）
    @OneToMany(mappedBy = "category", cascade = CascadeType.ALL)
    private List<Post> assignedPosts = new ArrayList<>();

    // 包含孤儿帖的自定义关联
    @OneToMany
    @JoinFormula(
        value = "(SELECT 1 FROM Post p WHERE p.category_id = id OR p.category_id IS NULL)",
        referencedColumnName = "id"
    )
    private List<Post> allPostsWithOrphans = new ArrayList<>();

    // Getter/Setter
}

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