public class Course {
private Long courseId
;
private String courseName
;
private List
<AudienceInfo> audienceList
;
}
public class AudienceInfo {
private String audienceId
;
private Long roleType
;
}
<resultMap id
="DictResultMap" type
="com.emotte.trainingbox.model.Course">
<result column
="COURSE_ID" property
="courseId" />
<result column
="COURSE_NAME" property
="courseName" />
<!-- collection 标签需放在最后
-->
<collection property
="audienceList" resultMap
="DictItemsMap"/>
</resultMap
>
<resultMap id
="DictItemsMap" type
="com.emotte.trainingbox.model.AudienceInfo">
<result column
="AUDIENCE_ID" property
="audienceId" />
<result column
="ROLE_TYPE" property
="roleType" />
</resultMap
>
<select id
="getList" resultMap
="DictResultMap">
SELECT T
.COURSE_ID
,
T
.COURSE_NAME
,
n
.audience_id
,
n
.role_type
FROM PERSON
.T_EMP_COURSE T LEFT JOIN person
.t_emp_audience_info n ON t
.course_id
= n
.course_id
WHERE T
.VALID
= 1
</select
>
