一站式网上办事大厅

import sqlite3

conn = sqlite3.connect('school.db')

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS leave_application (

id INTEGER PRIMARY KEY AUTOINCREMENT,

student_name TEXT NOT NULL,

reason TEXT NOT NULL,

start_date DATE NOT NULL,

end_date DATE NOT NULL,

status TEXT DEFAULT 'pending'

)

''')

conn.commit()

conn.close()

from flask import Flask, request, render_template

app = Flask(__name__)

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

def apply_leave():

if request.method == 'POST':

student_name = request.form['student_name']

reason = request.form['reason']

start_date = request.form['start_date']

研究生自助服务系统

end_date = request.form['end_date']

# Save data to database (omitted for brevity)

return "Leave application submitted!"

return render_template('apply_leave.html')

if __name__ == '__main__':

app.run(debug=True)