pwdmodify.cpp

银行管理系统,在VisualC++中操作SQL数据库进行银行帐号的创建,删除,修改,转帐,存款,取款,生成密码卡等操作.

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

#include "stdafx.h"
#include "BankSystem.h"
#include "PWDModify.h"
#include ".\pwdmodify.h"
#include "BankSystemDlg.h"



// PWDModify 对话框

IMPLEMENT_DYNAMIC(PWDModify, CDialog)
PWDModify::PWDModify(CWnd* pParent /*=NULL*/)
	: CDialog(PWDModify::IDD, pParent)
	, m_OPWD(_T(""))
	, NewPWD(_T(""))
	, NewPWDAgain(_T(""))
{
}

PWDModify::~PWDModify()
{
}

void PWDModify::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT1, m_OPWD);
	DDX_Text(pDX, IDC_EDIT2, NewPWD);
	DDX_Text(pDX, IDC_EDIT6, NewPWDAgain);
}


BEGIN_MESSAGE_MAP(PWDModify, CDialog)
	ON_BN_CLICKED(IDC_Update, OnBnClickedUpdate)
END_MESSAGE_MAP()


// PWDModify 消息处理程序

void PWDModify::OnBnClickedUpdate()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData();
	CString strQuery="SELECT * FROM bankbook WHERE bankbook.uname=\'"+UserName+"\' AND bankbook.password=\'"+m_OPWD+"\'";

	try{
		pRst=pConn->Execute(_bstr_t(strQuery),NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}
	if(!pRst->rsEOF)
	{
		if(NewPWDAgain==NewPWD)
		{
			pRst.CreateInstance("ADODB.Recordset");
			pRst->Open(_bstr_t(strQuery),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);

			pRst->put_Collect(_variant_t("password"),_variant_t(NewPWD));
			pRst->Update();

			AfxMessageBox("密码已修改");
			OnOK();
		}
		else
		{
			AfxMessageBox("两次新密码不相同");
		}
	}
	else
	{
		AfxMessageBox("原密码不正确");
		OnOK();
	}

}