基于校友信息管理系统的试用分析与实现

        # 导入必要的库
        from flask import Flask, request, jsonify
        import mysql.connector

        # 初始化Flask应用
        app = Flask(__name__)

        @app.route('/add_alumni', methods=['POST'])
        def add_alumni():
            data = request.get_json()
            alumni_name = data['alumni_name']
            alumni_email = data['alumni_email']

            # 连接数据库
            db = mysql.connector.connect(
                host="localhost",
                user="root",
                password="password",
                database="alumni_system"
            )
            cursor = db.cursor()

            # 插入数据
            sql = "INSERT INTO alumni (name, email) VALUES (%s, %s)"
            val = (alumni_name, alumni_email)
            cursor.execute(sql, val)
            db.commit()

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