基于‘迎新管理系统’开发在泉州高校的应用实践

import sqlite3

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

major TEXT NOT NULL,

room_number TEXT,

status TEXT DEFAULT '未报到'

);

''')

conn.commit()

conn.close()

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

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

def add_student():

data = request.get_json()

name = data['name']

major = data['major']

# 其他字段...

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

]]>

迎新管理系统

]]>