mysql odbc的补丁

#include <windows.h>
#include <sql.h>
#include <sqlext.h>
#include <stdio.h>

int main() {
    SQLHENV env;
    SQLHDBC dbc;
    SQLRETURN ret;

    // 分配环境句柄
    ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    if (!SQL_SUCCEEDED(ret)) {
        printf("Failed to allocate environment handle.\n");
        return 1;
    }

    // 设置ODBC版本
    SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);

    // 分配连接句柄
    ret = SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
    if (!SQL_SUCCEEDED(ret)) {
        printf("Failed to allocate connection handle.\n");
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // 连接到数据库
    ret = SQLConnect(dbc, (SQLCHAR*)"your_database", SQL_NTS, (SQLCHAR*)"your_username", SQL_NTS, (SQLCHAR*)"your_password", SQL_NTS);
    if (!SQL_SUCCEEDED(ret)) {
        printf("Failed to connect to database.\n");
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // 执行查询
    SQLHSTMT stmt;
    ret = SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);
    if (!SQL_SUCCEEDED(ret)) {
        printf("Failed to allocate statement handle.\n");
        SQLDisconnect(dbc);
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    ret = SQLExecDirect(stmt, (SQLCHAR*)"SELECT * FROM your_table", SQL_NTS);
    if (!SQL_SUCCEEDED(ret)) {
        printf("Failed to execute query.\n");
        SQLFreeHandle(SQL_HANDLE_STMT, stmt);
        SQLDisconnect(dbc);
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // 处理查询结果
    SQLCHAR col1[256], col2[256];
    while (SQLFetch(stmt) == SQL_SUCCESS) {
        SQLGetData(stmt, 1, SQL_C_CHAR, col1, sizeof(col1), NULL);
        SQLGetData(stmt, 2, SQL_C_CHAR, col2, sizeof(col2), NULL);
        printf("Col1: %s, Col2: %s\n", col1, col2);
    }

    // 清理资源
    SQLFreeHandle(SQL_HANDLE_STMT, stmt);
    SQLDisconnect(dbc);
    SQLFreeHandle(SQL_HANDLE_DBC, dbc);
    SQLFreeHandle(SQL_HANDLE_ENV, env);

    return 0;
}