<insert id="addShopList">
INSERT INTO `pig`.`drugstore`
(OrgNo,OrgName,xqy,mgb,Address,Telephone,Isfrozen,kmsj,dysj,qyjl,lng,lat)
VALUES
<foreach collection="addList" item="item" index="index" separator=",">
(
#{item.OrgNo},
#{item.OrgName},
#{item.xqy},
#{item.mgb},
#{item.Address},
#{item.Telephone},
#{item.Isfrozen},
#{item.kmsj},
#{item.dysj},
#{item.qyjl},
#{item.lng},
#{item.lat}
)
</foreach>
ON DUPLICATE KEY UPDATE
OrgName=VALUES(OrgName),
xqy=VALUES(xqy),
mgb=VALUES(mgb),
Address=VALUES(Address),
Telephone=VALUES(Telephone),
Isfrozen=VALUES(Isfrozen),
kmsj=VALUES(kmsj),
dysj=VALUES(dysj),
qyjl=VALUES(qyjl)
</insert>