一对多
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.example.dao.TeacherMapper">
<resultMap id="getTeacherStudent" type="Teacher">
<result property="id" column="tid"/>
<result property="name" column="tname"/>
<collection property="student" ofType="Student">
<result property="id" column="sid"/>
<result property="name" column="sname"/>
<result property="tid" column="tid"/>
</collection>
</resultMap>
<select id="getTeacher" resultMap="getTeacherStudent">
select s.id sid,s.name sname,t.name tname,t.id tid
from teacher t,student s
where t.id = s.tid
and t.id = #{tid};
</select>
</mapper>
多对一
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.example.dao.StudentMapper">
<resultMap id="StudentTeacher" type="Student">
<result column="sid" property="id" />
<result column="sname" property="name"/>
<association property="teacher" javaType="Teacher" >
<result column="tid" property="id"/>
<result column="tname" property="name"/>
</association>
</resultMap>
<select id="getStudent" resultMap="StudentTeacher">
select s.id sid,s.name sname,t.id tid,t.name tname
from student s,teacher t
where s.tid = t.id;
</select>
</mapper>