软件工程课程设计任务书——图书管理系统(5)

软件工程课程设计——

m_rsDataSet.m_strFilter = m_rsDataSet.m_strFilter + "'"; } else { m_rsDataSet.m_strFilter = "BOOK_NAME='" + m_strBookNameQ; m_rsDataSet.m_strFilter = m_rsDataSet.m_strFilter + "'"; } }

m_rsDataSet.Requery(); DisplayRecord(); SetButtonState();

通过传递m_rsDataSet.m_strFilter="BOOK_ID='m_strBookIDQ AND BOOK_NAME=m_strBookNameQ"这个条件实现查询。 C、连接数据库使数据能够读出和导入

CBookDataSet::CBookDataSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CBookDataSet) m_BOOK_ID = _T(""); m_BOOK_NAME = _T(""); m_AUTHOR = _T(""); m_PRESS = _T(""); m_FLAG_BORROW = _T(""); m_nFields = 6; //图书信息的初始化 //}}AFX_FIELD_INIT m_nDefaultType = snapshot; }

CString CBookDataSet::GetDefaultConnect() { return _T("ODBC;DSN=Library"); //连接数据库 }

CString CBookDataSet::GetDefaultSQL() { return _T("[BOOK]"); }

void CBookDataSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CBookDataSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[BOOK_ID]"), m_BOOK_ID); RFX_Text(pFX, _T("[BOOK_NAME]"), m_BOOK_NAME); RFX_Text(pFX, _T("[AUTHOR]"), m_AUTHOR); RFX_Text(pFX, _T("[PRESS]"), m_PRESS); RFX_Text(pFX, _T("[PRESS_DATE]"), m_PRESS_DATE); RFX_Text(pFX, _T("[FLAG_BORROW]"), m_FLAG_BORROW);//将数据库中数据和界面文本控件关联起来 //}}AFX_FIELD_MAP }

/******************************************************************************************/

void CBookDlg::OnSave()

{ // TODO: Add your control notification handler code here