vc用ado访问数据库

#include <iostream>
#include <windows.h>
#include <adoint.h>

int main() {
    // 初始化 ADO
    ::CoInitialize(NULL);

    try {
        // 创建 Connection 对象
        _ConnectionPtr pConn(__uuidof(Connection));

        // 设置连接字符串
        pConn->ConnectionString = "Provider=SQLOLEDB;Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;";

        // 打开连接
        pConn->Open("", "", "", adConnectUnspecified);

        // 创建 Command 对象
        _CommandPtr pCmd(__uuidof(Command));
        pCmd->ActiveConnection = pConn;
        pCmd->CommandText = "SELECT * FROM myTable";

        // 执行命令并获取结果集
        _RecordsetPtr pRs(__uuidof(Recordset));
        pRs = pCmd->Execute(NULL, NULL, adCmdText);

        // 处理结果集
        while (!pRs->adoEOF) {
            for (long i = 0; i < pRs->Fields->Count; i++) {
                std::cout << pRs->Fields->Item[i]->Value << "\t";
            }
            std::cout << std::endl;
            pRs->MoveNext();
        }

        // 关闭连接
        pConn->Close();
    } catch (_com_error &e) {
        std::cerr << "Error: " << e.Description() << std::endl;
    }

    // 清理 ADO
    ::CoUninitialize();

    return 0;
}