|
|
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/epidemic2'
|
|
|
|
|
|
|
|
|
class Donor(db.Model):
|
|
|
donor_code = db.Column(db.String(255),primary_key=True)
|
|
|
donor_name = db.Column(db.String(255))
|
|
|
type1 = db.Column(db.String(255))
|
|
|
ded_name = db.Column(db.String(255))
|
|
|
ded_code = db.Column(db.String(255))
|
|
|
amount = db.Column(db.Integer)
|
|
|
date = db.Column(db.String(255))
|
|
|
trans = db.Column(db.String(255))
|
|
|
|
|
|
db.create_all()
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@app.route("/select")
|
|
|
|
|
|
def selectAll():
|
|
|
donorList = Donor.query.all()
|
|
|
return render_template("index.html", donor_list=donorList)
|
|
|
|
|
|
@app.route('/')
|
|
|
def index():
|
|
|
return selectAll()
|
|
|
|
|
|
# 添加数据
|
|
|
|
|
|
@app.route('/insert', methods=['GET', 'POST'])
|
|
|
def insert():
|
|
|
# 进行添加操作
|
|
|
donor_code = request.form['donor_code']
|
|
|
donor_name = request.form['donor_name']
|
|
|
type1 = request.form['type1']
|
|
|
ded_name = request.form['ded_name']
|
|
|
ded_code = request.form['ded_code']
|
|
|
amount = request.form['amount']
|
|
|
date = request.form['date']
|
|
|
trans = request.form['trans']
|
|
|
donor = Donor(donor_code=donor_code, donor_name=donor_name, type1=type1, ded_name=ded_name, ded_code=ded_code, amount= amount, date=date, trans=trans)
|
|
|
db.session.add(donor)
|
|
|
db.session.commit()
|
|
|
|
|
|
# 添加完成重定向至主页
|
|
|
return redirect('/')
|
|
|
|
|
|
@app.route("/insert_page")
|
|
|
def insert_page():
|
|
|
# 跳转至添加信息页面
|
|
|
return render_template("insert.html")
|
|
|
|
|
|
# 删除数据
|
|
|
|
|
|
@app.route("/delete", methods=['GET'])
|
|
|
def delete():
|
|
|
# 操作数据库得到目标数据，before_number表示删除之前的数量，after_name表示删除之后的数量
|
|
|
donor_code = request.args.get("donor_code")
|
|
|
donor = Donor.query.filter_by(donor_code=donor_code).first()
|
|
|
db.session.delete(donor)
|
|
|
db.session.commit()
|
|
|
return redirect('/')
|
|
|
|
|
|
# 修改操作
|
|
|
@app.route("/alter", methods=['GET', 'POST'])
|
|
|
def alter():
|
|
|
# 可以通过请求方式来改变处理该请求的具体操作
|
|
|
# 比如用户访问/alter页面 如果通过GET请求则返回修改页面 如果通过POST请求则使用修改操作
|
|
|
if request.method == 'GET':
|
|
|
donor_code = request.args.get("donor_code")
|
|
|
donor_name = request.args.get("donor_name")
|
|
|
type1 = request.args.get("type1")
|
|
|
ded_name = request.args.get("ded_name")
|
|
|
ded_code = request.args.get("ded_code")
|
|
|
amount = request.args.get("amount")
|
|
|
date = request.args.get("date")
|
|
|
trans = request.args.get("trans")
|
|
|
donor = Donor(donor_code=donor_code, donor_name=donor_name, type1=type1, ded_name=ded_name,ded_code=ded_code,
|
|
|
amount=amount, date=date, trans=trans)
|
|
|
return render_template("alter.html", donor=donor)
|
|
|
else:
|
|
|
donor_code = request.form["donor_code"]
|
|
|
donor_name = request.form['donor_name']
|
|
|
type1 = request.form['type1']
|
|
|
ded_name = request.form['ded_name']
|
|
|
ded_code = request.form['ded_code']
|
|
|
amount = request.form['amount ']
|
|
|
date = request.form['date']
|
|
|
trans = request.form['trans']
|
|
|
donor = Donor.query.filter_by(donor_code=donor_code).first()
|
|
|
donor.donor_name = donor_name
|
|
|
donor.type1 = type1
|
|
|
donor.ded_name = ded_name
|
|
|
donor.ded_code = ded_code
|
|
|
donor.amount = amount
|
|
|
donor.date = date
|
|
|
donor.trans = trans
|
|
|
db.session.commit()
|
|
|
return redirect('/')
|
|
|
|
|
|
if __name__ == "__main__":
|
|
|
app.run(debug=True)
|
