xml中批量增删改＜foreach＞

 //增加

<insert id="add" parameterType="java.util.List">

         <foreach collection="list" item="item" separator=";" close=";end;" index="index" open="begin">

                 insert into table(a,b,c) VALUES(#{item.a},#{item.b},1)

         </foreach>

</insert>

//修改

<update id="update" parameterType="java.util.List">

        <foreach collection="list" item="item" close=";end;" index="index" open="begin" separator=";">

                update table set a=#{item.a} WHERE id=#{item.id}

         </foreach>

</update>

//删除

<delete id="delete " parameterType="java.util.List">

        <foreach collection="list" item="item" close=";end;" index="index" open="begin" separator=";">

                delete from table WHERE id=#{item.id}

         </foreach>

</delete >