flask和python，navicat实现数据库和python的结合

 app.py

import pymysql
from flask import Flask, render_template, request

app = Flask(__name__)

@app.route('/add/user', methods=["GET", "POST"])
def add_user():
    if request.method == "GET":
        return render_template('add_user.html')  # 修正模板文件名

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

    # 连接MySQL
    conn = pymysql.connect(host="localhost", port=3306, user='root', passwd="root", charset='utf8', db='unicom')
    cursor = conn.cursor(pymysql.cursors.DictCursor)

    # 发送指令
    sql = "insert into admin(username,password,mobile) values(%s,%s,%s)"
    cursor.execute(sql, (username, password, mobile))
    conn.commit()

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

    r