vc查询数据库操作

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

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

    try {
        // 连接字符串
        _bstr_t strConn = "Provider=SQLOLEDB;Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password;";
        pConn->Open(strConn, "", "", adConnectUnspecified);

        // 执行查询
        _bstr_t strSQL = "SELECT * FROM your_table";
        pRs = pConn->Execute(strSQL, NULL, adCmdText);

        // 处理结果集
        while (!pRs->adoEOF) {
            for (long i = 0; i < pRs->Fields->Count; i++) {
                std::cout << pRs->Fields->GetItem(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;
}