sqldlg.cpp

VC++高级编程技巧与示例

// SQLDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ODBCSQL.h"
#include "SQLDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSQLDlg dialog


CSQLDlg::CSQLDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSQLDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSQLDlg)
	//}}AFX_DATA_INIT
	m_Statement="SELECT Account.ID,Account.帐号,"
				   "Basic.姓名, Account.存款, Basic.性别\r\n"
				   " FROM Basic INNER \r\nJOIN Account "
				   "ON Basic.ID = Account.ID \r\n"
				   "ORDER BY Account.存款 DESC;";
}


void CSQLDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSQLDlg)
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CSQLDlg message handlers

void CSQLDlg::OnOK() 
{
	// TODO: Add extra validation here
	GetDlgItemText(IDC_EDIT1,m_Statement);
	CDialog::OnOK();
}

BOOL CSQLDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	SetDlgItemText(IDC_EDIT1,m_Statement);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}