Visual c++ 6.0 ADO access
ADO¿â°üº¬Èý¸ö»ù±¾½Ó¿Ú:_ConnectionPtr½Ó¿Ú¡¢_CommandPtr½Ó¿ÚºÍ_RecordsetPtr½Ó¿Ú¡£
_ConnectionPtr½Ó¿Ú·µ»ØÒ»¸ö¼Ç¼¼¯»òÒ»¸ö¿ÕÖ¸Õë¡£
ͨ³£Ê¹ÓÃËüÀ´´´½¨Ò»¸öÊý¾ÝÁ¬½Ó»òÖ´ÐÐÒ»Ìõ²»·µ»ØÈκνá¹ûµÄSQLÓï¾ä£¬ÈçÒ»¸ö´æ´¢¹ý³Ì¡£
ʹÓÃ_ConnectionPtr½Ó¿Ú·µ»ØÒ»¸ö¼Ç¼¼¯²»ÊÇÒ»¸öºÃµÄʹÓ÷½·¨¡£
ͨ³£Í¬CdatabaseÒ»Ñù£¬Ê¹ÓÃËü´´½¨Ò»¸öÊý¾ÝÁ¬½Ó£¬È»ºóʹÓÃÆäËü¶ÔÏóÖ´ÐÐÊý¾ÝÊäÈëÊä³ö²Ù×÷¡£
_CommandPtr½Ó¿Ú·µ»ØÒ»¸ö¼Ç¼¼¯¡£
ËüÌṩÁËÒ»ÖÖ¼òµ¥µÄ·½·¨À´Ö´Ðзµ»Ø¼Ç¼¼¯µÄ´æ´¢¹ý³ÌºÍSQLÓï¾ä¡£
ÔÚʹÓÃ_CommandPtr½Ó¿Úʱ£¬Äã¿ÉÒÔÀûÓÃÈ«¾Ö_ConnectionPtr½Ó¿Ú£¬Ò²¿ÉÒÔÔÚ_CommandPtr½Ó¿ÚÀïÖ±½ÓʹÓÃÁ¬½Ó´®¡£
Èç¹ûÄãÖ»Ö´ÐÐÒ»´Î»ò¼¸´ÎÊý¾Ý·ÃÎʲÙ×÷£¬ºóÕßÊDZȽϺõÄÑ¡Ôñ¡£
µ«Èç¹ûÄãҪƵ·±·ÃÎÊÊý¾Ý¿â£¬²¢Òª·µ»ØºÜ¶à¼Ç¼¼¯£¬ÄÇô£¬ÄãÓ¦¸ÃʹÓÃÈ«¾Ö_ConnectionPtr½Ó¿Ú´´½¨Ò»¸öÊý¾ÝÁ¬½Ó£¬
È»ºóʹÓÃ_CommandPtr½Ó¿ÚÖ´Ðд洢¹ý³ÌºÍSQLÓï¾ä¡£
_RecordsetPtrÊÇÒ»¸ö¼Ç¼¼¯¶ÔÏó¡£
ÓëÒÔÉÏÁ½ÖÖ¶ÔÏóÏà±È£¬Ëü¶Ô¼Ç¼¼¯ÌṩÁ˸ü¶àµÄ¿ØÖƹ¦ÄÜ£¬Èç¼ÇÂ¼Ëø¶¨£¬ÓÎ±ê¿ØÖÆµÈ
¡£Í¬_CommandPtr½Ó¿ÚÒ»Ñù£¬Ëü²»Ò»¶¨ÒªÊ¹ÓÃÒ»¸öÒѾ´´½¨µÄÊý¾ÝÁ¬½Ó£¬
¿ÉÒÔÓÃÒ»¸öÁ¬½Ó´®´úÌæÁ¬½ÓÖ¸Õ븳¸ø_RecordsetPtrµÄconnection³ÉÔ±±äÁ¿£¬ÈÃËü×Ô¼º´´½¨Êý¾ÝÁ¬½Ó¡£
Èç¹ûÄãҪʹÓöà¸ö¼Ç¼¼¯£¬×îºÃµÄ·½·¨ÊÇͬCommand¶ÔÏóÒ»ÑùʹÓÃÒѾ´´½¨ÁËÊý¾ÝÁ¬½ÓµÄÈ«¾Ö_ConnectionPtr½Ó¿Ú
£¬È»ºóʹÓÃ_RecordsetPtrÖ´Ðд洢¹ý³ÌºÍSQLÓï¾ä¡£
(1)³õʼ»¯COM¿â£¬ÒýÈëADO¿â¶¨ÒåÎļþ
(2)ÓÃConnection¶ÔÏóÁ¬½ÓÊý¾Ý¿â
(3)ÀûÓý¨Á¢ºÃµÄÁ¬½Ó£¬Í¨¹ýConnection¡¢Command¶ÔÏóÖ´ÐÐSQLÃüÁ»òÀûÓÃRecordset¶ÔÏóÈ¡µÃ½á¹û¼Ç
¼¼¯½øÐвéѯ¡¢´¦Àí¡£
(4)ʹÓÃÍê±Ïºó¹Ø±ÕÁ¬½ÓÊͷŶÔÏó¡£
ÎÒÃÇ¿ÉÒÔʹÓÃAfxOleInit()À´³õʼ»¯COM¿â£¬ÕâÏ×÷ͨ³£ÔÚCWinApp::InitInstance()µÄÖØÔØº¯ÊýÖÐÍê
³É£¬Çë¿´ÈçÏ´úÂë:
BOOL CADOTest1App::InitInstance()
{
AfxOleInit();
......
}
ÎÒÃÇÔÚstdafx.hÖмÓÈëÈçÏÂÓï¾ä£º
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
Æä×îÖÕ×÷ÓÃͬÎÒÃÇÊìϤµÄ#includeÀàËÆ,±àÒëµÄʱºòϵͳ»áΪÎÒÃÇÉú³Émsado15.tlh,ado15.tliÁ½¸öC++Í·ÎļþÀ´¶¨ÒåADO¿â¡£
Ê×ÏÈÎÒÃÇÐèÒªÌí¼ÓÒ»¸öÖ¸ÏòConnection¶ÔÏóµÄÖ¸Õë:
_ConnectionPtr m_pConnection;
BOOL CADOTest1Dlg::OnInitDialog()
{
CDialog::OnInitDialog();
try
{
HRESULT hr = m_pConnection.CreateInstance("ADO
Ïà¹ØÎĵµ£º
ÎÊ:
È·ÈÏÒ»ÏÂc++Öв»ÄÜʹÓÃinterface£¨Èçjava£©ÄÇÑùµÄ¹¦ÄܰÑ
ÎÒÈÏΪÊDz»Äܵģ¬×¢ÒâÎÒ˵µÄÊÇinterface£¨ÓÃÓÚjava¶àÖØ¼Ì³ÐµÄÄǸö£¬²»ÊÇÒ»°ãÒâÒåµÄ½Ó¿Ú£©
ÎÒ¾õµÃÊÇûÓе쬵«ÊÇÍøÉÏËÑË÷˵ʲôµÄ¶¼ÓжøÇÒÈË»¹²»ÉÙ…… ËùÒÔÏ£Íû´ó¼ÒÄܸøÎÒÒ»¸öÃ÷È·µÄ´ð¸´ºÃô£¿×îºÃÄÜ»¹ÓÐһР......
¸øÎÒÃÇÉÏASP.NETµÄÀÏʦÔÚ½²½âC#µÄʱºò£¬×ÜÊÇҪѯÎÊÎÒÃÇC#ºÍC/C++¼äµÄ²»Í¬Ö®´¦£¬»òÕßһЩϸ½ÚÎÊÌ⣬µ«ÊÇÆ½Ê±²»ÔõôעÒ⣬»¹Õæ°ÑÎÒÃǸøÎʵ½ÁË£¡£¡
Ò».²»¾¹ýÖмä±äÁ¿ÔõÑù½»»»Á½¸öÊý¾Ý int a=25;b=10;
½â·¨: a=a+b;//35
b=a-b;//25
  ......
Îå¡¢Îļþ¶¨Î»
¡¡¡¡ºÍCµÄÎļþ²Ù×÷·½Ê½²»Í¬µÄÊÇ£¬C++ I/Oϵͳ¹ÜÀíÁ½¸öÓëÒ»¸öÎļþÏàÁªÏµµÄÖ¸Õë¡£Ò»¸öÊǶÁÖ¸Õ룬Ëü˵Ã÷ÊäÈë²Ù×÷ÔÚÎļþÖеÄλÖã»ÁíÒ»¸öÊÇдָÕ룬ËüÏ´Îд²Ù×÷µÄλÖá£Ã¿´ÎÖ´ÐÐÊäÈë»òÊä³öʱ£¬ÏàÓ¦µÄÖ¸Õë×Ô¶¯±ä»¯¡£ËùÒÔ£¬C++µÄÎļþ¶¨Î»·ÖΪ¶ÁλÖúÍдλÖõĶ¨Î»£¬¶ÔÓ¦µÄ³ÉÔ±º¯ÊýÊÇ seekg()ºÍ seekp()£¬seekg()ÊÇ ......
½ñÌì¹éÄÉ×ܽáÒ»ÏÂÎļþ²Ù×÷º¯Êý¼°¸÷¸ö²ÎÊýµÄº¬Òå:
ÏȽéÉÜÒ»ÏÂc++µÄÎļþ²Ù×÷£¬ÎªÊ²Ã´Ëµc++µÄÎļþ²Ù×÷ÄØ£¬ÒòΪ¶ÔÓÚcÓïÑԵIJÙ×÷£¬Ò²ÓÐËüµÄº¯ÊýÖ®²»¹ý´óͬСÒì°ÕÁË¡£
ÔÚc++µÄÎļþ²Ù×÷ÖÐÓУ¬ÓÐÒ»¸öÀà¶ÔÎļþ²Ù×÷½øÐвÙ×÷£¬¼´CFile£¬ÏÂÃæ¾Íдһ¶Î´úÂ룬À´¼òµ¥µÄ½øÐнéÉÜ¡£
CFile cf;
char zhi[]={1,2};
&n ......