使用_RecordsetPtr读表数据时切记要加上Try..catch捕捉错误

最新推荐文章于 2021-04-01 03:14:46 发布

我来自江南

最新推荐文章于 2021-04-01 03:14:46 发布

阅读量1.6k

点赞数

分类专栏： ms SQL VC++ 文章标签：数据库

本文链接：https://blog.csdn.net/abcdef8c/article/details/7064726

版权

VC++ 同时被 2 个专栏收录

45 篇文章 0 订阅

订阅专栏

ms SQL

5 篇文章 0 订阅

订阅专栏

HRESULT hr2=m_pRecorset.CreateInstance(__uuidof( Recordset ));
   if (SUCCEEDED(hr2))
   {
    AfxMessageBox("connect successfully!");

    try
    {
     m_pRecorset->Open("SELECT * from user.",m_pConnection.GetInterfacePtr()
      ,adOpenStatic,adLockOptimistic,adCmdText);

     //
     CString idStr,nameStr,wStr,hStr;
     _variant_t vRVariant;
     while (!m_pRecorset->EndOfFile)
     {
      vRVariant=m_pRecorset->Fields->GetItem((long)1)->GetValue();
      idStr=(char*)(_bstr_t)vRVariant;

vRVariant=m_pRecorset->Fields->GetItem((long)2)->GetValue();
nameStr=(char*)(_bstr_t)vRVariant;

vRVariant=m_pRecorset->Fields->GetItem((long)3)->GetValue();
wStr=(char*)(_bstr_t)vRVariant;

      vRVariant=m_pRecorset->Fields->GetItem((long)4)->GetValue();
      hStr=(char*)(_bstr_t)vRVariant;
     }
    }
    catch ( _com_error   &e)
    {
     _bstr_t   bstrSource   (e.Source());
     _bstr_t   bstrDescription   (e.Description());
     CString   strError;
     strError.Format( "无法连接test数据库。\r\n错误代码是：%08lx\r\n错误的原因是：%s\r\n错误源是：%s\r\n错误的描述是：%s\r\n ",   e.Error   (),   e.ErrorMessage   (),   (LPCTSTR)   bstrSource,   (LPCTSTR)   bstrDescription);
     MessageBox   (strError,   bstrDescription,MB_OK);
     return ;

    }
    catch (CFileException* e)
    {
     e->ReportError();
     e->Delete();
     return ;
    }
    catch (CException* e)
    {
     TRACE   (   "***   无法解决的错误   *** "   );
     return ;
    }
   }