python爬虫并存入数据库中

import requests
import pymysql

# 发起HTTP请求获取数据
response = requests.get('http://example.com/api/data')
data = response.json()

# 连接MySQL数据库
conn = pymysql.connect(
    host='localhost',
    user='username',
    password='password',
    database='dbname'
)
cursor = conn.cursor()

# 将数据存入数据库
for item in data:
    cursor.execute("INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)", (item['value1'], item['value2'], item['value3']))

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