多个Json对象导入到SQL Server表中

import pyodbc
import json

# JSON对象列表
json_objects = [
    {
        "id": 1,
        "name": "John",
        "age": 25
    },
    {
        "id": 2,
        "name": "Jane",
        "age": 30
    }
]

# SQL Server连接配置
server = 'your_server_name'
database = 'your_database_name'
username = 'your_username'
password = 'your_password'
driver = '{ODBC Driver 17 for SQL Server}'

# 建立与SQL Server的连接
conn = pyodbc.connect(f'DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password}')

# 创建游标
cursor = conn.cursor()

# 遍历JSON对象列表
for json_obj in json_objects:
    # 解析JSON对象
    id = json_obj['id']
    name = json_obj['name']
    age = json_obj['age']
    
    # 插入数据到表中
    cursor.execute(f"INSERT INTO YourTableName (id, name, age) VALUES ({id}, '{name}', {age})")

# 提交事务
conn.commit()

# 关闭连接
cursor.close()
conn.close()