mybatis根据id的集合批量更新数据库数据

<update id = "updateFlagByIds" parameterType = "java.util.List">

        update system.event set flag = 0 where id in

                <foreach item = "item" index = "index" collection = "ids" open = "(" separator = "," close = ")">

                        #{item}

                </foreach>

</update>

 

其中ids为唯一标识id的list（在mapper中的入参），map的集合也可以，具体可以参考mybatis中foreach标签的使用