C++-数据库【1】-C++连接MSSQL数据库

测试环境——

系统：Win7 64bit

编译器：VC++ 2015

数据库：MSSQL 2008 R2

#include <Windows.h>
#include <stdio.h>

#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")

int main(int argc, char* argv[])
{

    HRESULT hr = S_OK;
    try
    {
        CoInitialize(NULL);
        // Define string variables.
        _bstr_t strCnn("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=??;Password=????????;Initial Catalog=????????;Data Source=???.???.???.???;");

        _RecordsetPtr pRstAuthors = NULL;

        // Call Create instance to instantiate the Record set
        hr = pRstAuthors.CreateInstance(__uuidof(Recordset));

        if (FAILED(hr))
        {
            printf("Failed creating record set instance\n");
            return 0;
        }

        //Open the Record set for getting records from Author table
        pRstAuthors->Open("SELECT [ClubId], [ClubName] FROM Club.Clubs", strCnn, adOpenStatic, adLockReadOnly, adCmdText);

        //Declare a variable of type _bstr_t
        int valField1;
        _bstr_t valField2;

        pRstAuthors->MoveFirst();

        //Loop through the Record set
        if (!pRstAuthors->EndOfFile)
        {
            while (!pRstAuthors->EndOfFile)
            {
                valField1 = pRstAuthors->Fields->GetItem("ClubId")->Value.intVal;
                valField2 = pRstAuthors->Fields->GetItem("ClubName")->Value;
                printf("%d \t %s\n", valField1, (LPCSTR)valField2);
                pRstAuthors->MoveNext();
            }
        }

    }
    catch (_com_error & ce)
    {
        printf("Error:" + ce.Description() + "\n");
    }

    CoUninitialize();
    return 0;
}