from flask import Flask, request, jsonify

from sqlalchemy import create_engine, Column, Integer, String

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

app = Flask(__name__)

engine = create_engine('mysql+pymysql://username:password@localhost/nanning_school')

Base = declarative_base()

class Student(Base):

__tablename__ = 'students'

id = Column(Integer, primary_key=True)

name = Column(String(50))

campus_id = Column(Integer)

Session = sessionmaker(bind=engine)

数据管理系统

session = Session()

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

def add_student():

data = request.get_json()

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

session.add(new_student)

session.commit()

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

if __name__ == '__main__':

app.run(debug=True)

]]>