如何在整个应用程序中使用mysqlconnection

import mysql.connector
from mysql.connector import pooling

# 创建连接池
db_config = {
    "host": "localhost",
    "user": "your_user",
    "password": "your_password",
    "database": "your_database"
}

connection_pool = mysql.connector.pooling.MySQLConnectionPool(pool_name="mypool", pool_size=5, **db_config)

def get_data():
    try:
        # 从连接池获取连接
        connection = connection_pool.get_connection()
        cursor = connection.cursor(dictionary=True)
        
        # 执行查询
        cursor.execute("SELECT * FROM your_table")
        result = cursor.fetchall()
        
        return result
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()  # 连接会返回到连接池而不是关闭

# 在应用程序的其他部分调用 get_data 函数
data = get_data()
print(data)