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>