adddlg.cpp

使用ODBC访问SQL数据库

// AddDlg.cpp : implementation file
//

#include "stdafx.h"
#include "testODBC4.h"
#include "AddDlg.h"

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

#define IDMAX 403100	//4年级3班100号
#define IDMIN 101001	//1年级1班001号
/////////////////////////////////////////////////////////////////////////////
// CAddDlg dialog


CAddDlg::CAddDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddDlg)
	m_age = _T("24");
	m_class = _T("1");
	m_english = 80.0;
	m_grade = _T("3");
	m_id = 301001;
	m_math = 70.0;
	m_name = _T("李大美");
	m_physics = 68.0;
	m_politics = 86.0;
	m_sex = _T("女");
	m_adress = _T("湖北武汉");
	//}}AFX_DATA_INIT
}


void CAddDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddDlg)
	DDX_Text(pDX, IDC_age, m_age);
	DDX_Text(pDX, IDC_class, m_class);
	DDX_Text(pDX, IDC_english, m_english);
	DDX_Text(pDX, IDC_grade, m_grade);
	DDX_Text(pDX, IDC_id, m_id);
	DDX_Text(pDX, IDC_math, m_math);
	DDX_Text(pDX, IDC_name, m_name);
	DDX_Text(pDX, IDC_physics, m_physics);
	DDX_Text(pDX, IDC_politics, m_politics);
	DDX_Text(pDX, IDC_sex, m_sex);
	DDX_Text(pDX, IDC_adress, m_adress);
	//}}AFX_DATA_MAP
}


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

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

void CAddDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	if(m_id>IDMAX || m_id<IDMIN)
	{
		MessageBox("学号超出给定范围101001~403100");
		return;	
	}
	CDialog::OnOK();
}