MyBatis批量更新

最新推荐文章于 2024-09-13 22:38:14 发布

JZDELD

最新推荐文章于 2024-09-13 22:38:14 发布

阅读量104

点赞数

分类专栏： MySQL 文章标签： mysql mybatis

本文链接：https://blog.csdn.net/qq_43625640/article/details/116266965

版权

MySQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

方案一

关键：allowMultiQueries=true

datasource:
    url: jdbc:mysql://127.0.0.1:3306/my_db?characterEncoding=UTF-8&useUnicode=true&useSSL=false&allowMultiQueries=true&serverTimezone=GMT%2b8
    username: root
    password: root

<update id="batchUpdate">
    <foreach collection="list" item="param" index="index">
        UPDATE base_device SET
        device_type=#{param.deviceType},
        device_name=#{param.deviceName},
        device_location_des=#{param.deviceLocationDes},
        device_depart_id=#{param.deviceDepartId},
        long_lat=geomfromtext(#{param.longLat}),

        community_id=#{param.communityId},
        community=#{param.community},
        device_direction=#{param.deviceDirection},
        device_principal=#{param.devicePrincipal},

        remark=#{param.remark},
        update_by=#{param.updateBy},
        update_time=#{param.updateTime}

        WHERE
        third_system_id=#{param.thirdSystemId};
    </foreach>
</update>