<?python
# 导入必要的库
import sqlite3
from docx import Document
# 连接到SQLite数据库
conn = sqlite3.connect('university_assets.db')
cursor = conn.cursor()
# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS assets (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
category TEXT NOT NULL,
quantity INTEGER NOT NULL)''')
def add_asset(name, category, quantity):
cursor.execute("INSERT INTO assets (name, category, quantity) VALUES (?, ?, ?)", (name, category, quantity))
conn.commit()
def export_to_doc():
# 创建一个新的Word文档
doc = Document()
# 查询所有资产
cursor.execute("SELECT * FROM assets")
assets = cursor.fetchall()
# 添加表格
table = doc.add_table(rows=1, cols=4)
table.style = 'Table Grid'
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'ID'
hdr_cells[1].text = 'Name'
hdr_cells[2].text = 'Category'
hdr_cells[3].text = 'Quantity'
for asset in assets:
row_cells = table.add_row().cells
row_cells[0].text = str(asset[0])
row_cells[1].text = asset[1]
row_cells[2].text = asset[2]
row_cells[3].text = str(asset[3])
# 保存文档
doc.save('assets.docx')
# 示例数据
add_asset('Laptop', 'Electronics', 20)
add_asset('Desk', 'Furniture', 50)
# 导出到Doc文件
export_to_doc()
?>