commit()函数的问题

try:
    # 开始事务
    conn.begin()
    # 执行一系列数据库操作
    cursor.execute("UPDATE table SET column = value WHERE condition")
    cursor.execute("INSERT INTO table (column) VALUES (value)")
    # 提交事务
    conn.commit()
except Exception as e:
    # 发生异常时回滚事务
    conn.rollback()
    print(f"Transaction failed: {e}")
finally:
    cursor.close()
    conn.close()

import sqlite3

# 连接到数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

try:
    # 开始事务
    conn.execute("BEGIN")
    
    # 执行一系列数据库操作
    cursor.execute("INSERT INTO users (name, email) VALUES (?, ?)", ("Alice", "alice@example.com"))
    cursor.execute("UPDATE accounts SET balance = balance - 100 WHERE user_id = 1")
    
    # 提交事务
    conn.commit()
    print("Transaction committed successfully.")
except Exception as e:
    # 发生异常时回滚事务
    conn.rollback()
    print(f"Transaction failed: {e}")
finally:
    cursor.close()
    conn.close()