测试环境——
系统: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 ;
} //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 ;
}