CREATE TABLE student (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50),

department VARCHAR(100),

work_record TEXT

);

from flask import Flask, jsonify

app = Flask(__name__)

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

def get_students():

# 模拟查询数据库

return jsonify({"students": [{"id": 1, "name": "张三", "department": "计算机学院"}]})

if __name__ == '__main__':

app.run(debug=True)