一站式网上办事大厅

import sqlite3

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

cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS documents

(id INTEGER PRIMARY KEY, title TEXT, content TEXT, status TEXT)''')

conn.commit()

def add_document(title, content):

cursor.execute("INSERT INTO documents (title, content, status) VALUES (?, ?, ?)",

(title, content, "待提交"))

conn.commit()

def get_documents():

cursor.execute("SELECT * FROM documents")

return cursor.fetchall()