<resultMap type="ClassEntity" id="classResultMap">
<id property="classID" column="CLASS_ID" />
<result property="className" column="CLASS_NAME" />
<result property="classYear" column="CLASS_YEAR" />
<association property="teacherEntity" column="TEACHER_ID" select="getTeacher"/>
</resultMap>
<select id="getClassByID" parameterType="String" resultMap="classResultMap">
SELECT * FROM CLASS_TBL CT
WHERE CT.CLASS_ID = #{classID};
</select>
以上为实现联合的第一种方式,现在teacherMapper.xml中定义好根据id查询teacher尸体的语句,可以在class的mpaper.xml中通过以上方式从而查出具体的包含teacher尸体的数据。。。实体。。。
<pre name="code" class="java"><resultMap type="ClassEntity" id="classResultMap">
<id property="classID" column="CLASS_ID" />
<result property="className" column="CLASS_NAME" />
<result property="classYear" column="CLASS_YEAR" />
<association property="teacherEntity" column="TEACHER_ID" resultMap="teacherResultMap"/>
</resultMap>
<select id="getClassAndTeacher" parameterType="String" resultMap="classResultMap">
SELECT *
FROM CLASS_TBL CT LEFT JOIN TEACHER_TBL TT ON CT.TEACHER_ID = TT.TEACHER_ID
WHERE CT.CLASS_ID = #{classID};
</select>
以上为实现联合的第二种方式,不需要在teacherMapper.xml中写select但是在SQL中手动添加上连接
以上内容摘自:<a target=_blank href="http://limingnihao.iteye.com/blog/781878">点击打开链接</a>