重新整理Mybatis-06

写在前面：受限于自身编程语言水平，文中可能存在错误之处，博客本意只为自查，不建议作为学习之用

<!-- 一对一连表查询结果处理（嵌套结果方式） -->
	<resultMap type="Classes" id="getClasses">
		<id property="classId" column="c_id"/>
		<result property="className" column="c_name"/>
		<association property="teacherId" column="teacher_id" javaType="Teacher">
			<id property="teacherId" column="t_id"/>
			<result property="teacherName" column="t_name"/>
		</association>
	</resultMap>
	
	<select id="selectClass" parameterType="int" resultMap="getClasses">
		select * from class c,teacher t where t.t_id=c.teacher_id and c.c_id=#{id}
	</select>
	
	
	<!-- 一对一连表查询结果处理（嵌套查询方式） -->
	<select id="selectClass2" parameterType="int" resultMap="getClasses2">
		select * from class where c_id=#{id}
	</select>
	
	<select id="selectTeacher" parameterType="int" resultType="Teacher">
		select t_id teacherId,t_name teacherName from teacher where t_id=#{id}
	</select>
	
	<resultMap type="Classes" id="getClasses2">
		<id property="classId" column="c_id"/>
		<result property="className" column="c_name"/>
		<association property="teacherId" column="teacher_id" javaType="Teacher" select="selectTeacher"></association>
	</resultMap>