vc查询数据库

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

int main() {
    CoInitialize(NULL);
    _ConnectionPtr pConn(__uuidof(Connection));
    _RecordsetPtr pRs(__uuidof(Recordset));

    try {
        pConn->ConnectionString = "Provider=SQLOLEDB;Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password;";
        pConn->Open("", "", "", adConnectUnspecified);

        pRs = pConn->Execute("SELECT * FROM your_table", NULL, adCmdText);

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

        pRs->Close();
        pConn->Close();
    } catch (_com_error &e) {
        std::cerr << "Error: " << e.Description() << std::endl;
    }

    CoUninitialize();
    return 0;
}