批量修改    
<update id="updateTaskDistributions" parameterType="java.util.List"><foreach collection="viewTaskDistributions" index="index" item="item" open="begin" close=";end;" separator=";">update T_TASK_DISTRIBUTIONset task_Number = #{item.taskNumber,jdbcType=DECIMAL},Institution_Id = #{item.institutionId,jdbcType=DECIMAL},Institution_Name = #{item.institutionName,jdbcType=VARCHAR},describe = #{item.describe,jdbcType=VARCHAR},update_time = sysdatewhere id = #{item.id}</foreach></update>批量新增<insert id="addTaskDistributions" parameterType="list">insert into T_Task_Distribution(ID,TASK_ID,TASK_NUMBER,INSTITUTION_ID,INSTITUTION_NAME,CREATE_TIME,UPDATE_TIME)select SEQ_TASK_DISTRIBUTION_ID.nextval ID ,m.* from(<foreach collection="viewTaskDistributions" index="index" item="item" separator="union all">select #{taskId} TASK_ID,#{item.taskNumber} TASK_NUMBER,#{item.institutionId} INSTITUTION_ID,#{item.institutionName} INSTITUTION_NAME,SYSDATE CREATE_TIME,SYSDATE UPDATE_TIMEFROM dual</foreach>)m</insert>去掉某個符號標簽
<trim prefix="(" suffix=")" suffixOverrides="," ></trim>```