基于AI助手的研究生管理信息系统设计与实现

        from flask import Flask, request, jsonify
        from sqlalchemy import create_engine

        app = Flask(__name__)
        engine = create_engine('mysql+pymysql://username:password@localhost/grad_system')

        @app.route('/api/student', methods=['GET'])
        def get_students():
            query = "SELECT * FROM students"
            with engine.connect() as connection:
                result = connection.execute(query)
                students = [dict(row) for row in result]
            return jsonify(students)

        if __name__ == '__main__':
            app.run(debug=True)