from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

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

db = SQLAlchemy(app)

class Student(db.Model):

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

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

age = db.Column(db.Integer, nullable=False)

major = db.Column(db.String(80), nullable=False)

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

def add_student():

data = request.get_json()

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

db.session.add(new_student)

db.session.commit()

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

高職院校排課軟件源碼

if __name__ == '__main__':

db.create_all()

app.run(debug=True)

]]>