Python Selenium循环通过MySQL中的组

from selenium import webdriver
import pymysql

conn = pymysql.connect(host='localhost', user='root', password='password', database='database_name')

cursor = conn.cursor()

sql = "SELECT column1, column2 FROM table_name"

cursor.execute(sql)

for row in cursor.fetchall():
    column1_value = row[0]
    column2_value = row[1]
    
    # 在这里编写你的数据采集逻辑，使用Python Selenium进行网页操作和数据提取
    # 例如：
    driver = webdriver.Chrome()
    driver.get('https://www.example.com')
    element = driver.find_element_by_xpath('//div[@class="example"]')
    text = element.text
    
    # 将采集到的数据插入到另一个表中或进行其他操作
    insert_sql = "INSERT INTO another_table (column1, column2) VALUES (%s, %s)"
    cursor.execute(insert_sql, (text, column2_value))
    conn.commit()
    
    driver.quit()

conn.close()