前提: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>
重要说明: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>