基于Python的校友会管理平台设计与实现

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Alumni(db.Model):

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

排课管理系统

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

email = db.Column(db.String(120), unique=True, nullable=False)

graduation_year = db.Column(db.Integer, nullable=False)

def __repr__(self):

return f'Alumni({self.name}, {self.email})'

from flask import Flask, render_template

app = Flask(__name__)

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

db.init_app(app)

@app.route('/')

def index():

alumni_list = Alumni.query.all()

return render_template('index.html', alumni=alumni_list)

if __name__ == '__main__':

app.run(debug=True)