import mysql.connector

# 连接数据库

db = mysql.connector.connect(

host="localhost",

user="root",

password="yourpassword",

database="student_management"

)

cursor = db.cursor()

# 创建学生信息表

cursor.execute("""

CREATE TABLE IF NOT EXISTS student_info (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100),

major VARCHAR(50),

class_name VARCHAR(20)

)

""")

]]>

# 插入学生信息

sql = "INSERT INTO student_info (name, major, class_name) VALUES (%s, %s, %s)"

val = [

高校排课系统

("张三", "计算机科学", "软件1班"),

("李四", "土木工程", "建筑2班")

]

cursor.executemany(sql, val)

db.commit()

print(cursor.rowcount, "record inserted.")

]]>

def search_student(name):

cursor.execute("SELECT * FROM student_info WHERE name=%s", (name,))

result = cursor.fetchall()

for row in result:

print(f"ID: {row[0]}, Name: {row[1]}, Major: {row[2]}, Class: {row[3]}")

# 测试查询函数

search_student("张三")

]]>