passworddlg.cpp

最后的成品vc考勤ACCSEE数据库做的 还有文档 希望大家多多指点[e-mail]

// PasswordDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StudentScore.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)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CPasswordDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPasswordDlg)
	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)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

void CPasswordDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CEdit* pUsername=(CEdit*)this->GetDlgItem(IDC_EDIT_USERNAME);

	CEdit* pPassword=(CEdit*)this->GetDlgItem(IDC_EDIT_PASSWORD);
	CEdit* pNew=(CEdit*)this->GetDlgItem(IDC_EDIT_NEW);
	CEdit* pConfirm=(CEdit*)this->GetDlgItem(IDC_EDIT_CONFIRM);




	CString username,password,newPassword,confirmPassword;
	pUsername->GetWindowText(username);
	pPassword->GetWindowText(password);
	pNew->GetWindowText(newPassword);
	pConfirm->GetWindowText(confirmPassword);


	CDatabase m_database;
	CRecordset m_recordSet;
	if(newPassword.IsEmpty()||confirmPassword.IsEmpty())
	{ MessageBox("mi ma bu wei kong");
	}
	else
	{
		if(newPassword!=confirmPassword)
		{
			MessageBox("两次输入的不同");
			pNew->SetWindowText("");
			pConfirm->SetWindowText("");
			pNew->SetFocus();
		}
		else
		{
			if(!m_database.IsOpen())
			{
				if(m_database.Open(_T("studentscore")))
				{
					m_recordSet.m_pDatabase=&m_database;
					CString strSQL;
					strSQL.Format("SELECT * FROM userinfo WHERE user_name='%s' AND user_password='%s'",username,password);
					m_recordSet.Open(CRecordset::forwardOnly,strSQL);//and active_status='Y'
					if(m_recordSet.GetRecordCount()==0)
					{
						MessageBox("mima cuowu qing chongxinshuru ","mima cuowu",
							MB_OK|MB_ICONWARNING);
						pPassword->SetWindowText("");
						pNew->SetWindowText("");
						pConfirm->SetWindowText("");
						pPassword->SetFocus();

					}
					else 
					{
						strSQL.Format(" update userinfo set user_password='%s' where user_name='%s'",newPassword,username);
					    m_database.ExecuteSQL(strSQL);
						MessageBox("xiugai chenggong ");
						CDialog::OnOK();
					}
					m_recordSet.Close();
					m_database.Close();

				}
				else 
				{
					MessageBox("bu neng dakai");
				}
			}
		}
	}
}

void CPasswordDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();

	
}