安全存储双11活动

from cryptography.fernet import Fernet
import sqlite3

# 生成密钥
key = Fernet.generate_key()
cipher_suite = Fernet(key)

# 连接数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)''')

# 插入加密数据
name = "John Doe"
email = "johndoe@example.com"
encrypted_name = cipher_suite.encrypt(name.encode())
encrypted_email = cipher_suite.encrypt(email.encode())
cursor.execute("INSERT INTO users (name, email) VALUES (?, ?)", (encrypted_name, encrypted_email))

# 查询并解密数据
cursor.execute("SELECT * FROM users")
for row in cursor.fetchall():
    decrypted_name = cipher_suite.decrypt(row[1]).decode()
    decrypted_email = cipher_suite.decrypt(row[2]).decode()
    print(f"ID: {row[0]}, Name: {decrypted_name}, Email: {decrypted_email}")

conn.commit()
conn.close()