define.cpp

学生选课系统

// Define.cpp : implementation file
//

#include "stdafx.h"
#include "SC.h"
#include "Define.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDefine dialog


CDefine::CDefine(CWnd* pParent /*=NULL*/)
	: CDialog(CDefine::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDefine)
	m_strUser = _T("");
	m_strOldPw = _T("");
	m_strNewPw = _T("");
	//}}AFX_DATA_INIT
}


void CDefine::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDefine)
	DDX_Text(pDX, IDC_USER, m_strUser);
	DDX_Text(pDX, IDC_OLD_PASSWORD, m_strOldPw);
	DDX_Text(pDX, IDC_NEW_PASSWORD, m_strNewPw);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDefine, CDialog)
	//{{AFX_MSG_MAP(CDefine)
	ON_BN_CLICKED(IDC_SUMMIT, OnSummit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDefine message handlers

void CDefine::OnSummit() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	_bstr_t sql;
	m_pRecordset->MoveFirst();
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		CString temp=(char*)(_bstr_t)(m_pRecordset->GetCollect("Un"));
		if(temp==m_strUser)
		{
			temp=(char*)(_bstr_t)(m_pRecordset->GetCollect("Pw"));
			if(temp==m_strOldPw)
			{
				if(m_strNewPw.IsEmpty()==0)
				{
					m_AdoConn.OnInitADOConn();
					sql="UPDATE UserPw SET Pw='"+m_strNewPw+"' WHERE Un='"+m_strUser+"'";
					m_AdoConn.ExecuteSQL(sql);
					MessageBox(sql);
					MessageBox("修改成功");
					//m_AdoConn.ExitConnect();
					return;
				}
				else
				{
					AfxMessageBox("请输入新密码");
					return;
				}
				
			}
			else
			{
				AfxMessageBox("密码错误");
				return;
			}
		}
		m_pRecordset->MoveNext();
	}
	MessageBox("用户名错误");
	return;
}

BOOL CDefine::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_AdoConn.OnInitADOConn();
	_bstr_t sql;
	sql="SELECT * FROM UserPw";
	m_pRecordset=m_AdoConn.GetRecordSet(sql);

	return TRUE;
}