基于Python实现校友会管理系统的开发与实践

import sqlite3

# 连接到SQLite数据库（如果不存在，则会自动创建）

conn = sqlite3.connect('alumni.db')

cursor = conn.cursor()

# 创建校友信息表

cursor.execute('''

CREATE TABLE IF NOT EXISTS alumni (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

email TEXT UNIQUE,

graduation_year INTEGER

)

''')

print("数据库和表已成功创建！")

# 插入测试数据

cursor.execute('INSERT INTO alumni (name, email, graduation_year) VALUES (?, ?, ?)',

('张三', 'zhangsan@example.com', 2010))

cursor.execute('INSERT INTO alumni (name, email, graduation_year) VALUES (?, ?, ?)',

('李四', 'lisi@example.com', 2015))

conn.commit()

# 查询所有校友信息

cursor.execute('SELECT * FROM alumni')

rows = cursor.fetchall()

for row in rows:

print(row)

def main_menu():

print("\n校友会管理系统")

print("1. 查看校友列表")

print("2. 添加新校友")

print("3. 修改校友信息")

print("4. 删除校友")

print("5. 退出")

while True:

main_menu()

choice = input("请选择操作: ")

if choice == "1":

cursor.execute('SELECT * FROM alumni')

print(cursor.fetchall())

elif choice == "2":

name = input("请输入姓名: ")

email = input("请输入邮箱: ")

year = int(input("请输入毕业年份: "))

cursor.execute('INSERT INTO alumni (name, email, graduation_year) VALUES (?, ?, ?)',

(name, email, year))

conn.commit()

print("校友信息已添加！")

elif choice == "5":

print("感谢使用校友会管理系统！")

break