1 爬地址
https://you.ctrip.com/sight/Beijing1.html
2.直接干代码
# -*- coding: gbk -*-
import urllib.request
import re
import pymysql
config = {
'host':'127.0.0.1',
'port':3306,#MySQL默认端口
'user':'root',#mysql默认用户名
'password':'root',
'db':'test',#数据库
'charset':'utf8',
}
course={}
# 打开数据库连接
headers = ("User-Agent",
"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Ch