delphi7+accessÔõôʵÏÖÊý¾Ý¿â×·¼Ó¼Ç¼µ½Êý¾Ý¿âÖУ¿
delphi7+accessÔõôʵÏÖÊý¾Ý¿â×·¼Ó¼Ç¼µ½Êý¾Ý¿âÖУ¿
ACCESSÓÐÊÖ¶¯×·¼Ó¹¦ÄÜ£¬¾ÉÊý¾Ý²»¶¯£¬°ÑеļÓÉÏ¡£ÎÒÏëÈÃÈí¼þʵÏÖÕâ¸ö¹¦ÄÜ£¬ÄÜʵÏÖÂð£¿
ÓÐûÓÐÀý×ÓÖ®ÀàµÄ£¿
·Ç³£¸Ðл£¡
ÊÇACCESS¼Óµ½ACCESSÀï¡£Á½¸öÈ˶¼²Ù×÷ACCESS¼Ç¼£¬ÎÒÏëÈÃÈí¼þÄÜ×Ô¼ººÏÆðÀ´¡£
ʵÏÖÊý¾Ý¿â×·¼Ó¼Ç¼µ½Êý¾Ý¿âÖУ¿
²»Ì«Ã÷°×£¬×îºÃ½²Ï¸µã¡£
Ò»¸öÒ»¸ö±íµØÀ´¡£ÓÃOpendatasource»òÕßOpenrowsetº¯Êý£¬Õâ¶ùÓиöOpendatasourceµÄÀý×Ó
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'c:\trade.mdb'; 'admin'; '', ±íÃû)
SELECT *
from sqltablename
¾ßÌåÄã²é²éSQL°ïÖúÎĵµµÄOpendatasourceº¯Êý£¬ÀïÃæ½²ºÜÇå³þ
Ò»¸öÈí¼þ£¬Á½¸ö²»ÁªÍøµÄ¿Í»§Ê¹Óã¬ACCESS´æ´¢Êý¾Ý¡£Á½¸öÈËÏë·Ö±ð²Ù×÷£¬µ«ÓÐʱ¿ÉÄÜ»¥»»Êý¾Ý²¢ºÏÆðÀ´¡£»¹²»ÄÜÖ±½ÓÌæ»»Êý¾Ý¿â£¬ÒòΪ»á¶ªÊ§¼Ç¼¡£
Êý¾Ý¿âͬ²½ÎÊÌ⣬Èç¹ûÒªÇóͬ²½½øÀ´»¹ÄÜͬ²½¿ª·¢£¬¿ÉÒÔ°ÑË÷ÒýÉèΪGUID
Á½±ß¸÷×Ôµ¼³ö±¾»úµÄ¼Ç¼ÖÁXMLÎļþ£¬»¥Ïཻ»»XMLÎļþ£¬ÔÙ¸÷×Ôµ¼Èë¡£
½ö¹©Â¥Ö÷²Î¿¼
¼ÇµÃ×Ô¼ºµÄ¼Ç¼Ҫ×ö±êʶ£¬ÒÔ¼°µ¼³ö¹ýµÄ¼Ç¼ҲҪ×ö±êʶ£¬ÒÔÃâÏ´ÎÖظ´µ¼³ö¡£Ö»µ¼³ö×Ô¼ºµÄºÍûÓе¼³ö¹ýµÄ¼Ç¼¡£
Õâ¸öÊÇÉè¼ÆʱҪ¿¼ÂǺõġ£
ʵ¼Êµ¼ÈëʱҪһ¸ö±íÒ»¸ö±íÀ´¡£
Ïà¹ØÎÊ´ð£º
ÒÑÖªPython ÖУº
s = unicode("²âÊÔ", "gb2312")
s = u'\u6d4b\u8bd5'
print s
²âÊÔ
ÔÚDelphiÀïÃæÈçºÎ½«\u6d4b\u8bd5ÕâÑùµÄ»¹Ô³ÉGb2312µÄºº×ÖÄØ£¿
ÕÒµ½¸ö·½·¨
......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æʱ¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
Çë½Ì¸÷·¸ßÊÖ¡£ÎäÁÖÇ°±²¡£ÎÒ½«B.EXE×ö³É×ÊÔ´Îļþ£¬È»ºó¼Óµ½123.dllÖС£ÓÃA.EXEÀ´µ÷ÓÃ123.dllÖеÄB.EXE
Çë¸÷λǰ±²°ïæָ½ÌÏ¡£A.exeÈçºÎÀ´µ÷ÓÃdllÖеÄexe£¿´úÂëÓÖ¸ÃÈçºÎд£¿
ÎÞÈ˻شð£¿
×ö³É×ÊÔ´Î ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éÏ°ïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ³£ÉÏÀ´×ª×ªµÄ
ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔÒò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......