【Python Web】Flask框架（九）前端+python+MYSQL案例

前端+python+MYSQL案例

安装插件

pip3 install flask  
pip install cryptography 
pip3 install pymysql 

文件位置

新增用户

• app.py

from flask import Flask,render_template, request
import pymysql


app = Flask(__name__)


@app.route('/add/user', methods=["GET","POST"])
def add():
    if request.method == "GET":
        return render_template("add_user.html")

    username = request.form.get("user")
    pwd = request.form.get("pwd")
    mobile = request.form.get("mobile")

    # 连接mysql
    conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="root", charset='utf8', db='bkys')
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)

    sql = "insert into admin(username,password,mobile) values(%s,%s,%s)"
    cursor.execute(sql, [username, pwd, mobile])
    conn.commit()

    # 关闭
    cursor.close()
    conn.close()

    return "添加成功"

if __name__ =&