构建研究生管理系统与手册：一个实际案例

CREATE DATABASE grad_student;

USE grad_student;

CREATE TABLE students (

id INT AUTO_INCREMENT PRIMARY KEY,

排课管理系统源码

name VARCHAR(100) NOT NULL,

major VARCHAR(100),

grade FLOAT

);

CREATE TABLE projects (

id INT AUTO_INCREMENT PRIMARY KEY,

student_id INT,

title VARCHAR(255),

status ENUM('pending', 'in_progress', 'completed') DEFAULT 'pending',

FOREIGN KEY (student_id) REFERENCES students(id)

);

from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/grad_student'

db = SQLAlchemy(app)

class Student(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(100), nullable=False)

major = db.Column(db.String(100))

grade = db.Column(db.Float)

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

def create_student():

data = request.get_json()

new_student = Student(name=data['name'], major=data['major'], grade=data['grade'])

db.session.add(new_student)

db.session.commit()

return jsonify({'message': 'Student created'}), 201

if __name__ == '__main__':

app.run(debug=True)