简单的事情重复做,重复做的事情坚持做,坚持做的事情开心的做
今天的学习目标是:使用flask搭建学生管理系统,爬虫程序进行管理(增删改查)
1.首先安装数据库
pip install gsqlite3
可以使用import sqlite3来引入这个库
2.flask服务器程序
import sqlite3
import flask
import json
app = flask.Flask(__name__)
class StudentDB:
def openDB(self):
self.con = sqlite3.connect('students.db')
self.cursor = self.con.cursor()
def closeDB(self):
self.con.commit()
self.con.close()
def initTable(self):
res = {
}
try:
self.cursor.execute(
"create table students(No varchar(16)primary key,Name varchar(30),sex varchar(8),Age int)")
res['msg'] = 'ok'
except Exception as err:
res['msg'] = str(err)
return res
def insertRow(self, No, Name, Sex, Age):
res = {
}
try:
self.cursor.execute("insert into students(No,Name,Sex,Age) values(?,?,?,?)", (No, Name, Sex, Age))
res['msg'] = 'ok'
except Exception as err:
res['msg'] = str(err)
return res
def deleteRow(self, No):
res = {
}
try:
self.cursor.execute('delete from students where No=?', (No,))
res['msg'] = 'ok'
except Exception as err:
res['msg'] = str(err)
return res
def selectRows(self):
res = {
}
try:
data = []
self.cursor.execute('select * from students order by No')
rows = self.cursor.fetchall()
for row in rows:
d = {
}
d['No'] = row[0]
d['Name'] = row[1]
d['Sex'] = row