以下是一个可重复利用的使用 Python 通过连接池连接 MySQL 数据库的代码示例，这里使用 `mysql-connector-python` 库： ```python import mysql.connector from mysql.connector import pooling # 创建连接池 dbconfig = { "host": "localhost", "user": "your_username", "password": "your_password", "database": "your_database" } connection_pool = pooling.MySQLConnectionPool( pool_name="mypool", pool_size=5, **dbconfig ) # 从连接池获取连接 def get_connection(): return connection_pool.get_connection() # 示例：执行查询操作 def execute_query(query): conn = get_connection() cursor = conn.cursor() try: cursor.execute(query) result = cursor.fetchall() return result except Exception as e: print(f"Error: {e}") finally: cursor.close() conn.close() # 示例：执行插入操作 def execute_insert(query, values): conn = get_connection() cursor = conn.cursor() try: cursor.execute(query, values) conn.commit() print("Insert successful") except Exception as e: print(f"Error: {e}") conn.rollback() finally: cursor.close() conn.close() # 使用示例 if __name__ == "__main__": # 查询示例 select_query = "SELECT * FROM your_table" results = execute_query(select_query) for row in results: print(row) # 插入示例 insert_query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)" insert_values = ("value1", "value2") execute_insert(insert_query, insert_values) ```