java - 如何在hibernate java中使用where条件删除多条记录

Question

我想使用 hibernate 从我的表中删除记录列表:

我的 sql 查询如下所示:

delete from students where joinDate="2014-03-08"

我想删除所有在上述日期加入的记录。

在学生表中，我有两个外键:classId 和 courseId。

您能帮助如何为上述场景编写有效的 hibernate 删除查询方法吗？

感谢您的帮助!

Answer 1

最简单的方法是从每个表中单独删除:

-- Remove all connections from A which reference
-- the B-rows you want to remove
DELETE FROM A_has_B
WHERE B_id IN (1,2);

-- Remove all connections from C which reference
-- the B-rows you want to remove
DELETE FROM C_has_B
WHERE B_id IN (1,2);

-- Finally remove the B-rows
DELETE FROM B
WHERE B_id IN (1,2);