database.cpp

用C++编写的学生信息管理系统 兼有数据库

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

#include "stdafx.h"
#include "DATABASE.h"

#include "MainFrm.h"
#include "DATABASESet.h"
#include "DATABASEDoc.h"
#include "DATABASEView.h"
#include "PSWset.h"
#include "PassDlg.h"
#include "odbcinst.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)
	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()

/////////////////////////////////////////////////////////////////////////////
// CDATABASEApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CDATABASEApp object

CDATABASEApp theApp;
CString CurrentUser;
CString CurrentPass;

/////////////////////////////////////////////////////////////////////////////


/////////////////////////////////////////////////////////////////////////////

// CDATABASEApp initialization

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

	SetDialogBkColor (RGB (250, 250, 250), RGB (0, 0, 0,));
    
	CString sPath;
	GetModuleFileName(NULL,sPath.GetBufferSetLength(MAX_PATH+1),MAX_PATH);
	sPath.ReleaseBuffer ();
	int nPos;
	nPos=sPath.ReverseFind('\\');
    sPath=sPath.Left (nPos);
	CString lpszFile = sPath + "\\student0.mdb"; 
    char* szDesc;
	int mlen;
	szDesc=new char[256];
	sprintf(szDesc,"DSN=%s? UID=;PWD=126;DESCRIPTION=TOC support source? DBQ=%s? FIL=MicrosoftAccess? DEFAULTDIR=%s?? ","我的数据库0",lpszFile,sPath);
    
	mlen = strlen(szDesc);
    for (int i=0; i<mlen; i++)
	{
	if (szDesc[i] == '?')
	 szDesc[i] = '\0';
	}
	SQLConfigDataSource(NULL,ODBC_ADD_DSN,"Microsoft Access Driver (*.mdb)\0",(LPCSTR)szDesc);


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

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


	
	bool SEX = true;
	CString user, password,str;
	CPassDlg m_dlg;
    CPSWset m_Set;
	m_Set.Open();
    
	while(SEX){
	  if(m_dlg.DoModal() == IDOK)
	  { 
		  //int nIndex = m_dlg.m_users.GetCurSel();
		  //for(int i=0;i<=nIndex;i++) m_Set.MoveNext();
		  
		  CurrentUser=m_dlg.CurUser;
          
          //CurrentUser=m_Set.m_user;
    	  m_Set.m_strFilter.Format("user='%s'",CurrentUser);
          m_Set.Requery();

		  CurrentPass = password = m_Set.m_pass;
		  if(m_dlg.m_pass == password)
		  {
				SEX = false;
				break;
		  }
		  if(SEX)
		  {
            AfxMessageBox("密码错误，请您重新输入!");
		  }
	  }
	  else exit(-1);
	}
         m_Set.Close();

	SetDialogBkColor (RGB (22, 194, 211), RGB (0, 0, 0,));

	// 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(CDATABASEDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CDATABASEView));
	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_SHOWMAXIMIZED);
	m_pMainWnd->SetWindowText("学生管理系统 V1.0 课设版");
	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)
		// No message handlers
	//}}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)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

// App command to run the dialog
void CDATABASEApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	SetDialogBkColor (RGB (250, 250, 250), RGB (0, 0, 0,));
	aboutDlg.DoModal();
	SetDialogBkColor (RGB (230, 250, 250), RGB (0, 0, 0,));
}

/////////////////////////////////////////////////////////////////////////////
// CDATABASEApp message handlers