logindlg.cpp

一个由MFC做的学生信息管理系统

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SSF.h"
#include "LoginDlg.h"
#include"PassWord.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_strPass = _T("");
	m_bIsAdmin = _T("");
	m_strUser = _T("");
	//}}AFX_DATA_INIT
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_Text(pDX, IDC_code, m_strPass);
	DDX_CBString(pDX, IDC_COMBO1, m_bIsAdmin);
	DDX_Text(pDX, IDC_name, m_strUser);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLoginDlg, CDialog)
	//{{AFX_MSG_MAP(CLoginDlg)
	ON_BN_CLICKED(IDC_log, Onlog)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg message handlers

void CLoginDlg::Onlog() 
{
	// TODO: Add your control notification handler code here
	CPassWord recordset;
	CString strSQL;
    UpdateData(TRUE);	
	if(m_bIsAdmin.IsEmpty())
	{
		AfxMessageBox("请选择用户类型!");
		return;
	}
	if(m_strUser.IsEmpty())
	{
		AfxMessageBox("请输入用户名");
	    return;
	}
	if(m_strPass.IsEmpty())
	{
         AfxMessageBox("请输入密码!");
	     return;
	}
   strSQL.Format("select * from user where user='%s'AND passwd='%s' AND type='%s'",m_strUser,m_strPass,m_bIsAdmin);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	if(recordset.GetRecordCount()==0)
	{
		recordset.Close();
		MessageBox("密码错误，请重新输入!");
	    m_strPass = _T("");
	    UpdateData(FALSE);
	}
	else
	{
		
		recordset.Close();
		CDialog::OnOK();
		return ;
	}
}

BOOL CLoginDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CDialog::OnInitDialog();
	CPassWord recordset;
	CString strSQL;
	UpdateData(TRUE);
	strSQL="select * from user";
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return FALSE;
	}
	
	recordset.Close();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}