校友管理系统在医科大学中的应用与实现

CREATE TABLE alumni (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100) NOT NULL,

email VARCHAR(100),

graduation_year YEAR

);

import mysql.connector

# 连接到数据库

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="university"

)

cursor = conn.cursor()

# 插入数据

sql = "INSERT INTO alumni (name, email, graduation_year) VALUES (%s, %s, %s)"

流程化信息系统

val = ("张三", "zhangsan@example.com", 2020)

cursor.execute(sql, val)

conn.commit()

print(cursor.rowcount, "记录插入成功。")

cursor.close()

conn.close()

def search_alumni_by_year(year):

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="university"

)

cursor = conn.cursor(dictionary=True)

cursor.execute("SELECT * FROM alumni WHERE graduation_year = %s", (year,))

result = cursor.fetchall()

cursor.close()

conn.close()

return result