mybatis insert foreach批量添加

mybatis insert foreach批量添加

int insertSelectiveBatch(List<ImageDetailEntity> myList);

//写法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>