Mybatis批量修改，添加,删除

批量插入:

replace into xx (id, c1,c2) values

(#{it.id},#{it.c1},#{it.c2})

批量删除:

delete from emp where empno in

#{arr}

批量修改:
传进来的是一个list对象,然后根据每个对象的id来分别修改number

update T_WARE_COMMENT_TAG set NUMBER =NUMBER + when #{item.id} then #{item.number} where ID in #{i.id,jdbcType=INTEGER}