学生信息管理系统

CREATE TABLE Student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

gender ENUM('Male', 'Female') DEFAULT 'Male',

major VARCHAR(100),

grade YEAR,

email VARCHAR(100) UNIQUE

);

from flask import Flask, jsonify, request

app = Flask(__name__)

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

def get_student(student_id):

# 假设这里已连接到数据库

cursor.execute("SELECT * FROM Student WHERE id=%s", (student_id,))

result = cursor.fetchone()

return jsonify(result)

if __name__ == '__main__':

app.run(debug=True)