python mysql异常处理

import mysql.connector
from mysql.connector import Error

try:
    # 连接MySQL数据库
    connection = mysql.connector.connect(host='localhost',
                                         database='testdb',
                                         user='root',
                                         password='password')

    if connection.is_connected():
        # 创建游标对象
        cursor = connection.cursor()

        # 执行SQL语句
        cursor.execute("SELECT * FROM users")

        # 获取查询结果
        records = cursor.fetchall()

        for row in records:
            print(row)

except Error as e:
    # 捕获并处理异常
    print("Error while connecting to MySQL", e)

finally:
    # 关闭游标和连接
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")