passworddlg.cpp

这是一个课程设计

// PasswordDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Scoremanager.h"
#include "PasswordDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPasswordDlg dialog


CPasswordDlg::CPasswordDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPasswordDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPasswordDlg)
	//}}AFX_DATA_INIT
}


void CPasswordDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPasswordDlg)
	DDX_Control(pDX, IDOK, m_ok);
	DDX_Control(pDX, IDCANCEL, m_can);
	DDX_Control(pDX, IDC_EDIT_CONFIRM, m_strConfirm);
	DDX_Control(pDX, IDC_EDIT_NEW, m_strNew);
	DDX_Control(pDX, IDC_EDIT_PASSWORD, m_strPassword);
	DDX_Control(pDX, IDC_EDIT_USERNAME, m_strUserName);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CPasswordDlg message handlers

void CPasswordDlg::OnOK()
{

CString username,password,newPassword,confirmPassword;
m_strUserName.GetWindowText(username);
m_strPassword.GetWindowText(password);
m_strNew.GetWindowText(newPassword);
m_strConfirm.GetWindowText(confirmPassword);
CDatabase m_database;
CRecordset m_recordSet;
if(newPassword.IsEmpty()||confirmPassword.IsEmpty())
{
     MessageBox("密码不为空");
}
else
{
    if(newPassword!=confirmPassword)
	{
	  MessageBox("密码不一致，请重新输入新密码","密码错误",MB_OK|MB_ICONWARNING);
      m_strNew.SetWindowText("");
      m_strConfirm.SetWindowText("");
      m_strNew.SetFocus();
	}
    else
	{
		if(!m_database.IsOpen())
		{
     if(m_database.Open(_T("Scoremanager")))
	 {
     m_recordSet.m_pDatabase=&m_database;
     CString strSQL;
     strSQL.Format("select* from userinfo where user_name='%s' and user_password='%s' and active_status='Y'",username,password);
	 m_recordSet.Open(CRecordset::forwardOnly,strSQL);
     if(m_recordSet.GetRecordCount()==0)
	 {   
          MessageBox("密码错误,请重新输入","密码错误",MB_OK|MB_ICONWARNING);//提示密码错误
          m_strPassword.SetWindowText("");
          m_strNew.SetWindowText("");
          m_strConfirm.SetWindowText("");
          m_strPassword.SetFocus();
	 }
     else//如果找到记录
	 {






		 strSQL.Format("update    userinfo set  user_password='%s'  where user_name='%s'",newPassword,username);
          
          m_recordSet.Close();
		 m_database.ExecuteSQL(strSQL);
	
       
         MessageBox("修改密码成功!");
         CDialog::OnOK();
      }
         m_recordSet.Close();
         m_database.Close();
       }
    else
	{
                    MessageBox("不能打开数据库");
                    
	} 
                }
           }
      }

}     
          

void CPasswordDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}