logindlg.cpp

ODBC API访问数据库的文章却少之又少。虽然用ODBC访问数据库比较麻烦

// LoginDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "DataManager.h"
#include "LoginDlg.h"
#include ".\logindlg.h"
#include "DbOperator\DbOperator.h"

// CLoginDlg 对话框

IMPLEMENT_DYNAMIC(CLoginDlg, CDialog)
CLoginDlg::CLoginDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLoginDlg::IDD, pParent)
{
}

CLoginDlg::~CLoginDlg()
{
}

void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}


BEGIN_MESSAGE_MAP(CLoginDlg, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
END_MESSAGE_MAP()


// CLoginDlg 消息处理程序

void CLoginDlg::OnBnClickedOk()
{
	CComboBox* pComboUsername = (CComboBox*)GetDlgItem(IDC_COMBO_USERNAME);
	CEdit* pEditUserpwd = (CEdit*)GetDlgItem(IDC_EDIT_USERPWD);
	CString strUsername;
	CString strUserpwd;
	pComboUsername->GetWindowText(strUsername);
	pEditUserpwd->GetWindowText(strUserpwd);
	if(strUsername=="")
	{
		MessageBox("用户名不能够为空!");
		return;
	}
	if(strUserpwd=="")
	{
		MessageBox("密码不能够为空!");
		return;
	}

	CString strUserpwd_old;
	CDbOperator dbOperator;
	if(dbOperator.GetUserpwdByUsernina(strUsername, strUserpwd_old))
	{
		if(strUserpwd==strUserpwd_old)
		{
			OnOK();
		}
		else
		{
			pEditUserpwd->SetWindowText("");
			MessageBox("密码不正确，请重新输入！");
		}
	}
	else
	{
		MessageBox("用户名不存在！");
	}

}

BOOL CLoginDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	CComboBox* pComboUsername = (CComboBox*)GetDlgItem(IDC_COMBO_USERNAME);
	CDbOperator dbOperator;
	int arrUserId[100];
	int nUserCount = 0;
	CString strNickname;
	dbOperator.GetUserIdFromObj_User(arrUserId, nUserCount);
	for(int nUser=0; nUser<nUserCount; nUser++)
	{
		dbOperator.GetNinaByUserId(arrUserId[nUser], strNickname);
		pComboUsername->AddString(strNickname);
		pComboUsername->SetCurSel(0);
	}
	return TRUE; 
}