adddlg.cpp

一个用ODBC访问Access的实例

// AddDlg.cpp : implementation file
//

#include "stdafx.h"
#include "vocabulory.h"
#include "AddDlg.h"
#include "logindlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddDlg dialog


CAddDlg::CAddDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddDlg)
	m_Eword = _T("");
	m_Cword = _T("");
	m_Addition = _T("");
	//}}AFX_DATA_INIT
}


void CAddDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddDlg)
	DDX_Text(pDX, IDC_EDIT1, m_Eword);
	DDX_Text(pDX, IDC_EDIT2, m_Cword);
	DDX_Text(pDX, IDC_EDIT3, m_Addition);
	//}}AFX_DATA_MAP
}


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

BOOL CAddDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// 
	CString sqlStr;
	sqlStr="SELECT * FROM VOCABULORY";
	if(!wordset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("单词表打开失败!");
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

/////////////////////////////////////////////////////////////////////////////
// CAddDlg message handlers

void CAddDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	if(m_Eword.IsEmpty()||m_Cword.IsEmpty())
	{
		AfxMessageBox("请输入相应的数据!");
	}
	else
	{
		wordset.AddNew();
	
		wordset.m_Eword = m_Eword;
		wordset.m_Cword = m_Cword;
		wordset.m_Addition = m_Addition;
		wordset.Update();
		wordset.Requery();
		MessageBox("添加单词成功!");
		m_Eword = "";
		m_Cword = "";
		m_Addition = "";
		UpdateData(false);
	}
}

void CAddDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	if(wordset.IsOpen())
	{
		wordset.Close();
	}
	CDialog::OnCancel();
}