VC++ÍùACCESSдÊý¾ÝµÄÎÊÌâ - VC/MFC / Êý¾Ý¿â
ÎÒÔÚVC++ÀﶨÒåÁ˼¸¸öÈ«¾Ö±äÁ¿£¬¾¹ýһϵÁеļÆËãÖ®ºó£¬½«ÕâЩȫ¾Ö±äÁ¿µÄÖµ´æµ½ACCESS¶ÔÓ¦µÄ×Ö¶ÎÏÂÃæ¡£²»Öª¸ÃÈçºÎʵÏÖ¡£Õ⼸¸ö±äÁ¿ÓÐSTRING£¬Ò²ÓÐDOUBLEÀàÐ͵ġ£¸ÃACCESS²»ÓëÈκζԻ°¿òÓбäÁ¿Êý¾Ý´«µÝµÄÁªÏµ£¬½ö½öÊÇ´¢´æ×îºóºÍһϵÁнá¹û¡£
ÎҵijÌÐòÓõÄÊÇODBC£¬²»ÊÇADO¡£¿ÉÒÔÔÚODBCÉÏÌî ¼ÓADOµÄÓï¾äÂð£¿
²»ÒªÓÃODBC£¬ÄÇʱ×îÔçµÄ¼¼Êõ£¬ADO±ÈËü¿ìËÙÏȽø£¬ODBCºÍADO
ÊÇÁ½ÖÖ¼¼Êõ£¬²»ÄÜ»¥²Ù×÷¡£
·ÇÒªÓÃODBCµÄ»°£¬ÔÚÉÏÃæÄǸöÍøÕ¾ÕÒÕÒÀý×Ó¡£
Ò»£®¸ÅÊö
----ODBCÊÇÒ»ÖÖʹÓÃSQLµÄ³ÌÐòÉè¼Æ½Ó¿Ú¡£Ê¹ÓÃODBCÈÃÓ¦ÓóÌÐòµÄ±àдÕß±ÜÃâÁËÓëÊý¾ÝÔ´ÏàÁªµÄ¸´ÔÓÐÔ¡£ÕâÏî¼¼ÊõĿǰÒѾµÃµ½ÁË´ó¶àÊýDBMS³§ÉÌÃǵĹ㷺֧³Ö¡£
----Microsoft Developer StudioΪ´ó¶àÊý±ê×¼µÄÊý¾Ý¿â¸ñʽÌṩÁË32λODBCÇý¶¯Æ÷¡£ÕâЩ±ê×¼Êý¾Ý¸ñʽ°üÀ¨ÓУºSQL Server¡¢Access¡¢Paradox¡¢dBase¡¢FoxPro¡¢Excel¡¢OracleÒÔ¼°Microsoft Text¡£Èç¹ûÓû§Ï£ÍûʹÓÃÆäËûÊý¾Ý¸ñʽ£¬Óû§ÐèÒªÏàÓ¦µÄODBCÇý¶¯Æ÷¼°DBMS¡£
----Óû§Ê¹ÓÃ×Ô¼ºµÄDBMSÊý¾Ý¿â¹ÜÀí ¹¦ÄÜÉú³ÉеÄÊý¾Ý¿âģʽºó£¬¾Í¿ÉÒÔʹÓÃODBCÀ´µÇ¼Êý ¾ÝÔ´¡£¶ÔÓû§µÄÓ¦ÓóÌÐòÀ´Ëµ£¬Ö»Òª°²×°ÓÐÇý¶¯³ÌÐò£¬¾ÍÄÜ×¢²áºÜ¶à²»Í¬µÄÊý¾Ý¿â¡£µÇ¼Êý¾Ý¿âµÄ¾ßÌå²Ù×÷²Î¼ûÓйØODBCµÄÁª»ú°ïÖú¡£
--------------------------------------------------------------------------------
¶þ£®MFCÌṩµÄODBCÊý¾Ý¿âÀà
----VisualC++µÄMFC»ùÀà¿â¶¨ÒåÁ˼¸¸öÊý¾Ý¿âÀà¡£ÔÚÀûÓÃODBC±à³Ìʱ£¬¾³£ÒªÊ¹Óõ½CDatabase(Êý¾Ý¿âÀà)£¬CRecordSet(¼Ç¼¼¯Àà)ºÍCRecordView(¿ÉÊӼǼ¼¯Àà)¡£ Æ
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
´ó¼ÒºÃ£º
ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿
ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......