add.cpp

数据库课程设计

// ADD.cpp : implementation file
//

#include "stdafx.h"
#include "phonebook.h"
#include "ADD.h"
#include "SQL.h"
#include "string.h"

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

/////////////////////////////////////////////////////////////////////////////
// CADD dialog


CADD::CADD(CWnd* pParent /*=NULL*/)
	: CDialog(CADD::IDD, pParent)
{
	//{{AFX_DATA_INIT(CADD)
	m_address = _T("");
	m_gender = _T("");
	m_name = _T("");
	m_phone = _T("");
	m_kind = _T("");
	//}}AFX_DATA_INIT
}


void CADD::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CADD)
	DDX_Text(pDX, IDC_address_EDIT3, m_address);
	DDX_CBString(pDX, IDC_gender_COMBO1, m_gender);
	DDX_Text(pDX, IDC_name_EDIT1, m_name);
	DDX_Text(pDX, IDC_phone_EDIT2, m_phone);
	DDX_CBString(pDX, IDC_kind_COMBO2, m_kind);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CADD message handlers

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

void CADD::OnOK() 
{
	// TODO: Add extra validation here
	SQL sql;
	UpdateData(true);
	CString str="driver={sql server};server=(local);database=phonebook;uid=sa;pwd=";
	sql.m_db.OpenEx(str);
	
	CString str1;
     
	
    if(m_kind.Compare("朋友")==0)
	{
	    str="insert into person(name,gender,phone,address) values('"+m_name+"','"+m_gender+"','"+m_phone+"','"+m_address+"')";
	    sql.m_db.ExecuteSQL(str);
	    if(sql.m_db.CanUpdate()) MessageBox("successful");	
	}
	if(m_kind.Compare("客户")==0)
	{
		str1="insert into customer(name,gender,phone,address) values('"+m_name+"','"+m_gender+"','"+m_phone+"','"+m_address+"')";
	
	   sql.m_db.ExecuteSQL(str1);
	   if(sql.m_db.CanUpdate()) MessageBox("successful");
	}
	//CDialog::OnOK();
}