adorwaccess.cpp

ADO的使用

//////////////////////////////////////////////////////////////////////////////
//类名：CAdoRWAccessApp
//功能：应用程序的初始化
//作者：徐景周([e-mail])
//组织：未来工作室(Future Studio)
//日期：2002.12.10
/////////////////////////////////////////////////////////////////////////////
#include "stdafx.h"
#include "AdoRWAccess.h"
#include "AdoRWAccessDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAdoRWAccessApp

BEGIN_MESSAGE_MAP(CAdoRWAccessApp, CWinApp)
	//{{AFX_MSG_MAP(CAdoRWAccessApp)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG
	ON_COMMAND(ID_HELP, CWinApp::OnHelp)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdoRWAccessApp construction

CAdoRWAccessApp::CAdoRWAccessApp()
{
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CAdoRWAccessApp object

CAdoRWAccessApp theApp;

/////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////
//名称：InitInstance
//功能：初始化程序实例
//作者：徐景周([e-mail])
//组织：未来工作室(Future Studio)
//日期：2002.12.10
/////////////////////////////////////////////////////////////////////////////
BOOL CAdoRWAccessApp::InitInstance()
{
	AfxEnableControlContainer();

	// Standard initialization
	// If you are not using these features and wish to reduce the size
	//  of your final executable, you should remove from the following
	//  the specific initialization routines you do not need.

#ifdef _AFXDLL
	Enable3dControls();			// Call this when using MFC in a shared DLL
#else
	Enable3dControlsStatic();	// Call this when linking to MFC statically
#endif

	// 此程序只能运行一次，用互斥量来判断程序是否已运行
    HANDLE m_hMutex=CreateMutex(NULL,TRUE, m_pszAppName); 
    if(GetLastError()==ERROR_ALREADY_EXISTS) { return FALSE; }

	// 设置对话框背景和文本颜色
//	SetDialogBkColor(RGB(160,180,220),RGB(0,0,0));

	// ------------------------------------------------------------------------------------------------
	// 初始化COM,创建ADO连接等操作
	AfxOleInit();
	m_pConnection.CreateInstance(__uuidof(Connection));

	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 因为它有时会经常出现一些想不到的错误。jingzhou xu
	try                 
	{	
		// 打开本地Access库Demo.mdb
		m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Demo.mdb","","",adModeUnknown);
		
	}
	catch(_com_error e)
	{
		AfxMessageBox("数据库连接失败，确认数据库Demo.mdb是否在当前路径下!");
		return FALSE;
	} 
	// ---------------------------------------------------------------------------------------------------

	CAdoRWAccessDlg dlg;
	m_pMainWnd = &dlg;
	int nResponse = dlg.DoModal();
	if (nResponse == IDOK)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with OK
	}
	else if (nResponse == IDCANCEL)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with Cancel
	}

	// Since the dialog has been closed, return FALSE so that we exit the
	//  application, rather than start the application's message pump.
	return FALSE;
}

//////////////////////////////////////////////////////////////////////////////
//名称：ExitInstance
//功能：退出时清除工作
//作者：徐景周([e-mail])
//组织：未来工作室(Future Studio)
//日期：2002.12.10
/////////////////////////////////////////////////////////////////////////////
int CAdoRWAccessApp::ExitInstance() 
{
	// 关闭ADO连接状态
	if(m_pConnection->State)
		m_pConnection->Close();
	m_pConnection= NULL;

	return CWinApp::ExitInstance();
}