完成登录功能，用session记住用户名

登录功能完成：

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

session：

从`flask`中导入`session`
设置`SECRET_KEY`

操作字典一样操作`session`：增加用户名`session['username']=`username

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

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)
    nickname = db.Column(db.String(50))


#db.create_all()

#增加数据
#user=User(username = 'shanshan1',password = '111111')
#db.session.add(user)
#db.session.commit()

#查询数据
#user=User.query.filter(user.username == 'shanshan1').first()
#print(user.id,user.username,user.password)


#修改数据
#user=User.query.filter(user.username == 'shanshan3').first()
#user.password = '0000'
#db.session.commit()

#删除数据
#user=User.query.filter(user.username == 'shanshan3').first()
#db.session.delete(user)
#db.session.commit()


@app.route('/')
def index():
    return  render_template('shouye.html')
@app.route(   '/manhua')
def manhua():
    return  render_template('manhua.html')

@app.route('/login',methods=['GET','POST'])
def login():
    if request.method =='GET':
        return render_template('denglu.html')
    else:
        name = request.form.get('name')
        passw = request.form.get('password')
        user = User.query.filter(User.username == name).first()
    if user:
       if user.password==passw:
           session['user']=name
           return redirect(url_for("manhua"))
       else:
           return "密码错误！"
    else:
        return "用户名不存在！"

@app.route("/register",methods=['GET','POST'])
def register():
    if request.method == 'GET':
        return render_template("zhuce.html")
    else:
        name = request.form.get('name')
        passw = request.form.get('password')
        user = User.query.filter(User.username == name).first()
    if user:
        return "用户名已存在！"

    else:
        user = User(username=name, password=passw)
        db.session.add(user)
        db.session.commit()
        return render_template("denglu.html")



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

import os

SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:@localhost:3306/mis_db?charset=utf8'
SQLALCHEMY_TRACK_MODIFICATIONS = False

SECRET_KEY =os.urandom(24)

{% extends'shouye.html' %}
{% block title %}
    Login
{% endblock %}
{% block head %}
    <link rel="stylesheet"type="text/css"href="../static/css/denglu.css">
    <script src="../static/js/denglu.js"></script>
{% endblock %}
{% block main %}
<body>
    <div class="b1" >
    <form action="{{ url_for("login") }}" method="post">
        <div class="s1" ><h3>用户登录/LOGIN </h3></div>
        <div class="b2" >
        户名：<input id="name" type="text"placeholder="请输入用户名"name="name"><br>
        密码：<input id="password" type="password"placeholder="请输入密码"name="password"><br>
        </div>
        <div id="error_box"><br></div>
    <div class="s2" >
         <button onclick="return myLogin()">登录</button>
         <button type="button" onclick=window.alert("是否取消登录")>取消</button>
          <label for="remember_me" style="padding: 0;">Remember me?</label>
          <input type="checkbox" id="remember_me" style="position: relative; top: 3px; margin: 0; " name="remember_me"/>
          <div class="design">
              <p>Design by ss</p>
         </div>

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

function myLogin() {
        var oUname = document.getElementById("name");
        var oError = document.getElementById("error_box");
        var opassword = document.getElementById("password");
         oError.innerHTML="<br>";
            //oUname
         if(oUname.value.length<6||oUname.value.length>12){
                oError.innerHTML="用户名请输入6-12个字符";
                return false;
            }else if ((oUname.value.charCodeAt(0)>=48) &&(oUname.value.charCodeAt(0)<=57)){
                 oError.innerHTML="用户名首字符不能为数字";
                 return false;
         }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) < 97) || (oUname.value.charCodeAt(i) > 122)){
                   oError.innerHTML="用户名只能是字母和数字";
                   return false;
               }

         }

         //opassword
         if(opassword.value.length<6||opassword.value.length>12){
                oError.innerText="密码请输入6-12个字符内";
                return false;
            }
         return true;
             }

posted on 2017-11-22 16:35 104鲍珊珊阅读(321) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

0104鲍珊珊

完成登录功能，用session记住用户名

导航

公告