4,012
社区成员
发帖
与我相关
我的任务
分享
COracle_messageApp theApp;
int i=0;
theApp.m_pConnection->Execute((_bstr_t)sql,NULL,adCmdText);
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open("select*from myhome;",theApp.m_pConnection.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
try
{
if(!m_pRecordset->BOF)
m_pRecordset->MoveFirst();
else
{
AfxMessageBox("表内数据为空");
return;
}
}
catch(_com_error e)//捕捉异常
{
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());
CString sError;
sError.Format("Source:%s \n Description : %s\n",(LPCSTR)bstrSource,(LPCSTR)bstrDescription);
AfxMessageBox(sError);
return;
}
while (!(m_pRecordset->BOF)) //如果记录集不空
{
m_list.InsertItem(i,(LPTSTR)(_bstr_t)(m_pRecordset->GetCollect("id")));
// m_list.SetItemText(i,1,(LPTSTR)(_bstr_t)(pRs->GetCollect(_T("name"))));
// m_list.SetItemText(i,2,(LPTSTR)(_bstr_t)(pRs->GetCollect(_T("job"))));
// m_list.SetItemText(i,3,(LPTSTR)(_bstr_t)(pRs->GetCollect(_T("score"))));
m_pRecordset->MoveNext();
i++;
}
}