使用resultMap将SQL查询结果放入List，List中再嵌套List和其他对象

<resultMap id="sjqsMap" type="com.jqxx.digtwinresop.module.equipment.controller.admin.equipmentData.vo.dto.EquipmentDataDto">
        <id column = "id_a" property = "id" />这是重中之重
        <collection property="equipmentInfoVo" ofType="com.jqxx.digtwinresop.module.equipment.controller.admin.equipmentInfo.vo.EquipmentInfoVo" resultMap="infoVoMap"/>
        <collection property="dataVoList" ofType="com.jqxx.digtwinresop.module.equipment.controller.admin.equipmentData.vo.EquipmentDataVo" resultMap="dataVoMap"/>
    </resultMap>

    <resultMap id="infoVoMap" type="com.jqxx.digtwinresop.module.equipment.controller.admin.equipmentInfo.vo.EquipmentInfoVo">
        <id property="id" column="id_a" />
        <result property="name" column="name_a" />
        <result property="status" column="status_a" />
        <result property="createTime" column="create_time_a" />
        <result property="updateTime" column="update_time_a" />
        <result property="sbwz" column="sbwz_a" />
        <result property="sfgz" column="sfgz_a" />
        <result property="xzb" column="xzb_a" />
        <result property="yzb" column="yzb_a" />
        <result property="gczb" column="gczb_a" />
        <result property="yjyzxxOne" column="yjyzxx_one_a" />
        <result property="yjyzxxTwo" column="yjyzxx_two_a" />
        <result property="yjyzsxOne" column="yjyzsx_one_a" />
        <result property="yjyzsxTwo" column="yjyzsx_two_a" />
        <result property="bjyzxxOne" column="bjyzxx_one_a" />
        <result property="bjyzxxTwo" column="bjyzxx_two_a" />
        <result property="equipmentGroup" column="equipment_group_a" />
    </resultMap>

    <resultMap id="dataVoMap" type="com.jqxx.digtwinresop.module.equipment.controller.admin.equipmentData.vo.EquipmentDataVo">
        <id property="id" column="id_b" />
        <result property="equipmentInfoId" column="equipment_info_id_b" />
        <result property="createTime" column="create_time_b" />
        <result property="status" column="status_b" />
        <result property="value" column="value_b" />
        <result property="equipmentInfoName" column="equipment_info_name_b" />
    </resultMap>

记个笔记，免得以后再翻资料

p: 最关键的一步，<id column = "id_a" property = "id" />，必须加上这句，不然查询结果不对，查询的每个集合中的数据单独成一个对象封装在集合了