python mysql捕获异常处理

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='testdb',
                                         user='root',
                                         password='password')
except Error as e:
    print(f"Error while connecting to MySQL: {e}")
else:
    print("Successfully connected to MySQL")

try:
    cursor = connection.cursor()
    query = "SELECT * FROM non_existent_table"  # 错误的表名
    cursor.execute(query)
except Error as e:
    print(f"SQL Error: {e}")

try:
    insert_query = "INSERT INTO users (username, email) VALUES (%s, %s)"
    data = ('john_doe', 'john@example.com')
    cursor.execute(insert_query, data)
    connection.commit()
except mysql.connector.errors.IntegrityError as e:
    print(f"Data integrity error: {e}")
    connection.rollback()