如何批量修改(更新)

昨天遇到批量修改的问题，结果是自己在apifox传递参数出问题了。但是还是记录一下

接口：

        

    /**
     * 批量更新数据
     *
     * @return 影响行数
     */
    int insertOrUpdateBatch(@Param("list") List<JsMaintenanceContent> maintenanceId);

sql

   <!-- 批量更新数据 -->
    <update id="insertOrUpdateBatch">
        <foreach collection="list" item="maintenanceId" separator=";">
            update js_maintenance_content
            <set>
                xm_type = #{maintenanceId.xmType},
                maintenance_content = #{maintenanceId.maintenanceContent},
                requirement = #{maintenanceId.requirement},
                remarks = #{maintenanceId.remarks},
                whether_delete = #{maintenanceId.whetherDelete},
                CREATE_BY = #{maintenanceId.createBy},
                CREATE_TIME = #{maintenanceId.createTime},
                UPDATE_BY = #{maintenanceId.updateBy},
                UPDATE_TIME = #{maintenanceId.updateTime}
            </set>
            where maintenance_id = #{maintenanceId.maintenanceId}
        </foreach>
    </update>

测试

content": [
        {
            "xmType": "111",
            "maintenanceContent": "非常好11",
            "requirement": "高级11",
            "remarks": "哈哈11",
            "whetherDelete": 0
        }
    ]