logindlg.cpp

学生成绩管理系统 在VCsql的开发环境下编写的

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "cj.h"
#include "LoginDlg.h"


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

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg dialog


CLoginDlg::CLoginDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLoginDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLoginDlg)
	m_password = _T("");
	m_username = _T("");
	//}}AFX_DATA_INIT
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_Text(pDX, IDC_EDIT_PASSWORD, m_password);
	DDX_CBString(pDX, IDC_COMBO_user, m_username);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLoginDlg, CDialog)
	//{{AFX_MSG_MAP(CLoginDlg)
	ON_BN_CLICKED(IDSY, OnSy)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

void CLoginDlg::OnOK() 
{
CLoginDlg logindlg;
CString name,password;
int icount;
UpdateData(TRUE);
CDatabase m_database;//定义一个数据库连接对象
m_database.Open(_T("ODBC;DSN=student"));
CRecordset rs(&m_database);
name=m_username;
password=m_password;
rs.Open(CRecordset::forwardOnly,"select * from 管理员 where systemName='"+name+"' and systemPassword='"+password+"'");
icount=rs.GetRecordCount();
rs.Close();
   if(icount!=0){
    EndDialog(IDOK); m_database.Close();
   }
  else{
  MessageBox("请确认您的用户名和口令是否正确！","系统提示：",MB_ICONEXCLAMATION);
   m_database.Close();
  }
}

void CLoginDlg::OnCancel() 
{
	if(MessageBox("真的要退出系统吗?","退出询问",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)
	CDialog::OnCancel();
}

void CLoginDlg::OnSy() 
{
EndDialog(IDOK);	
}


BOOL CLoginDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CenterWindow();//让窗口在中央
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}