Access ±¨±íɸѡÆ÷
µ±±¨±íʹÓùýɸѡÆ÷ºó£¬Ôٴδò¿ª±¨±íÏÔʾµÄ½á¹û»¹ÊÇÉÏ´ÎɸѡµÄ½á¹û£¬ÈçºÎÔٴδò¿ª±¨±í£¬ÊÇÊý¾Ý»¹Ôµ½Ã»ÓÃʹÓùýɸѡÆ÷µÄ״̬£¬¼´Access ±¨±íÔØÈëʱ£¬ËùÓÐÇå¿ÕɸѡÆ÷£¬ÊÇ·ñÊÇÔÚÔØÈëµÄµØ·½+VBA´úÂ룬ÈçºÎд
»òÕßÓÐûÓÐÆäËû°ì·¨£¿
лл
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÇëÎÊ
ÎÒʹÓÃ_accessº¯ÊýÈ¥ÅжÏÎļþÊÇ·ñ´æÔÚ
ͬһ¸öÓ¦ÓóÌÐòÔÚһ̨»úÆ÷ÉÏÔËÐÐʧ°Ü¶þÁíһ̨»úÆ÷ÉÏÈ´Êdzɹ¦µÄ
ËùÅжϵÄÎļþÊÇ´æÔÚ´ÅÅÌÉϵÄ
ÇëÎÊÕâÊÇʲô»ØÊ£¿
ÈçºÎʹÓã¿£¿if (0 == access(filename.c_str(), 0 ......