目录
一、一对多
示例:一个老师对应多个学生
<select id="getStudentsByTeacherId" resultMap="TeacherStudent">
select s.id sid, s.name sname , t.name tname,t.id tid
from student s,teacher t where s.tid = t.id and t.id = #{tid}
</select>
<resultMap id="TeacherStudent" type="teacher">
<result property="id" column="tid"/>
<result property="name" column="tname"/>
<collection property="students" ofType="student">
<result property="id" column="sid"/>
<result property="name" column="sname"/>
<result property="tid" column="tid"/>
</collection>
</resultMap>
二、多对一
示例:多个学生对应一个老师
1、查询嵌套处理(相当于 连表查询)
<!-- 查询嵌套处理-->
<mapper>
<select id="getStudents" resultMap="StudentTeacher">
select * from student
</select>
<resultMap id="StudentTeacher" type="Student">
<id property="id" column="id"></id>
<result property="name" column="name"></result>
<!--association关联属性(属性是对象时用association)
property属性名 column在多的一方的表中的列名 javaType属性类型 -->
<association property="teacher" column="tid" javaType="Teacher" select="getTeacherById"/>
</resultMap>
<!--
这里传递过来的id,只有一个属性的时候,下面可以写任何值
association中column多参数配置:
column="{key=value,key=value}"
其实就是键值对的形式,key是传给下个sql的取值名称,value是片段一中sql查询的字段名。
-->
<select id="getTeacherById" resultType="teacher">
select * from teacher where id = #{id}
</select>
</mapper>
2、结果嵌套处理(相当于 子查询)
<mapper namespace="com.liyilin.dao.StudentMapper">
<select id="getStudents2" resultMap="StudentTeacher2">
select s.id sid, s.name sname , t.name tname
from student s,teacher t
where s.tid = t.id
</select>
<resultMap id="StudentTeacher2" type="student">
<result property="id" column="sid"/>
<result property="name" column="sname"/>
<association property="teacher" javaType="Teacher">
<result property="name" column="tname"/>
</association>
</resultMap>
</mapper>