如何编写删除所有“大孩子”的Hibernate HQL查询元素? [英] How to write Hibernate HQL query which remove all "grand children" elements?
本文介绍了如何编写删除所有“大孩子”的Hibernate HQL查询元素?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想将所有学生从特定学校中删除。
$
$ b
删除FROM students1
WHERE students1.group_id IN
(SELECT id FROM group1 WHERE group1.school_id =:school_id)
如何转换这个SQL查询到Hibernate HQL?
我使用H2数据库引擎。
我的真实查询比较复杂和简单的级联删除学校不适合我)。
解决方案
工作脚本如下所示:
DELETE FROM Student AS s
WHERE s IN
(SELECT s FROM Student AS s WHERE s.group IN
( SELECT g FROM Group AS g WHERE g.school IN
(SELECT s FROM School's WHERE s.id =:schoolId)))
感谢doc_180的评论
I have schools, which contains groups, which contains students.
I would like to remove all students from specific school.
In SQL I can write the following query:
DELETE FROM students1
WHERE students1.group_id IN
(SELECT id FROM group1 WHERE group1.school_id = :school_id)
How to transform this SQL query to Hibernate HQL?
I use H2 database engine.
(My real query is more complex and simple cascade deletion of school is not suitable for me).
解决方案
The working script follows:
DELETE FROM Student AS s
WHERE s IN
(SELECT s FROM Student AS s WHERE s.group IN
(SELECT g FROM Group AS g WHERE g.school IN
(SELECT s FROM School s WHERE s.id = :schoolId)))
Thanks to comments of doc_180
这篇关于如何编写删除所有“大孩子”的Hibernate HQL查询元素?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文