\n| \u91c7\u96c6\u65f6\u95f4<\/td>\n | \u6570\u636e\u5feb\u7167\u65f6\u95f4<\/td>\n | \u65f6\u5e8f\u5206\u6790<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n3.2 \u5b8c\u6574\u722c\u866b\u5b9e\u73b0<\/h4>\nimport\u00a0requests
\nfrom\u00a0bs4\u00a0import\u00a0BeautifulSoup
\nimport\u00a0time
\nimport\u00a0random
\nimport\u00a0json
\nimport\u00a0pandas\u00a0as\u00a0pd
\nfrom\u00a0fake_useragent\u00a0import\u00a0UserAgent
\nfrom\u00a0datetime\u00a0import\u00a0datetime
\nimport\u00a0sqlite3<\/p>\n class\u00a0TmallScraper:
\n\u00a0\u00a0\u00a0\u00a0def\u00a0__init__(self,\u00a0use_tunnel=True):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.session\u00a0=\u00a0requests.Session()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.ua\u00a0=\u00a0UserAgent()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.use_tunnel\u00a0=\u00a0use_tunnel
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if\u00a0use_tunnel:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.proxies\u00a0=\u00a0{
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"http":\u00a0"http:\/\/\u7528\u6237\u540d:\u5bc6\u7801@tps.zdaye.com:8080",
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"https":\u00a0"http:\/\/\u7528\u6237\u540d:\u5bc6\u7801@tps.zdaye.com:8080"
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0else:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.proxies\u00a0=\u00a0None
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u00a0\u521d\u59cb\u5316\u6570\u636e\u5e93
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self._init_db()
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0def\u00a0_init_db(self):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"""\u521d\u59cb\u5316SQLite\u6570\u636e\u5e93\u5b58\u50a8\u4ef7\u683c\u5386\u53f2"""
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.conn\u00a0=\u00a0sqlite3.connect('tmall_prices.db')
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cursor\u00a0=\u00a0self.conn.cursor()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cursor.execute('''
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0CREATE\u00a0TABLE\u00a0IF\u00a0NOT\u00a0EXISTS\u00a0price_history\u00a0(
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0id\u00a0INTEGER\u00a0PRIMARY\u00a0KEY\u00a0AUTOINCREMENT,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0product_id\u00a0TEXT,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0product_name\u00a0TEXT,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0brand\u00a0TEXT,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0price\u00a0REAL,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sales\u00a0INTEGER,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0collect_time\u00a0TEXT
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0''')
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.conn.commit()
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0def\u00a0_get_headers(self):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0{
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"User-Agent":\u00a0self.ua.random,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"Referer":\u00a0"https:\/\/www.tmall.com\/",
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"Accept":\u00a0"text\/html,application\/xhtml+xml",
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"Accept-Language":\u00a0"zh-CN,zh;q=0.9",
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"Connection":\u00a0"keep-alive"
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0def\u00a0search_brand_products(self,\u00a0brand_name,\u00a0max_pages=5):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"""
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u641c\u7d22\u67d0\u732b\u54c1\u724c\u65d7\u8230\u5e97\u7684\u5546\u54c1
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"""
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0results\u00a0=\u00a0[]
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for\u00a0page\u00a0in\u00a0range(1,\u00a0max_pages\u00a0+\u00a01):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0url\u00a0=\u00a0f"https:\/\/list.tmall.com\/search_shopitem.htm?q={brand_name}&pageNo={page}"
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0print(f"\u641c\u7d22\u54c1\u724c\u00a0{brand_name}\u00a0\u7b2c{page}\u9875…")
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0html\u00a0=\u00a0self._fetch(url)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if\u00a0not\u00a0html:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0break
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0soup\u00a0=\u00a0BeautifulSoup(html,\u00a0'html.parser')
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0items\u00a0=\u00a0soup.find_all('div',\u00a0class_='product-item')\u00a0\u00a0#\u00a0\u5b9e\u9645\u9009\u62e9\u5668\u9700\u786e\u8ba4
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for\u00a0item\u00a0in\u00a0items:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0try:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0title\u00a0=\u00a0item.find('a',\u00a0class_='product-title').text.strip()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0price\u00a0=\u00a0item.find('span',\u00a0class_='price').text.strip()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sales\u00a0=\u00a0item.find('span',\u00a0class_='sales').text.strip()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0link\u00a0=\u00a0item.find('a').get('href',\u00a0'')
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0results.append({
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'brand':\u00a0brand_name,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'title':\u00a0title,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'price':\u00a0float(price.replace('\u00a5',\u00a0'').replace(',',\u00a0'')),
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'sales':\u00a0int(sales.replace('\u4eba\u4ed8\u6b3e',\u00a0'').replace('+',\u00a0'')),
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'link':\u00a0link,
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'collect_time':\u00a0datetime.now().isoformat()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0})
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0except\u00a0Exception\u00a0as\u00a0e:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0continue
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0time.sleep(random.uniform(2,\u00a04))
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0results
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0def\u00a0save_to_db(self,\u00a0products):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0"""\u4fdd\u5b58\u4ef7\u683c\u5feb\u7167\u5230\u6570\u636e\u5e93"""
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cursor\u00a0=\u00a0self.conn.cursor()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for\u00a0p\u00a0in\u00a0products:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cursor.execute('''
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0INSERT\u00a0INTO\u00a0price_history\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(product_id,\u00a0product_name,\u00a0brand,\u00a0price,\u00a0sales,\u00a0collect_time)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUES\u00a0(?,\u00a0?,\u00a0?,\u00a0?,\u00a0?,\u00a0?)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0''',\u00a0(p.get('link',\u00a0''),\u00a0p.get('title',\u00a0''),\u00a0p.get('brand',\u00a0''),
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0p.get('price',\u00a00),\u00a0p.get('sales',\u00a00),\u00a0p.get('collect_time',\u00a0'')))
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.conn.commit()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0print(f"\u5df2\u4fdd\u5b58\u00a0{len(products)}\u00a0\u6761\u4ef7\u683c\u8bb0\u5f55")
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0def\u00a0close(self):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0self.conn.close()<\/p>\n #\u00a0\u4f7f\u7528\u793a\u4f8b
\nif\u00a0__name__\u00a0==\u00a0"__main__":
\n\u00a0\u00a0\u00a0\u00a0scraper\u00a0=\u00a0TmallScraper(use_tunnel=True)
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0#\u00a0\u76d1\u63a7\u591a\u4e2a\u54c1\u724c
\n\u00a0\u00a0\u00a0\u00a0brands\u00a0=\u00a0["Apple",\u00a0"\u534e\u4e3a",\u00a0"\u5c0f\u7c73",\u00a0"\u7f8e\u7684"]
\n\u00a0\u00a0\u00a0\u00a0all_data\u00a0=\u00a0[]
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0for\u00a0brand\u00a0in\u00a0brands:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0print(f"\\\\n\u5f00\u59cb\u91c7\u96c6\u54c1\u724c:\u00a0{brand}")
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0products\u00a0=\u00a0scraper.search_brand_products(brand,\u00a0max_pages=3)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0scraper.save_to_db(products)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0all_data.extend(products)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0time.sleep(random.uniform(3,\u00a05))
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0scraper.close()
\n\u00a0\u00a0\u00a0\u00a0print(f"\u91c7\u96c6\u5b8c\u6210，\u5171\u00a0{len(all_data)}\u00a0\u6761\u5546\u54c1\u8bb0\u5f55")<\/p>\n 3.3 \u5b9a\u65f6\u91c7\u96c6\u4e0e\u4ef7\u683c\u8d8b\u52bf\u5206\u6790<\/h4>\n\u5b9e\u9645\u7684\u4ef7\u683c\u76d1\u63a7\u9700\u8981\u5b9a\u65f6\u8fd0\u884c（\u5982\u6bcf\u592910:00\u548c20:00\u5404\u4e00\u6b21），\u79ef\u7d2f\u5386\u53f2\u6570\u636e\u540e\u5206\u6790\u8d8b\u52bf\u3002<\/p>\n import\u00a0schedule<\/p>\n def\u00a0daily_price_task():
\n\u00a0\u00a0\u00a0\u00a0scraper\u00a0=\u00a0TmallScraper(use_tunnel=True)
\n\u00a0\u00a0\u00a0\u00a0brands\u00a0=\u00a0["Apple",\u00a0"\u534e\u4e3a",\u00a0"\u5c0f\u7c73",\u00a0"\u7f8e\u7684"]
\n\u00a0\u00a0\u00a0\u00a0for\u00a0brand\u00a0in\u00a0brands:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0products\u00a0=\u00a0scraper.search_brand_products(brand,\u00a0max_pages=2)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0scraper.save_to_db(products)
\n\u00a0\u00a0\u00a0\u00a0scraper.close()<\/p>\n #\u00a0\u6bcf\u592910:00\u548c20:00\u6267\u884c
\nschedule.every().day.at("10:00").do(daily_price_task)
\nschedule.every().day.at("20:00").do(daily_price_task)<\/p>\n while\u00a0True:
\n\u00a0\u00a0\u00a0\u00a0schedule.run_pending()
\n\u00a0\u00a0\u00a0\u00a0time.sleep(60)<\/p>\n \u56db\u3001\u53cc11\u4ef7\u683c\u771f\u76f8：\u6570\u636e\u80fd\u544a\u8bc9\u6211\u4eec\u4ec0\u4e48？<\/h3>\n\u6301\u7eed\u91c7\u96c6\u7684\u4ef7\u683c\u6570\u636e\u53ef\u4ee5\u63ed\u793a\u53cc11\u671f\u95f4\u7684\u4ef7\u683c\u53d8\u5316\u89c4\u5f8b\u3002<\/p>\n 4.1 \u4ef7\u683c\u66f2\u7ebf\u5206\u6790<\/h4>\nimport\u00a0sqlite3
\nimport\u00a0pandas\u00a0as\u00a0pd
\nimport\u00a0matplotlib.pyplot\u00a0as\u00a0plt<\/p>\n conn\u00a0=\u00a0sqlite3.connect('tmall_prices.db')<\/p>\n #\u00a0\u67e5\u8be2\u7279\u5b9a\u5546\u54c1\u7684\u4ef7\u683c\u5386\u53f2
\ndf\u00a0=\u00a0pd.read_sql_query('''
\n\u00a0\u00a0\u00a0\u00a0SELECT\u00a0product_name,\u00a0price,\u00a0collect_time\u00a0
\n\u00a0\u00a0\u00a0\u00a0FROM\u00a0price_history\u00a0
\n\u00a0\u00a0\u00a0\u00a0WHERE\u00a0product_name\u00a0LIKE\u00a0'%iPhone%'
\n\u00a0\u00a0\u00a0\u00a0ORDER\u00a0BY\u00a0collect_time
\n''',\u00a0conn)<\/p>\n #\u00a0\u7ed8\u5236\u4ef7\u683c\u8d8b\u52bf\u56fe
\ndf['collect_time']\u00a0=\u00a0pd.to_datetime(df['collect_time'])
\nplt.figure(figsize=(12,\u00a06))
\nfor\u00a0name,\u00a0group\u00a0in\u00a0df.groupby('product_name'):
\n\u00a0\u00a0\u00a0\u00a0plt.plot(group['collect_time'],\u00a0group['price'],\u00a0marker='o',\u00a0label=name)<\/p>\n plt.title('\u53cc11\u671f\u95f4iPhone\u4ef7\u683c\u53d8\u5316\u8d8b\u52bf')
\nplt.xlabel('\u65f6\u95f4')
\nplt.ylabel('\u4ef7\u683c\u00a0(\u5143)')
\nplt.legend()
\nplt.xticks(rotation=45)
\nplt.tight_layout()
\nplt.savefig('price_trend.png')
\nconn.close()<\/p>\n 4.2 \u53cc11\u4ef7\u683c\u771f\u76f8<\/h4>\n\u6839\u636e2025\u5e74\u53cc11\u7684\u8c03\u67e5\u6570\u636e，\u6d88\u8d39\u8005\u906d\u9047\u7684\u5178\u578b\u95ee\u9898\u5305\u62ec：<\/p>\n \u4ef7\u683c\u5012\u6302：\u540c\u6b3e\u51b0\u7bb1618\u53565723\u5143，\u53cc11\u53cd\u800c\u6da8\u52307742\u5143，\u4ef7\u5dee\u9ad8\u8fbe2019\u5143\u3002<\/p>\n \u51d1\u5355\u53cd\u8d35：\u5355\u72ec\u8d2d\u4e701298.72\u5143\u7684\u7fbd\u7ed2\u670d，\u51d1\u5355\u540e\u53cd\u800c\u53d8\u62101302.11\u5143\u3002\u539f\u56e0\u662f\u4f18\u60e0\u5238\u6709\u603b\u989d\u5ea6\u4e0a\u9650，\u5206\u644a\u5230\u591a\u4ef6\u5546\u54c1\u540e\u5355\u4ef6\u4f18\u60e0\u51cf\u5c11\u3002<\/p>\n VIP\u5dee\u5f02\u5b9a\u4ef7：\u540c\u6837\u5f00\u901a88VIP\u7684\u4e0d\u540c\u8d26\u53f7，\u540c\u4e00\u5546\u54c1\u7ed3\u7b97\u4ef7\u76f8\u5dee17\u5143\u3002<\/p>\n \u8fd9\u4e9b\u73b0\u8c61\u8bf4\u660e：\u53cc11\u7684\u201c\u4f4e\u4ef7\u201d\u5e76\u4e0d\u603b\u662f\u771f\u7684\u4f4e\u4ef7\u3002\u53ea\u6709\u901a\u8fc7\u6301\u7eed\u7684\u6570\u636e\u91c7\u96c6\u548c\u4ef7\u683c\u8ffd\u8e2a，\u624d\u80fd\u770b\u6e05\u771f\u5b9e\u7684\u4ef7\u683c\u53d8\u5316\u66f2\u7ebf\u3002<\/p>\n \u4e94\u3001\u5e38\u89c1\u95ee\u9898\u4e0e\u907f\u5751\u6307\u5357<\/h3>\n5.1 \u8bf7\u6c42\u88ab\u62e6\u622a\u600e\u4e48\u529e？<\/h4>\n\n- \n
\u68c0\u67e5\u662f\u5426\u643a\u5e26\u4e86\u5b8c\u6574\u7684\u8bf7\u6c42\u5934<\/p>\n<\/li>\n - \n
\u786e\u8ba4Cookie\u662f\u5426\u6709\u6548<\/p>\n<\/li>\n - \n
\u4f7f\u7528\u96a7\u9053\u4ee3\u7406\u81ea\u52a8\u5207\u6362IP<\/p>\n<\/li>\n - \n
\u589e\u52a0\u8bf7\u6c42\u95f4\u9694\u52303-5\u79d2<\/p>\n<\/li>\n<\/ul>\n 5.2 \u4ef7\u683c\u6570\u636e\u83b7\u53d6\u4e0d\u5168\u600e\u4e48\u529e？<\/h4>\n\n- \n
\u4f18\u5148\u91c7\u96c6\u79fb\u52a8\u7aef\u63a5\u53e3（m.tmall.com），\u52a0\u5bc6\u76f8\u5bf9\u7b80\u5355<\/p>\n<\/li>\n - \n
\u4f7f\u7528Selenium\/Playwright\u6e32\u67d3\u52a8\u6001\u4ef7\u683c<\/p>\n<\/li>\n - \n
\u5173\u6ce8\u4ef7\u683c\u63a5\u53e3\u7684API\u8c03\u7528，\u800c\u975e\u9875\u9762\u89e3\u6790<\/p>\n<\/li>\n<\/ul>\n 5.3 IP\u9891\u7e41\u88ab\u5c01\u600e\u4e48\u529e？<\/h4>\n\n- \n
\u4f7f\u7528\u7ad9\u5927\u7237\u96a7\u9053\u4ee3\u7406\u7684period\u53c2\u6570\u63a7\u5236IP\u66f4\u6362\u5468\u671f<\/p>\n<\/li>\n - \n
\u907f\u514d\u56fa\u5b9a\u65f6\u95f4\u95f4\u9694\u8bf7\u6c42，\u52a0\u5165\u968f\u673a\u5ef6\u8fdf<\/p>\n<\/li>\n - \n
\u914d\u5408Cookie\u6c60\u8f6e\u6362\u4f7f\u7528<\/p>\n<\/li>\n<\/ul>\n 5.4 \u6cd5\u5f8b\u4e0e\u5408\u89c4\u63d0\u9192<\/h4>\n\n- \n
\u722c\u53d6\u524d\u67e5\u770b\u67d0\u732b\u7684robots.txt<\/p>\n<\/li>\n - \n
\u63a7\u5236\u8bf7\u6c42\u9891\u7387，\u907f\u514d\u5bf9\u670d\u52a1\u5668\u9020\u6210\u8fc7\u5927\u538b\u529b<\/p>\n<\/li>\n - \n
\u4ec5\u5c06\u6570\u636e\u7528\u4e8e\u5b66\u4e60\u548c\u4e2a\u4eba\u7814\u7a76\u76ee\u7684<\/p>\n<\/li>\n<\/ul>\n \u516d\u3001\u603b\u7ed3<\/h3>\n\u53cc11\u7684\u201c\u4f4e\u4ef7\u72c2\u6b22\u201d\u80cc\u540e，\u85cf\u7740\u590d\u6742\u7684\u5b9a\u4ef7\u7b56\u7565\u548c\u4f18\u60e0\u89c4\u5219\u3002\u7528\u6570\u636e\u63ed\u7a7f\u201c\u5148\u6da8\u540e\u964d\u201d\u7684\u5957\u8def，\u6b63\u662f\u722c\u866b\u6280\u672f\u5728\u6d88\u8d39\u8005\u6743\u76ca\u4fdd\u62a4\u4e2d\u7684\u4ef7\u503c\u3002<\/p>\n \u672c\u6587\u7684\u6838\u5fc3\u65b9\u6848\u53ef\u4ee5\u6982\u62ec\u4e3a：<\/p>\n \n\u6311\u6218\u89e3\u51b3\u65b9\u6848<\/tr>\n \n\n| \u52a8\u6001\u4ee4\u724c\u4e0e\u8bbe\u5907\u6307\u7eb9<\/td>\n | \u5b8c\u6574\u8bf7\u6c42\u5934 + User-Agent\u8f6e\u6362<\/td>\n<\/tr>\n | \n| IP\u884c\u4e3a\u753b\u50cf<\/td>\n | \u7ad9\u5927\u7237\u96a7\u9053\u4ee3\u7406，\u81ea\u52a8\u5207\u6362IP<\/td>\n<\/tr>\n | \n| \u52a8\u6001\u6e32\u67d3\u4ef7\u683c<\/td>\n | \u5b9a\u65f6\u91c7\u96c6 + \u6570\u636e\u5e93\u5b58\u50a8\u5386\u53f2<\/td>\n<\/tr>\n | \n| \u4ef7\u683c\u771f\u76f8\u63ed\u793a<\/td>\n | \u4ef7\u683c\u66f2\u7ebf\u53ef\u89c6\u5316 + \u591a\u54c1\u724c\u5bf9\u6bd4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u6280\u672f\u9009\u578b\u901f\u89c8：\u63a8\u8350\u201crequests + BeautifulSoup + \u7ad9\u5927\u7237\u96a7\u9053\u4ee3\u7406\u201d\u7684\u7ec4\u5408\u65b9\u6848\u3002\u96a7\u9053\u4ee3\u7406\u89e3\u51b3IP\u5c01\u7981\u95ee\u9898，\u5b9a\u65f6\u91c7\u96c6\u79ef\u7d2f\u4ef7\u683c\u5386\u53f2，\u6570\u636e\u5206\u6790\u63ed\u793a\u771f\u5b9e\u4ef7\u683c\u53d8\u5316\u3002<\/p>\n \u67d0\u732b\u7684\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\u662f\u6d1e\u5bdf\u7535\u5546\u4ef7\u683c\u7b56\u7565\u7684\u7a97\u53e3\u3002\u901a\u8fc7\u5408\u7406\u7684\u722c\u866b\u6280\u672f\u548c\u6570\u636e\u5206\u6790\u65b9\u6cd5，\u53ef\u4ee5\u770b\u6e05\u5927\u4fc3\u671f\u95f4\u7684\u4ef7\u683c\u771f\u76f8\u2014\u2014\u54ea\u4e9b\u662f\u771f\u4f18\u60e0，\u54ea\u4e9b\u53ea\u662f\u201c\u6570\u5b57\u6e38\u620f\u201d\u3002<\/p>\n \u6700\u540e\u63d0\u9192：\u6570\u636e\u91c7\u96c6\u884c\u4e3a\u5e94\u5f53\u9075\u5faa\u5e73\u53f0\u89c4\u5219，\u63a7\u5236\u8bf7\u6c42\u9891\u7387\u3002\u8bf7\u9075\u5b88\u76f8\u5173\u6cd5\u5f8b\u6cd5\u89c4，\u4ec5\u5c06\u722c\u866b\u6280\u672f\u7528\u4e8e\u5b66\u4e60\u548c\u7814\u7a76\u76ee\u7684\u3002\u5e0c\u671b\u672c\u6587\u80fd\u5e2e\u52a9\u4f60\u5728\u7535\u5546\u6570\u636e\u5206\u6790\u7684\u9053\u8def\u4e0a\u8d70\u5f97\u66f4\u8fdc\u3002<\/p>\n","protected":false},"excerpt":{"rendered":" \u5f15\u8a00\u201c\u540c\u6b3e\u51b0\u7bb1\u4eca\u5e74618\u53565723\u5143，\u53cc11\u53cd\u800c\u6da8\u52307742\u5143，\u8fd9\u662f\u4fc3\u9500\u8fd8\u662f\u62a2\u94b1？\u201d\u6cb3\u5357\u5f20\u5973\u58eb\u7684\u906d\u9047\u5e76\u975e\u4e2a\u4f8b\u30022025\u5e74\u53cc11\u671f\u95f4，\u201c\u8d8a\u4fc3\u8d8a\u8d35\u201d\u7684\u5410\u69fd\u51b2\u4e0a\u70ed\u641c，\u9ed1\u732b\u6295\u8bc9\u5e73\u53f0\u8fd12\u4e07\u6761\u6295\u8bc9\u76f4\u6307\u7535\u5546\u5e73\u53f0\u201c\u4ef7\u683c\u6b3a\u8bc8\u201d\u3002\u5728\u8fd9\u4e2a\u53f7\u79f0\u201c\u53f2\u4e0a\u6700\u957f\u201d\u7684\u53cc11（\u6301\u7eed37\u5929）\u91cc，\u6d88\u8d39\u8005\u53d1\u73b0：\u5237\u65b0\u4e00\u4e0b\u4ef7\u683c\u6da8\u4e86，\u4ed8\u5b8c\u6b3e\u4f18\u60e0\u53c8\u6765\u4e86，\u6284\u5e95\u51e0\u4e4e\u6210\u4e86\u4e00\u573a\u201c\u7384<\/p>\n","protected":false},"author":2,"featured_media":96868,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[677],"topic":[],"class_list":["post-96869","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-677"],"yoast_head":"\n \u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/96869.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u5f15\u8a00\u201c\u540c\u6b3e\u51b0\u7bb1\u4eca\u5e74618\u53565723\u5143，\u53cc11\u53cd\u800c\u6da8\u52307742\u5143，\u8fd9\u662f\u4fc3\u9500\u8fd8\u662f\u62a2\u94b1？\u201d\u6cb3\u5357\u5f20\u5973\u58eb\u7684\u906d\u9047\u5e76\u975e\u4e2a\u4f8b\u30022025\u5e74\u53cc11\u671f\u95f4，\u201c\u8d8a\u4fc3\u8d8a\u8d35\u201d\u7684\u5410\u69fd\u51b2\u4e0a\u70ed\u641c，\u9ed1\u732b\u6295\u8bc9\u5e73\u53f0\u8fd12\u4e07\u6761\u6295\u8bc9\u76f4\u6307\u7535\u5546\u5e73\u53f0\u201c\u4ef7\u683c\u6b3a\u8bc8\u201d\u3002\u5728\u8fd9\u4e2a\u53f7\u79f0\u201c\u53f2\u4e0a\u6700\u957f\u201d\u7684\u53cc11（\u6301\u7eed37\u5929）\u91cc，\u6d88\u8d39\u8005\u53d1\u73b0：\u5237\u65b0\u4e00\u4e0b\u4ef7\u683c\u6da8\u4e86，\u4ed8\u5b8c\u6b3e\u4f18\u60e0\u53c8\u6765\u4e86，\u6284\u5e95\u51e0\u4e4e\u6210\u4e86\u4e00\u573a\u201c\u7384\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/96869.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-28T07:49:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260828074903-6a913d6f1c031.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/96869.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/96869.html\",\"name\":\"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-08-28T07:49:04+00:00\",\"dateModified\":\"2026-08-28T07:49:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/96869.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/96869.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/96869.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/96869.html","og_locale":"zh_CN","og_type":"article","og_title":"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u5f15\u8a00\u201c\u540c\u6b3e\u51b0\u7bb1\u4eca\u5e74618\u53565723\u5143，\u53cc11\u53cd\u800c\u6da8\u52307742\u5143，\u8fd9\u662f\u4fc3\u9500\u8fd8\u662f\u62a2\u94b1？\u201d\u6cb3\u5357\u5f20\u5973\u58eb\u7684\u906d\u9047\u5e76\u975e\u4e2a\u4f8b\u30022025\u5e74\u53cc11\u671f\u95f4，\u201c\u8d8a\u4fc3\u8d8a\u8d35\u201d\u7684\u5410\u69fd\u51b2\u4e0a\u70ed\u641c，\u9ed1\u732b\u6295\u8bc9\u5e73\u53f0\u8fd12\u4e07\u6761\u6295\u8bc9\u76f4\u6307\u7535\u5546\u5e73\u53f0\u201c\u4ef7\u683c\u6b3a\u8bc8\u201d\u3002\u5728\u8fd9\u4e2a\u53f7\u79f0\u201c\u53f2\u4e0a\u6700\u957f\u201d\u7684\u53cc11（\u6301\u7eed37\u5929）\u91cc，\u6d88\u8d39\u8005\u53d1\u73b0：\u5237\u65b0\u4e00\u4e0b\u4ef7\u683c\u6da8\u4e86，\u4ed8\u5b8c\u6b3e\u4f18\u60e0\u53c8\u6765\u4e86，\u6284\u5e95\u51e0\u4e4e\u6210\u4e86\u4e00\u573a\u201c\u7384","og_url":"https:\/\/www.wsisp.com\/helps\/96869.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-08-28T07:49:04+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260828074903-6a913d6f1c031.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/96869.html","url":"https:\/\/www.wsisp.com\/helps\/96869.html","name":"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-08-28T07:49:04+00:00","dateModified":"2026-08-28T07:49:04+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/96869.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/96869.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/96869.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u67d0\u732b\u5546\u54c1\u6570\u636e\u722c\u866b\uff1a\u722c\u53d6\u54c1\u724c\u65d7\u8230\u5e97\u6570\u636e\uff0c\u5206\u6790\u53cc11\u4ef7\u683c\u53d8\u5316"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/96869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=96869"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/96869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/96868"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=96869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=96869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=96869"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=96869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | |
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260828074903-6a913d6f1c031.png\")
<\/p>\n