知识资产管理系统

import sqlite3

# 连接数据库（如果不存在则会自动创建）

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

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS archives (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

type TEXT,

date TEXT

)

''')

# 提交更改并关闭连接

conn.commit()

conn.close()

]]>

def add_archive(name, archive_type, date):

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

cursor = conn.cursor()

cursor.execute("INSERT INTO archives (name, type, date) VALUES (?, ?, ?)",

(name, archive_type, date))

conn.commit()

conn.close()

# 示例调用

add_archive("合同A", "商业", "2023-10-01")

]]>

def find_archive(name):

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

cursor = conn.cursor()

cursor.execute("SELECT * FROM archives WHERE name=?", (name,))

result = cursor.fetchone()

conn.close()

return result

# 示例调用

print(find_archive("合同A"))

]]>