changepwd.cpp

本人工作中的一个软件开发实例。里面包含了数据库

// ChangePwd.cpp : implementation file
//

#include "stdafx.h"
#include "OIL.h"
#include "ChangePwd.h"

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

extern  COILApp    theApp;
/////////////////////////////////////////////////////////////////////////////
// CChangePwd dialog


CChangePwd::CChangePwd(CWnd* pParent /*=NULL*/)
	: CDialog(CChangePwd::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChangePwd)
	m_strNewPwd1 = _T("");
	m_strNewPwd2 = _T("");
	m_strOldPwd = _T("");
	//}}AFX_DATA_INIT
}


void CChangePwd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangePwd)
	DDX_Text(pDX, IDC_NEWPWD1, m_strNewPwd1);
	DDX_Text(pDX, IDC_NEWPWD2, m_strNewPwd2);
	DDX_Text(pDX, IDC_OLDPWD, m_strOldPwd);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CChangePwd message handlers

void CChangePwd::OnOK() 
{
	// TODO: Add extra validation here
	
	//比较前后两次密码是否相同
	UpdateData();
	if(m_strNewPwd1!=m_strNewPwd2)
	{
		AfxMessageBox("两次输入的新密码不相同，请重新输入");
		m_strNewPwd2=_T("");
		UpdateData(false);
		GetDlgItem(IDC_NEWPWD2)->SetFocus();
		return;
	}
 
	//更新数据库
	_RecordsetPtr	  m_pRecordset;
    CString sql="Update operator set operatorpassword='"+m_strNewPwd1+"' where operatorid='"+theGlobal.strUserID+ "' and OperatorPassword='"+m_strOldPwd+"'";

	//执行语句
	_variant_t RecordsAffected;
	theApp.m_pConnection->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);

	if((long)RecordsAffected==1)
	{
		//提示修改成功
		AfxMessageBox("密码修改成功");
	}
	else
	{   
		AfxMessageBox("密码修改失败，请输入正确的旧密码");
		SetDlgItemText(IDC_OLDPWD,"");
		(CEdit *)GetDlgItem(IDC_OLDPWD)->SetFocus();
		return;
	}
	CDialog::OnOK();
}