sql批量新增，修改

 1 　　<insert id="insertExtDocList" parameterType="map">
 2         INSERT INTO extprjdoc
 3         (docName,createTime,extProjectId)
 4         VALUES
 5         <foreach collection="list" item="item" index="index" separator=","> <!--  list 为传来的集合数据 -->
 6             (#{item.docName},NOW(),#{extProjectId})
 7         </foreach>
 8     </insert>
 9 
10     <update id="updateList" parameterType="map">
11         UPDATE extprjdoc SET sendUnit = #{sendUnit},reveiceUnit = #{reveiceUnit}
12         WHERE extProjectId IN
13         <foreach collection="list" item="item" index="index" separator="," open="("
14                  close=")">
15             #{item}
16         </foreach>
17     </update>

 

转载于:https://www.cnblogs.com/xueyicanfei/p/10191383.html