基于研究生管理信息系统的解决方案设计与实现

CREATE TABLE Student (

ID INT PRIMARY KEY,

Name NVARCHAR(50),

Major NVARCHAR(50)

);

]]>

from flask import Flask, jsonify, request

app = Flask(__name__)

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

def get_students():

# 模拟数据

students = [

{"id": 1, "name": "Alice", "major": "Computer Science"},

{"id": 2, "name": "Bob", "major": "Mathematics"}

]

return jsonify(students)

if __name__ == '__main__':

app.run(debug=True)

]]>

import React, { useState, useEffect } from 'react';

function App() {

const [students, setStudents] = useState([]);

useEffect(() => {

fetch('http://localhost:5000/students')

.then(response => response.json())

.then(data => setStudents(data));

}, []);

return (

);

}

export default App;

]]>