操作数据库

最新推荐文章于 2024-11-03 09:30:00 发布

lovemy

最新推荐文章于 2024-11-03 09:30:00 发布

阅读量1.6k

点赞数

分类专栏：心情笔记文章标签：数据库 null

本文链接：https://blog.csdn.net/lovemy/article/details/579952

版权

心情笔记专栏收录该内容

7 篇文章 0 订阅

订阅专栏

CDbTools db;
_RecordsetPtr m_recordset = db.getResult("select * from product");
CString xfrq;
xfrq.Format("%d/%d/%d",m_xfrq.GetYear(),m_xfrq.GetMonth(),m_xfrq.GetDay());
m_recordset->AddNew();
m_recordset->PutCollect("cpmc",_variant_t(m_cpmc));
m_recordset->PutCollect("uid",_variant_t("1"));
m_var.iVal = m_sl;
m_recordset->PutCollect("sl",m_var.iVal);
m_recordset->PutCollect("lx",_variant_t(m_lx));
m_var.iVal = m_je;
m_recordset->PutCollect("je",m_var.iVal);
m_recordset->PutCollect("sccj",_variant_t(m_sccj));
m_recordset->PutCollect("xfrq",_variant_t(xfrq));
m_recordset->PutCollect("bz",_variant_t(m_bz));
m_recordset->PutCollect("bz",_variant_t(m_lrrq));
m_recordset->Update();
m_recordset->Close();
m_recordset=NULL;