MyBatis多对多级联查询
<resultMap id="GroupUserMap" type="com.incito.interclass.entity.Group" ><id column="id" property="id"/>
<result column="name" property="name"/>
<result column="logo" property="logo"/>
<result column="slogan" property="slogan"/>
<result column="course_id" property="courseId"/>
<result column="teacher_id" property="teacherId"/>
<result column="class_id" property="classId"/>
<result column="table_id" property="tableId"/>
<result column="ctime" property="ctime"/>
<collection property="students" column="id" ofType="com.incito.interclass.entity.Student"
select="com.incito.interclass.persistence.UserMapper.getStudentByGroupId">
<id column="id" property="id"/>
<result column="uname" property="uname"/>
<result column="password" property="password"/>
<result column="name" property="name"/>
<result column="email" property="email"/>
<result column="sex" property="sex"/>
<result column="is_active" property="isActive"/>
<result column="role" property="role"/>
<result column="ctime" property="ctime"/>
<result column="number" property="number"/>
<result column="avatar" property="avatar"/>
</collection>
</resultMap>
页:
[1]