1、实现效果
2、MyBatis配置文件中SQL写法
<select id="selectTeachersByName" resultMap="teacherMap">
select tea.teacher_id as teaId,tea.teacher_name as teaName,
aca.academy_name as acaName,cou.course_name as couName
from (select * from interact_teacher where teacher_name like '%'||#{teacherName}||'%')
tea join interact_academy aca
on tea.academy_id=aca.academy_id
join interact_course cou
on cou.teacher_id=tea.teacher_id order by tea.teacher_id
</select>
<select id="selectTeachersByAcademy" resultMap="teacherMap">
select tea.teacher_id as teaId,tea.teacher_name as teaName,
aca.academy_name as acaName,cou.course_name as couName
from interact_teacher tea join
(select * from interact_academy where academy_name like '%'||#{academyName}||'%')
aca on tea.academy_id=aca.academy_id
join interact_course cou
on cou.teacher_id=tea.teacher_id order by tea.teacher_id
</select>