登录功能完成:
- js:设置return
- html:设置
- form
- input
- py:
- @app.route设置methods
- GET
- POST
- 读取表单数据
- 查询数据库
- 用户名密码对:
- 记住用户名
- 跳转到首页
- 用户名密码不对:
- 提示相应错误。
- 用户名密码对:
session:
- 从`flask`中导入`session`
- 设置`SECRET_KEY`
- 操作字典一样操作`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