如何在Mywebservice中插入多条来自json的记录

import json
import mysql.connector

# 解析JSON数据
json_data = '''
[
    {"name": "John", "age": 25},
    {"name": "Jane", "age": 30},
    {"name": "Tom", "age": 35}
]
'''
records = json.loads(json_data)

# 连接到数据库
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="mydatabase"
)
cursor = conn.cursor()

# 构建插入语句
insert_query = "INSERT INTO mytable (name, age) VALUES (%s, %s)"

# 执行插入操作
for record in records:
    values = (record["name"], record["age"])
    cursor.execute(insert_query, values)

# 提交事务并关闭连接
conn.commit()
cursor.close()
conn.close()