使用Python将BS4抓取的数据发送到sqlite3数据库

from bs4 import BeautifulSoup
import requests
import sqlite3

url = "网页的URL"
response = requests.get(url)
soup = BeautifulSoup(response.text, "html.parser")

conn = sqlite3.connect("数据库文件路径")
cursor = conn.cursor()

create_table_query = """
CREATE TABLE IF NOT EXISTS 表名 (
    字段1 数据类型,
    字段2 数据类型,
    ...
)
"""
cursor.execute(create_table_query)

data = soup.find_all("标签名")
for item in data:
    value1 = item.find("子标签1").text.strip()
    value2 = item.find("子标签2").text.strip()
    
    insert_query = """
    INSERT INTO 表名 (字段1, 字段2)
    VALUES (?, ?)
    """
    cursor.execute(insert_query, (value1, value2))

conn.commit()
conn.close()