研究生管理信息系统与科学的融合

CREATE DATABASE GraduateManagement;

USE GraduateManagement;

]]>

CREATE TABLE Students (

student_id INT PRIMARY KEY,

name VARCHAR(100),

email VARCHAR(100),

major VARCHAR(100)

);

CREATE TABLE Grades (

grade_id INT PRIMARY KEY AUTO_INCREMENT,

student_id INT,

course_name VARCHAR(100),

score DECIMAL(5,2),

FOREIGN KEY (student_id) REFERENCES Students(student_id)

);

]]>

SELECT s.name, g.course_name, g.score

FROM Students s

JOIN Grades g ON s.student_id = g.student_id

WHERE s.student_id = ?;

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

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

def get_student_grades(student_id):

# 假设这里有一个函数来从数据库获取成绩

grades = get_grades_from_db(student_id)

return jsonify(grades)

if __name__ == '__main__':

app.run(debug=True)

]]>