user.py
2.74 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
import time
import hashlib
from flask import Blueprint, redirect, render_template, request, Flask, session
from utils.query import query
from utils.errorResponse import errorResponse
ub = Blueprint('user',
__name__,
url_prefix='/user',
template_folder='templates')
# 密码加密函数
def hash_password(password: str, salt: str = 'XiaoXueQi2024') -> str:
"""
使用 SHA256 对密码进行加盐哈希
:param password: 用户输入的密码
:param salt: 加盐值，默认值为 'XiaoXueQi2024'
:return: 哈希后的密码
"""
hash_with_salt = hashlib.sha256(salt.encode('utf-8'))
hash_with_salt.update(password.encode('utf-8'))
return hash_with_salt.hexdigest()
@ub.route('/login', methods=['GET', 'POST'])
def login():
"""
处理用户登录请求
:return: 登录页面或重定向到主页
"""
if request.method == 'GET':
return render_template('login_and_register.html') # 显示登录页面
# 提取表单数据
username = request.form.get('username', '').strip()
password = hash_password(request.form.get('password', '').strip())
# 查询用户信息
user_query = 'SELECT * FROM user WHERE username = %s AND password = %s'
users = query(user_query, [username, password], 'select')
if not users:
# 登录失败，返回登录页面并显示错误信息
return render_template('login_and_register.html', error='账号或密码错误', username=username)
# 登录成功，设置会话并重定向
session['username'] = username
return redirect('/page/home')
@ub.route('/register', methods=['GET', 'POST'])
def register():
if request.method == 'GET':
return render_template('login_and_register.html')
else:
def filter_fn(user):
return request.form['username'] in user
users = query('select * from user', [], 'select')
filter_list = list(filter(filter_fn, users))
if len(filter_list):
return errorResponse('该用户名已被注册')
else:
time_tuple = time.localtime(time.time())
hash_with_salt = hashlib.sha256('XiaoXueQi2024'.encode('utf-8'))
hash_with_salt.update(request.form['password'].encode('utf-8'))
query(
'''
insert into user(username,password,createTime) values(%s,%s,%s)
''', [
request.form['username'],
hash_with_salt.hexdigest(),
str(time_tuple[0]) + '-' + str(time_tuple[1]) + '-' +
str(time_tuple[2])
])
return redirect('/user/login')
@ub.route('/logOut')
def logOut():
session.clear()
return redirect('/user/login')