共享文件数据库出错

import sqlite3

def create_connection(db_file):
    """ 创建数据库连接 """
    conn = None
    try:
        conn = sqlite3.connect(db_file)
        print(f"SQLite Database connected: {db_file}")
    except sqlite3.Error as e:
        print(e)
    return conn

def execute_query(conn, query):
    """ 执行SQL查询 """
    try:
        cursor = conn.cursor()
        cursor.execute(query)
        conn.commit()
        print("Query executed successfully")
    except sqlite3.Error as e:
        print(f"An error occurred: {e}")

def main():
    database = "example.db"

    # 创建数据库连接
    conn = create_connection(database)

    # 创建表
    create_table_query = """
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL,
        email TEXT NOT NULL
    );
    """
    execute_query(conn, create_table_query)

    # 插入数据
    insert_query = """
    INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');
    """
    execute_query(conn, insert_query)

    # 关闭连接
    if conn:
        conn.close()

if __name__ == '__main__':
    main()