知识点
- BeautifulSoup
- 类的使用
- sqlite3创建的使用
- request
import requests
from bs4 import BeautifulSoup
import sqlite3
class WeatherDB:
def openDB(self):
self.con=sqlite3.connect("weathers.db")
self.coursor=self.con.cursor()
try:
self.coursor.execute("create table weathers (wCity varchar(16),wDate varchar(16),wWeather varchar(64),"
"wTemp varchar(32),constraint pk_weather primary key (wCity,wDate))")
except:
self.coursor.execute("delete from weathers")
def colseDB(self):
self.con.commit()
self.con.close()
def insertDB(self,city,data,weather,temp):
try:
self.coursor.execute("insert into weathers (wCity,wDate,wWeather,wTe