flask框架写一个注册页面

serve.py

import flask
app = flask.Flask("web")

@app.route("/", methods=["GET", "POST"])
def index():
    msg = ""
    if flask.request.method == "POST":
        user = flask.request.values.get("user", "")
        pwd = flask.request.values.get("pwd", "")
        if user != "" and pwd != "":
            msg = user + "," + pwd
    return flask.render_template("register.html", msg=msg)

app.debug=True
if __name__ == "__main__":
    app.run()

templates文件夹下register.html文件

<h1>用户注册</h1>
<form name="frm" id="frm" action="" method="post">
  <div>用户<input type="text" name="user" id="user"></div>
  <div>密码<input type="password" name="pwd" id="pwd"></div>
  <div><input type="submit" value="注册"></div>
</form>
<div>{{msg}}</div>

这个就是一个简单的注册页面，如果输入用户和密码，下边会出现用户，密码

加上数据库的注册程序

serve.py

import flask
app = flask.Flask("web")
import pymysql

def saveUser(user, pwd):
    try:
        # 创建数据的链接对象con
        # 数据库将user设置为主键
        con = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="123456", db="test", charset="utf8")
        # 数据库名是test
        # 创建一个字典类型的游标cursor
        cursor = con.cursor(pymysql.cursors.DictCursor)
        # cursor执行SQL命令
        sql = "insert into users (user, pwd) values ('"+user+"', '"+pwd+"')"
        # 数据库test中表名users (user, pwd)，user是主键
        cursor.execute(sql)
        # 提交数据库
        con.commit()
        con.close()
        return True
    except Exception as err:
        return False

# def readUser(user, pwd):
#     try:
#         # 创建数据的链接对象con
#         con = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="123456", db="test", charset="utf8")
#         # 创建一个字典类型的游标cursor
#         cursor = con.cursor(pymysql.cursors.DictCursor)
#         # cursor执行SQL命令
#         sql = "select * from users where user='" + user + "'and pwd='" + pwd+"'"
#         cursor.execute(sql)
#         row = cursor.fetchone()
#         # 提交数据库
#         con.commit()
#         con.close()
#         if row:
#             return True
#         else:
#             return False
#     except Exception as err:
#         return False

@app.route("/", methods=["GET", "POST"])
def index():
    msg = ""
    if flask.request.method == "POST":
        user = flask.request.values.get("user", "")
        pwd = flask.request.values.get("pwd", "")
        # 获得网页上输入的user和pwd
        if user != "" and pwd != "":

            if saveUser(user, pwd):
                msg = user + "注册成功"
            else:
                msg = user + "已经存在"
                # 若user在数据库中存在，则说明已经存在，user是主键，同一个user只能出现一次
            # if readUser(user, pwd):
            #     msg = user + "登录成功"
            # else:
            #     msg = user + "登录失败"
    return flask.render_template("register.html", msg=msg)

app.debug=True
if __name__ == "__main__":
    app.run()

templates文件夹下register.html文件

<h1>注册登录</h1>
<form name="frm" id="frm" action="" method="post">
  <div>用户<input type="text" name="user" id="user"></div>
  <div>密码<input type="password" name="pwd" id="pwd"></div>
  <div><input type="submit" value="注册">
<!--    <input type="submit" value="登录">-->
  </div>
</form>
<div>{{msg}}</div>

如果是登录的话见注释