python重复连接mysql数据库

import pymysql

# 建立数据库连接
conn = pymysql.connect(
    host='数据库主机名',
    port=3306,
    user='数据库用户名',
    password='数据库密码',
    db='数据库名',
    charset='utf8mb4',
    cursorclass=pymysql.cursors.DictCursor
)

try:
    # 执行SQL语句
    with conn.cursor() as cursor:
        # 创建表
        create_table_sql = "CREATE TABLE IF NOT EXISTS `users` (`id` INT(11) AUTO_INCREMENT, `name` VARCHAR(255), PRIMARY KEY (`id`))"
        cursor.execute(create_table_sql)
        
        # 插入数据
        insert_data_sql = "INSERT INTO `users` (`name`) VALUES (%s)"
        cursor.executemany(insert_data_sql, [('Alice',), ('Bob',), ('Charlie',)])
        
    # 提交事务
    conn.commit()

    # 查询数据
    with conn.cursor() as cursor:
        select_data_sql = "SELECT * FROM `users`"
        cursor.execute(select_data_sql)
        result = cursor.fetchall()
        for row in result:
            print(row)
finally:
    # 关闭数据库连接
    conn.close()