如何在循环中插入记录到表中？

import pymysql

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

# 准备要插入的记录数据
records = [
    {'name': 'John', 'age': 25},
    {'name': 'Alice', 'age': 30},
    {'name': 'Bob', 'age': 35}
]

# 循环插入记录
for record in records:
    # 构建插入语句
    sql = "INSERT INTO mytable (name, age) VALUES (%s, %s)"
    values = (record['name'], record['age'])
    
    try:
        # 执行插入语句
        cursor.execute(sql, values)
        conn.commit()
        print("Record inserted successfully.")
    except Exception as e:
        conn.rollback()
        print("Failed to insert record:", e)

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