基于学工管理系统在济南高校的应用与实现

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

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(120))

class Teacher(db.Model):

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

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

department = db.Column(db.String(120))

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

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

db.init_app(app)

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

def add_student():

data = request.get_json()

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

db.session.add(new_student)

db.session.commit()

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

]]>

@app.route('/student/', 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

})

]]>