如何检查Python中的MySQL连接是否已关闭？

import mysql.connector

# 创建连接
conn = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

# 检查连接是否已关闭
if not conn.is_connected():
    print("连接已关闭")
else:
    print("连接未关闭")

# 关闭连接
conn.close()

import mysql.connector

# 使用with语句创建连接
with mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
) as conn:
    # 在这里执行您的数据库操作
    pass

# 当退出with语句时，连接将自动关闭

import mysql.connector

# 创建连接
conn = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

try:
    # 在这里执行您的数据库操作
    pass
finally:
    # 关闭连接
    conn.close()