Access²éÕÒÖظ´ÎÊÌâ
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æʱ¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ÓеÄΪISBNºÅ£¬µ«ISBNºÅÓÐÖظ´£¬ÔõÑù±àдSQLÓïÑÔ£¬Ê¹ISBNÖÐΪ¿ÕÖµµÄÏî±£Áô£¬ÓÐÖµµÄÏîÖ»ÏÔʾһ´Î£¨Ò²¾ÍÊǹýÂ˵ôÖظ´µÄÏµ«×¢Òâµ±ISBNΪ¿ÕÊDZ£Áô£©
ÉÏ´«Äã²âÊÔÓõÄMDBÊý¾Ý¿âÎļþ
¿ÉÒÔÉÏ´«µ½ http://www.access911.net/csdn
ΪʲôȫΪ±¸×¢
ÒòΪ¶«Î÷±È½Ï¶à£¬ÓñðµÄÊôÐԷŲ»Ï£¬¡°±¸×¢¡±ÊôÐÔÔÊÐí·ÅµÄ×ֱȽ϶à
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
dim conn
dim connstr
dim db
dim dbpaswd (Õâ¸öÃÜÂë¼ÓÔÚÄÄ)
db=dbpath&"/"&dbname
connstr="DBQ="+server.mappath(""&db&"")+" ......
ÎÒдÁ˸ö²É¼¯³ÌÐò£¬Ôڲɼ¯µÄʱºò´ò¿ª²»ÁËÍøÕ¾£¬²É¼¯ÍêÁËÊý¾Ý¿âÊÍ·ÅÁ˲ſÉÒÔ´ò¿ª
ÇëÎÊÈçºÎ×öµ½²É¼¯ºÍä¯ÀÀ²»³åÍ»£¬Ò²¾ÍÊÇ˵²É¼¯Ê±ÍùÊý¾Ý¿âдÊý¾Ýʱ£¬Í¬Ñù¿ÉÒÔÕý³£¶ÁÈ¡Êý¾Ý £¿
ллÄãµÄ½¨Ò飬²»¹ý²»ÊʺÏÎÒÓà ......
ÎÒÓÃAccessµÄʱºò£¬IDÊÇÖ÷¼ü×Ô¶¯Éú³É¡£
ÄDzåÈëÒ»Ìõ¼Ç¼µÄʱºò£¬ÔÚÖ´ÐÐÁ˲åÈëÓï¾äÖ®ºó»¹ÓÐÒ»¸ö´úÂëstring sqlGetId = "select max(Nid) from News" ;
ÊÇÏë»ñÈ¡¸Õ²Å²åÈëµÄ¼Ç¼ËùÉú³ÉµÄID£¬¿ÉÊÇÿ´Î»ñÈ ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖظ´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖظ´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......