話不多說，直接上干貨
先引用插件
from flask import Flask, render_template, session, request, redirect
from flask_sqlalchemy import SQLAlchemy
from flask_session import Session
import pymysql
import redis
再完成相關(guān)的配置
pymysql.install_as_MySQLdb()
# 初始化Session對象
f_session = Session()
app = Flask(__name__)
# 設(shè)置連接數(shù)據(jù)庫的URL
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:123456@127.0.0.1:3306/xiangqin'
# 數(shù)據(jù)庫和模型類同步修改
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
# 查詢是會顯示原始SQL語句
app.config['SQLALCHEMY_ECHO'] = True
db = SQLAlchemy(app)
app.config['SECRET_KEY'] = 'laowangaigebi' # 加密的密鑰
app.config['SESSION_USE_SIGNER'] = True # 是否對發(fā)送到瀏覽器上session的cookie值進(jìn)行加密
app.config['SESSION_TYPE'] = 'redis' # session類型為redis
app.config['SESSION_KEY_PREFIX'] = 'session:' # 保存到session中的值的前綴
app.config['PERMANENT_SESSION_LIFETIME'] = 7200 # 失效時間 秒
app.config['SESSION_REDIS'] = redis.Redis(host='127.0.0.1', port='6379', db=4) # redis數(shù)據(jù)庫連接
# 綁定flask的對象
f_session.init_app(app)
app.config['SECRET_KEY'] = 'xiaohuaxiaohua' #設(shè)置session加密的密鑰
登錄視圖的實(shí)現(xiàn)
簡單的登錄頁面
<form action="/login/" method="post">
賬號：<input type="text" name="name"><br>
密碼：<input type="text" name="password"><br>
{# <button type="submit" value="登錄">登錄</button>#}
<input type="submit" value="登錄">
<a href="/register/">沒有賬號同诫？去注冊</a>
</form>
@app.route('/login/', methods=['GET', 'POST'])
def login():
if request.method == 'GET':
return render_template('login.html')
elif request.method == 'POST':
name = request.form.get('name')
password = request.form.get('password')
user = User.query.filter_by(name=name).first()
if user:
if password != user.password:
return render_template('login.html')
else:
session['uid'] = user.id
session['islogin'] = 1
return redirect('/index/')
else:
cxt = {
'error': '沒有此用戶'
}
return render_template('login.html', **cxt)
注冊視圖的實(shí)現(xiàn)
簡單的注冊頁面
<form action="/register/" method="post">
賬號：<input type="text" name="name"><br>
密碼：<input type="text" name="password"><br>
重復(fù)密碼：<input type="text" name="password1"><br>
{# 昵稱：<input type="text" name="nickname" value="請?zhí)顚戧欠Q"><br>#}
性別：
男：<input type="radio" name="gender" value="1">
女：<input type="radio" name="gender" value="0"><br>
<input type="submit" value="注冊"><br>
<a href="/login/">已有賬號着茸？去登陸</a>
</form>
@app.route('/register/', methods=['GET', 'POST'])
def register():
if request.method == 'GET':
return render_template('register.html')
elif request.method == 'POST':
name = request.form.get('name')
password = request.form.get('password')
password1 = request.form.get('password1')
gender = request.form.get('gender')
user = User.query.filter_by(name=name).first()
if user:
cxt = {
'error': '該用戶名已存在壮锻，請重新創(chuàng)建'
}
return render_template('register.html', **cxt)
else:
if password != password1:
cxt = {
'error': '兩次密碼不一致，請重新輸入'
}
return render_template('register.html', **cxt)
else:
user_s = User(name=name, password=int(password), gender=int(gender))
db.session.add(user_s)
db.session.commit()
return redirect('/login/')
退出登錄的實(shí)現(xiàn)
@app.route('/logout/')
def logout():
session.clear()
return redirect('/index/')
首頁的展示用戶信息以及狀態(tài)保持涮阔，我做的是一個賊簡單的相親網(wǎng)站猜绣，只展示與自己相反性別的人
簡單的首頁
<body>
{% if islogin == 1 %}
<h1>歡迎{{ user.name }}</h1><br>
<a href="/logout/"><h1>退出登錄</h1></a>
<ul>
{% for foo in list_obj %}
<li>
{{ foo.name }}--{{ foo.set() }}
</li>
{% endfor %}
</ul>
{% else %}
<a href="/login/"><h1>去登錄</h1><br></a>
{% endif %}
</body>
@app.route('/index/')
def index():
uid = session.get('uid')
islogin = session.get('islogin')
if uid:
user = User.query.filter_by(id=uid).first()
obj = User.query.offset(user.gender).all()
print(obj)
list_obj = []
for i in obj:
if i.id != user.id:
list_obj.append(i)
cxt = {
'user': user,
'islogin': islogin,
'obj': obj,
'list_obj': list_obj
}
return render_template('index.html', **cxt)
else:
return render_template('index.html')
完整代碼（包含數(shù)據(jù)庫創(chuàng)建以及模型類的創(chuàng)建查詢）
from flask import Flask, render_template, session, request, redirect
from flask_sqlalchemy import SQLAlchemy
from flask_session import Session
import pymysql
import redis
pymysql.install_as_MySQLdb()
# 初始化Session對象
f_session = Session()
app = Flask(__name__)
# 設(shè)置連接數(shù)據(jù)庫的URL
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:123456@127.0.0.1:3306/xiangqin'
# 數(shù)據(jù)庫和模型類同步修改
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
# 查詢是會顯示原始SQL語句
app.config['SQLALCHEMY_ECHO'] = True
db = SQLAlchemy(app)
app.config['SECRET_KEY'] = 'laowangaigebi' # 加密的密鑰
app.config['SESSION_USE_SIGNER'] = True # 是否對發(fā)送到瀏覽器上session的cookie值進(jìn)行加密
app.config['SESSION_TYPE'] = 'redis' # session類型為redis
app.config['SESSION_KEY_PREFIX'] = 'session:' # 保存到session中的值的前綴
app.config['PERMANENT_SESSION_LIFETIME'] = 7200 # 失效時間 秒
app.config['SESSION_REDIS'] = redis.Redis(host='127.0.0.1', port='6379', db=4) # redis數(shù)據(jù)庫連接
# 綁定flask的對象
f_session.init_app(app)
app.config['SECRET_KEY'] = 'xiaohuaxiaohua' #設(shè)置session加密的密鑰
@app.route('/index/')
def index():
uid = session.get('uid')
islogin = session.get('islogin')
if uid:
user = User.query.filter_by(id=uid).first()
obj = User.query.offset(user.gender).all()
print(obj)
list_obj = []
for i in obj:
if i.id != user.id:
list_obj.append(i)
cxt = {
'user': user,
'islogin': islogin,
'obj': obj,
'list_obj': list_obj
}
return render_template('index.html', **cxt)
else:
return render_template('index.html')
@app.route('/login/', methods=['GET', 'POST'])
def login():
if request.method == 'GET':
return render_template('login.html')
elif request.method == 'POST':
name = request.form.get('name')
password = request.form.get('password')
user = User.query.filter_by(name=name).first()
if user:
if password != user.password:
return render_template('login.html')
else:
session['uid'] = user.id
session['islogin'] = 1
return redirect('/index/')
else:
cxt = {
'error': '沒有此用戶'
}
return render_template('login.html', **cxt)
@app.route('/register/', methods=['GET', 'POST'])
def register():
if request.method == 'GET':
return render_template('register.html')
elif request.method == 'POST':
name = request.form.get('name')
password = request.form.get('password')
password1 = request.form.get('password1')
gender = request.form.get('gender')
user = User.query.filter_by(name=name).first()
if user:
cxt = {
'error': '該用戶名已存在，請重新創(chuàng)建'
}
return render_template('register.html', **cxt)
else:
if password != password1:
cxt = {
'error': '兩次密碼不一致敬特，請重新輸入'
}
return render_template('register.html', **cxt)
else:
user_s = User(name=name, password=int(password), gender=int(gender))
db.session.add(user_s)
db.session.commit()
return redirect('/login/')
@app.route('/logout/')
def logout():
session.clear()
return redirect('/index/')
'''創(chuàng)建模型類'''
class User(db.Model):
# 定義表名
__tablename__ = 'tbl_user'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(32), unique=True)
password = db.Column(db.String(32), unique=True)
gender = db.Column(db.SmallInteger, default=0)
def set(self):
if self.gender == 0:
return '女'
else:
return '男'
if __name__ == '__main__':
app.run(host='0.0.0.0', port=5000, debug=True)
# db.drop_all()
# db.create_all() # 創(chuàng)建表
#
# user1 = User(name='zs', password='123456', gender=1)
# db.session.add(user1)
# db.session.commit()
