研究生管理系统中的解决方案及其实现

CREATE DATABASE GraduateManagement;

USE GraduateManagement;

CREATE TABLE Students (

student_id INT AUTO_INCREMENT,

name VARCHAR(100),

major VARCHAR(100),

PRIMARY KEY (student_id)

);

CREATE TABLE Courses (

course_id INT AUTO_INCREMENT,

course_name VARCHAR(100),

credits INT,

PRIMARY KEY (course_id)

);

]]>

const express = require('express');

const mysql = require('mysql');

const app = express();

const connection = mysql.createConnection({

host: 'localhost',

user: 'root',

password: 'password',

database: 'GraduateManagement'

});

app.get('/students', (req, res) => {

connection.query('SELECT * FROM Students', (err, results) => {

if (err) throw err;

res.send(results);

});

});

app.listen(3000, () => console.log('Server running on port 3000'));

]]>

import React from 'react';

import axios from 'axios';

class StudentList extends React.Component {

state = {

students: []

};

componentDidMount() {

axios.get('http://localhost:3000/students')

.then(res => {

this.setState({ students: res.data });

})

.catch(err => console.error(err));

}

render() {

return (

);

}

}

]]>