book.cpp

一个小型的图书管理系统,用到了access数据库,其中有三种权限的用户登陆这个系统,每种用户将拥有不同的权限,用户密码和帐户打开程序中的access便可知道.

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

#include "stdafx.h"
#include "Book.h"
#include "BookDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#include <odbcinst.h>
/////////////////////////////////////////////////////////////////////////////
// CBookApp

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

/////////////////////////////////////////////////////////////////////////////
// CBookApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CBookApp object

CBookApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CBookApp initialization

BOOL CBookApp::InitInstance()
{
	if (!AfxSocketInit())
	{
		AfxMessageBox(IDP_SOCKETS_INIT_FAILED);
		return FALSE;
	}

    CString sPath;
	GetModuleFileName(NULL,sPath.GetBufferSetLength(MAX_PATH+1),MAX_PATH);
	sPath.ReleaseBuffer();
	int nPos;
	nPos=sPath.ReverseFind ('\\');
	sPath=sPath.Left (nPos);
	nPos=sPath.ReverseFind('\\');
    sPath=sPath.Left (nPos);
	CString lpszFile = sPath + "\\bookuser.mdb";
	
   
    char* szDesc;
	int mlen;
	szDesc=new char[256];
	sprintf(szDesc,"DSN=%s? DESCRIPTION=TOC support source? DBQ=%s? FIL=MicrosoftAccess? DEFAULTDIR=%s?? ","bookuser",lpszFile,sPath);



	mlen = strlen(szDesc);
    for (int i=0; i<mlen; i++)
	{
	if (szDesc[i] == '?')
	 szDesc[i] = '\0';
	}

	if (FALSE == SQLConfigDataSource(NULL,ODBC_ADD_DSN,"Microsoft Access Driver (*.mdb)\0",(LPCSTR)szDesc))
	AfxMessageBox("SQLConfigDataSource Failed");
			
    try
	{
     CString strConnect;
	 strConnect.Format("DSN=bookuser;");
	 if(!m_DB.OpenEx(strConnect,CDatabase::useCursorLib))
     {
     AfxMessageBox("Unable to Connect to the Specified Data Source");
     return FALSE ;
     }
	}
	catch(CDBException *pE)
	{	
        pE->ReportError();
        pE->Delete();
        return FALSE;
	}
	
	AfxEnableControlContainer();
	SetDialogBkColor (RGB(92, 150, 224),RGB(188,190,192));
	// 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
    
	CDengLu dengdlg;//创建登录对话框
	if(dengdlg.DoModal()==IDCANCEL)//点击登录对话框退出按钮退出程序
		return FALSE;
	
	CBookDlg 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;
}