数据库上机考试预习报告.docx

stdafx.h中添加代码 #import C:\Program Files\Common Files\System\ado\msado15.dll no_namespace rename(EOF,adoEOF) rename(BOF,adoBOF)//导入类型库，连接数据库时候设置路径用msado15.dll去C盘中查找运行一下！！！解决方案资源管理器找在StudentExample.h中定义public:_ConnectionPtr m_pCon;BOOL ConnectDataBase(_ConnectionPtr m_pConnection,LPCTSTR DataBaseName,LPCTSTR UserID,LPCTSTR PassWord,long Options = adModeUnknown);在StudentExample.cpp中SetRegistryKey(_T(应用程序向导生成的本地应用程序))后面加代码：（改数据库名）if (!ConnectDataBase(m_pCon,LStudentManagment,L,L))return FALSE;//传递连接对象给登录界面AfxMessageBox(LDataBase Connected Succeedly!);在StudentExample.cpp尾部定义ConnectDataBase函数体：（改函数作用域）BOOL CStudentExampleApp::ConnectDataBase(_ConnectionPtr m_pConnection,LPCTSTR DataBaseName,LPCTSTR UserID,LPCTSTR PassWord,long Options){//初始化COM库::CoInitialize(NULL);//定义连接字符串CString strLinkWord;strLinkWord.Format(Ldriver={SQL Server};Server=127.0.0.1,1433;DATABASE=%s;,DataBaseName);if(!SUCCEEDED(m_pCon.CreateInstance(__uuidof(Connection)))) //注意这个地方是两道下划线{m_pCon = NULL;TRACE(Database CreateInstance failed);}ASSERT(m_pConnection != NULL); return SUCCEEDED(m_pConnection-Open(_bstr_t(strLinkWord),_bstr_t(UserID),_bstr_t(PassWord),Options)); //特别注意连接字符串} 运行，显示“DataBase Connected Succeedly!”解决方案资源管理器找StudentExampleDlg.h中定义public: _RecordsetPtr m_pRec; _RecordsetPtr DBRecordSetGet(LPCTSTR Sql); _ConnectionPtr m_pCon;StudentExample.cpp中添加代码：dlg.m_pCon=m_pCon;StudentExampleDlg.cpp中尾部添加代码：（改函数的作用域）_RecordsetPtr CStudentExampleDlg::DBRecordSetGet(LPCTSTR Sql){m_pRec.CreateInstance(ADODB.Recordset);m_pRec= m_pCon-Execute((_bstr_t)Sql,NULL,adCmdText);return m_pRec;}运行一下！！！解决方案资源管理器找StudentExampleDlg.h中定义public: BOOL GetCollect(LPCTSTR Name,_variant_t OutCol);StudentExampleDlg.cpp中尾部添加代码：（改函数的作用域）BOOL CStudentExampleDlg::GetCollect(LPCTSTR Name,_variant_t OutCol){_variant_t vt;vt = m_pRec-GetCollect(Name);if(vt.vt != VT_NULL){OutCol = vt;return TRUE;}elsereturn FALSE;}SQL新建查询：（。。。。。。。。。。。。。。。。。。。。。。粘贴复制之后，要执行，再保存）create proc login@SNo char(8),@Psd char(16)asSELECT COUNT(*) as NumFROM S