我们提供学生信息管理系统招投标所需全套资料,包括学工系统介绍PPT、学生管理系统产品解决方案、
学生管理系统产品技术参数,以及对应的标书参考文件,详请联系客服。
import mysql.connector
# 连接到数据库
db = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="school_system"
)
cursor = db.cursor()
# 创建students表
cursor.execute("""
CREATE TABLE IF NOT EXISTS students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
age INT,
major VARCHAR(100)
)
""")
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/add_student', methods=['POST'])
def add_student():
data = request.get_json()
cursor.execute("INSERT INTO students (name, age, major) VALUES (%s, %s, %s)",
(data['name'], data['age'], data['major']))
db.commit()
return jsonify({"message": "Student added successfully!"})
if __name__ == '__main__':
app.run(host='0.0.0.0', port=5000)
]]>