锦中迎新管理系统

# 导入所需模块

from flask import Flask, render_template, request

from flask_sqlalchemy import SQLAlchemy

统一登录认证

# 初始化应用实例

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.db'

db = SQLAlchemy(app)

# 定义数据模型

class Student(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(80), nullable=False)

department = db.Column(db.String(80))

# 路由定义

@app.route('/')

def index():

students = Student.query.all()

return render_template('index.html', students=students)

@app.route('/add', methods=['POST'])

def add_student():

name = request.form['name']

department = request.form['department']

new_student = Student(name=name, department=department)

db.session.add(new_student)

db.session.commit()

return "Student added successfully!"

if __name__ == '__main__':

db.create_all()

app.run(debug=True)