学生信息管理系统

from flask import Flask, request, render_template

import sqlite3

app = Flask(__name__)

def get_db():

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

return conn

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

def add_student():

name = request.form['name']

student_id = request.form['student_id']

major = request.form['major']

class_name = request.form['class']

conn = get_db()

cursor = conn.cursor()

cursor.execute("INSERT INTO students (name, student_id, major, class) VALUES (?, ?, ?, ?)",

(name, student_id, major, class_name))

conn.commit()

conn.close()

return "学生信息添加成功！"

if __name__ == '__main__':

app.run(debug=True)