import requests
import json
import pymysql
import time
conn= pymysql.connect(host='localhost',user='root',passwd='123456',db='mysql',port=3306,charset='utf8')
cursor= conn.cursor()
headers= {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36',
'Referer': 'https://item.jd.com/100005332346.html'
}
urls= [f'https://sclub.jd.com/comment/productPageComments.action?productId=100005332346&score=0&sortType=5&page={str(i)}&pageSize=10&isShadowSku=0&rid=0&fold=1' for iin range(0,10)]
for urlin urls:
res= requests.get(url,headers = headers)
json_data= json.loads(res.text)
comments= json_data['comments']
for commentin comments:
content= comment['content']
creationTime= comment['creationTime']
productSize= comment['productSize']
usefulVoteCount= comment['usefulVoteCount']
cursor.execute("insert into mars_info (content, creationTime, productSize, usefulVoteCount) values(%s, %s, %s, %s)",
(content, creationTime, productSize, usefulVoteCount))
conn.commit()
time.sleep(4)
conn.close()
屏幕截圖.jpg
