assetenrol.cpp

这是本人前不久为公司做的一个财产登记软件,实现中用到的是ADO Access数据库.登陆的初始密码为:111111,当然你可以进行更改.

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

#include "stdafx.h"
#include "AssetEnrol.h"

#include "MainFrm.h"
#include "AssetEnrolDoc.h"
#include "AssetEnrolView.h"
#include "PassWord.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAssetEnrolApp

BEGIN_MESSAGE_MAP(CAssetEnrolApp, CWinApp)
	//{{AFX_MSG_MAP(CAssetEnrolApp)
	ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG_MAP
	// Standard file based document commands
	ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)
	ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)
	// Standard print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAssetEnrolApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CAssetEnrolApp object

CAssetEnrolApp theApp;
BOOL IsOpen;
CString queryName;
BOOL asset;

/////////////////////////////////////////////////////////////////////////////
// CAssetEnrolApp initialization

BOOL CAssetEnrolApp::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


    //add...

	asset=FALSE;

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

	//初始化COM（ADO本身就是一个组件）
	//创建ADO连接等操作
	AfxOleInit();

	//_ConnectionPtr智能指针，通常用于打开或关闭一个库连接
	//或用它的Execute方法来执行一个不返回结果的命令语句
    

	
	//创建一个数据库连接
	HRESULT hr1;
	hr1=m_pConnection.CreateInstance(__uuidof(Connection)); 

	try
	{
	hr1=m_pConnection->Open(_T("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=PassWord.mdb;Jet OLEDB:DataBase Password=111111;Mode=Share Deny Read|Share Deny Write"),"","",adModeUnknown);
	}

	catch(_com_error e)
	{
		AfxMessageBox("数据库连接失败!\n\n确认数据库在当前路径下!");
		return FALSE;
	}

    //进行身份验证
	PassWord dlg;
	if(dlg.DoModal()==IDCANCEL)
	{
		return FALSE;
	}

	//当用户通过验证后应该关闭数据库
	//否则新的数据库就打不开!!
	if(IsOpen==TRUE)
	{
		hr1=m_pConnection->Close();
	}


	//创建一个数据库连接
	HRESULT hr;
	hr=m_pConnection.CreateInstance(__uuidof(Connection)); 


	//在ADO操作中经常要用到try...catch()来捕获错误信息

	try
	{
		//打开本地的Acess数据库Demo.mdb
		hr=m_pConnection->Open(_T("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=Asset.mdb;Jet OLEDB:DataBase Password=111111;Mode=Share Deny Read|Share Deny Write"),"","",adModeUnknown);
		
	}
	catch(_com_error e)
	{
		AfxMessageBox("数据库连接失败!\n\n确认数据库在当前路径下!");
		return FALSE;
	}
	
	



	// Change the registry key under which our settings are stored.
	// TODO: You should modify this string to be something appropriate
	// such as the name of your company or organization.
	SetRegistryKey(_T("Local AppWizard-Generated Applications"));

	LoadStdProfileSettings();  // Load standard INI file options (including MRU)

	// Register the application's document templates.  Document templates
	//  serve as the connection between documents, frame windows and views.

	CSingleDocTemplate* pDocTemplate;
	pDocTemplate = new CSingleDocTemplate(
		IDR_MAINFRAME,
		RUNTIME_CLASS(CAssetEnrolDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CAssetEnrolView));
	AddDocTemplate(pDocTemplate);

	// Parse command line for standard shell commands, DDE, file open
	CCommandLineInfo cmdInfo;
	ParseCommandLine(cmdInfo);

	// Dispatch commands specified on the command line
	if (!ProcessShellCommand(cmdInfo))
		return FALSE;

	// The one and only window has been initialized, so show and update it.
	m_pMainWnd->ShowWindow(SW_SHOW);
	m_pMainWnd->UpdateWindow();

	return TRUE;
}


/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	virtual BOOL OnInitDialog();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

// App command to run the dialog
void CAssetEnrolApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CAssetEnrolApp message handlers


BOOL CAboutDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
    

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}