Flask+前端+MySQL实现增加、显示用户的功能

哲此一生984

已于 2023-11-30 10:39:29 修改

阅读量115

点赞数

文章标签： flask 前端 mysql

于 2023-11-26 19:30:48 首次发布

本文链接：https://blog.youkuaiyun.com/qq_64556701/article/details/134631632

版权

html代码

1、显示用户页面代码

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <h1>用户列表</h1>
    <table border="1">
        <thead>
            <tr>
                <th>用户名</th>
                <th>密码</th>
            </tr>
        </thead>

         <tbody>
                {% for item in data_list %}
                    <tr>
                        <td>{{item.user}}</td>
                        <td>{{item.password}}</td>
                    </tr>
                {% endfor %}
         </tbody>
    </table>
</body>
</html>

2、用户登陆页面代码

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <h1>添加用户</h1>
    <form method="post" action="/add/user">
        <input type="text" name="user" placeholder="用户名">
        <input type="password" name="pwd" placeholder="密码">
        <input type="submit" value="提交">
    </form>

</body>
</html>

注意：html文件一定要在 templates包下

Python代码

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")
    # 1、连接数据库
    conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", password='123456', charset="utf8", db='itcast')
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)

    # 2、发送指令,（千万不要用字符串格式化去做字符串的拼接，安全隐患sql注入）
    sql = "insert into laptop(user,password) values(%s,%s)"
    cursor.execute(sql, [username, password])
    conn.commit()
    # 3、关闭连接
    cursor.close()
    conn.close()
    return "添加成功"

@app.route("/show/user")
def show_user():
    conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", password='123456', charset="utf8", db='itcast')
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    cursor.execute("select * from laptop")
    data_list = cursor.fetchall()
    conn.commit()
    cursor.close()
    conn.close()
    return render_template("show_user.html",data_list=data_list)

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