学生信息管理系统

CREATE TABLE student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

class VARCHAR(20),

phone VARCHAR(15),

score DECIMAL(5,2)

);

]]>

import pymysql

# 连接数据库

conn = pymysql.connect(host='localhost', user='root', password='password', database='school')

cursor = conn.cursor()

# 插入数据

sql = "INSERT INTO student (name, class, phone, score) VALUES (%s, %s, %s, %s)"

data = ('Alice', 'Class A', '12345678901', 95.5)

cursor.execute(sql, data)

一站式网上服务大厅

# 提交事务

conn.commit()

cursor.close()

conn.close()

]]>

import pymysql

conn = pymysql.connect(host='localhost', user='root', password='password', database='school')

cursor = conn.cursor()

sql = "SELECT * FROM student"

cursor.execute(sql)

results = cursor.fetchall()

for row in results:

print(row)

cursor.close()

conn.close()

]]>

from flask import Flask, request, render_template

app = Flask(__name__)

@app.route('/')

def index():

return render_template('index.html')

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

def submit():

name = request.form['name']

class_name = request.form['class']

phone = request.form['phone']

score = float(request.form['score'])

# 插入数据库逻辑...

if __name__ == '__main__':

app.run(debug=True)

]]>