logon.cpp

使用vc进行数据库编程的好例子

// Logon.cpp : implementation file
//

#include "stdafx.h"
#include "ManageSystem.h"
#include "Logon.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLogon dialog


CLogon::CLogon(CWnd* pParent /*=NULL*/)
	: CDialog(CLogon::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogon)
	m_Key = _T("");
	m_Name = _T("");
	//}}AFX_DATA_INIT
}


void CLogon::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogon)
	DDX_Control(pDX, IDOK, m_btnOK);
	DDX_Control(pDX, IDCANCEL, m_btnCancel);
	DDX_Control(pDX, IDC_NAME, m_ctrName);
	DDX_Control(pDX, IDC_KEY, m_ctrKey);
	DDX_Text(pDX, IDC_KEY, m_Key);
	DDV_MaxChars(pDX, m_Key, 20);
	DDX_Text(pDX, IDC_NAME, m_Name);
	DDV_MaxChars(pDX, m_Name, 20);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLogon, CDialog)
	//{{AFX_MSG_MAP(CLogon)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLogon message handlers

BOOL CLogon::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_btnCancel.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	m_btnOK.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CLogon::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	m_AdmiSet=NULL;
	CString strKey;

	if(m_Name.IsEmpty())
	{
		AfxMessageBox("请输入用户名。");
		m_ctrName.SetFocus();
		return;
	}

	if(m_Key.IsEmpty())
	{
		AfxMessageBox("请输入密码。");
		m_ctrKey.SetFocus();
		return;
	}

	//============================
	try
	{
		m_AdmiSet=new CAdmiSet();
		CString strSQL("SELECT * from administrator where admi_name='");
		strSQL+=m_Name;
		strSQL+="'";
		m_AdmiSet->Open(CRecordset::snapshot,strSQL);

		strKey=m_AdmiSet->m_admi_password;
		strKey.TrimRight();

		if(!m_AdmiSet->IsEOF())
		{
			if(m_Key!=strKey)
			{	
				AfxMessageBox("密码不正确");
				m_Key="";
				UpdateData(false);
				m_ctrKey.SetFocus();
				m_AdmiSet->Close();
				delete m_AdmiSet;
				return;
			}
			else
			{
				Admi_id=m_AdmiSet->m_admi_id;
				IsAdmi=m_AdmiSet->m_isadmini;
			}
		}
		else
		{
			AfxMessageBox("该用户名不存在。");
			m_Name="";
				
			m_Key="";
			UpdateData(false);
			m_ctrName.SetFocus();
			m_AdmiSet->Close();
			delete m_AdmiSet;
			return;
		}
		m_AdmiSet->Close();
		delete m_AdmiSet;
	}
	catch(CDBException* pe)
	{
		AfxMessageBox(pe->m_strError);

		if(m_AdmiSet)
		{
			if(m_AdmiSet->IsOpen())
				m_AdmiSet->Close();
			delete m_AdmiSet;
		}

		pe->Delete();
	}	

	
	CDialog::OnOK();
}

void CLogon::OnCancel() 
{
	// TODO: Add extra cleanup here
	if(AfxMessageBox("你确认要退出吗？",MB_OKCANCEL)==IDCANCEL)
		return;
	
	CDialog::OnCancel();
}