Flask - 数据库 (密码加密)

加密

• 使用**hashlib.sha256()**

import hashlib
from flask import Blueprint, request, render_template
from apps.user.models import User
from exts import db

user_bp = Blueprint('user', __name__)


# 注册
@user_bp.route('/register', methods=['GET', 'POST'])
def register():
    if request.method == 'POST':
        username = request.form.get('username')
        password = request.form.get('password')
        repassword = request.form.get('repassword')
        phone = request.form.get('phone')
        if repassword == password:
            # 与模型结合
            # 创建模型对象
            user = User()
            # 给对象赋值
            user.username = username
            # 把加密后的密码赋值给user对象
            user.password = hashlib.sha256(password.encode('utf-8')).hexdigest()
            user.phone = phone
            # 添加
            # 将user对象添加到session
            db.session.add(user)
            # 提交
            db.session.commit()
            return '注册成功'
        else:
            return '两次密码不一致'
    else:
        return render_template('user/register.html')

查询

• 语法 :
  • 查询所有数据 : 对象.query.all()

用户首页

views.py

# 用户首页
@user_bp.route('/')
def user_center():
    # 查询数据库中的数据
    user = User.query.all()  # select * from user;
    print(user)
    return render_template('user/center.html', user=user)

center.html

{% extends 'base.html' %}
{% block title %}用户首页{% endblock %}
{% block footer %}
    <div>
        <a href="{{ url_for('user.register') }}">注册</a> <br>
        <a href="">登录</a>
    </div>
    <div>
        <h1>所有的用户信息如下:</h1>
        {% if user %}
            <table border="1">
            <tr>
                <th>序号</th>
                <th>用户名</th>
                <th>手机号</th>
                <th>注册时间</th>
                <th>操作</th>
            </tr>
            {% for user in user %}
                <tr>
                    <th>{{ loop.index }}</th>
                    <th>{{ user.username }}</th>
                    <th>{{ user.phone }}</th>
                    <th>{{ user.rdatetime }}</th>
                    <th>
                        <a href="{{ url_for('user.update') }}">修改</a>
                        <a href="javascript:;">删除</a>
                    </th>
                </tr>
            {% endfor %}
        </table>
        {% else %}
            <p style="color: red">当前还没有任何的用户</p>
        {% endif %}
    </div>
{% endblock %}