import requests
from fack useragent import User-Agent
from lxml import etree
url = ‘http://datachart.500.com/ssq/’
response = requests.get(url, headers={“User-Agent”:UserAgent().charm})
e = etree.HTML(response.text)
trs = e.xpath(‘//tbody[@id=“tdata”]tr’)
count = 0
for data_time , tr in zip(data_times , trs):
if count % 5 ==0:
continue
count+=1
red_ball = “_”.join(tr.xpath(‘./td[@class=“chartBa1101”]/text()’))
bule_ball = tr.xpath(‘./td[@class=“chartBa1102”]/text()’)[0]
print(“第” + data_time +“红球是” + red_ball + "绿球是” + bule_ball)
cursor.execute(sql, [data_time, red_ball, bule_ball])
cursor.close()
content.close()