10,612
社区成员




<!--批量添加上架商品-->
<insert id="insertMultiGis" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="gis_id" keyColumn="gis_id">
INSERT INTO goodinstore
(goodid,businessid,retailprice,min_stock,stock)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.good.id},#{item.businessid},#{item.retailPrice},#{item.min_stock},#{item.stock})
</foreach>
ON DUPLICATE KEY UPDATE
retailprice = values(retailprice),
min_stock = values(min_stock),
stock = values(stock)
</insert>
ON DUPLICATE KEY UPDATE
retailprice = values(retailprice),
min_stock = values(min_stock),
stock = values(stock)