4,011
社区成员
发帖
与我相关
我的任务
分享
bool Test()
{
char szSql[64] = "select * from TEST";
int iRows = 0;
char szError[512] = {0};
char szID[128] = {0};
char szName[128] = {0};
char szAddress[128] = {0};
try
{
_RecordsetPtr pRecord = m_conPtr->Execute((_bstr_t)szSql,(VARIANT*)&iRows,adCmdText);
strcpy(szID, (char*)(_bstr_t)pRecord->GetCollect("ID"));
strcpy(szName, (char*)(_bstr_t)pRecord->GetCollect("Name"));
strcpy(szAddress, (char*)(_bstr_t)pRecord->GetCollect("Address"));
pRecord->Close();
}
catch(_com_error e)
{
printf("%s\n", e.ErrorMessage())
exit(-1);
}
return true;
}
bool Test()
{
char szSql[64] = "select * from YF_TEST";
int iRows = 0;
char szError[512] = {0};
char szID[128] = {0};
char szName[128] = {0};
char szAddress[128] = {0};
_RecordsetPtr pRst(__uuidof(Recordset));
_CommandPtr pCmd(__uuidof(Command));
try
{
pCmd->put_ActiveConnection(_variant_t((IDispatch*)m_conPtr));
pCmd->CommandText=szSql;
pRst=pCmd->Execute(NULL,NULL,adCmdText);
strcpy(szID, (char*)(_bstr_t)pRst->GetCollect("ID"));
strcpy(szName, (char*)(_bstr_t)pRst->GetCollect("Name"));
strcpy(szAddress, (char*)(_bstr_t)pRst->GetCollect("Address"));
pRst->Close();
}
catch(_com_error e)
{
printf("%s\n", e.ErrorMessage());
exit(-1);
}
return true;
}
char szSql[64] = "select * from YF_TEST";
改为
char szSql[64] = "select * from YF_TEST where rownum<1000";//防止表YF_TEST万一有≥100万条记录
试试看。
bool Test()
{
char szSql[64] = "select * from YF_TEST";
int iRows = 0;
char szError[512] = {0};
char szID[128] = {0};
char szName[128] = {0};
char szAddress[128] = {0};
try
{
_RecordsetPtr pRecord = m_conPtr->Execute((_bstr_t)szSql,(VARIANT*)&iRows,adCmdText);
strncpy(szID, (char*)(_bstr_t)pRecord->GetCollect("ID"),127);szID[127]=0;
strncpy(szName, (char*)(_bstr_t)pRecord->GetCollect("Name"),127);szName[127]=0;
strncpy(szAddress, (char*)(_bstr_t)pRecord->GetCollect("Address"),127);szAddress[127]=0;
pRecord->Close();
}
catch(_com_error e)
{
printf("%s\n", e.ErrorMessage());
exit(-1);
}
return true;
}
char szID[128] = {0};
strncpy(szID, (char*)(_bstr_t)pRecord->GetCollect("ID"), 127);
char szName[128] = {0};
strncpy(szName, (char*)(_bstr_t)pRecord->GetCollect("Name"), 127);
char szAddress[128] = {0};
strncpy(szAddress, (char*)(_bstr_t)pRecord->GetCollect("Address"), 127);
string strID = (char*)(_bstr_t)pRecord->GetCollect("ID");
string strName = (char*)(_bstr_t)pRecord->GetCollect("Name");
string strAddress = (char*)(_bstr_t)pRecord->GetCollect("Address");
bool Test()
{
char szSql[64] = "select * from TEST";
int iRows = 0;
char szError[512] = {0};
char szID[128] = {0};
char szName[128] = {0};
char szAddress[128] = {0};
try
{
_RecordsetPtr pRecord = m_conPtr->Execute((_bstr_t)szSql,(VARIANT*)&iRows,adCmdText);
strncpy(szID, (char*)(_bstr_t)pRecord->GetCollect("ID"),127);szID[127]=0;
strncpy(szName, (char*)(_bstr_t)pRecord->GetCollect("Name"),127);szName[127]=0;
strncpy(szAddress, (char*)(_bstr_t)pRecord->GetCollect("Address"),127);szAddress[127]=0
pRecord->Close();
}
catch(_com_error e)
{
printf("%s\n", e.ErrorMessage())
exit(-1);
}
return true;
}