caradddlg.cpp

利用odbc编程实现以下功能： 航班

// caradddlg.cpp : implementation file
//

#include "stdafx.h"
#include "dbexe.h"
#include "caradddlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Ccaradddlg dialog


Ccaradddlg::Ccaradddlg(CWnd* pParent /*=NULL*/)
	: CDialog(Ccaradddlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Ccaradddlg)
	m_location = _T("");
	m_price = 0;
	m_carnum = 0;
	m_caravail = 0;
	//}}AFX_DATA_INIT
}


void Ccaradddlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Ccaradddlg)
	DDX_Text(pDX, IDC_EDIT1, m_location);
	DDX_Text(pDX, IDC_EDIT2, m_price);
	DDX_Text(pDX, IDC_EDIT3, m_carnum);
	DDX_Text(pDX, IDC_EDIT4, m_caravail);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Ccaradddlg, CDialog)
	//{{AFX_MSG_MAP(Ccaradddlg)
	ON_BN_CLICKED(IDC_OK, OnOk)
	ON_BN_CLICKED(IDC_CANCEL, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Ccaradddlg message handlers

void Ccaradddlg::OnOk() 
{
	// TODO: Add your control notification handler code here
	if(!m_database.IsOpen()){
	m_database.Open(_T("database1"));
}
CString strSQL;
UpdateData(TRUE);
strSQL.Format("insert into cars values(\'%s\',%d,%d,%d)",m_location,m_price,m_carnum,m_caravail);
m_database.ExecuteSQL(strSQL);
m_database.Close();
CDialog::OnOK();
m_database.Close();	
}

void Ccaradddlg::OnCancel() 
{
	m_database.Close();
    CDialog::OnCancel();// TODO: Add your control notification handler code here
	
}