database.cpp

对数据库简单的调用、添加、删除

// Database.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "Database.h"
#include "DatabaseDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDatabaseApp

BEGIN_MESSAGE_MAP(CDatabaseApp, CWinApp)
	//{{AFX_MSG_MAP(CDatabaseApp)
		// 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()

/////////////////////////////////////////////////////////////////////////////
// CDatabaseApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CDatabaseApp object

CDatabaseApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CDatabaseApp initialization

BOOL CDatabaseApp::InitInstance()
{
	skinppLoadSkin(_T("AlphaOS.ssk")); //加载皮肤
	
	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.
	
	// 初始化OLE/COM环境
	::CoInitialize(NULL);

//	if(!AfxOleInit()) 
//
//	{ 
//		AfxMessageBox("OLE初始化出错!"); 
//		return FALSE; 
//	} 
	
	try
	{
		//创建Connection对象
		m_pConnection.CreateInstance("ADODB.Connection");

		_bstr_t strConection = "Provider=Microsoft.Jet.OLEDB.4.0;\
			                   Data Source=doctorinfo.mdb;";
		m_pConnection->Open(strConection,"","",adModeUnknown);
	}
	catch (_com_error e)
	{
		//显示错误信息
		AfxMessageBox(e.ErrorMessage());
	}

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

	CDatabaseDlg 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;
}

int CDatabaseApp::ExitInstance() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	if (m_pConnection->State)
	{
		m_pConnection->Close();
		m_pConnection = NULL;
	}

	// 释放环境
	::CoUninitialize();
	
	return CWinApp::ExitInstance();
}