结果图
python代码
import pymysql
import json
import requests
from fake_useragent import UserAgent
import urllib.request as urllib2
import time
from datetime import datetime
from datetime import timedelta
import random
#连接数据库
db = pymysql.connect("localhost", "用户名", "密码", "数据库名", charset='utf8mb4' ) #编码utf8mb4:存储含表情的评论
cursor = db.cursor()
#网页参数设定(去掉不必要)
url = 'https://rate.taobao.com/feedRateList.htm'
itemId = "561659965569"
sellerid = "511894637"
callback = "jsonp_tbcrate_reviews_list"
referer = "https://item.taobao.com/item.htm"
cookie = "cookie2=16450e96b87635edd21c8c23098ee16e; _tb_token_=59bb309e37883; tk_trace=oTRxOWSBNwn9dPyorMJE%2FoPdY8zfvmw%2Fq5hmBNkq3fFfIkz%2Bp6pXJBhANegSkYg0Wj02rNZ1LnIJvPe3YgKDlSp%2FnhwFeZ7ejyQD7SYAlQOWOCqN9%2B4JkUeTRl7IyIE%2FVvkyBxwiUrhAHNzSqJ1VeRZVtFE%2FVoKDslCc8HsIcY%2FsoW%2F240wjdFDLyOM3qy22dIAuyyPLbWLwjsGnKdK0qpw9frUbJH1LVOtqrnNcCQWZ21BxMnDGemJf%2Fxz203DVQ%2BSceixTKAPkJFjdNiGoBM%2B7Jw%3D%3D; _samesite_flag_=true; t=eb7e3e377ddf3017ed7bdbd075f22c82; thw=cn; hng=CN%7Czh-CN%7CCNY%7C156; _m_h5_tk=256c7a4c3468f9cf9ab3976cb0f4777e_1582207720076; _m_h5_tk_enc=2279a5391e7ea76e0d32ea71c347c240; mt=ci=0_0; cna=b5WFFR2YV0YCAdNHHAf7KxeS; v=0; enc=2R%2B5LqoA59X5sQMuom5oGltHQ1Avsy57fn5U9BYgqWR1i82dfH0Gia4i6IZGooYayZfUDlgP%2BR8dv%2Fi0MrOFvQ%3D%3D; tfstk=cFbFBnvIRyUUlrZNmETyF7L1TbLda0xk0VRJxixIPV7qFjvM3s4neC4LvCRvHPxh.; uc1=cookie14=UoTUOLFGSn0wIg%3D%3D; x5sec=7b22726174656d616e616765723b32223a22396335373865633339326533656362383064316566633232356638636439626143504771762f4946454b6174716365792b7450616967453d227d; l=dBgUhRSmqK_SOAQaBOfgqRyY8y_OFIOfGsPr79hg4ICPOYCkMAlCWZVhQmYDCnGV3savR3J6m7-0BqLaDyUIhEGfIqlBs2JNxdTpR; isg=BGJi0-ZvSPKdiVdlhfToL2hZs-jEs2bNvI1vIaz6oFX1fwb5lEB53W65q7uD795l"
#采集类
class COLLECT():
#初始化
def