python爬虫入库操作教程

import mysql.connector as mysqldb = mysql.connect(    host="localhost",    user="root",    password="rootpassword",  # 替换为您的密码    database="my_database",)cursor = db.cursor()

sql = "INSERT INTO my_table (field1, field2, field3) VALUES (%s, %s, %s)"

data = ("value1", "value2", "value3")cursor.execute(sql, data)

db.commit()

cursor.close()db.close()

import requestsfrom bs4 import BeautifulSoupimport mysql.connector as mysql# 爬取网页数据url = "example.com"response = requests.get(url)soup = BeautifulSoup(response.text, "html.parser")# 提取数据并准备 SQL 插入语句sql = "INSERT INTO my_table (title, content) VALUES (%s, %s)"data = []for article in soup.find_all("article"):    title = article.find("h1").text    content = article.find("p").text    data.append((title, content))# 建立数据库连接并执行插入操作db = mysql.connect(...)  # 同上cursor = db.cursor()cursor.executemany(sql, data)db.commit()# 关闭连接cursor.close()db.close()