changepassworddlg.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// ChangePasswordDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LibDBS.h"
#include "ChangePasswordDlg.h"
#include "LoginSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CChangePasswordDlg dialog


CChangePasswordDlg::CChangePasswordDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CChangePasswordDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChangePasswordDlg)
	m_strUserName = _T("");
	m_strPassword_old = _T("");
	m_strPassword_new1 = _T("");
	m_strPassword_new2 = _T("");
	//}}AFX_DATA_INIT
}


void CChangePasswordDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangePasswordDlg)
	DDX_Text(pDX, IDC_EDIT_USERNAME, m_strUserName);
	DDX_Text(pDX, IDC_EDIT_OLD_PASSWORD, m_strPassword_old);
	DDX_Text(pDX, IDC_EDIT_NEW2_PASSWORD, m_strPassword_new1);
	DDX_Text(pDX, IDC_EDIT_NEW1_PASSWORD, m_strPassword_new2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChangePasswordDlg, CDialog)
	//{{AFX_MSG_MAP(CChangePasswordDlg)
	ON_BN_CLICKED(IDC_BUTTON_OK, OnButtonOk)
	ON_BN_CLICKED(IDC_BUTTON_BACK, OnButtonBack)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChangePasswordDlg message handlers

void CChangePasswordDlg::OnButtonOk() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strUserName.IsEmpty())
	{
		MessageBox("请输入用户名!","登录系统",MB_OK|MB_ICONEXCLAMATION);
		m_strUserName.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		//连接数据源
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("连接数据库失败!","图书管理系统",MB_OK|MB_ICONINFORMATION);
			return;
		}
	}
	if(m_strPassword_new1 != m_strPassword_new2)
	{
		MessageBox("两次密码不同!","确认密码",MB_OK|MB_ICONEXCLAMATION);
		m_strPassword_old.Empty();
		m_strUserName.Empty();
		m_strPassword_new1.Empty();
		m_strPassword_new2.Empty();
		UpdateData(FALSE);
		return;
	}
	
	CLoginSet *m_pLogset=new CLoginSet(&m_database);

	//编写SQL语句
	CString strSQL;
	strSQL.Format("select * from Admin_Info where User_Name='%s' AND Password='%s'",m_strUserName,m_strPassword_old);
	//编写SQL语句结束
	
	m_pLogset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	
	if(m_pLogset->GetRecordCount()==0)
	{
	
		MessageBox("登录失败!","图书管理系统",MB_OK|MB_ICONERROR);
		m_strPassword_old.Empty();
		m_strUserName.Empty();
		m_strPassword_new1.Empty();
		m_strPassword_new2.Empty();
		UpdateData(FALSE);
	}
	else
	{
		m_pLogset->Edit();
		m_pLogset->m_Password = m_strPassword_new2;
		m_pLogset->Update();
		m_pLogset->Requery();
		
		MessageBox("修改成功!","修改密码",MB_OK|MB_ICONEXCLAMATION);
		m_strPassword_old.Empty();
		m_strUserName.Empty();
		m_strPassword_new1.Empty();
		m_strPassword_new2.Empty();
		UpdateData(FALSE);
		m_database.Close();	

		return;
	}		
}

void CChangePasswordDlg::OnButtonBack() 
{
	// TODO: Add your control notification handler code here
	if(m_database.IsOpen())
		m_database.Close();
	OnOK();		
}
void CChangePasswordDlg::OnClose() 
{
	OnButtonBack();
}