|
; SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return FALSE ;
}
BOOL CDBRecordSet::IsEof(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return TRUE ;
}
BOOL bEnd = TRUE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bEnd = (BOOL)(DBRECORDSETPtr->GetEndOfFile());
}
return bEnd ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return TRUE ;
}
//是否当前位置位于第一条记录前面
BOOL CDBRecordSet::IsBof(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return TRUE ;
}
BOOL bEnd = TRUE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bEnd = (BOOL)(DBRECORDSETPtr->GetBOF());
}
return bEnd ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return TRUE ;
}
//获取记录总数
int CDBRecordSet::GetRecordCount(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return -1 ;
}
int nRecordCount = -1 ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
nRecordCount = (int)DBRECORDSETPtr->GetRecordCount() ;
}
return nRecordCount ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return -1 ;
}
//移动到第一个记录
BOOL CDBRecordSet::MoveFirst(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return FALSE ;
}
BOOL bMovedOK = FALSE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bMovedOK = SUCCEEDED(DBRECORDSETPtr->MoveFirst()) ;
}
return bMovedOK ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return FALSE ;
}
//移到下一个记录
BOOL CDBRecordSet::MoveNext(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return FALSE ;
}
BOOL bMovedOK = FALSE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bMovedOK = SUCCEEDED(DBRECORDSETPtr->MoveNext()) ;
}
return bMovedOK ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return FALSE ;
}
//移动到最后一个记录
BOOL CDBRecordSet::MoveLast(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return FALSE ;
}
BOOL bMovedOK = FALSE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bMovedOK = SUCCEEDED(DBRECORDSETPtr->MoveLast()) ;
}
return bMovedOK ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return FALSE ;
}
//移动到前一个记录
BOOL CDBRecordSet::MovePrevious(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return FALSE ;
}
BOOL bMovedOK = FALSE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bMovedOK = SUCCEEDED(DBRECORDSETPtr->MovePrevious()) ;
}
return bMovedOK ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return FALSE ;
}
BOOL CDBRecordSet::Move(int nOffset)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return FALSE ;
}
BOOL bMovedOK = FALSE ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
bMovedOK = SUCCEEDED(DBRECORDSETPtr->Move((long)nOffset)) ;
}
return bMovedOK ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return FALSE ;
}
int CDBRecordSet::GetFieldCount(void)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return -1 ;
}
int nFieldCount = -1 ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
if(DBRECORDSETPtr->GetFields() != NULL)
{
//记录集中包含的字段数
nFieldCount = (int)DBRECORDSETPtr->GetFields()->GetCount() ;
}
}
return nFieldCount ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return -1 ;
}
int CDBRecordSet::GetFieldOrder(LPCTSTR szFieldName)
{
try
{
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return -1 ;
}
int nFieldOrder = -1 ;
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
if(DBRECORDSETPtr->GetFields() != NULL)
{
//记录集中包含的字段数
long nFieldCount = (int)DBRECORDSETPtr->GetFields()->GetCount() ;
for(long nIndex = 0L; nIndex < nFieldCount; nIndex++)
{
if(DBRECORDSETPtr->GetFields()->Item[nIndex]->Name == _bstr_t(szFieldName))
{
nFieldOrder = nIndex ;
break ; //找到该字段
}
}
}
}
return nFieldOrder ;
}
catch (_com_error &e)
{
SetErrorMessage((LPCTSTR)e.Description(),__FILE__,__LINE__) ;
}
catch (...)
{
SetErrorMessage(EXCEPTION_UNKNOWN,__FILE__,__LINE__) ;
}
return -1 ;
}
LPCTSTR CDBRecordSet::GetFieldName(int nFieldOrder)
{
try
{
m_strTempFieldName.Empty() ;
if (!m_pRecordSetImpl->isValid())
{
SetErrorMessage(RECORDSET_INVALIDHANDLE,__FILE__,__LINE__) ;
return (LPCTSTR)m_strTempFieldName;
}
if(DBRECORDSETPtr->GetState() == adStateOpen)
{
if(DBRECORDSETPtr->GetFields() != NULL)
{
//记录集中包含的字段数
long nFieldCount = (int)DBRECORDSETPtr->GetFields()->GetCount() ;
if(nFieldCount > 0)
{
if((nFieldOrder >= 0) & 上一页 [1] [2] [3] 下一页
[VB.NET程序]ADO 在informix的 Addnew [VB.NET程序]ADO 的测试
[VB.NET程序]ADO 揭密 1 [Web开发][ADO]如何修改ADO的线程模型
[Web开发]Delphi7下仿Ado.Net类的实现 [Web开发]通过COM使用ADO
[Web开发]ADO & ADO.NET中使用存储过程的两个共用的函数 [Web开发]Binding a DataGrid to an ADO Recordset
[Web开发]ADOCE for ADO Programmers [Web开发]Delphi多线程下的ADO编程
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
