linux c数据库连接池

#include <stdio.h>
#include <stdlib.h>
#include <mysql.h>

#define MAX_POOL_SIZE 10

typedef struct {
    MYSQL *connections[MAX_POOL_SIZE];
    int current_size;
} ConnectionPool;

ConnectionPool* create_pool() {
    ConnectionPool *pool = (ConnectionPool*)malloc(sizeof(ConnectionPool));
    pool->current_size = 0;
    for (int i = 0; i < MAX_POOL_SIZE; i++) {
        pool->connections[i] = mysql_init(NULL);
        if (!mysql_real_connect(pool->connections[i], "host", "user", "password", "database", 0, NULL, 0)) {
            fprintf(stderr, "%s\n", mysql_error(pool->connections[i]));
            exit(1);
        }
        pool->current_size++;
    }
    return pool;
}

MYSQL* get_connection(ConnectionPool *pool) {
    if (pool->current_size > 0) {
        return pool->connections[--pool->current_size];
    } else {
        return NULL;
    }
}

void release_connection(ConnectionPool *pool, MYSQL *conn) {
    if (pool->current_size < MAX_POOL_SIZE) {
        pool->connections[pool->current_size++] = conn;
    }
}

void destroy_pool(ConnectionPool *pool) {
    for (int i = 0; i < pool->current_size; i++) {
        mysql_close(pool->connections[i]);
    }
    free(pool);
}

int main() {
    ConnectionPool *pool = create_pool();
    MYSQL *conn = get_connection(pool);
    if (conn) {
        // 使用连接进行数据库操作
        release_connection(pool, conn);
    }
    destroy_pool(pool);
    return 0;
}