ÇóÖú access ÎÞȨÏÞ´ò¿ª±í
°²×° SkyÓªÏú¹ÜÀíϵͳ ºó
ÓÐÎļþ Sample.sky , ÎÒ°ÑÕâÎļþ Ð޸ijÉSample.mdb
È»ºóÓÃaccess´ò¿ªSample.mdb £¨ÐèÒªÃÜÂ룩
È»ºó¿ÉÒÔ¿´µ½ËùÓбíµÄÁбíÒ³£¬
µ«ÊÇ´ò¿ª±íÌáʾ£º²»ÄܶÁÈ¡¶¨Ò壻¶Ô±í»ò²éѯ ¡®××ס¯Ã»ÓжÁÈ¡¶¨ÒåȨÏÞ
Çó¸÷λ°ï棡£¡£¡£¡
»¹Óиö System.mdwÎļþ Ó¦¸ÃÊÇ¿ØÖÆÈ¨Ï޵İÉ
²»ÊÇÖ»¶ÁÎļþ£¬
ÄÜÔÚaccess´ò¿ª Sample.mdb µ«ÊÇûÓÐÈκÎȨÏÞ ÈçÓÒ¼ü ¸´ÖÆ¡¢µ¼³ö¡¢É¾³ýµÈµÈ¶¼ÊDz»¿ÉÒ﵀ £¬
ÔÚÏëÊDz»ÊÇ¿ÉÒÔÈà Sample.mdb ºÍ System.mdw È¡Ïû°ó¶¨ »òÕßÓÐû±ðµÄ·½·¨ ÔÚËÑË÷ÄØ
{{
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......