flask--- py----MySQL--单表

flask_demo

from flask import Flask, request
from flask import render_template
import pymysql.cursors
app = Flask(__name__)
# 验证
connect = pymysql.Connect(
    host='localhost',
    port=3306,
    user='root',
    password='root',
    db='user',
    charset='utf8'
)
cursor = connect.cursor()

@app.route('/')
def hello_world():
    return render_template("login.html")
@app.route('/login',methods = ["GET","POST"])
def login():
    #获取前端传来的用户名密码
    #print(request.method)
    #print(request.args)
    #print(request.form)
    #print(request.values)

    username = request.form['username']
    password = request.form['password']
    print(password , username)
    sql = "SELECT id,username,password FROM user"
    cursor.execute(sql)
    user_arr = []
    flag = False
    for row in cursor.fetchall():
        user_arr.append(row)
        if username == row[1] and password == row[2]:
            # 查询所有用户信息
            flag = True
    if flag:
        return render_template("main.html", users=user_arr)
    else:
        return render_template("login.html", error="用户名或密码错误")


@app.route('/deluser',methods=["GET","POST"])
def delete():
    id = int(request.args.get('id'))
    print(id)
    sql = "delete from user