CREATE TABLE students (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

age INT,

grade VARCHAR(10),

enrollment_date DATE

);

]]>

from flask import Flask, jsonify, request

import mysql.connector

app = Flask(__name__)

# 连接数据库

db = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="sms"

)

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

def get_students():

cursor = db.cursor()

cursor.execute("SELECT * FROM students")

result = cursor.fetchall()

students = []

for row in result:

student = {

'id': row[0],

'name': row[1],

'age': row[2],

'grade': row[3],

'enrollment_date': str(row[4])

}

students.append(student)

return jsonify(students)

if __name__ == '__main__':

app.run(debug=True)

]]>

import pandas as pd

# 加载学生数据

df = pd.read_json('students.json')

# 数据清洗和特征提取

X = df[['age', 'grade']]

y = df['enrollment_date']

]]>