校友管理系统中的用户注册功能设计与实现
import sqlite3
def register_user(name, email, graduation_year):
conn = sqlite3.connect('alumni.db')
cursor = conn.cursor()
# 检查邮箱是否已存在
cursor.execute("SELECT * FROM Alumni WHERE email = ?", (email,))
if cursor.fetchone():
print("邮箱已存在,请使用其他邮箱!")
return
# 插入新用户
cursor.execute("""
INSERT INTO Alumni (name, email, graduation_year)
VALUES (?, ?, ?)
""", (name, email, graduation_year))
conn.commit()
print("注册成功!")
conn.close()
# 示例调用
register_user("张三", "zhangsan@example.com", 2020)
]]>
本站知识库部分内容及素材来源于互联网,如有侵权,联系必删!