Mybatis的Mapper.xml 一对多

第一种方法:

一条sql语句:

<resultMap type="Teacher" id="teacherMap">
		<id column="id" property="id"/>
		<result column="name" property="name"/>
		<collection property="students" ofType="Student" column="id">
			<id column="sid" property="id"/><!-- 这里的column对应的是下面查询的别名，而不是表字段名 -->
			<result column="sname" property="name"/><!-- property对应JavaBean中的属性名 -->
			<result column="className" property="className"/>
		</collection>
	</resultMap>
	
	<!-- 查询所有的老师级各自的所有学生 -->
	<select id="getTeachers" parameterType="Teacher" resultMap="teacherMap">
		SELECT
			t.id,
			t.NAME,
			t.class_Name,
			s.id AS sid,
			s. NAME AS sname,
			s.class_name as className
		FROM
			teacher t
		LEFT JOIN student s ON t.id = s.teacher_id
	</select>

第二种方法:

两条sql语句:

<resultMap type="Teacher" id="teacherMaps">
		<id column="id" property="id"/>
		<result column="name" property="name"/>
		<result column="class_name" property="className"/>
		<collection property="students" ofType="Student" select="getStudents" column="id">
		</collection>
	</resultMap>
	
	
	<!-- 查询所有的老师级各自的所有学生 -->
	<select id="getAllTeacher" parameterType="Teacher" resultMap="teacherMaps">
		SELECT
			t.id,
			t.NAME,
			t.class_name
		FROM
			teacher t
	</select>
	
	<select id="getStudents" parameterType="int" resultType="Student">
		select 
			s.id,
			s. NAME,
			s.class_name as className
		from student s
		where teacher_id = #{id}
	</select>

1. JavaType和ofType都是用来指定对象类型的，但是JavaType是用来指定pojo中类属性的类型，而ofType指定的是映射到list集合属性中pojo的类型。

2. collection中的column对应关联表的主键别名(高效率不写column)