构建基于招生系统的培训机构管理系统

import mysql.connector

# 连接数据库

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="training_center"

)

cursor = conn.cursor()

# 创建学生表

cursor.execute("""

CREATE TABLE IF NOT EXISTS students (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100),

phone VARCHAR(15),

email VARCHAR(100)

);

""")

# 插入学生信息

cursor.execute("""

INSERT INTO students (name, phone, email) VALUES (%s, %s, %s);

""", ("Alice Wang", "1234567890", "alice@example.com"))

conn.commit()

cursor.execute("SELECT * FROM students;")

rows = cursor.fetchall()

for row in rows:

print(row)

cursor.execute("SELECT * FROM students WHERE phone LIKE '123%';")

rows = cursor.fetchall()

for row in rows:

print(row)