在try-except块中关闭游标后如何关闭连接？

import psycopg2

try:
    connection = psycopg2.connect(database="mydb", user="myuser", password="mypassword", host="localhost", port="5432")
    cursor = connection.cursor()
    # 执行数据库操作

except Exception as e:
    # 处理异常

finally:
    if cursor is not None:
        cursor.close()
    if connection is not None:
        connection.close()

import psycopg2

try:
    with psycopg2.connect(database="mydb", user="myuser", password="mypassword", host="localhost", port="5432") as connection:
        with connection.cursor() as cursor:
            # 执行数据库操作

except Exception as e:
    # 处理异常