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>
