python+flask+数据库案例

发布于:2024-03-23 ⋅ 阅读:(49) ⋅ 点赞:(0)

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")
    #1连接数据库
    name = request.form.get("user")
    pwd= request.form.get("pwd")
    phone = request.form.get("moble")

    conn = pymysql.connect(host='127.0.0.1', user='root', port=3306, password='123456', charset='utf8', db="unicom")
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    sql="insert into username(username,password,mobile) values(%s,%s,%s)"
    cursor.execute(sql,[name,pwd,phone])
    # 必须执行,提交数据
    conn.commit()
    # 3关闭连接
    cursor.close()
    conn.close()
    return "添加成功"
@app.route("/show/user")
def show_user():
    #从数据库获取所有信息
    conn = pymysql.connect(host='127.0.0.1', user='root', port=3306, password='123456', charset='utf8', db="unicom")
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    sql = "select * from username"
    cursor.execute(sql)
    # 必须执行,提交数据
    data_list = cursor.fetchall()
    # 3关闭连接
    cursor.close()
    conn.close()
    print(data_list)

    return render_template('show_user.html',data_list=data_list)
if __name__ == "__main__":
    app.run(debug=True)


网站公告

今日签到

点亮在社区的每一天
去签到