C++ 中使用数据库的问题

thoreau_zzy 2007-04-10 11:03:20

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

#include <iostream.h>
#include <iomanip> //for setw()
#include <stdlib.h>
#include <string>
using namespace std;

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

try
{
_ConnectionPtr pConn("ADODB.Connection");
_bstr_t strConnect= "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=schedule";
pConn->Open(strConnect,"","",adModeUnknown);
_RecordsetPtr pRs("ADODB.Recordset");
pRs->Open("Select *From PLAN", _variant_t(pConn,true), adOpenStatic, adLockOptimistic, adCmdText);

while( !pRs->EndOfFile )
{
cout<<"sg: "<<_bstr_t(pRs->GetCollect("sg"))<<"\t";
string b = _bstr_t(pRs->GetCollect("sg"));
printf("b :\t",_bstr_t(pRs->GetCollect("sg")));
pRs->MoveNext();

}
pRs->Close();
pConn->Close();

}

catch(_com_error &e)
{
cout<<e.Error ()<<endl;

}
return 0;
}

SG的表为字符串
DT3482D1
DQ3440E1
DQ3440E1
DQ3440E1
DQ3440E1
AP1056E1
AP1056E1
AP1056E1
AP1056E1
AP1056E1
AP1056E1
AP1055E5
AP1055E5
现在想把它存到变量b中，不知道怎么存，

...全文