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>