from flask import Flask,render_template,request
import pymysql
app = Flask(__name__)
@app.route('/')
def hello_world():
return render_template("index.html")
@app.route('/login',methods=['POST','GET'])
def login():
if request.method=="GET":
username=request.args.get("floatingInput")
password=request.args.get("floatingPassword")
print(username,password)
# conn = sqlite3.connect('test.db')
#
# cur=conn.cursor()
# cur.execute("select * from company where name ='{}' and passorwd='{}'".format(username,password))
# aa=cur.fetchall()
# print(aa)
#
# if aa:
#
#
# return render_template("add.html")
# else:
# return render_template("index.html")
# conn = pymysql.connect(host="", user="root", passwd="root", database="bishe", charset="utf8")
# cur = conn.cursor()
# cur.execute("select * from uid where nameid ='{}' and password='{}'".format(username, password))
# aa = cur.fetchall()
# print(aa)
# text = "密码错误！请重新输入！"
# for stu in aa:
#
# if username == stu[2] and password == stu[3]:
# return render_template("add.html")
# else:
# return render_template("index.html")
# conn.commit()
# conn.close()
conn=pymysql.connect(user="root",passwd="root",database="bishe",charset="utf8")
cur=conn.cursor()
cur.execute("select * from uid where nameid ='{}' and password='{}'".format(username,password))
aa=cur.fetchall()
print(aa)
if aa:
return render_template("add.html")
else:
return render_template("index.html")
if __name__ == '__main__':
app.run()
flask实现列表增删查改.rar （25个子文件） 
flask实现列表增删查改 
app.py 2KB templates 
add.html 1KB index.html 2KB __pycache__ app.cpython-38.pyc 2KB app.cpython-36.pyc 3KB test.db 12KB lian.py 741B static assets dist css bootstrap.min.css 160KB bootstrap.rtl.min.css 160KB bootstrap.rtl.min.css.map 648KB bootstrap.min.css.map 441KB js bootstrap.bundle.min.js 76KB bootstrap.bundle.min.js.map 323KB brand 
bootstrap-logo-white.svg 1007B bootstrap-logo.svg 2KB signin.css 598B .idea dataSources.xml 479B misc.xml 294B modules.xml 277B workspace.xml 12KB .gitignore 184B dataSources.local.xml 848B inspectionProfiles profiles_settings.xml 174B untitled5.iml 674B dataSources dd1f856b-8871-42eb-87f6-c7a802e0999a.xml 2KB
评论10