基于校友管理平台的医科大学私董会技术实现

# Python 后端示例代码

from flask import Flask, jsonify, request

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/alumni'

db = SQLAlchemy(app)

class Alumnus(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)

@app.route('/alumni', methods=['GET'])

def get_alumni():

alumni = Alumnus.query.all()

return jsonify([{'id': a.id, 'name': a.name, 'email': a.email} for a in alumni])

]]>