选排课系统

-- 创建学工系统数据库

CREATE DATABASE StudentManagement;

USE StudentManagement;

-- 创建学生表

CREATE TABLE Students (

student_id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

major VARCHAR(50),

grade INT,

phone_number VARCHAR(15)

);

]]>

// 学生信息添加接口 (Python Flask 示例)

from flask import Flask, request, jsonify

app = Flask(__name__)

@app.route('/add_student', methods=['POST'])

def add_student():

data = request.get_json()

name = data['name']

major = data['major']

grade = data['grade']

phone_number = data['phone_number']

# 连接数据库并插入数据

cursor.execute("INSERT INTO Students (name, major, grade, phone_number) VALUES (%s, %s, %s, %s)",

(name, major, grade, phone_number))

db.commit()

return jsonify({"message": "Student added successfully"}), 201

if __name__ == '__main__':

app.run(debug=True)

]]>

// React 学生信息录入组件

import React, { useState } from 'react';

function AddStudentForm() {

const [formData, setFormData] = useState({

name: '',

major: '',

grade: '',

phone_number: ''

});

const handleChange = (e) => {

setFormData({ ...formData, [e.target.name]: e.target.value });

};

const handleSubmit = async (e) => {

e.preventDefault();

await fetch('http://localhost:5000/add_student', {

method: 'POST',

headers: { 'Content-Type': 'application/json' },

body: JSON.stringify(formData)

});

alert('Student Added!');

};

return (

);

}

export default AddStudentForm;

]]>