VC数据库操作实例解析(ADO技术使用一个辅助类来进行操作).doc

在工程里添?加两个文件?： 1、DataM?anage?1.h // DataM?anage?1.h: inter?face for the CData?Manag?e class?. // ////////////////////////////////////////////////////////////////////// #if !defin?ed(AFX_D?ATAMA?NAGE1?_H__D?EAF61?0B_45?5E_45?55_B5?34_B8?56E70?F2E46?__INC?LUDED?_) #defin?e AFX_D?ATAMA?NAGE1?_H__D?EAF61?0B_45?5E_45?55_B5?34_B8?56E70?F2E46?__INC?LUDED?_ #if _MSC_?VER 1000 #pragm?a once #endif? // _MSC_?VER 1000 class? CData?Manag?e { publi?c: CData?Manag?e(); virtu?al ~CData?Manag?e(); publi?c: _Reco?rdset?Ptr Recor?d1; _Reco?rdset?Ptr Recor?d2; prote?cted: _Conn?ectio?nPtr DataC?onn; _Reco?rdset?Ptr DataR?ecord?; publi?c: // bool InfoI?sExis?t(CStri?ng sTabl?e,CStri?ng fathe?rID,CStri?ng sTemp?NewNu?mber); // CStri?ng AutoN?umber?(CStri?ng sTabl?e,CStri?ng sFiel?dName?,CStri?ng fathe?rID,int categ?ory); CStri?ng Padl(CStri?ng n,int in,CStri?ng c); CStri?ng AutoN?umber?(CStri?ng sTabl?e,CStri?ng sFiel?dName?,CStri?ng categ?oryNa?me); _Conn?ectio?nPtr GetCo?nn();//获取ado?Conne?ction?对象 _Reco?rdset?Ptr GetRe?cords?et();//获取ado?Recor?dset对?象 bool Conne?ctDat?abase?(CStri?ng const?r); //连接数据库? bool ExecS?QL(CStri?ng sql); }; #endif? // !defin?ed(AFX_D?ATAMA?NAGE1?_H__D?EAF61?0B_45?5E_45?55_B5?34_B8?56E70?F2E46?__INC?LUDED?_) 2、DataM?anage?1.cpp： // DataM?anage?1.cpp: imple?menta?tion of the CData?Manag?e class?. // ////////////////////////////////////////////////////////////////////// #inclu?de stdaf?x.h #inclu?de DataM?anage?1.h //#inclu?de Exter?nDllH?eader?.h #inclu?de strin?g.h #ifdef? _DEBU?G #undef? THIS_?FILE stati?c char THIS_?FILE[]=__FIL?E__; #defin?e new DEBUG?_NEW #endif? //HINST?ANCE hInst?ance; ////////////////////////////////////////////////////////////////////// // Const?ructi?on/Destr?uctio?n ////////////////////////////////////////////////////////////////////// CData?Manag?e::CData?Manag?e() { //hInst?ance =LoadL?ibrar?y(RxDLL?.dll); DataC?onn.Creat?eInst?ance(_uuid?of(Conne?ction?)); DataR?ecord?.Creat?eInst?ance(_uuid?of(Recor?dset));