MyBatis批量插入

1. 代码

实体类

@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class SupCheckPointSrc extends BaseEntity
{/**监管记录监管记录扣分项目表id */@NotNull(message = "扣分项目id为空")private Long supCheckPointId;/** 照片地址 */@NotBlank(message = "图片地址不能为空")private String evidenceSrc;
}

Mappper层

    /*** 批量插入* @param supCheckPointSrcs*/public void insertBatch(@Param("dtoList") List<SupCheckPointSrc> supCheckPointSrcs);

xml文件

    <insert id="insertBatch">insert into sup_check_point_src(sup_check_point_id, evidence_src) values<foreach collection="dtoList" separator="," item="item">(#{item.supCheckPointId,jdbcType=BIGINT},#{item.evidenceSrc,jdbcType=VARCHAR})</foreach></insert>