mybatis批量修改数据

xxxMapper.xml:

<update id="updateSensorWarnings" parameterType="java.util.List" >
    <foreach collection="list" item="item" index="index" open="" close="" separator=";">
        update sensor_warning
        <set >
            <if test="item.handlePerson != null and item.handlePerson != ''  " >
                handle_person = #{item.handlePerson},
            </if>
            <if test="item.processProgress != null and item.processProgress != ''  " >
                process_progress = #{item.processProgress}
            </if>
        </set>
        where id = #{item.id}
    </foreach>
</update>

示例代码:

原文地址:https://www.cnblogs.com/congyiblog/p/13847335.html