- 用上下文处理器app_context_processor定义函数
- 获取session中保存的值
- 返回字典
- 在父模板中更新导航,插入登录状态判断代码。
- 注意用{% ... %}表示指令。
- {{ }}表示变量
- 完成注销功能。
- 清除session
- 跳转
from flask import Flask,request,render_template,redirect,url_for,session
from flask_sqlalchemy import SQLAlchemy
import sqlconnect
from functools import wraps
from datetime import datetime
app = Flask(__name__)
app.config.from_object(sqlconnect)#app连接数据库
db = SQLAlchemy(app)
class User(db.Model):
__tablename__ ='user1'
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)
#againpass = db.Column(db.String(20), nullable=False)
#db.create_all()
#增加
# user = User(username ='xxxxx1',password ='123456')
# db.session.add(user)
# db.session.commit()
#查找
# user = User.query.filter(User.username =='xxxxx1').first()
# user.password ='123456'
# user.againpass='123456'
# print(user.id,user.username,user.password)
#删除
# user = User.query.filter(User.username =='xxxxx1').first()
# db.session.delete(user)
# db.session.commit()
@app.route('/')
def first():
return render_template("first.html")
@app.context_processor
def mycontext():
usern = session.get('user')
if usern:
return{'username':usern}
else:
return {}
@app.route('/logout/')
def logout():
session.clear()
return redirect(url_for('first'))
@app.route("/login/",methods=['GET','POST'])
def sign_in():
if request.method =='GET':
return render_template("sign_in.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('first'))
else:
return u'密码错误!'
else:
return u'不存在该用户名!'
@app.route("/regiter/",methods=['GET','POST'])
def sign_up():
if request.method == 'GET':
return render_template("sign_up.html")
else:
name = request.form.get('newname')
passw = request.form.get('newpass')
samename = User.query.filter(User.username == name).first()
if samename:
return u'username existed!'
else:
# 将用户名和密码存入数据库
users =User(username = name ,password = passw)
db.session.add(users)
db.session.commit()
return render_template("sign_in.html")#注册成功后跳转到登录界面
@app.route("/question/")
def question():
return render_template("wenda.html")
if __name__ == '__main__':
app.run(debug=True)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>{% block title %}{% endblock %}France </title>
<link href="../static/base.css" rel="stylesheet" type="text/css">
<script src="../static/base.js"></script>
{% block head %}{% endblock %}
</head>
<body class="bodycolor" id="myBody">
<div class="daohanglang" id="daohanglang">
<nav>
<img class="turn_on_off" id="on_off" onclick="mySwitch()" src="{{ url_for('static',filename='image/on.jpg') }}" width="40px">
<a class="daohang" href="{{ url_for('first')}}">首页</a>
<a class="daohang" href="">卢浮宫</a>
<a class="daohang" href="">塞纳河</a>
<a class="daohang" href="">埃菲尔铁塔</a>
<a class="daohang" href="">香榭丽大道</a>
<a class="daohang" href="">巴黎圣母院</a>
<input class="sousuo" id="sousuo" type="text" placeholder="搜索" >
<img onclick="chaZhao()" id="chazhao" src="{{ url_for('static',filename='image/on.jpg') }}" width="20px">
</nav>
<nav>
{% if username %}
<a class="daohangright" href="{{ url_for('logout') }}">注销</a>
<a class="daohangright" href="#">{{ username }}</a>
{% else %}
<a class="daohangright" href="{{ url_for('sign_up') }}" >注册</a>
<a class="daohangright" href="{{ url_for('sign_in') }}" >登录</a>
{% endif %}
</nav>
<HR align=center width=100% color=#c0c0c0 SIZE=1>
</div>
{% block main %}{% endblock %}
<div class="foot-menu" id="dibudaohang">
<HR align=center width=100% color=#c0c0c0 SIZE=1>
<nav>
<a class="daohang" href="">法国历史</a>
<a class="daohang" href="">法国地图</a>
<a class="daohang" href="">旅行攻略</a>
<a class="daohang" href="{{ url_for('question') }}">发布问答</a>
<p>版权@ linxx</p>
</nav>
</div>
</body>
</html>