统一消息系统

import sqlite3

# 连接到SQLite数据库

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

cursor = conn.cursor()

# 创建用户表

cursor.execute('''CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)''')

# 批量插入数据

cursor.executemany('INSERT INTO users VALUES (?, ?, ?)', [(1, 'Alice', 'alice@example.com'), (2, 'Bob', 'bob@example.com')])

# 提交事务

conn.commit()

# 关闭连接

conn.close()

import smtplib

from email.mime.text import MIMEText

import sqlite3

# 连接到数据库

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

cursor = conn.cursor()

# 查询所有用户的邮箱

cursor.execute("SELECT email FROM users")

emails = cursor.fetchall()

# 发送邮件

综合服务门户

server = smtplib.SMTP('smtp.example.com', 587)

server.starttls()

server.login("your-email@example.com", "your-password")

for email in emails:

msg = MIMEText("这是一封测试邮件。")

msg['Subject'] = "校园通知"

msg['From'] = "your-email@example.com"

msg['To'] = email[0]

server.send_message(msg)

# 关闭服务器连接

server.quit()

# 关闭数据库连接

conn.close()