import sqlite3
from docx import Document
# 连接数据库
conn = sqlite3.connect('graduates.db')
cursor = conn.cursor()
# 查询数据
cursor.execute("SELECT name, major, contact FROM graduates")
data = cursor.fetchall()
# 创建Word文档
doc = Document()
doc.add_heading('毕业生就业信息', level=1)
# 写入数据到Word文档
for row in data:
doc.add_paragraph(f'姓名: {row[0]}, 专业: {row[1]}, 联系方式: {row[2]}')
# 保存文档
doc.save('graduates_info.docx')