基于学工管理系统的徐州高校信息化实践

# 学生表示例

CREATE TABLE students (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

gender ENUM('M', 'F') DEFAULT 'M',

major VARCHAR(100),

phone VARCHAR(15)

);

# 教师表示例

CREATE TABLE teachers (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

department VARCHAR(100),

email VARCHAR(100) UNIQUE

);

# 课程表示例

CREATE TABLE courses (

id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(100) NOT NULL,

teacher_id INT,

FOREIGN KEY (teacher_id) REFERENCES teachers(id)

);

研究生论文管理系统

]]>

from flask import Flask, jsonify, request

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:password@localhost/xz_university'

db = SQLAlchemy(app)

class Student(db.Model):

__tablename__ = 'students'

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

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

# 其他字段省略...

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

def add_student():

data = request.get_json()

new_student = Student(name=data['name'], ...)

db.session.add(new_student)

db.session.commit()

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

]]>