修改mysql数据库连接的提交

import mysql.connector

try:
    # 连接到数据库
    conn = mysql.connector.connect(user='username', password='password',
                                   host='hostname', database='database_name')
    
    # 创建一个cursor对象
    cursor = conn.cursor()
    
    # 开始事务
    conn.start_transaction()
    
    try:
        # 执行SQL语句
        cursor.execute("UPDATE account SET balance = balance - 100 WHERE id = 1")
        cursor.execute("UPDATE account SET balance = balance + 100 WHERE id = 2")
        
        # 提交事务
        conn.commit()
        print("Transaction committed successfully.")
    except mysql.connector.Error as err:
        # 发生错误时回滚事务
        conn.rollback()
        print(f"Transaction failed, rolled back: {err}")
finally:
    # 关闭cursor和连接
    cursor.close()
    conn.close()