hoteladddlg.cpp

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

// hoteladddlg.cpp : implementation file
//

#include "stdafx.h"
#include "dbexe.h"
#include "hoteladddlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Choteladddlg dialog


Choteladddlg::Choteladddlg(CWnd* pParent /*=NULL*/)
	: CDialog(Choteladddlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Choteladddlg)
	m_location = _T("");
	m_price = 0;
	m_roomnum = 0;
	m_roomavail = 0;
	//}}AFX_DATA_INIT
}


void Choteladddlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Choteladddlg)
	DDX_Text(pDX, IDC_EDIT1, m_location);
	DDX_Text(pDX, IDC_EDIT2, m_price);
	DDX_Text(pDX, IDC_EDIT3, m_roomnum);
	DDX_Text(pDX, IDC_EDIT4, m_roomavail);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Choteladddlg message handlers

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