ADO wrapper

2007-03-30 01:14:22 511 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

嵌入式开发必备：aarch64-linux-gnu-gcc交叉编译工具链保姆级安装指南（含常见错误解决）本文详细介绍了aarch64-linux-gnu-gcc交叉编译工具链的安装与配置方法，涵盖从系统软件源安装到Linaro二进制包部署的全流程。针对嵌入式开发中常见的依赖错误、版本冲突等问题提供实用解决方案，并分享性能优化技巧与项目集成经验，帮助开发者高效完成ARM64设备的跨平台开发。阅读详情

/********************************************************************
Created: 2007/03/30
Created: 30:3:2007 13:06
Author: 刘胤

Purpose: wrapper for _Recordset
*********************************************************************/

#ifndef AdoRecordSet_H
#define AdoRecordSet_H

#include <AfxDisp.h>
#include <icrsint.h>

#pragma warning(disable:4146)
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF", "adoEOF"), rename("BOF", "adoBOF")
#pragma warning(default:4146)

namespace AdoUtility
{
class CAdoConnection;

class CAdoRecordSet
{
public:
CAdoRecordSet(BOOL bInit = TRUE);
~CAdoRecordSet();

void Attach(_Recordset *pRecordset);
_Recordset * Detach();

BOOL SetIndex(const CString &strIndex) const;
BOOL GetIndex(CString &strIndex) const;

BOOL Resync(AffectEnum AffectRecords, ResyncEnum ResyncValues) const;

BOOL GetDataMember(CString &strDataMember) const;
BOOL SetDataMember(const CString &strDataMember) const;

BOOL SetStayInSync(BOOL bStayInSync) const;
BOOL GetStayInSync(BOOL &bStayInSync) const;

BOOL GetActiveCommand(IDispatch **ppCmd) const;

BOOL Find(const CString &strFind, long nSkipRecords, SearchDirectionEnum nSearchDirection) const;

BOOL GetMarshalOptions(MarshalOptionsEnum &nMarshalOptions) const;
BOOL SetMarshalOptions(MarshalOptionsEnum nMarshalOptions) const;

BOOL GetSupports(CursorOptionEnum CursorOptions, VARIANT_BOOL &bSupports) const;

BOOL UpdateBatch(AffectEnum AffectRecords) const;
BOOL CancelBatch(AffectEnum AffectRecords) const;

CAdoRecordSet * Clone(LockTypeEnum nLockType) const;
CAdoRecordSet * xClone() const;

BOOL GetPageSize(long &nPageSize) const;
BOOL SetPageSize(long nPageSize) const;

BOOL GetSort(CString &strSort) const;
BOOL SetSort(const CString &strSort) const;

BOOL GetPageCount(long &nPageCount) const;

BOOL xResync(AffectEnum AffectRecords) const;

BOOL Requery(long nOptions) const;

BOOL GetAbsolutePage(PositionEnum &nPosition) const;
BOOL SetAbsolutePage(PositionEnum nPosition) const;

BOOL SetSource(const CString &strSource) const;
BOOL GetSource(CString &strSource) const;

BOOL GetLockType(LockTypeEnum &nLockType) const;
BOOL SetLockType(LockTypeEnum nLockType) const;

BOOL GetCacheSize(long &nCacheSize) const;
BOOL SetCacheSize(long nCacheSize) const;

BOOL GetBookmark(BookmarkEnum &bookmark) const;
BOOL SetBookmark(BookmarkEnum bookmark = adBookmarkFirst) const;

BOOL SetAbsolutePosition(PositionEnum nPosition) const;
BOOL GetAbsolutePosition(PositionEnum &nPosition) const;

BOOL GetCursorLocation(CursorLocationEnum &nCursorLocation) const;
BOOL SetCursorLocation(CursorLocationEnum nCursorLocation = adUseClient) const;

BOOL GetCursorType(CursorTypeEnum &nCursorType) const;
BOOL SetCursorType(CursorTypeEnum nCursorType = adOpenStatic) const;

BOOL GetState(long &nState) const;
BOOL GetStatus(long &nStatus) const;

BOOL GetFieldAttributes(long nIndex, long &nAttributes) const;
BOOL GetFieldAttributes(LPCTSTR pszFieldName, long &nAttributes) const;

BOOL GetFieldType(long nIndex, DataTypeEnum &nDataType) const;
BOOL GetFieldType(LPCTSTR pszFieldName, DataTypeEnum &nDataType) const;

CAdoConnection * GetConnection() const;
BOOL SetAdoConnection(CAdoConnection * const pConnection) const;

BOOL GetEditMode(EditModeEnum &nEditMode) const;

BOOL Open(const CString &strSQL, long nOption = adCmdText, CursorTypeEnum nCursorType = adOpenStatic, LockTypeEnum nLockType = adLockOptimistic) const;
BOOL Cancel() const;
BOOL Close() const;

BOOL IsOpen() const;
BOOL IsBOF(BOOL &bBOF) const;
BOOL IsEOF(BOOL &bEOF) const;

BOOL GetRecordCount(long &nRecordCount) const;
BOOL GetFieldsCount(long &nFieldsCount) const;

BOOL GetMaxRecordCount(long &nMaxRecordCount) const;
BOOL SetMaxRecordCount(long nMaxRecordCount) const;

BOOL MoveFirst() const;
BOOL MoveNext() const;
BOOL MovePrevious() const;
BOOL MoveLast() const;
BOOL Move(long nRecords, const CComVariant &varStartPos = CComVariant((long) adBookmarkFirst)) const;

BOOL GetFieldName(long nIndex, CString &strFieldName) const;

public:
BOOL AddNew() const;
BOOL Update() const;
BOOL CancelUpdate() const;
BOOL Delete(AffectEnum AffectRecords = adAffectCurrent) const;

BOOL GetCollect(long nIndex, bool &bValue) const;
BOOL GetCollect(long nIndex, CString &strValue) const;
BOOL GetCollect(long nIndex, double &dValue) const;
BOOL GetCollect(long nIndex, float &dValue) const;
BOOL GetCollect(long nIndex, long &nValue) const;
BOOL GetCollect(long nIndex, DWORD &dwValue) const;
BOOL GetCollect(long nIndex, int &nValue) const;
BOOL GetCollect(long nIndex, short &nValue) const;
BOOL GetCollect(long nIndex, BYTE &nValue) const;
BOOL GetCollect(long nIndex, COleDateTime &oleValue) const;
BOOL GetCollect(long nIndex, COleCurrency &oleValue) const;

BOOL GetCollect(LPCSTR pszFieldName, bool &bValue) const;
BOOL GetCollect(LPCSTR pszFieldName, CString &strValue) const;
BOOL GetCollect(LPCSTR pszFieldName, double &dValue) const;
BOOL GetCollect(LPCSTR pszFieldName, float &dValue) const;
BOOL GetCollect(LPCSTR pszFieldName, long &nValue) const;
BOOL GetCollect(LPCSTR pszFieldName, DWORD &dwValue) const;
BOOL GetCollect(LPCSTR pszFieldName, int &nValue) const;
BOOL GetCollect(LPCSTR pszFieldName, short &nValue) const;
BOOL GetCollect(LPCSTR pszFieldName, BYTE &nValue) const;
BOOL GetCollect(LPCSTR pszFieldName, COleDateTime &value) const;
BOOL GetCollect(LPCSTR pszFieldName, COleCurrency &value) const;

public:
BOOL PutCollect(long nIndex, LPCTSTR pszValue) const;
BOOL PutCollect(long nIndex, const double &dValue) const;
BOOL PutCollect(long nIndex, const float &dValue) const;
BOOL PutCollect(long nIndex, long nValue) const;
BOOL PutCollect(long nIndex, DWORD nValue) const;
BOOL PutCollect(long nIndex, int nValue) const;
BOOL PutCollect(long nIndex, short nValue) const;
BOOL PutCollect(long nIndex, BYTE nValue) const;
BOOL PutCollect(long nIndex, bool bValue) const;
BOOL PutCollect(long nIndex, const COleDateTime &oleValue) const;
BOOL PutCollect(long nIndex, const COleCurrency &oleValue) const;

BOOL PutCollect(LPCTSTR pszFieldName, LPCTSTR pszValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, const double &dValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, const float &dValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, long nValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, DWORD nValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, int nValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, short nValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, BYTE nValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, bool bValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, const COleDateTime &oleValue) const;
BOOL PutCollect(LPCTSTR pszFieldName, const COleCurrency &oleValue) const;

...全文

如何用Megatron-LM搭建多卡集群？手把手教你配置分布式训练环境本文提供了一份详细的Megatron-LM多卡集群搭建实战指南。从硬件兼容性检查、软件栈版本对齐，到分布式并行策略（数据并行、张量并行、流水线并行）的配置与多节点启动脚本编写，手把手教你配置稳定高效的分布式训练环境，并分享了关键的排错与性能调优经验。阅读详情

LiuYinChina

数据库 4,017 成员 39,805 内容

+ 关注 + 加入社区

切换为时间正序

maplewang2011 2012-07-30

打赏
举报

AdoConnection 代码没有呢。

meiZiNick 2008-05-01

打赏
举报

以后需再关注，现在先帮你顶一下

leechiyang 2008-03-31

打赏
举报

codeproject上有2个封装ado的代码，一般的功能还能满足。

LiuYinChina 2007-03-30

打赏
举报

CAdoConnection * CAdoRecordSet::GetConnection() const
{
return NULL;
}

BOOL CAdoRecordSet::SetAdoConnection(CAdoConnection * const pAdoConnection) const
{
Close();

CComPtr<_Connection> pConnection;
if (!pAdoConnection->GetConnection(&pConnection)) {
return FALSE;
}

return SUCCEEDED(m_pRecordset->put_ActiveConnection(CComVariant(pConnection)));
}

BOOL CAdoRecordSet::GetEditMode(EditModeEnum &nEditMode) const
{
nEditMode = adEditNone;
if (!IsOpen()) {
return FALSE;
}

return SUCCEEDED(m_pRecordset->get_EditMode(&nEditMode));
}

BOOL CAdoRecordSet::Open(const CString &strSQL, long nOption, CursorTypeEnum nCursorType, LockTypeEnum nLockType) const
{
if (strSQL.IsEmpty()) {
return FALSE;
}

Close();

CComVariant varAdoConnection;
if (FAILED(m_pRecordset->get_ActiveConnection(&varAdoConnection))) {
return FALSE;
}

return SUCCEEDED(m_pRecordset->raw_Open(CComVariant(strSQL), varAdoConnection, nCursorType, nLockType, nOption));
}

BOOL CAdoRecordSet::Close() const
{
if (!IsOpen()) {
return TRUE;
}

return SUCCEEDED(m_pRecordset->raw_Close());
}

BOOL CAdoRecordSet::IsEOF(BOOL &bEOF) const
{
bEOF = FALSE;
if (!IsOpen()) {
return FALSE;
}

VARIANT_BOOL vbEOF = VARIANT_FALSE;
HRESULT hResult = m_pRecordset->get_adoEOF(&vbEOF);
bEOF = (vbEOF == VARIANT_TRUE);
return SUCCEEDED(hResult);
}

BOOL CAdoRecordSet::IsBOF(BOOL &bBOF) const
{
bBOF = FALSE;
if (!IsOpen()) {
return FALSE;
}

VARIANT_BOOL vbBOF = VARIANT_FALSE;
HRESULT hResult = m_pRecordset->get_adoBOF(&vbBOF);
bBOF = (vbBOF == VARIANT_TRUE);
return SUCCEEDED(hResult);
}

BOOL CAdoRecordSet::Cancel() const
{
if (!IsOpen()) {
return FALSE;
}

return SUCCEEDED(m_pRecordset->raw_Cancel());
}

BOOL CAdoRecordSet::GetRecordCount(long &nRecordCount) const
{
nRecordCount = 0L;
if (!IsOpen()) {
return FALSE;
}

if (FAILED(m_pRecordset->get_RecordCount(&nRecordCount)))
return FALSE;

if (nRecordCount >= 0L) {
return TRUE;
}

nRecordCount = 0L;
PositionEnum nAbsolutePosition = adPosUnknown;
if (!GetAbsolutePosition(nAbsolutePosition))
return FALSE;

if (!MoveFirst())
return FALSE;

while (!m_pRecordset->adoEOF) {
nRecordCount++;
m_pRecordset->raw_MoveNext();
}

SetAbsolutePosition(nAbsolutePosition);
return TRUE;
}

BOOL CAdoRecordSet::GetFieldsCount(long &nFieldsCount) const
{
nFieldsCount = 0L;
if (!IsOpen()) {
return FALSE;
}

CComPtr<Fields> pFields;
if (!GetFields(&pFields)) {
return FALSE;
}

return SUCCEEDED(pFields->get_Count(&nFieldsCount));
}

BOOL CAdoRecordSet::GetAbsolutePosition(PositionEnum &nPosition) const
{
nPosition = adPosUnknown;
if (!IsOpen()) {
return FALSE;
}

return SUCCEEDED(m_pRecordset->get_AbsolutePosition(&nPosition));
}

BOOL CAdoRecordSet::MoveFirst() const
{
if (!IsOpen()) {
return FALSE;
}

HRESULT hResult = E_FAIL;
try {
hResult = m_pRecordset->raw_MoveFirst();
}
catch (...) {
// ...
}

return SUCCEEDED(hResult);
}

BOOL CAdoRecordSet::MoveNext() const
{
if (!IsOpen()) {
return FALSE;
}

HRESULT hResult = E_FAIL;
try {
hResult = m_pRecordset->raw_MoveNext();
}
catch (...) {
// ...
}

return SUCCEEDED(hResult);
}

BOOL CAdoRecordSet::GetFieldName(long nIndex, CString &strFieldName) const
{
strFieldName.Empty();
if (!IsOpen()) {
return FALSE;
}

CComPtr<Fields> pFields;
if (!GetFields(&pFields)) {
return FALSE;
}

CComPtr<Field> pField;
if (!GetField(nIndex, &pField)) {
return FALSE;
}

CComBSTR bstrName;
HRESULT hResult = pField->get_Name(&bstrName);
if (FAILED(hResult)) {
return FALSE;
}

strFieldName = bstrName;
return TRUE;
}

BOOL CAdoRecordSet::MovePrevious() const
{
if (!IsOpen()) {
return FALSE;
}

HRESULT hResult = E_FAIL;
try {
hResult = m_pRecordset->raw_MovePrevious();
}
catch (...) {
// ...
}

return SUCCEEDED(hResult);
}

BOOL CAdoRecordSet::MoveLast() const
{
if (!IsOpen()) {
return FALSE;
}

HRESULT hResult = E_FAIL;
try {
hResult = m_pRecordset->raw_MoveLast();
}
catch (...) {
// ...
}

return SUCCEEDED(hResult);
}

BOOL CAdoRecordSet::Move(long nRecords, const CComVariant &varStartPos) const
{
if (!IsOpen()) {
return FALSE;
}

HRESULT hResult = E_FAIL;
try {
hResult = m_pRecordset->raw_Move(nRecords, varStartPos);
}
catch (...) {
// ...
}

return SUCCEEDED(hResult);
}

LiuYinChina 2007-03-30

打赏
举报

LiuYinChina 2007-03-30

打赏
举报

public:
BOOL xSave(const CString &strFileName, PersistFormatEnum PersistFormat) const;
BOOL Save(LPCTSTR strFileName, PersistFormatEnum PersistFormat = adPersistXML) const;
BOOL Load(LPCTSTR strFileName) const;

BOOL AppendChunk(long nIndex, void *pData, unsigned long nBytes) const;
BOOL AppendChunk(LPCTSTR pszFieldName, void *pData, unsigned long nBytes) const;

BOOL GetChunk(Field *pField, void *pData, unsigned long &nBytes) const;
BOOL GetChunk(long nIndex, void *pData, unsigned long &nBytes) const;
BOOL GetChunk(LPCTSTR pszFieldName, void *pData, unsigned long &nBytes) const;

private:
void InitRecordset();

BOOL GetCollect(const CComVariant &varIndex, CComVariant &varValue) const;
BOOL PutCollect(const CComVariant &varIndex, const CComVariant &varValue) const;
BOOL AppendChunk(Field *pField, void *pData, unsigned long nBytes) const;

BOOL GetFieldAttributes(const CComVariant &varIndex, long &nAttributes) const;
BOOL GetFieldType(const CComVariant &varIndex, DataTypeEnum &nDataType) const;

BOOL GetFields(Fields **pFields) const;
BOOL GetField(long nIndex, Field **pField) const;
BOOL GetField(LPCTSTR pszFieldName, Field **pField) const;
BOOL GetField(const CComVariant &varIndex, Field **pField) const;

CComPtr<_Recordset> m_pRecordset;
};
}

#endif

ADO wrapper

相关推荐