构建高效招生管理系统与定制化解决方案

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Student(db.Model):

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

student_id = db.Column(db.String(20), unique=True, nullable=False)

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

phone = db.Column(db.String(15))

class Admin(db.Model):

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

username = db.Column(db.String(50), unique=True, nullable=False)

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

role = db.Column(db.String(20), nullable=False)

]]>

from flask import Flask, request, jsonify

from flask_jwt_extended import JWTManager, create_access_token, jwt_required

app = Flask(__name__)

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

app.config['JWT_SECRET_KEY'] = 'super-secret'

db.init_app(app)

jwt = JWTManager(app)

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

def login():

username = request.json.get('username')

password = request.json.get('password')

# 简单检查逻辑，实际需加密存储密码

if username == 'admin' and password == 'admin':

access_token = create_access_token(identity=username)

return jsonify(access_token=access_token), 200

else:

return jsonify({"msg": "Bad username or password"}), 401

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

@jwt_required()

def get_students():

students = Student.query.all()

return jsonify([student.to_dict() for student in students]), 200

]]>