一站式网上办事大厅

// 假设使用Python和Flask框架构建后台服务

from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

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

企业身份管理云服务商

db = SQLAlchemy(app)

class LeaveRequest(db.Model):

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

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

start_date = db.Column(db.Date, nullable=False)

end_date = db.Column(db.Date, nullable=False)

reason = db.Column(db.Text, nullable=False)

@app.route('/submit-leave', methods=['POST'])

def submit_leave():

data = request.get_json()

new_request = LeaveRequest(

student_name=data['studentName'],

start_date=data['startDate'],

end_date=data['endDate'],

reason=data['reason']

)

db.session.add(new_request)

db.session.commit()

return jsonify({"message": "Leave request submitted successfully!"}), 201

if __name__ == '__main__':

db.create_all()

app.run(debug=True)

]]>