一站式网上办事大厅

CREATE TABLE students (

student_id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

major VARCHAR(50),

email VARCHAR(100)

);

CREATE TABLE courses (

course_id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(100) NOT NULL,

credits INT,

instructor_id INT

);

CREATE TABLE projects (

project_id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(100) NOT NULL,

description TEXT,

supervisor_id INT,

budget DECIMAL(10, 2)

);

]]>

from flask import Flask, jsonify, request

app = Flask(__name__)

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

def get_student_courses(student_id):

# 这里假设我们有一个函数从数据库获取数据

courses = fetch_student_courses(student_id)

return jsonify(courses)

if __name__ == '__main__':

app.run(debug=True)

]]>