数据库编程new讲解.ppt

* * * * * * * * * * * * * * * * 为了算帐统计方便，会计可能喜欢这样设计表格，如幻灯片所示。 * 讲解目前这些表格可能出现的问题，可以采用提问方式。 * * * * * CASE：计算机辅助软件工程 (computer-aided software engineering) * CDM：Conceptual Data Model PDM：Physical Data Model OOM：Object Oriented Model BPM：Business Process Model * * * * * * * * * * * * * * * public: _ConnectionPtr m_pConnection; BOOL CADObApp::InitInstance() { ::CoInitialize(NULL); m_pConnection.CreateInstance(ADODB.Connection); m_pConnection- Open(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\vc++\\ADOb\\studentDB.mdb,,,adModeUnknown); 返回 protected: _RecordsetPtr m_pRecordset; m_pRecordset.CreateInstance(__uuidof(Recordset)); m_pRecordset-Open(SELECT * FROM STUDENT, theApp.m_pConnection.GetInterfacePtr(), adOpenDynamic,adLockOptimistic,adCmdText); //显示记录到界面上 DispRecord(); void CADODlg::DispRecord() { _variant_t theValue; //获取学号的值 if(!m_pRecordset-adoEOF) { theValue=m_pRecordset-GetCollect(stuID); if(theValue.vt!=VT_NULL) m_stuid=(char*)_bstr_t(theValue); //获取学生姓名 theValue=m_pRecordset-GetCollect(name); if(theValue.vt!=VT_NULL) m_name=(char *)_bstr_t(theValue); //获取学生年龄 theValue=m_pRecordset-GetCollect(age); if(theValue.vt!=VT_NULL) m_age=theValue.iVal; //获取学生性别 theValue=m_pRecordset-GetCollect(sex); if(theValue.vt!=VT_NULL) m_sex=(char *)_bstr_t(theValue); //获取学生专业 theValue=m_pRecordset-GetCollect(subject); if(theValue.vt!=VT_NULL) m_subject=(char *)_bstr_t(theValue); } UpdateData(FALSE);} void CADODlg::OnNextButton() { // TODO: Add your control notification handler code here m_pRecordset-MoveNext(); if(m_pRecordset-adoEOF) m_pRecordset-MoveLast(); DispRecord(); } void CADObDlg::OnPreButton() { // TODO: Add your control notification handler code here m_pRecordset-MovePrevious(); if(m_pRecordset-adoBOF)