mybatis的association用法，表示has-one

我是条汉子

前提：Student(id,name,supervisor_id), Teacher(id,name)，其中student.supervisor_id关联teacher.id，表示一个学生只有一个导师，一对一关系。

重要说明：column属性对应的SQL语句中，定义的别名（如果定义的话）

写法一：嵌套的select语句
<resultMap>
<association property="supervisor" column="supervisor_id"  
select="findTeacherById" />
</resultMap>

<select id="findTeacherById" parameterType="int" resultMap="TeacherResultMap" >
    select *
    from   t_Teacher
    where  id=#{id}
</select>

<select id="findStudentById" parameterType="int" resultMap="StudentResultMap" >
    select  *
    from    t_Student
    where   id=#{id}
</select>

写法二： 嵌套的resultMap，直接在association中映射t_teacher表
<resultMap>
<association property="supervisor" javaType="Teacher">
    <id property="id" column="t_id"/>
    <result property="name" column="t_name"/>
</association>
</resultMap>

<select id="findSuperVisorByStudent" parameterType="int" resultMap="StudentResultMap">
    select  ts.id as s_id,
   ts.name as s_name,
   ts.supervisor_id as s_supervisor_id,
   tt.id as t_id,
   tt.name as t_name
    from    t_student ts left outer join t_teacher tt
    on    ts.supervisor_id = tt.id
    where   ts.id = #{id}
</select>

写法三： 嵌套的resultMap，在外部映射t_teacher表
<resultMap>
<association property="supervisor" resultMap="supervisorResultMap" />
</resultMap>

<resultMap type="Teacher" id="supervisorResultMap">
    <id property="id" column="t_id"/>
    <result property="name" column="t_name"/>
</resultMap>

<select id="findSuperVisorByStudent" parameterType="int" resultMap="StudentResultMap">
    select  ts.id as s_id,
   ts.name as s_name,
   ts.supervisor_id as s_supervisor_id,
   tt.id as t_id,
   tt.name as t_name
    from    t_student ts left outer join t_teacher tt
    on    ts.supervisor_id = tt.id
    where   ts.id = #{id}
</select>