mybtis 批量修改

来源：华佗小知识

<update id="batchUpdate"> update set_pay_type set <foreach collection="payTypeList" item

  <update id="batchUpdate">
    update set_pay_type set
      <foreach collection="payTypeList" item="item" open="order_num=case" close="else order_num end">
        when id=#{item.id} then #{item.orderNum}
      </foreach>
      where id in
      <foreach collection="payTypeList" item="item" open="(" close=")" separator=",">
        #{item.id}
      </foreach>
  </update>


mysql输出
update set_pay_type set   order_num=case     when id=? then ?   when id=? then ?     else order_num end        where id in        (           ?        ,          ?        )

参考文献

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文

全部频道

mybtis 批量修改