mybatis中的多表查询数据封装

一般是这样的,如下所示:

<resultMap id="RM-BizGroupRelatedEventInfo" type="com.XXX.bean.BizGroupRelatedEventInfo">
    <result column="event_id" property="id" jdbcType="BIGINT" />
    <result column="event_name" property="name" jdbcType="VARCHAR" />
    <result column="image_obj" property="imageObj" jdbcType="VARCHAR" />
    <result column="inst_id" property="instId" jdbcType="BIGINT" />
    <result column="inst_name" property="teamName" jdbcType="VARCHAR" />
    <result column="description" property="description" jdbcType="VARCHAR" />
</resultMap>

但是我们有时候我们需要的是将一个实体类作为一个参数放在主表的实体类中,
我们就要进行collection标签的使用

<resultMap id="RM-BizGroupRelatedEventInfo" type="com.XXX.bean.BizGroupRelatedEventInfo">
    <result column="event_id" property="id" jdbcType="BIGINT" />
    <result column="event_name" property="name" jdbcType="VARCHAR" />
    <result column="image_obj" property="imageObj" jdbcType="VARCHAR" />
    <result column="inst_id" property="instId" jdbcType="BIGINT" />
    <result column="inst_name" property="teamName" jdbcType="VARCHAR" />
    <result column="description" property="description" jdbcType="VARCHAR" />
    <collection property="versionList" ofType="java.lang.String" javaType="java.util.List">
        <result column="event_version"/>
    </collection>
    <collection property="statusList" ofType="java.lang.Integer" javaType="java.util.List">
        <result column="event_version_status"/>
    </collection>
    <collection property="platforms" ofType="java.lang.Integer" javaType="java.util.List">
        <result column="platform"/>
    </collection>
</resultMap>

如果resultMap是自动生成的里面并没有我们需要的这样的话我们就需要对其进行扩展:

<resultMap id="ExtendResultMap" type="Java class" extends="BaseResultMap"></resultMap>