智慧校园系统与学生的互动：一个编程案例

def create_db():

conn = mysql.connector.connect(user='root', password='password', host='localhost')

cursor = conn.cursor()

cursor.execute("CREATE DATABASE IF NOT EXISTS campusdb")

cursor.execute("USE campusdb")

cursor.execute("""

CREATE TABLE IF NOT EXISTS students (

数据标准

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

age INT,

major VARCHAR(255)

)

""")

cursor.close()

conn.close()

create_db()

conn = mysql.connector.connect(user='root', password='password', database='campusdb')

cursor = conn.cursor()

query = "INSERT INTO students (name, age, major) VALUES (%s, %s, %s)"

values = (name, age, major)

cursor.execute(query, values)

conn.commit()

cursor.close()

conn.close()

add_student('Alice', 20, 'Computer Science')

conn = mysql.connector.connect(user='root', password='password', database='campusdb')

cursor = conn.cursor()

query = "SELECT * FROM students WHERE id=%s"

cursor.execute(query, (id,))

result = cursor.fetchone()

cursor.close()

conn.close()

return result

print(get_student(1))