mybatis collection 的用法实践

    <resultMap id="vmlist" type="com.govcloud.msbusinessserviceprovider.model.VmListzhs">
        <result column="id" property="id"/>
        <result column="systemname" property="systemname"/>
        <collection property="vmList" column="id" javaType="ArrayList"
                    ofType="com.govcloud.msbusinessserviceprovider.model.business.EntityModel.BusiVMInfo"
                    select="getbusivminfo" />
    </resultMap>
    <select id="selectVmList" resultMap="vmlist">
        select id,systemname from "odgovcloud"."od_busisysteminfo"
    </select>
    <select id="getbusivminfo" parameterType="string" resultType="com.govcloud.msbusinessserviceprovider.model.business.EntityModel.BusiVMInfo">
        select * from "odgovcloud"."od_busivminfo" where systemid=#{id}
    </select>

需要注意的是<collection>中的column="id"，这个是两个SQL的关联字段，id必须是selectVmList的返回字段中

实体类

public class VmListzhs  {
    private  String id;
    private  String systemname;
    private List<BusiVMInfo> vmList;
}

返回结果如图