vc读取mysql数据库连接

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

void ConnectToMySQL() {
    SQLHENV env;
    SQLHDBC dbc;
    SQLRETURN ret;

    // 分配环境句柄
    ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    if (ret != SQL_SUCCESS) {
        std::cerr << "Failed to allocate environment handle." << std::endl;
        return;
    }

    // 设置ODBC版本
    ret = SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
    if (ret != SQL_SUCCESS) {
        std::cerr << "Failed to set ODBC version." << std::endl;
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return;
    }

    // 分配连接句柄
    ret = SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
    if (ret != SQL_SUCCESS) {
        std::cerr << "Failed to allocate connection handle." << std::endl;
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return;
    }

    // 连接数据库
    ret = SQLConnect(dbc, (SQLCHAR*)"your_database", SQL_NTS, (SQLCHAR*)"your_username", SQL_NTS, (SQLCHAR*)"your_password", SQL_NTS);
    if (ret != SQL_SUCCESS) {
        std::cerr << "Failed to connect to database." << std::endl;
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return;
    }

    std::cout << "Connected to MySQL database successfully!" << std::endl;

    // 释放资源
    SQLDisconnect(dbc);
    SQLFreeHandle(SQL_HANDLE_DBC, dbc);
    SQLFreeHandle(SQL_HANDLE_ENV, env);
}

int main() {
    ConnectToMySQL();
    return 0;
}