from flask import Flask, render_template, request
import pymysql
app = Flask(__name__)
@app.route("/add/user",methods=["GET","POST"])
def add_user():
if request.method == "GET":
return render_template("add_user.html")
#1连接数据库
name = request.form.get("user")
pwd= request.form.get("pwd")
phone = request.form.get("moble")
conn = pymysql.connect(host='127.0.0.1', user='root', port=3306, password='123456', charset='utf8', db="unicom")
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
sql="insert into username(username,password,mobile) values(%s,%s,%s)"
cursor.execute(sql,[name,pwd,phone])
# 必须执行,提交数据
conn.commit()
# 3关闭连接
cursor.close()
conn.close()
return "添加成功"
@app.route("/show/user")
def show_user():
#从数据库获取所有信息
conn = pymysql.connect(host='127.0.0.1', user='root', port=3306, password='123456', charset='utf8', db="unicom")
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
sql = "select * from username"
cursor.execute(sql)
# 必须执行,提交数据
data_list = cursor.fetchall()
# 3关闭连接
cursor.close()
conn.close()
print(data_list)
return render_template('show_user.html',data_list=data_list)
if __name__ == "__main__":
app.run(debug=True)