adddlg.cpp

本程序是用MFC设计的通讯录。能够完成添加

// AddDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Adress.h"
#include "AddDlg.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_editEmail = _T("");
	m_editName = _T("");
	m_editSex = _T("");
	m_editTelephone = _T("");
	m_editType = _T("");
	//}}AFX_DATA_INIT
}


void CAddDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddDlg)
	DDX_Text(pDX, IDC_EDIT_EMAIL, m_editEmail);
	DDX_Text(pDX, IDC_EDIT_NAME, m_editName);
	DDX_Text(pDX, IDC_EDIT_SEX, m_editSex);
	DDX_Text(pDX, IDC_EDIT_TELEPHONE, m_editTelephone);
	DDX_Text(pDX, IDC_EDIT_TYPE, m_editType);
	//}}AFX_DATA_MAP
}


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

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

void CAddDlg::OnOK() 
{
	UpdateData(TRUE);

	if(m_editSex!="F"&&m_editSex!="M")
	{
		MessageBox("性别只能是M(男)或F(女)!");
		return;
	}
	
	CString strSQL;
	strSQL.Format("insert into book(name,sex,type,telephone,email) values ('%s','%s','%s','%s','%s')",m_editName,m_editSex,m_editType,m_editTelephone,m_editEmail);
	pDB->Execute(strSQL);
	MessageBox("添加成功!");
	CDialog::OnOK();
}

BOOL CAddDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	CString strConnection="File Name=my_data.udl";
	pDB=new CADODatabase;
	pDB->Open(strConnection);

	
	return TRUE;  // return TRUE  unless you set the focus to a control
}