### Flask框架实现前后端与数据库互联及注册登录和发送邮箱验证码功能 以下是一个完整的教程，详细介绍了如何使用Python Flask框架实现前后端与数据库的互联，并包含用户注册、登录以及发送邮箱验证码的功能。 --- #### 一、环境配置 1. **安装依赖库** 在项目根目录下创建`requirements.txt`文件，添加以下内容： ```plaintext Flask==2.3.2 Flask-SQLAlchemy==3.0.5 Flask-Mail==0.9.1 itsdangerous==2.1.2 pymysql==1.0.2 ``` 使用以下命令安装依赖库： ```bash pip install -r requirements.txt ``` 2. **配置环境变量** 编辑`.flaskenv`文件（或在`.bashrc`中设置），添加以下配置： ```plaintext FLASK_APP=app.py FLASK_ENV=development FLASK_DEBUG=1 MAIL_SERVER=smtp.qq.com MAIL_PORT=587 MAIL_USE_TLS=True MAIL_USERNAME=your_email@qq.com MAIL_PASSWORD=your_email_auth_code SECRET_KEY='your_secret_key' SQLALCHEMY_DATABASE_URI=mysql+pymysql://username:password@localhost/database_name ``` 3. **激活虚拟环境** 确保已激活虚拟环境并加载环境变量： ```bash flask shell ``` --- #### 二、数据库模型设计 1. **定义数据模型** 创建`models.py`文件，定义用户模型： ```python from app import db from itsdangerous import TimedJSONWebSignatureSerializer as Serializer class User(db.Model): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(120), unique=True, nullable=False) username = db.Column(db.String(80), unique=True, nullable=False) password_hash = db.Column(db.String(128), nullable=False) confirmed = db.Column(db.Boolean, default=False) def generate_confirmation_token(self, expiration=3600): s = Serializer(current_app.config['SECRET_KEY'], expiration) return s.dumps({'confirm': self.id}).decode('utf-8') def confirm(self, token): s = Serializer(current_app.config['SECRET_KEY']) try: data = s.loads(token.encode('utf-8')) except: return False if data.get('confirm') != self.id: return False self.confirmed = True db.session.add(self) return True ``` 2. **迁移数据库** 使用Flask-Migrate进行数据库迁移： ```bash flask db init flask db migrate -m "initial migration" flask db upgrade ``` --- #### 三、邮件发送功能 1. **配置邮件服务** 在`__init__.py`中初始化邮件服务： ```python from flask import Flask from flask_mail import Mail from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config.from_object('config') mail = Mail(app) db = SQLAlchemy(app) from app import routes, models ``` 2. **实现邮件发送逻辑** 创建`utils.py`文件，定义邮件发送函数： ```python from flask_mail import Message from app import mail def send_email(to, subject, template): msg = Message( subject, recipients=[to], html=template ) mail.send(msg) ``` 3. **调用邮件发送函数** 在视图函数中调用`send_email`函数： ```python from .utils import send_email @auth.route('/register', methods=['POST']) def register(): # 获取表单数据并验证 user = User(email=form.email.data, username=form.username.data, password_hash=generate_password_hash(form.password.data)) db.session.add(user) db.session.commit() token = user.generate_confirmation_token() send_email(user.email, 'Confirm Your Account', f'<a href="http://localhost:5000/auth/confirm/{token}">Click here</a>') flash('A confirmation email has been sent to you by email.') return redirect(url_for('auth.login')) ``` --- #### 四、前端交互 1. **HTML模板** 创建`templates/auth/register.html`文件： ```html <form method="POST"> Email: <input type="email" name="email"><br> Username: <input type="text" name="username"><br> Password: <input type="password" name="password"><br> <button type="submit">Register</button> </form> ``` 2. **AJAX请求** 在`static/js/main.js`中实现AJAX请求： ```javascript $.ajax({ url: '/auth/register', type: 'POST', data: JSON.stringify({ email: 'test@example.com', username: 'testuser', password: 'password' }), contentType: 'application/json', success: function(response) { alert('Registration successful!'); }, error: function(error) { console.error(error); } }); ``` --- #### 五、路由与视图函数 1. **定义蓝图** 创建`auth.py`文件，定义注册和登录路由： ```python from flask import Blueprint, request, redirect, url_for, flash from app.models import User from app import db from werkzeug.security import generate_password_hash, check_password_hash auth = Blueprint('auth', __name__) @auth.route('/login', methods=['POST']) def login(): email = request.form['email'] password = request.form['password'] user = User.query.filter_by(email=email).first() if user and check_password_hash(user.password_hash, password): flash('Login successful!') return redirect(url_for('main.index')) else: flash('Invalid credentials!') return redirect(url_for('auth.login')) @auth.route('/confirm/<token>') def confirm(token): user = User.query.filter_by(confirmed=False).first() if user.confirm(token): flash('You have confirmed your account. Thanks!') else: flash('The confirmation link is invalid or has expired.') return redirect(url_for('main.index')) ``` --- #### 六、运行项目 启动Flask应用： ```bash flask run ``` 访问以下链接测试功能： - 首页：`127.0.0.1:5000` - 注册页面：`127.0.0.1:5000/auth/register` - 登录页面：`127.0.0.1:5000/auth/login` --- ###