代码如下:
// AddWuziinfor.cpp : 实现文件
//
#include "stdafx.h"
#include "AddWuziinfor.h"
#include "MyApp.h"
// CAddWuziinfor 对话框
IMPLEMENT_DYNAMIC(CAddWuziinfor, CDialog)
CAddWuziinfor::CAddWuziinfor(CWnd* pParent /*=NULL*/)
: CDialog(CAddWuziinfor::IDD, pParent)
, mWuziCode(_T(""))
, mDanwei(_T(""))
, mWeight(_T(""))
, mUselife(_T(""))
{
}
CAddWuziinfor::~CAddWuziinfor()
{
}
void CAddWuziinfor::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
DDX_Text(pDX, IDC_WuziCode, mWuziCode);
DDV_MaxChars(pDX, mWuziCode, 10);
DDX_Text(pDX, IDC_Danwei, mDanwei);
DDV_MaxChars(pDX, mDanwei, 4);
DDX_Text(pDX, IDC_Weight, mWeight);
DDV_MaxChars(pDX, mWeight, 4);
DDX_Text(pDX, IDC_Uselife, mUselife);
DDV_MaxChars(pDX, mUselife, 10);
}
BEGIN_MESSAGE_MAP(CAddWuziinfor, CDialog)
ON_BN_CLICKED(IDOK, &CAddWuziinfor::OnBnClickedOk)
END_MESSAGE_MAP()
// CAddWuziinfor 消息处理程序
void CAddWuziinfor::OnBnClickedOk()
{
// TODO: 在此添加控件通知处理程序代码
//OnOK();
//取到数据
UpdateData(true);
//根据变量组合一个sql语句
CString sql;
sql.Format(L"insert into wuziinfor values('%s','%s','%s','%s')",
mWuziCode,mDanwei,mWeight,mUselife);
_variant_t v;
if(((CMyApp*)AfxGetApp())->mDB.ExecuteSQL((_bstr_t)sql,&v))
{
CString s;
AfxMessageBox(L"成功的添加了"+CAdoDB::toString(v)+L"个学生信息");
}
}
ExecuteSQL 这个函数应该不支持传递两个参数