mybatis批量更新写法

1、mapper

void batchUpdateLevel(@Param("sysDeptList") List<SysDept> sysDeptList);

2、mapper.xml

<update id="batchUpdateLevel" parameterType="map">
  <foreach collection="sysDeptList" item="dept" separator=";">
    UPDATE sys_dept
    SET level = #{dept.level}
    WHERE id = #{dept.id}
  </foreach>
</update>