simpleadoclass.cpp

采用VC++编写访问数据库非常麻烦

// SimpleAdoClass.cpp : 定义 DLL 应用程序的入口点。
//

#include "stdafx.h"
#include "SimpleAdoClass_def.h"
#include "MyAdoClass.h"

BOOL APIENTRY DllMain( HANDLE hModule, 
                       DWORD  ul_reason_for_call, 
                       LPVOID lpReserved
					 )
{
	switch (ul_reason_for_call)
	{
	case DLL_PROCESS_ATTACH:
	case DLL_THREAD_ATTACH:
	case DLL_THREAD_DETACH:
	case DLL_PROCESS_DETACH:
		break;
	}
    return TRUE;
}


CSimpleAdoClass::CSimpleAdoClass()
{
	pMyAdoClass = new CMyAdoClass();
}

CSimpleAdoClass::~CSimpleAdoClass()
{
	delete pMyAdoClass;
}


// CSimpleAdoClass 成员函数

bool CSimpleAdoClass::ExecuteCommand(VARIANT_BOOL bStoredProcedure, VARIANT_BOOL bChangeRec)
{
	return pMyAdoClass->ExecuteCommand(bStoredProcedure, bChangeRec);
}

bool CSimpleAdoClass::Close(void)
{
	return pMyAdoClass->Close();
}

bool CSimpleAdoClass::CloseRecordset(void)
{
	return pMyAdoClass->CloseRecordset();
}

bool CSimpleAdoClass::Delete(void)
{
	return pMyAdoClass->Delete();
}

//使用SQL语句修改记录，例如：
//建立表:ExecuteConnection("CREATE TABLE HotBikes (ID INTEGER, Model VarChar(25), Manufacturer VarChar(80))", VARIANT_FALSE);
//插入记录:insert into HotBikes (ID, Model, Manufacturer) values (?, ?, ?)";
//修改记录:UPDATE HotBikes SET TopSpeed=170 WHERE ID=1
bool CSimpleAdoClass::ExecuteConnection(BSTR query, VARIANT_BOOL bChangeRec)
{
	return pMyAdoClass->ExecuteConnection(query, bChangeRec);
}

bool CSimpleAdoClass::MoveFirst()
{
	return pMyAdoClass->MoveFirst();
}

short CSimpleAdoClass::get_BOF()
{
	return pMyAdoClass->get_BOF();
}

bool CSimpleAdoClass::get_CommandText(BSTR * newVal)
{
	return pMyAdoClass->get_CommandText(newVal);
}

short CSimpleAdoClass::get_Empty()
{
	return pMyAdoClass->get_Empty();
}

short CSimpleAdoClass::get_EOF()
{
	return pMyAdoClass->get_EOF();
}

bool CSimpleAdoClass::get_Field(int FieldIndex,VARIANT *FieldValue)
{
	return pMyAdoClass->get_Field(FieldIndex,FieldValue);
}

bool CSimpleAdoClass::get_FieldCount(long * newVal)
{
	return pMyAdoClass->get_FieldCount(newVal);
}

bool CSimpleAdoClass::MoveLast()
{
	return pMyAdoClass->MoveLast();
}

bool CSimpleAdoClass::MoveNext()
{
	return pMyAdoClass->MoveNext();
}

bool CSimpleAdoClass::OpenRecordset(VARIANT query,bool isBatchUpdate)
{
	return pMyAdoClass->OpenRecordset(query,isBatchUpdate);//获取记录;
}

bool CSimpleAdoClass::put_CommandText(BSTR newVal)
{
	return pMyAdoClass->put_CommandText(newVal);
}

bool CSimpleAdoClass::put_Field(int idx, VARIANT newVal)
{
	return pMyAdoClass->put_Field(idx, newVal);
}

bool CSimpleAdoClass::put_StoredProc(BSTR newVal)
{
	return pMyAdoClass->put_StoredProc(newVal);
}

bool CSimpleAdoClass::MovePrev()
{
	return pMyAdoClass->MovePrev();
}

bool CSimpleAdoClass::Requery()
{
	return pMyAdoClass->Requery();
}

bool CSimpleAdoClass::ADORelease()
{
	return pMyAdoClass->ADORelease();
}

bool CSimpleAdoClass::Open(const WCHAR* ConnectStr, const WCHAR* UserName, const WCHAR* Password)
{
	return pMyAdoClass->Open(ConnectStr, UserName, Password);
}

bool CSimpleAdoClass::GetFieldsName(long *pFieldsCount,LPWSTR** ppFieldsNameArray)
{
	return pMyAdoClass->GetFieldsName(pFieldsCount,ppFieldsNameArray);
}

bool CSimpleAdoClass::GetFieldsValue(long *pFieldsCount,VARIANT** ppFieldsValue)
{
	return pMyAdoClass->GetFieldsValue(pFieldsCount,ppFieldsValue);
}
// 按照需要设置指定列的值
bool CSimpleAdoClass::PutFieldsValue(DWORD FieldIndexCount, long *FieldIndexArray,VARIANT* FieldsValue)
{
	return pMyAdoClass->PutFieldsValue(FieldIndexCount, FieldIndexArray,FieldsValue);
}

bool CSimpleAdoClass::AddNewRecord(void)
{
	return pMyAdoClass->AddNewRecord();
}

bool CSimpleAdoClass::Update(bool isUpdateOrCancelUpdate)
{
	return pMyAdoClass->Update(isUpdateOrCancelUpdate);
}

bool CSimpleAdoClass::UpdateBatch(bool isUpdateOrCancelUpdate)
{
	return pMyAdoClass->UpdateBatch(isUpdateOrCancelUpdate);
}

bool CSimpleAdoClass::GetRecordCount(LONG *pRecordCount)
{
	return pMyAdoClass->GetRecordCount(pRecordCount);
}

bool CSimpleAdoClass::DatabaseIsOpen(void)
{
	return pMyAdoClass->DatabaseIsOpen();
}

bool CSimpleAdoClass::RecordsetIsOpen(void)
{
	return pMyAdoClass->RecordsetIsOpen();
}

bool CSimpleAdoClass::GetRecordsetAllFieldsValue(long *pRowCount,long *pFieldCount,VARIANT** ppFieldsValue)
{
	return pMyAdoClass->GetRecordsetAllFieldsValue(pRowCount,pFieldCount,ppFieldsValue);
}