mybatis批量处理

最新推荐文章于 2024-07-10 21:37:49 发布

爱窦

最新推荐文章于 2024-07-10 21:37:49 发布

阅读量389

点赞数 5

文章标签： mybatis java 数据库

本文链接：https://blog.csdn.net/weixin_44342481/article/details/139990915

版权

批量修改    
<update id="updateTaskDistributions" parameterType="java.util.List">
        <foreach collection="viewTaskDistributions" index="index" item="item" open="begin" close=";end;" separator=";">
            update T_TASK_DISTRIBUTION
            set 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 = sysdate
            where 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_TIME
                FROM dual
            </foreach>
        )m
    </insert>

去掉某个符号标签
<trim prefix="(" suffix=")" suffixOverrides="," ></trim>```