hibernate单向多对多HQL语句的问题

Question

• Student 和Teacher是单向多对多关系，Student这边配置了many-to-many 和 Set， 运行后，生成了学生，老师表，还有一张中间表。假如我要找 学生ID为1 的老师有哪些。HQL语句要怎么写？求指导。谢谢！

Answer 1

HQL form Student s where s.id =1 就可以获取 Student 对象 hibernateTemplate.queryForObject(hql)；然后通过student get Teacher 对象

Answer 2

Set:哪就是在配置文件的学生bean配置了学生和老师的多对多关系假设配置如下：<set&nbsp;name="teachers"&nbsp;table="student_teacher">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<key&nbsp;column="Student_Id"></key>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<many-to-many&nbsp;column="teacher_Id"&nbsp;class="·····.Teacher">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</many-to-many>&nbsp;&nbsp; </set>HQL:select * from Teacher t，Student s where t.id in elements(s.teachers) and s.id=1

Answer 3

select t from Teacher as t，Student as s where t.stuid=s.stuid and s.id=1