C++ sqlserver native client oledb 封装库

// Test.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include "..\MSSqlDBAccess\MSSqlDatabase.h" int _tmain(int argc, _TCHAR* argv[]) { CoInitialize( NULL ); CMSSqlDatabase db; HRESULT bRe = db.InitAndConnect( L".\\sqlexpress",L"TestDB",L"sa",L"sa" ); if( SUCCEEDED(bRe)) { IDBCreateCommand* pCmd = NULL; bRe = db.CreateCmd( pCmd ); CMsSqlTable tbl; LONG lAffected = 0;//the data is not valid.please turn to tbl.RowsCount() if( db.Execute( pCmd,tbl,L"SELECT * FROM tbl",lAffected ) ) { printf("Columns name:"); for( size_t i=0;i<tbl.Fileds().size();++i ) wprintf(L"%s (%d)",tbl.Fileds()[i]->Name().c_str(),tbl.Fileds()[i]->Type() ); printf("\n"); for( size_t i=0;i<tbl.RowsCount();++i ) { printf("\nrow %d:\n",i ); for( size_t j=0;j<tbl.Fileds().size();++j ) { switch( tbl.Fileds()[j]->Type() ) { case CTableBase::typeInt4: { int v = tbl.GetInt4( i,j); printf("int4:%d,",v ); } break; case CTableBase::typeBool: { bool b = tbl.GetBool( i,j); printf("bool:%s,",b ? "true" : "false" ); } break; case CTableBase::typeString: { const char* pcStr = tbl.GetString( i,j); printf("string:%s,",pcStr ); } break; case CTableBase::typeWString: { const wchar_t* pcStr = tbl.GetWString( i,j); wprintf(L"wstirng:%s,",pcStr ); } break; } } } } //create another connection to db. IDBCreateCommand* pCmd2 = NULL; bRe = db.CreateCmd( pCmd2 ); db.UnInit(); } CoUninitialize(); getchar(); return 0; }