rms.cpp

图文资源管理程序,access数据库

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

#include "stdafx.h"
#include "RMS.h"
#include "RMSDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRMSApp

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

/////////////////////////////////////////////////////////////////////////////
// CRMSApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CRMSApp object

CRMSApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CRMSApp initialization

BOOL CRMSApp::InitInstance()
{
	AfxEnableControlContainer();

   if(!AfxOleInit()) //初始化OLE/COM库环境
   {
	   AfxMessageBox("OLE初始化出错!");
	   return FALSE;
   }
/*
AfxOleInit();//初始化OLE/COM库环境
*/
  HRESULT hr;//结果句柄变量
  try
  {
  hr = m_pConnection.CreateInstance("ADODB.Connection");//创建Connection对象
  //hr = m_pConnection.CreateInstance(_uuidof(Connection));//创建Connection对象 __uuidof() 伪指令的用法可扩展用于获取接口 ID。 
 // CString m_sConn="Provider=SQLOLEDB.1;Data Source=192.168.3.9;Initial Catalog=sode"; //sode是数据库服务器192.168.3.9上的一个数据库
  if(SUCCEEDED(hr))
  {//连接数据库  Provider是针对ACCESS2000环境的，对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51;
  hr = m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=bluewind.mdb","","",adModeUnknown);
  //hr=m_pConn->Open((_bstr_t)m_sConn,"sa","mapper",adConnectUnspecified);  
  }
  }
  catch(_com_error e)//捕捉异常
  {
  CString errormessage;
  errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
  AfxMessageBox(errormessage);//显示错误信息
  }

	// 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

	CRMSDlg 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 CRMSApp::ExitInstance() 
{
	// TODO: Add your specialized code here and/or call the base class
	if(m_pConnection->State) 
	m_pConnection->Close(); // 关闭连接
	return CWinApp::ExitInstance();
}