知识资产管理系统

import sqlite3

def create_database():

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

cursor = conn.cursor()

# 创建档案表

cursor.execute('''

CREATE TABLE IF NOT EXISTS Archive (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

creation_date TEXT NOT NULL,

status TEXT DEFAULT 'active'

)

''')

conn.commit()

conn.close()

if __name__ == "__main__":

create_database()

]]>

def add_archive(name):

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

cursor = conn.cursor()

cursor.execute('INSERT INTO Archive (name, creation_date) VALUES (?, ?)',

(name, '2023-01-01'))

conn.commit()

conn.close()

if __name__ == "__main__":

add_archive('重要合同')

]]>

def list_archives():

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

cursor = conn.cursor()

cursor.execute('SELECT * FROM Archive')

archives = cursor.fetchall()

for archive in archives:

print(archive)

conn.close()

if __name__ == "__main__":

list_archives()

]]>