自己开发数据库

import sqlite3

class SimpleKVStore:
    def __init__(self, db_name):
        self.conn = sqlite3.connect(db_name)
        self.create_table()

    def create_table(self):
        cursor = self.conn.cursor()
        cursor.execute('''
            CREATE TABLE IF NOT EXISTS kvstore (
                key TEXT PRIMARY KEY,
                value TEXT
            )
        ''')
        self.conn.commit()

    def set(self, key, value):
        cursor = self.conn.cursor()
        cursor.execute('INSERT OR REPLACE INTO kvstore (key, value) VALUES (?, ?)', (key, value))
        self.conn.commit()

    def get(self, key):
        cursor = self.conn.cursor()
        cursor.execute('SELECT value FROM kvstore WHERE key = ?', (key,))
        result = cursor.fetchone()
        return result[0] if result else None

    def close(self):
        self.conn.close()

# 示例使用
store = SimpleKVStore('example.db')
store.set('name', 'Alice')
print(store.get('name'))  # 输出: Alice
store.close()