Mybatis-批量操作

晚霞虽美不如你

已于 2023-06-22 10:23:38 修改

阅读量148

点赞数

分类专栏： Mysql 文章标签： java

于 2023-05-26 15:51:09 首次发布

本文链接：https://blog.csdn.net/qq_33879443/article/details/130888489

版权

Mysql 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

批量更新

 @Update("<script>"
            + "UPDATE sy_game_register_retain "
            + "SET "
            + "retain_user = CASE id "
            + "<foreach collection='list' item='item' index='index'>"
            + "WHEN #{item.id} THEN #{item.retainUser} "
            + "</foreach>"
            + "END, "
            + "retain_new_pay_user = CASE id "
            + "<foreach collection='list' item='item' index='index'>"
            + "WHEN #{item.id} THEN #{item.retainNewPayUser} "
            + "</foreach>"
            + "END, "
            + "retain_active_number = CASE id "
            + "<foreach collection='list' item='item' index='index'>"
            + "WHEN #{item.id} THEN #{item.retainActiveNumber} "
            + "</foreach>"
            + "END, "
            + "register_retain_payment = CASE id "
            + "<foreach collection='list' item='item' index='index'>"
            + "WHEN #{item.id} THEN #{item.registerRetainPayment} "
            + "</foreach>"
            + "END, "
            + "region_code = CASE id "
            + "<foreach collection='list' item='item' index='index'>"
            + "WHEN #{item.id} THEN #{item.regionCode} "
            + "</foreach>"
            + "END, "
            + "modified_time = CASE id "
            + "<foreach collection='list' item='item' index='index'>"
            + "WHEN #{item.id} THEN #{item.modifiedTime} "
            + "</foreach>"
            + "END "
            + "WHERE id IN "
            + "<foreach collection='list' item='item' index='index' open='(' close=')' separator=','>"
            + " #{item.id}"
            + "</foreach>"
            + "</script>")
    void batchUpdate(@Param("list") List<GameRegisterRetainDO> list);

批量插入

  @Insert("<script>"
            + "INSERT INTO sy_game_register_retain "
            + "(gid,gcid,platform,benchmark_date,days,retain_user,created_time,modified_time,"
            + "retain_new_pay_user,retain_active_number,register_retain_payment,region_code) "
            + "VALUES "
            + "<foreach collection='list' item='item' separator=',' >"
            + " ( "
            + "  #{item.gid},#{item.gcid},#{item.benchmarkDate},#{item.days},#{item.retainUser},"
            + "  unix_timestamp(),unix_timestamp(),#{item.retainNewPayUser},#{item.retainNewPayUser},"
            + "#{item.retainActiveNumber},#{item.registerRetainPayment},#{item.regionCode} "
            + " ) "
            + "</foreach>"
            + "</script>")
    void batchInsert(@Param("list") List<GameRegisterRetainDO> list);