sss

<insert id="saveImageUrlByList" parameterType="java.util.List">
insert into t_product_color_imgurl_mapping(product_id,color,img_url)values(
<foreach collection="list" item="item" index="index" separator=",">
(#{item.productID,jdbcType=VARCHAR},#{item.color,jdbcType=VARCHAR},#{item.imageUrl,jdbcType=VARCHAR})
</foreach>
)
</insert>