【项目】爬取+导入+定时器

mysql:https://dev.mysql.com/downloads/windows/installer/5.7.html

需求：

#爬取数据
#检查数据库是否存在
#不:保存数据库
#是:不保存

#每个月执行一次

#_*_ coding=utf-8 _*_
from html.parser import HTMLParser
import requests
import re
import pymysql
import time
import schedule

host = "http://alk.12348.gov.cn"
url = "http://alk.12348.gov.cn/LawMultiSearch/Search"

data ={"searchField":u"案例全文",
       "checkDatabaseID":"44,66",
       "pageSizeNow":"10"}

headers = {"Content-Type": "application/x-www-form-urlencoded; charset=UTF-8",
"Cookie":"ASP.NET_SessionId=uczdhbfwhdoe4ndbxmu0bune; lang=zh; __jsluid=3f2b0dcf29ea3a7dc2bd7dd00b48444e; ResultColumnInfo=H4sIA