如:
1端 : TEACHER
多端:STUDENTS
条件: where student.name = "XXX"
中间表: TEACHER_STUDENT (ID, TEACHER_ID, STUDENT_ID)
查询结果, student.name = "XXX"的 TEACHER 对象 LIST<TEACHER>
思路: 1个学生 有多个老师, 1个老师有多名学生。
Sql : select * from TEACHER T LEFT JOIN TEACHER_STUDENT TS ON ST.TEACHER_ID = T.ID LEFT JOIN STUDENT S ON TS_STUDENT_ID = S.ID
AND S.NAME = 'xxx';
HQL :
from Teacher.class.getName() t join students s where s.name = 'XXX';
即用 JOIN关联students 然后 用 students 去查询条件