构建智慧校园平台的技术实践与对话

CREATE TABLE students (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

age INT,

gender ENUM('M', 'F'),

major VARCHAR(100)

);

]]>

import mysql.connector

conn = mysql.connector.connect(

host='localhost',

user='root',

password='yourpassword',

database='school'

)

cursor = conn.cursor()

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

val = ("Alice", 20, "F", "Computer Science")

cursor.execute(sql, val)

conn.commit()

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

]]>

def authenticate(username, password):

# 假设已连接到数据库conn

cursor = conn.cursor(dictionary=True)

cursor.execute("SELECT * FROM users WHERE username=%s AND password=%s", (username, password))

result = cursor.fetchone()

return True if result else False

]]>