爬虫之sqlite3存储天气预报信息

知识点

• 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