mybatis insert foreach批量添加

mybatis insert foreach批量添加

代码语言：javascript代码运行次数：0运行复制

int insertSelectiveBatch(List<ImageDetailEntity> myList);

代码语言：javascript代码运行次数：0运行复制

//写法1
<insert id="insertSelectiveBatch">
        <foreach item="record" collection="list" separator=",">
        insert into image_detail(
            `order_no`,
            `img_receive_date`,
            `source`,
            `img_type`,
            `img_url`,
            `ext1`,
            `ext2`,
            `ext3`,
            `ext4`,
            `ext5`
        )values(
            #{record.orderNo},
            #{record.imgReceiveDate},
            #{record.source},
            #{record.imgType},
            #{record.imgUrl},
            #{record.ext1},
            #{record.ext2},
            #{record.ext3},
            #{record.ext4},
            #{record.ext5}
            )
        </foreach>
    </insert>


//写法2
//collection="list" 固定值    
    <insert id="insertSelectiveBatch">
        insert into image_detail(
            `order_no`,
            `img_receive_date`,
            `source`,
            `img_type`,
            `img_url`,
            `ext1`,
            `ext2`,
            `ext3`,
            `ext4`,
            `ext5`
        )values
        <foreach item="record" collection="list" separator=",">
            (
            #{record.orderNo},
            #{record.imgReceiveDate},
            #{record.source},
            #{record.imgType},
            #{record.imgUrl},
            #{record.ext1},
            #{record.ext2},
            #{record.ext3},
            #{record.ext4},
            #{record.ext5}
            )
        </foreach>
    </insert>

本文参与 腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。 原始发表：2023-08-14，如有侵权请联系 cloudcommunity@tencent 删除前往查看foreachinsertlistrecordmybatis