简单ADO编程源代码分析.doc

简单ADO编程源代码分析1. / ADO.cpp : Defines the entry point for the console application. 2. / 3.4. #include stdafx.h 5. #include 6. #include 7. #include 8. #include 9. #import C:/Program Files/Common Files/System/ado/msado15.dll no_namespace rename(EOF, adoEOF) 10.11. using namespace std; 12.13.14. int _tmain(int argc, _TCHAR* argv) 15. 16. CoInitialize(NULL); /Initialize the com enviroment 17. _ConnectionPtr pMyConnect(_uuidof(Connection); /定义连接对象并实例化对象 18. _RecordsetPtr pRst(_uuidof(Recordset); /定义记录集对象并实例化对象 19. try 20. /打开数据库 21. /CString strConnect=DRIVER=Provider=Microsoft.Jet.OLEDB.4.0;Microsoft Access Driver(*.mdb);uid=;pwd=;DBQ=F:/C+ study/ADO/ADO/shujuku.mdb; 22. CString strConnect=DSN=RocketsPlayers;/ 23. DBQ=F:/C+ study/源程序/源程序/chap13/RocketsPlayers.mdb;/ 24. DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5; 25. /CString strConnect=Provider=SQLOLEDB;Data Source=F:/C+ study/ADO/ADO/shujuku.mdb; 26. pMyConnect-Open(_bstr_t)strConnect,NULL); 27. /pMyConnect-Open(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=shujuku.mdb;Persist Security Inof=False;,adModeUnknown); 28. 29. catch(_com_error &e) 30. 31. coutInitialize database failedendl; 32. coute.Description()endl; 33. coute.HelpFile()endl; 34. return 0; 35. 36.37. coutConnect database success!Execute(select * from Rockets, NULL, adCmdText); 41. if(!pRst-BOF) 42. 43. pRst-MoveFirst(); 44. 45. else 46. 47. coutThe data in the table is nullendl; 48. return 0; 49. 50.51. /存储表的所有列名 52. vector column_name; 53. for(int i=0; iFields-GetCount();i+) 54. 55. coutFields-GetItem(_variant_t(long)i)-NameFields-GetItem(_variant_t(long)i)-Name); 57. 58. coutadoEOF) 62. 63. vector:iterator iter = column_name.begin(); 64. /*for(iter;iter!=column_name.end();iter+) 65. */ 66. if(pRst-GetCollect(*iter).vt != VT_NULL) 67. 68. /coutGetCollect(*iter)/t/t i=iendl; 69. cout/tFields-Item_variant_t(PlayerID)-Value; 70. cout/tFields-Item_variant_t(Name)-Value; 71. cout/tFields-Item_variant_t(Number)-Value; 72. cout/tFields-Item_variant_t(Age)-Value; 73. cout/tFields-Item_variant_t(State)-Value; 74. cout/tFields-Item_variant_t(Height)-Value; 75. cout/tFields-Item_variant_t(Weight)-Value; 76. 77. else 78. 79. coutNULLMoveNext(); /关闭记录集 82. coutendl; 83.84. / 85. 86. 87. catch(_com_error &e) 88. 89. coute.Description()endl; 90. coute.HelpFile()Close(); /关闭记录集 97. pMyConnect-Close(); /关闭数据库 98. pRst.Release(); /释放记录集对象指针 99. pMyConnect.Release(); /释放连接对象指针 100. 101. catch(_com_error &e) 102. 103. coute.