登录功能完成:

  1. js:设置return
  2. html:设置
    1. form
    2. input
  3. py:
    1. @app.route设置methods
    2. GET
    3. POST
      1. 读取表单数据
      2. 查询数据库
        1. 用户名密码对:
          1. 记住用户名
          2. 跳转到首页
        2. 用户名密码不对:
          1. 提示相应错误。

session:

  1. 从`flask`中导入`session`
  2. 设置`SECRET_KEY`
  3. 操作字典一样操作`session`:增加用户名`session['username']=`username

 JS文件代码如下:

function foLogin() {
            var oUname = document.getElementById("uname");
            var oError = document.getElementById("error_box");
            var oUpass = document.getElementById("upass");

            var isError = true;
            oError.innerHTML = "<br>";

            if (oUname.value.length < 6 || oUname.value.length > 12) {
                oError.innerHTML = "用户名要6-12位";
                isError = false;
                return;
            }else if(oUname.value.charCodeAt(0)>=48 &&(oUname.value.charCodeAt(0)<=57)){
                oError.innerHTML="首位不能为数字";
                isError = false;
                return isError;

            }else for (var i=0;i<oUname.value.length;i++){
               if((oUname.value.charCodeAt(i)<48)||(oUname.value.charCodeAt(i)>57)&&(oUname.value.charCodeAt(i)<58)&&(oUname.value.charCodeAt(i)>97)){
                oError.innerHTML="只能为数字和字母";
                isError = false;
                return isError;
            }
            }
            if (oUpass.value.length < 6 || oUpass.value.length > 12) {
                oError.innerHTML = "密码要6-20位";
                isError = false;
                isError = false;
                return isError;
             }
            return ture;
            }

html文件代码如下:

{% extends 'ba.html' %}
{% block title %}
开心果
{% endblock %}
{% block main %}
    <link rel="stylesheet" type="text/css" href="../static/css/登录注册样式.css">
    <script src="../static/js/登录页面.js"></script>


</head>
<body bgcolor="#ffe4c4">
   <form action="{{ url_for('denglu') }}" method="post">
<div class="box">
    <div id="tittle"><h2 align="center">登录</h2></div>
    <p class="input_box">
        账户: <input id="uname" type="text" placeholder="请输入您的账户"name="username">
    </p>
    <p class="input_box">
        密码: <input id="upass" type="password" placeholder="请输入您的号码" name="password">
    </p>

    <div id="error_box"><br></div>
    <div class="input_button"><button type="submit" onclick="return foLogin()">登录</button></div>
   <h4 align="center"> <a href="zhuce.html">没有账号?点我啊</a></h4>

</div>
   </form>
{% endblock %}
</body>

py主文件代码如下:

from flask import Flask, render_template,request,redirect,url_for,session
from flask_sqlalchemy import SQLAlchemy
import config

app = Flask(__name__)
app.config.from_object(config)
db = SQLAlchemy(app)


class User(db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    username = db.Column(db.String(20), nullable=False)
    password = db.Column(db.String(20), nullable=False)


# db.create_all()
# # 增加
# user = User(username = 'zhuyinyin',password='113428164508')
# db.session.add(user)
# db.session.commit()
# 修改
# ser=User.query.filter(User.username =='zhuyinyin').first()
# user.password='123'
# print(user.username,user.password)
# db.session.commit()
#查询:
# User.query.filter(User.username == 'zhuyinyin').first()
# print(user.username,user.password)

# db.session.commit()
# 修改:
# user.password = '111111'
# db.session.commit()

# 删除:
# db.session.delete(user)
# db.session.commit()


@app.route('/')
def hello_world():
    return render_template('ba.html')
@app.route('/zhuce/',methods=['GET','POST'])
def zhuce():
    if request.method == 'GET':
        return render_template('zhuce.html')
    else:
        username = request.form.get('username')  # 获取form中的数据
        password = request.form.get('password')  # 获取form中的数据
        # email = request.form.get('email')  # 获取form中的数据
        user = User.query.filter(User.username ==username).first()
        if user:
            return'用户已存在'
        else:
            user = User(username = username,password=password)
            db.session.add(user)
            db.session.commit()
            return redirect(url_for('denglu'))

# @app.route('/denglu/',methods=['GET','POST'])
# def denglu():
#     if request.method=='GET':
#         return render_template('denglu.html')
#     else:
#         username=request.form.get('username')
#         password=request.form.get('password')
#         user=User.query.filter(User.username==username,User.password==password).first()
#         #判断用户名是否存在
#         if user:
#             if user.password==password:
#                 return redirect(url_for('shouye'))
#             else:
#                 return '密码错误'
#         else:
#             return '用户不存在'

#第二种写法
@app.route('/denglu/',methods=['GET','POST'])
def denglu():
    if request.method=='GET':
        return render_template('denglu.html')
    else:
        username = request.form.get('username')
        password = request.form.get('password')

        user=User.query.filter(User.username==username).first()
        #判断用户名是否存在
        if user:
            session['user']=username
            session.permanent=True
            if user.password==password:
                return redirect(url_for('shouye'))
            else:
                return '密码错误'
        else:
            return '此用户不存在'



@app.route('/shouye/')
def shouye():
    return render_template('春夏秋冬.html')
@app.route('/wenda/')
def wenda():
    return render_template('wenda.html')

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

config代码如下:

import os
DEBUG=True
SECRET_KEY=os .urandom(24)

DIALECT='mysql'
DRIVER='mysqldb'
USERNAME='root'
PASSWORD='123456'
HOST='127.0.0.1'
PORT='3306'
DATABASE='reader'

SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:123456@127.0.0.1:3306/reader?charset=utf8'
SQLALCHEMY_TRACK_MODIFICATIONS = False

 

 

posted on 2017-11-21 15:06  朱茵茵  阅读(248)  评论(0编辑  收藏  举报