adoconn.cpp

很好的VC操作数据库的学习源码

// ADOConn.cpp: implementation of the ADOConn class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Testbank.h"
#include "ADOConn.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

ADOConn::ADOConn()
{

}

ADOConn::~ADOConn()
{

}

void ADOConn::OnInitDBConnect()
{
	::CoInitialize(NULL); //初始化COM环境变量

	try
	{
	 m_pConnection.CreateInstance(__uuidof(Connection));//定义指向定义ADO对象的指针类型 

	 _bstr_t strConnect="Provider=MSDASQL.1;Persist Security Info=False;Data Source=Saving";
	 m_pConnection->Open(strConnect,"","",adModeUnknown);
	}

	catch(_com_error e)
	{
	     AfxMessageBox(e.Description());
	
	}

}

_RecordsetPtr ADOConn::GetRecordSet(_bstr_t bstrSQL)
 {
    try
	{
	    if(m_pConnection==NULL)
			OnInitDBConnect();
		m_pRecordset.CreateInstance(__uuidof(Recordset));

		m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		
	}
   catch(_com_error e)
	{
		AfxMessageBox(e.Description());
	
	}

   return m_pRecordset;

}


BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL)
{
   try
   {
       if(m_pConnection==NULL)
		   OnInitDBConnect();
	   m_pConnection->Execute(bstrSQL,NULL,adCmdText);
	   return true;
   
   }
    catch(_com_error e)
	{
		::AfxMessageBox(e.Description());
		return false;
	}
}

void ADOConn::ExitConnect()
{
   if(m_pRecordset!=NULL)
	   m_pRecordset->Close();
   m_pConnection->Close();

   ::CoUninitialize();

}