MyBatis踩坑记录-多表关联字段相同，字段数据覆盖问题

1. 背景描述

现有一下业务，单个任务下可能会有多个子任务，现将通过关联查询将子任务放在单个任务下，类似于这样的数据结构：

{"task": {"id": "1","name": "a","createTime": "2024-07-03 17:15:00"},"info": [{"id": "01","name": "aa","createTime": "2024-07-03 17:15:00"},{"id": "001","name": "aaa","createTime": "2024-07-03 17:15:00"},{"id": "0001","name": "aaaa","createTime": "2024-07-03 17:15:00"}]
}

2. 实体记录

public class TaskInfoVO {private TaskDO task;private List<SubTaskInfo> subTaskInfos;
}/*** 任务总表* @TableName task_list*/
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class TaskDO implements Serializable {private Long id;private String name;private Date createTime;private static final long serialVersionUID = 1L;
}/*** 子任务* @TableName task_list*/
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
@JsonInclude(JsonInclude.Include.ALWAYS)
public class SubTaskInfo implements Serializable {private Long id = 0L;private String name;private Date createTime;private static final long serialVersionUID = 1L;

3. 错误映射

<resultMap id="TaskInfoVOMap" type="com.iqiyi.auto.module.heal.controller.VO.TaskInfoVO"><association property="task" javaType="com.iqiyi.auto.module.heal.DO.TaskDO"><id property="id" column="id" jdbcType="BIGINT"/><result property="name" column="name" jdbcType="VARCHAR"/><result property="createTime" column="create_time" jdbcType="TIMESTAMP"/></association><collection property="subTaskInfos" ofType="com.iqiyi.auto.module.heal.DTO.SubTaskInfo" notNullColumn="id"><id property="id" column="id" jdbcType="BIGINT"/><result property="name" column="name" jdbcType="VARCHAR"/><result property="createTime" column="create_time" jdbcType="TIMESTAMP"/></collection></resultMap>

3.1 造成的影响

4. 解决办法

4.1 修改映射文件

<resultMap id="TaskInfoVOMap" type="com.iqiyi.auto.module.heal.controller.VO.TaskInfoVO"><association property="task" javaType="com.iqiyi.auto.module.heal.DO.TaskDO"><id property="id" column="id" jdbcType="BIGINT"/><result property="name" column="task_name" jdbcType="VARCHAR"/><result property="createTime" column="create_time" jdbcType="TIMESTAMP"/></association><collection property="subTaskInfos" ofType="com.iqiyi.auto.module.heal.DTO.SubTaskInfo" notNullColumn="id"><id property="id" column="id_sub" jdbcType="BIGINT"/><result property="name" column="name_sub" jdbcType="VARCHAR"/><result property="createTime" column="create_time_sub" jdbcType="TIMESTAMP"/></collection></resultMap>

5. 修复后的效果

5.1 返回的数据

5.2 正确展示

7. end ~

一天上一当，当当不一样，坑坑多多