dialogadd.cpp

vc++ 利用ADO访问MYSQL数据

// DialogAdd.cpp : implementation file
//

#include "stdafx.h"
#include "Student.h"
#include "DialogAdd.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDialogAdd dialog


CDialogAdd::CDialogAdd(CWnd* pParent /*=NULL*/)
	: CDialog(CDialogAdd::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialogAdd)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDialogAdd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogAdd)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDialogAdd message handlers

void CDialogAdd::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
    CString straddnum,straddname,straddchinese,straddenglish,straddmaths,straddphyics,straddchemistry;
	GetDlgItemText(IDC_EDIT_ADDNUM,straddnum);
    GetDlgItemText(IDC_EDIT_ADDNAME,straddname);
	GetDlgItemText(IDC_EDIT_ADDCHINESE,straddchinese);
	GetDlgItemText(IDC_EDIT_ADDMATHS,straddmaths);
	GetDlgItemText(IDC_EDIT_ADDENGLISH,straddenglish);
	GetDlgItemText(IDC_EDIT_ADDPHYICS,straddphyics);
	GetDlgItemText(IDC_EDIT_ADDCHEMISTRY,straddchemistry);
	SetDlgItemText(IDC_EDIT_ADDNUM,_T(""));
	SetDlgItemText(IDC_EDIT_ADDNAME,_T(""));
	SetDlgItemText(IDC_EDIT_ADDCHINESE,_T(""));
	SetDlgItemText(IDC_EDIT_ADDMATHS,_T(""));
	SetDlgItemText(IDC_EDIT_ADDENGLISH,_T(""));
	SetDlgItemText(IDC_EDIT_ADDPHYICS,_T(""));
    SetDlgItemText(IDC_EDIT_ADDCHEMISTRY,_T(""));
	if (straddnum.GetLength()==0&&straddname.GetLength()==0&&straddmaths.GetLength()==0&&straddenglish.GetLength()==0&&straddchinese.GetLength()==0&&straddchemistry.GetLength()==0&&straddphyics.GetLength()==0)
	{
		MessageBox("请注意添加的记录不能为空！");
		return;
	}
    CString sql;
	sql.Format("insert into student (STU_NUM,STU_NAME,STU_CHINESE,STU_MATHS,STU_ENGLISH,STU_PHYSICS,STU_CHEMISTRY) values ('%s','%s','%s','%s','%s','%s','%s')",
		straddnum,straddname,straddchinese,straddmaths,straddenglish,straddphyics,straddchemistry);
    theApp.m_ado.ExeNoneQureSql(sql);
//	CDialog::OnOK();
}

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