如何检查sqlite3的返回值

import sqlite3

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

# 执行SQL语句
cursor.execute("INSERT INTO table_name (column1, column2) VALUES (?, ?)", (value1, value2))

# 检查返回值
if cursor.rowcount > 0:
    print("插入成功")
else:
    print("插入失败")

# 关闭数据库连接
conn.close()

import sqlite3

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

    # 执行SQL语句
    cursor.execute("INSERT INTO table_name (column1, column2) VALUES (?, ?)", (value1, value2))

    # 提交事务
    conn.commit()
    print("插入成功")

except sqlite3.Error as e:
    print("插入失败:", e)

finally:
    # 关闭数据库连接
    conn.close()