如何通过for或while将json数组放入数据库？

import json
import pymysql

# 连接到数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')
cursor = conn.cursor()

# JSON数组
json_array = '[{"name": "John", "age": 30}, {"name": "Jane", "age": 25}, {"name": "Tom", "age": 35}]'

# 解析JSON数组
data = json.loads(json_array)

# 遍历JSON数组
for item in data:
    name = item['name']
    age = item['age']
    
    # 将数据插入数据库表
    sql = "INSERT INTO table_name (name, age) VALUES (%s, %s)"
    cursor.execute(sql, (name, age))
    conn.commit()

# 关闭数据库连接
cursor.close()
conn.close()