db.cpp

简单的学生成绩管理系统,只能供入门者参考

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

#include "stdafx.h"
#include "DB.h"
#include"PASSWORD.h"
#include "MainFrm.h"
#include "DBSet.h"
#include "DBDoc.h"
#include "DBView.h"
#include "odbcinst.h" 
#include"PWSet.h"   
#include"LOGINDLG.h"   
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
bool showflag;
bool show;
/////////////////////////////////////////////////////////////////////////////
// CDBApp

BEGIN_MESSAGE_MAP(CDBApp, CWinApp)
	//{{AFX_MSG_MAP(CDBApp)
	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 print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDBApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CDBApp object

CDBApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CDBApp initialization

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



	
		CString sPath;//保存数据库文件路径名
	GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);//为sPath分配存储空间
	sPath.ReleaseBuffer();
	int nPos;
	nPos=sPath.ReverseFind('\\');
	sPath=sPath.Left(nPos);//获取文件的Debug路径
        nPos=sPath.ReverseFind('\\');
	sPath=sPath.Left(nPos);//获取文件的工程文件夹路径
	CString lpszFileName = sPath + "\\xxx.mdb";//保存数据库文件名称                          //需要修改hc
	CFileFind  fFind;
	if(!fFind.FindFile(lpszFileName))
	{
		::AfxMessageBox("没有找到数据库xxx");
		exit(0);
	}
	CString szDesc;//保存对数据源的描述
	szDesc.Format( "DSN=xxx;FIL=Microsoft Access;DEFAULTDIR=%s;DBQ=%s;" ,sPath,lpszFileName);      //需要修改hc
	//添加数据源
	if(!::SQLConfigDataSource(NULL,ODBC_ADD_DSN, "Microsoft Access Driver (*.mdb)",(LPCSTR)szDesc))
	{
		::AfxMessageBox("32位ODBC数据源配置错误!");
		exit(0);
	}
    m_Skin.LoadSkinFile("corona.smf");
	m_Skin.SetDialogSkin("Dialog");
   bool flag;
	flag=false;
	PASSWORD mydlg;
    PWSet myset; //若在多个函数中使用可在头文件中定义

    myset.Open( );
	
aa:	for(int i=0;i<=2;i++)
	{if(mydlg.DoModal()==IDOK)
	
	{if(mydlg.m_sno.IsEmpty()||(mydlg.m_password.IsEmpty()))
	   {  AfxMessageBox("您没有输入密码，系统将以浏览的方式打开");   }
	   else
		   
	   { while(!myset.IsEOF())
	   {
		   if((myset.m_sno==mydlg.m_sno)&&(myset.m_password==mydlg.m_password))
		   {flag=!flag;	m_quanxian=myset.m_authority;myset.Close();break;}//关闭数据表
		   else  myset.MoveNext();}
	   if(flag)
		   break;
	   }
	  
	}
	else 
		return false;}
	if(!flag)
	{if(AfxMessageBox(_T("三次登录错误!程序即将终止,你需要注册账号吗"),MB_YESNO|MB_ICONINFORMATION)==IDYES)
	{
		
		LOGINDLG mydlg;
		if(mydlg.DoModal()==IDOK)
		{
			myset.AddNew();
			myset.m_sno=mydlg.m_sno;
			myset.m_password=mydlg.m_password1;
			myset.m_authority="1";
			myset.Update();
			myset.Requery();
			AfxMessageBox("注册成功！");
			goto aa;
		}
		else
			return false;
		
	}
	else
		return false;}
    
	// 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)

	// 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(CDBDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CDBView));
	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->UpdateWindow();

    m_Skin.LoadSkinFile("corona.smf");
	m_Skin.SetWindowSkin(m_pMainWnd->m_hWnd, "MainFrame");
	m_Skin.SetDialogSkin("Dialog");
	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 CDBApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CDBApp message handlers