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

LibraFree

已于 2022-09-21 17:11:47 修改

阅读量1.3k

点赞数 8

分类专栏： python篇 MySQL 前端篇文章标签： python flask 前端

于 2022-09-20 22:58:20 首次发布

本文链接：https://blog.csdn.net/qq_51670115/article/details/126962832

版权

python篇同时被 3 个专栏收录

33 篇文章 4 订阅

订阅专栏

前端篇

8 篇文章 1 订阅

订阅专栏

MySQL

4 篇文章 0 订阅

订阅专栏

文章目录

- 前端+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__ == '__main__':
    app.run()

add_user.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>添加用户</title>
</head>
<body>

<h1>添加用户</h1>
<form method="post" action="/add/user">
    <input type="text" name="user" placeholder="用户名">
    <input type="text" name="pwd" placeholder="密码">
    <input type="text" name="mobile" placeholder="手机号">
    <input type="submit" value="提交">
</form>

</body>
</html>

查询所有用户

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 "添加成功"

@app.route("/show/user")
def show_user():
    # 连接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 = "select * from admin"
    cursor.execute(sql)
    data_list = cursor.fetchall()

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

    print(data_list)

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


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

show_user.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>用户列表</title>
</head>
<body>

    <h1>用户列表</h1>
    <table border="1">
        <thead>
            <tr>id</tr>
            <tr>name</tr>
            <tr>user</tr>
            <tr>mobile</tr>
        </thead>
        <tbody>
        {% for item in data_list %}
            <tr>
                <td>{{ item.id }}</td>
                <td>{{ item.username }}</td>
                <td>{{ item.password }}</td>
                <td>{{ item.mobile }}</td>
            </tr>
        {% endfor %}
        </tbody>
    </table>


</body>
</html>