mybatis级联查询（主子查询）

主表类

public class SysClass{
	private String classId;
	private String className;
	private String classType;
	//主表中添加子表的集合
	private List<SysStudent> sysStudentList;
	//get,set..
}

根据主表id查询出主表信息，返回map结果

<!-- 根据主键查询 -->
<select id="findById" parameterType="java.lang.String" resultMap="classAndStudentsMap">
	SELECT
		A.ID AS "id",
		A.NAME AS "name",
		A.TYPE AS "type"
	FROM SYS_CLASS A WHERE A.ID=#{id}
</select>

在map结果中映射主子关系，映射子表在主表的字段，并根据主表id查询子表信息

<!-- 映射子表在主表的字段，并根据主表id查询子表信息 -->
<resultMap id="classAndStudentsMap" type="com.wyd.model.SysClass">
	<id property="id" column="id"/>
	<collection property="sysStudentList" column="id" javaType="ArrayList" select="findSysStudentById"/>
</resultMap>

根据主表的id，查询子表的信息

<!-- 根据主表的id，查询子表的信息 -->
<select id="findSysStudentById" resultType="com.wyd.model.SysStudent">
       SELECT
       	B.ID AS "stuId"
       	B.Name AS "stuName"
		B.SEX AS "stuSex"
       FROM SYS_STUDENT B WHERE B.SYS_CLASS_ID = #{id}
</select>