04 2021 档案

摘要:main.py (主程序) 1 from bs4 import BeautifulSoup 2 import urllib.request 3 import urllib.parse 4 import sqlite3 5 import setting 6 import func 7 import t 阅读全文
posted @ 2021-04-23 16:38 vosoland 阅读(186) 评论(0) 推荐(0)
摘要:func.py (定义函数) 1 from bs4 import BeautifulSoup 2 import urllib.request 3 import urllib.parse 4 import sqlite3 5 import setting 6 import time 7 import 阅读全文
posted @ 2021-04-23 16:37 vosoland 阅读(229) 评论(0) 推荐(0)
摘要:setting.py (用于定义各种变量) 1 from bs4 import BeautifulSoup 2 import urllib.request 3 import urllib.parse 4 import sqlite3 5 import func 6 import time 7 imp 阅读全文
posted @ 2021-04-23 16:36 vosoland 阅读(105) 评论(0) 推荐(0)
摘要:1 from bs4 import BeautifulSoup 2 import urllib.request 3 import urllib.parse 4 import urllib.error 5 import sqlite3 6 import xlwt 7 import re 8 impor 阅读全文
posted @ 2021-04-17 16:22 vosoland 阅读(136) 评论(0) 推荐(0)
摘要:1 def save_database(para_datalist, para_dbpath): 2 conn = sqlite3.connect(para_dbpath) 3 c = conn.cursor() 4 5 for data in para_datalist: 6 for index 阅读全文
posted @ 2021-04-17 15:48 vosoland 阅读(88) 评论(0) 推荐(0)
摘要:1 from bs4 import BeautifulSoup 2 import urllib.request 3 import urllib.parse 4 import urllib.error 5 import xlwt 6 import re 7 8 9 # Excel文件保存路径 10 s 阅读全文
posted @ 2021-04-17 10:30 vosoland 阅读(122) 评论(0) 推荐(0)
摘要:import xlwt my_workbook = xlwt.Workbook(encoding='utf-8') my_sheet1 = my_workbook.add_sheet('sheet1') for i in range(0, 9): # i:行号 for j in range(0, i 阅读全文
posted @ 2021-04-16 21:36 vosoland 阅读(113) 评论(0) 推荐(0)
摘要:1 import urllib.request as ur 2 import os 3 import time 4 5 6 def url_open(url): 7 # url = url.replace(' ', '%20') 8 req = ur.Request(url) 9 response 阅读全文
posted @ 2021-04-10 13:34 vosoland 阅读(182) 评论(0) 推荐(0)