校友会管理平台在理工大学中的应用

from flask import Flask, request, jsonify

import mysql.connector

app = Flask(__name__)

# 配置数据库连接

db = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="alumni_db"

)

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

def add_alumni():

data = request.get_json()

name = data['name']

graduation_year = data['graduation_year']

email = data['email']

数据可视化平台

cursor = db.cursor()

query = "INSERT INTO alumni (name, graduation_year, email) VALUES (%s, %s, %s)"

values = (name, graduation_year, email)

cursor.execute(query, values)

db.commit()

return jsonify({"message": "Alumni added successfully"}), 201

if __name__ == '__main__':

app.run(debug=True)

]]>