4,011
社区成员
发帖
与我相关
我的任务
分享
BOOL CBook_Dao::Alter(CBook * pBook)//修改图书信息
{
CString Tsql;//sql语句
Tsql = _T("select * from book where bookNo = '");
Tsql = Tsql + pBook->getBookNo();
Tsql = Tsql + _T("' and bookColor = '");
Tsql = Tsql + pBook->getColor();
Tsql = Tsql + _T("'");
try//尝试打开记录集
{
m_pRecordset->Open(_bstr_t(Tsql), m_pConnection.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdText);
}
catch (_com_error e)//失败则跳出警示
{
AfxMessageBox(e.Description());
return FALSE;
}
//录入修改数据
//------------------
m_pRecordset->PutCollect("bookNo", _variant_t(pBook->getBookNo()));
m_pRecordset->PutCollect("bookColor", _variant_t(pBook->getColor()));
m_pRecordset->PutCollect("bookName", _variant_t(pBook->getBookName()));
m_pRecordset->PutCollect("author", _variant_t(pBook->getAuthor()));
m_pRecordset->PutCollect("publish", _variant_t(pBook->getPublish()));
m_pRecordset->PutCollect("price", _variant_t(pBook->getPrice()));
//------------------
m_pRecordset->Update();//更新数据库-将新纪录存入数据库
m_pRecordset->Close();//关闭记录集
return TRUE;
}
BOOL CBook_Dao::Del(CBook * pBook)//删除图书信息
{
CString Tsql;
Tsql = _T("select * from book where bookNo = '");
Tsql = Tsql + pBook->getBookNo();
Tsql = Tsql + _T("' and bookColor = '");
Tsql = Tsql + pBook->getColor();
Tsql = Tsql + _T("'");
try//尝试打开记录集
{
m_pRecordset->Open(_bstr_t(Tsql), m_pConnection.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdText);
}
catch (_com_error e)//失败则跳出警示
{
AfxMessageBox(e.Description());
return FALSE;
}
m_pRecordset->Delete(adAffectCurrent);
m_pRecordset->Update();//更新数据库-将新纪录存入数据库
m_pRecordset->Close();//关闭记录集
return TRUE;
}