锦中招生管理系统

# 导入必要的库

from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

# 创建Flask应用实例

走班排课系统源码

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///zhengzhou_recruitment.db'

db = SQLAlchemy(app)

# 定义数据库模型

class Student(db.Model):

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

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

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

score = db.Column(db.Float, nullable=False)

# 初始化数据库

with app.app_context():

db.create_all()

# API接口：添加学生信息

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

def add_student():

data = request.get_json()

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

db.session.add(new_student)

db.session.commit()

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

# API接口：查询学生信息

@app.route('/get_students/', methods=['GET'])

def get_student(student_id):

student = Student.query.get_or_404(student_id)

return jsonify({

"id": student.id,

"name": student.name,

"major": student.major,

"score": student.score

})

if __name__ == '__main__':

app.run(debug=True)