scrapy 存储MySQL数据库

需要安装：

pip install pymysql

代码：

import scrapy
import pymysql  # 导入 pymysql
from selenium import webdriver
from selenium.webdriver.chrome.service import Service
from selenium.webdriver.chrome.options import Options
import time
import os
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
from selenium.webdriver.common.action_chains import ActionChains
from selenium.common.exceptions import NoSuchElementException
from bs4 import BeautifulSoup

class SavearrSpider(scrapy.Spider):
    name = "savearr"
    allowed_domains = ["***.com"]
    start_urls = ["https://www.***.com"]

    def __init__(self, *args, **kwargs):
        super(SavearrSpider, self).__init__(*args, **kwargs)
        chrome_options = Options()
        chrome_options.add_argument("--start-maximized")  # 启动最大化
        chrome_options.add_ar