利用flask,pymsql,实现网页对MySQL进行增加和查看数据的功能

app.py

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")
    username = request.form.get("user")
    password = request.form.get("pwd")
    mobile = request.form.get("mobile")

    # 1.连接MySQL
    conn = pymysql.connect(host="127.0.0.1", port=3306, user='root', passwd="123456", charset='utf8', db='unicom')
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    # 2.提交SQL语句
    sql = "insert into admin(username,password,mobile) values(%s,%s,%s)"
    cursor.execute(sql, [username, password, mobile])
    conn.commit()
    # 3.关闭SQL连接
    cursor.close()
    conn.close()
    return "success"


@app.route("/show/user")
def show_user():
    ######获取所有信息#######
    # 1.连接MySQL
    conn = pymysql.connect(host="127.0.0.1", port=3306, user='root', passwd="123456", charset='utf8', db='unicom')
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    # 2.提交SQL语句
    sql = "select * from admin"
    cursor.execute(sql)
    data_list = cursor.fetchall()
    # 3.关闭SQL连接
    cursor.close()
    conn.close()

    print(data_list)
    return render_template("show_user.html", data_list=data_list)


if __name__ == '__main__':
    app.run()

add_user.html

    
    


添加用户

    
    
    
    

show_user.html

    
    
    



    
用户列表
    
        {% for item in data_list %}
        
        {% endfor %}
        

        

        

            
ID
            
姓名
            
密码
            
手机号
        
        
        

            
{{ item.id }}
            
{{ item.username }}
            
{{ item.password }}
            
{{ item.mobile }}
        
    

<script src="static/js/jquery-3.6.0.min.js"></script>
<script src="static/plugins/bootstrap-3.4.1-dist/js/bootstrap.js"></script>