|
|
|
|
|
from flask import Flask,render_template,request,redirect
|
|
|
|
|
|
from flask_sqlalchemy import SQLAlchemy
|
|
|
|
|
|
|
|
|
|
|
|
app = Flask(__name__)
|
|
|
|
|
|
db = SQLAlchemy(app)
|
|
|
|
|
|
|
|
|
|
|
|
#设置数据库连接
|
|
|
|
|
|
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:@127.0.0.1:3306/bbq'
|
|
|
|
|
|
|
|
|
|
|
|
class province(db.Model):
|
|
|
|
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
|
|
|
|
name = db.Column(db.String(255))
|
|
|
|
|
|
heavynum = db.Column(db.Integer)
|
|
|
|
|
|
newnum=db.Column(db.Integer)
|
|
|
|
|
|
deadnum=db.Column(db.Integer)
|
|
|
|
|
|
curenum=db.Column(db.Integer)
|
|
|
|
|
|
adnum=db.Column(db.Integer)
|
|
|
|
|
|
acnum=db.Column(db.Integer)
|
|
|
|
|
|
ainum=db.Column(db.Integer)
|
|
|
|
|
|
|
|
|
|
|
|
class hospital(db.Model):
|
|
|
|
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
|
|
|
|
name=db.Column(db.String(255))
|
|
|
|
|
|
level=db.Column(db.String(255))
|
|
|
|
|
|
|
|
|
|
|
|
class doctor(db.Model):
|
|
|
|
|
|
id=db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
|
|
|
|
name=db.Column(db.String(255))
|
|
|
|
|
|
sex=db.Column(db.String(255))
|
|
|
|
|
|
num=db.Column(db.Integer)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
class patient(db.Model):
|
|
|
|
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
|
|
|
|
name=db.Column(db.String(255))
|
|
|
|
|
|
sex=db.Column(db.String(255))
|
|
|
|
|
|
con=db.Column(db.String(255))
|
|
|
|
|
|
area1=db.Column(db.String(255))
|
|
|
|
|
|
|
|
|
|
|
|
#定义模型
|
|
|
|
|
|
class fmember(db.Model):
|
|
|
|
|
|
#表模型
|
|
|
|
|
|
id = db.Column(db.Integer,primary_key=True,autoincrement=True)
|
|
|
|
|
|
name = db.Column(db.String(255))
|
|
|
|
|
|
sex = db.Column(db.String(255))
|
|
|
|
|
|
num = db.Column(db.Integer)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#查询所有数据
|
|
|
|
|
|
|
|
|
|
|
|
@app.route('/')
|
|
|
|
|
|
def index():
|
|
|
|
|
|
return render_template("rindex.html")
|
|
|
|
|
|
|
|
|
|
|
|
###############医院#########################
|
|
|
|
|
|
@app.route("/hos")
|
|
|
|
|
|
def hos():
|
|
|
|
|
|
hoslist=hospital.query.order_by(hospital.id.asc()).all()
|
|
|
|
|
|
return render_template("hospital.html",hoslist = hoslist)
|
|
|
|
|
|
|
|
|
|
|
|
#医院添加数据
|
|
|
|
|
|
@app.route('/hos_insert',methods=['GET','POST'])
|
|
|
|
|
|
def hos_insert():
|
|
|
|
|
|
#进行添加操作
|
|
|
|
|
|
id = request.form['id']
|
|
|
|
|
|
name = request.form['name']
|
|
|
|
|
|
level = request.form['level']
|
|
|
|
|
|
Hospital = hospital(id=id ,name=name,level=level)
|
|
|
|
|
|
db.session.add(Hospital)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
#添加完成重定向至主页
|
|
|
|
|
|
return redirect('/hos')
|
|
|
|
|
|
|
|
|
|
|
|
@app.route("/hos_insert_page")
|
|
|
|
|
|
def hos_insert_page():
|
|
|
|
|
|
#跳转至添加信息页面
|
|
|
|
|
|
return render_template("hos_insert.html")
|
|
|
|
|
|
#删除医院数据
|
|
|
|
|
|
@app.route("/hos_delete",methods=['GET'])
|
|
|
|
|
|
def hos_delete():
|
|
|
|
|
|
#操作数据库得到目标数据，before_number表示删除之前的数量，after_name表示删除之后的数量
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
Hospital = hospital.query.filter_by(id=id).first()
|
|
|
|
|
|
db.session.delete(Hospital)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/hos')
|
|
|
|
|
|
|
|
|
|
|
|
#医院修改操作
|
|
|
|
|
|
@app.route("/hos_alter",methods=['GET','POST'])
|
|
|
|
|
|
def hos_alter():
|
|
|
|
|
|
# 可以通过请求方式来改变处理该请求的具体操作
|
|
|
|
|
|
# 比如用户访问/alter页面 如果通过GET请求则返回修改页面 如果通过POST请求则使用修改操作
|
|
|
|
|
|
if request.method == 'GET':
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
name = request.args.get("name")
|
|
|
|
|
|
level = request.args.get("level")
|
|
|
|
|
|
Hospital = hospital(id = id,name=name,level=level)
|
|
|
|
|
|
return render_template("hos_alter.html",hospital = Hospital)
|
|
|
|
|
|
else:
|
|
|
|
|
|
#接收参数，修改数据
|
|
|
|
|
|
id = request.form.get('id')
|
|
|
|
|
|
name = request.form.get("name")
|
|
|
|
|
|
level = request.form.get("level")
|
|
|
|
|
|
Hospital=hospital.query.filter_by(id = id).first()
|
|
|
|
|
|
Hospital.id=id
|
|
|
|
|
|
Hospital.name=name
|
|
|
|
|
|
Hospital.level=level
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/hos')
|
|
|
|
|
|
#############医院########################
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
###############医生#########################
|
|
|
|
|
|
@app.route("/doc")
|
|
|
|
|
|
def doc():
|
|
|
|
|
|
doclist=doctor.query.order_by(doctor.id.asc()).all()
|
|
|
|
|
|
return render_template("doctor.html",doclist=doclist)
|
|
|
|
|
|
|
|
|
|
|
|
#医生添加数据
|
|
|
|
|
|
@app.route('/doc_insert',methods=['GET','POST'])
|
|
|
|
|
|
def doc_insert():
|
|
|
|
|
|
#进行添加操作
|
|
|
|
|
|
id = request.form['id']
|
|
|
|
|
|
name = request.form['name']
|
|
|
|
|
|
sex=request.form['sex']
|
|
|
|
|
|
num = request.form['num']
|
|
|
|
|
|
Doctor = doctor(id=id ,name=name,sex=sex,num=num)
|
|
|
|
|
|
db.session.add(Doctor)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
#添加完成重定向至主页
|
|
|
|
|
|
return redirect('/doc')
|
|
|
|
|
|
|
|
|
|
|
|
@app.route("/doc_insert_page")
|
|
|
|
|
|
def doc_insert_page():
|
|
|
|
|
|
#跳转至添加信息页面
|
|
|
|
|
|
return render_template("doc_insert.html")
|
|
|
|
|
|
#删除医生数据
|
|
|
|
|
|
@app.route("/doc_delete",methods=['GET'])
|
|
|
|
|
|
def doc_delete():
|
|
|
|
|
|
#操作数据库得到目标数据，before_number表示删除之前的数量，after_name表示删除之后的数量
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
Doctor = doctor.query.filter_by(id=id).first()
|
|
|
|
|
|
db.session.delete(Doctor)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/doc')
|
|
|
|
|
|
|
|
|
|
|
|
#医生修改操作
|
|
|
|
|
|
@app.route("/doc_alter",methods=['GET','POST'])
|
|
|
|
|
|
def doc_alter():
|
|
|
|
|
|
# 可以通过请求方式来改变处理该请求的具体操作
|
|
|
|
|
|
# 比如用户访问/alter页面 如果通过GET请求则返回修改页面 如果通过POST请求则使用修改操作
|
|
|
|
|
|
if request.method == 'GET':
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
name = request.args.get("name")
|
|
|
|
|
|
sex = request.args.get("sex")
|
|
|
|
|
|
num = request.args.get("num")
|
|
|
|
|
|
Doctor = doctor(id = id,name=name,sex=sex,num=num)
|
|
|
|
|
|
return render_template("doc_alter.html",doctor = Doctor)
|
|
|
|
|
|
else:
|
|
|
|
|
|
#接收参数，修改数据
|
|
|
|
|
|
id = request.form.get("id")
|
|
|
|
|
|
name = request.form.get("name")
|
|
|
|
|
|
sex = request.form.get("sex")
|
|
|
|
|
|
num = request.form.get("num")
|
|
|
|
|
|
Doctor = doctor.query.filter_by(id = id).first()
|
|
|
|
|
|
Doctor.name = name
|
|
|
|
|
|
Doctor.sex = sex
|
|
|
|
|
|
Doctor.num = num
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/doc')
|
|
|
|
|
|
#############医生########################
|
|
|
|
|
|
|
|
|
|
|
|
###############患者#########################
|
|
|
|
|
|
@app.route("/pat")
|
|
|
|
|
|
def pat():
|
|
|
|
|
|
patlist=patient.query.order_by(patient.id.asc()).all()
|
|
|
|
|
|
return render_template("patient.html",patlist = patlist)
|
|
|
|
|
|
|
|
|
|
|
|
#患者添加数据
|
|
|
|
|
|
@app.route('/pat_insert',methods=['GET','POST'])
|
|
|
|
|
|
def pat_insert():
|
|
|
|
|
|
#进行添加操作
|
|
|
|
|
|
id = request.form['id']
|
|
|
|
|
|
name = request.form['name']
|
|
|
|
|
|
sex = request.form['sex']
|
|
|
|
|
|
con = request.form['con']
|
|
|
|
|
|
area1 = request.form['area1']
|
|
|
|
|
|
Patient = patient(id=id ,name=name,sex=sex,con=con,area1=area1)
|
|
|
|
|
|
db.session.add(Patient)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
#添加完成重定向至主页
|
|
|
|
|
|
return redirect('/pat')
|
|
|
|
|
|
|
|
|
|
|
|
@app.route("/pat_insert_page")
|
|
|
|
|
|
def pat_insert_page():
|
|
|
|
|
|
#跳转至添加信息页面
|
|
|
|
|
|
return render_template("pat_insert.html")
|
|
|
|
|
|
#删除患者数据
|
|
|
|
|
|
@app.route("/pat_delete",methods=['GET'])
|
|
|
|
|
|
def pat_delete():
|
|
|
|
|
|
#操作数据库得到目标数据，before_number表示删除之前的数量，after_name表示删除之后的数量
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
Patient = patient.query.filter_by(id=id).first()
|
|
|
|
|
|
db.session.delete(Patient)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/pat')
|
|
|
|
|
|
|
|
|
|
|
|
#患者修改操作
|
|
|
|
|
|
@app.route("/pat_alter",methods=['GET','POST'])
|
|
|
|
|
|
def pat_alter():
|
|
|
|
|
|
# 可以通过请求方式来改变处理该请求的具体操作
|
|
|
|
|
|
# 比如用户访问/alter页面 如果通过GET请求则返回修改页面 如果通过POST请求则使用修改操作
|
|
|
|
|
|
if request.method == 'GET':
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
name = request.args.get("name")
|
|
|
|
|
|
sex = request.args.get("sex")
|
|
|
|
|
|
con = request.args.get("con")
|
|
|
|
|
|
area1 = request.args.get("area1")
|
|
|
|
|
|
Patient = patient(id = id,name=name,sex=sex,con=con,area1=area1)
|
|
|
|
|
|
return render_template("pat_alter.html",patient = Patient)
|
|
|
|
|
|
else:
|
|
|
|
|
|
#接收参数，修改数据
|
|
|
|
|
|
id = request.form.get("id")
|
|
|
|
|
|
name = request.form.get("name")
|
|
|
|
|
|
sex = request.form.get("sex")
|
|
|
|
|
|
con = request.form.get("con")
|
|
|
|
|
|
area1 = request.form.get("area1")
|
|
|
|
|
|
Patient = patient.query.filter_by(id = id).first()
|
|
|
|
|
|
Patient.id = id
|
|
|
|
|
|
Patient.name = name
|
|
|
|
|
|
Patient.sex = sex
|
|
|
|
|
|
Patient.con = con
|
|
|
|
|
|
Patient.area1 = area1
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/pat')
|
|
|
|
|
|
#############患者########################
|
|
|
|
|
|
|
|
|
|
|
|
###############患者家属#########################
|
|
|
|
|
|
@app.route("/fme")
|
|
|
|
|
|
def fme():
|
|
|
|
|
|
fmelist=fmember.query.order_by(fmember.id.asc()).all()
|
|
|
|
|
|
return render_template("fmember.html",fmelist = fmelist)
|
|
|
|
|
|
|
|
|
|
|
|
#患者家属添加数据
|
|
|
|
|
|
@app.route('/fme_insert',methods=['GET','POST'])
|
|
|
|
|
|
def fme_insert():
|
|
|
|
|
|
#进行添加操作
|
|
|
|
|
|
id = request.form['id']
|
|
|
|
|
|
name = request.form['name']
|
|
|
|
|
|
sex = request.form['sex']
|
|
|
|
|
|
num = request.form['num']
|
|
|
|
|
|
Fmember = fmember(id=id ,name=name,sex=sex,num=num)
|
|
|
|
|
|
db.session.add(Fmember)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
#添加完成重定向至主页
|
|
|
|
|
|
return redirect('/fme')
|
|
|
|
|
|
|
|
|
|
|
|
@app.route("/fme_insert_page")
|
|
|
|
|
|
def fme_insert_page():
|
|
|
|
|
|
#跳转至添加信息页面
|
|
|
|
|
|
return render_template("fme_insert.html")
|
|
|
|
|
|
#删除患者家属数据
|
|
|
|
|
|
@app.route("/fme_delete",methods=['GET'])
|
|
|
|
|
|
def fme_delete():
|
|
|
|
|
|
#操作数据库得到目标数据，before_number表示删除之前的数量，after_name表示删除之后的数量
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
Fmember = fmember.query.filter_by(id=id).first()
|
|
|
|
|
|
db.session.delete(Fmember)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/fme')
|
|
|
|
|
|
|
|
|
|
|
|
#患者家属修改操作
|
|
|
|
|
|
@app.route("/fme_alter",methods=['GET','POST'])
|
|
|
|
|
|
def fme_alter():
|
|
|
|
|
|
# 可以通过请求方式来改变处理该请求的具体操作
|
|
|
|
|
|
# 比如用户访问/alter页面 如果通过GET请求则返回修改页面 如果通过POST请求则使用修改操作
|
|
|
|
|
|
if request.method == 'GET':
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
name = request.args.get("name")
|
|
|
|
|
|
sex = request.args.get("sex")
|
|
|
|
|
|
num = request.args.get("num")
|
|
|
|
|
|
Fmember = fmember(id = id,name=name,sex=sex,num=num)
|
|
|
|
|
|
return render_template("fme_alter.html",fmember = Fmember)
|
|
|
|
|
|
else:
|
|
|
|
|
|
#接收参数，修改数据
|
|
|
|
|
|
id = request.form.get("id")
|
|
|
|
|
|
name = request.form.get("name")
|
|
|
|
|
|
sex = request.form.get("sex")
|
|
|
|
|
|
num = request.form.get("num")
|
|
|
|
|
|
Fmember = fmember.query.filter_by(id = id).first()
|
|
|
|
|
|
Fmember.id = id
|
|
|
|
|
|
Fmember.name = name
|
|
|
|
|
|
Fmember.sex = sex
|
|
|
|
|
|
Fmember.num = num
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/fme')
|
|
|
|
|
|
#############患者家属########################
|
|
|
|
|
|
|
|
|
|
|
|
###############疫情地区#########################
|
|
|
|
|
|
@app.route("/pro")
|
|
|
|
|
|
def pro():
|
|
|
|
|
|
prolist=province.query.order_by(province.id.asc()).all()
|
|
|
|
|
|
return render_template("province.html",prolist = prolist)
|
|
|
|
|
|
|
|
|
|
|
|
#疫情地区添加数据
|
|
|
|
|
|
@app.route('/pro_insert',methods=['GET','POST'])
|
|
|
|
|
|
def pro_insert():
|
|
|
|
|
|
#进行添加操作
|
|
|
|
|
|
id = request.form['id']
|
|
|
|
|
|
name = request.form['name']
|
|
|
|
|
|
heavynum=request.form['heavynum']
|
|
|
|
|
|
newnum = request.form['newnum']
|
|
|
|
|
|
deadnum = request.form['deadnum']
|
|
|
|
|
|
curenum = request.form['curenum']
|
|
|
|
|
|
adnum = request.form['adnum']
|
|
|
|
|
|
acnum = request.form['acnum']
|
|
|
|
|
|
ainum = request.form['ainum']
|
|
|
|
|
|
Province = province(id=id ,name=name,heavynum=heavynum,newnum=newnum,deadnum=deadnum,curenum=curenum,adnum=adnum,acnum=acnum,ainum=ainum)
|
|
|
|
|
|
db.session.add(Province)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
#添加完成重定向至主页
|
|
|
|
|
|
return redirect('/pro')
|
|
|
|
|
|
|
|
|
|
|
|
@app.route("/pro_insert_page")
|
|
|
|
|
|
def pro_insert_page():
|
|
|
|
|
|
#跳转至添加信息页面
|
|
|
|
|
|
return render_template("pro_insert.html")
|
|
|
|
|
|
#删除疫情地区数据
|
|
|
|
|
|
@app.route("/pro_delete",methods=['GET'])
|
|
|
|
|
|
def pro_delete():
|
|
|
|
|
|
#操作数据库得到目标数据，before_number表示删除之前的数量，after_name表示删除之后的数量
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
Province = province.query.filter_by(id=id).first()
|
|
|
|
|
|
db.session.delete(Province)
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/pro')
|
|
|
|
|
|
|
|
|
|
|
|
#疫情地区修改操作
|
|
|
|
|
|
@app.route("/pro_alter",methods=['GET','POST'])
|
|
|
|
|
|
def pro_alter():
|
|
|
|
|
|
# 可以通过请求方式来改变处理该请求的具体操作
|
|
|
|
|
|
# 比如用户访问/alter页面 如果通过GET请求则返回修改页面 如果通过POST请求则使用修改操作
|
|
|
|
|
|
if request.method == 'GET':
|
|
|
|
|
|
id = request.args.get("id")
|
|
|
|
|
|
name = request.args.get("name")
|
|
|
|
|
|
heavynum = request.args.get("heavynum")
|
|
|
|
|
|
newnum = request.args.get("newnum")
|
|
|
|
|
|
deadnum = request.args.get("deadnum")
|
|
|
|
|
|
curenum = request.args.get("curenum")
|
|
|
|
|
|
adnum = request.args.get("adnum")
|
|
|
|
|
|
acnum = request.args.get("acnum")
|
|
|
|
|
|
ainum = request.args.get("ainum")
|
|
|
|
|
|
Province = province(id = id,name=name,heavynum=heavynum,newnum=newnum,deadnum=deadnum,curenum=curenum,adnum=adnum,acnum=acnum,ainum=ainum)
|
|
|
|
|
|
return render_template("pro_alter.html",province = Province)
|
|
|
|
|
|
else:
|
|
|
|
|
|
#接收参数，修改数据
|
|
|
|
|
|
id = request.form.get("id")
|
|
|
|
|
|
name = request.form.get("name")
|
|
|
|
|
|
heavynum = request.form.get("heavynum")
|
|
|
|
|
|
newnum = request.form.get("newnum")
|
|
|
|
|
|
deadnum = request.form.get("deadnum")
|
|
|
|
|
|
curenum = request.form.get("curenum")
|
|
|
|
|
|
adnum = request.form.get("adnum")
|
|
|
|
|
|
acnum = request.form.get("acnum")
|
|
|
|
|
|
ainum =request.form.get("ainum")
|
|
|
|
|
|
Province = province.query.filter_by(id = id).first()
|
|
|
|
|
|
Province.id = id
|
|
|
|
|
|
Province.name = name
|
|
|
|
|
|
Province.heavynum = heavynum
|
|
|
|
|
|
Province.newnum = newnum
|
|
|
|
|
|
Province.deadnum = deadnum
|
|
|
|
|
|
Province.curenum = curenum
|
|
|
|
|
|
Province.adnum = adnum
|
|
|
|
|
|
Province.acnum = acnum
|
|
|
|
|
|
Province.ainum=ainum
|
|
|
|
|
|
db.session.commit()
|
|
|
|
|
|
return redirect('/pro')
|
|
|
|
|
|
#############疫情省市########################
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
if __name__ == "__main__":
|
|
|
|
|
|
app.run(debug = True,host='0.0.0.0',port=9981)
|
