mfcÔõÑù²åÈëaccessÊý¾Ý¿â? - VC/MFC / Êý¾Ý¿â
ÎÒÏë×öÒ»¸ö¹¤³Ì£¬ÓÐÁ½¸öexeµÄÎļþ£¬¹²Í¬ÔËÓÃͬһ¸öÊý¾Ý¿â£¬¶Ôͬһ¸öÊý¾Ý¿âµÄÎļþ½øÐвÙ×÷£¬µ«ÊÇ£¬²»ÖªµÀÔõôÔÚÆäÖвÁÈëÒ»¸öÊý¾Ý¿â£¬Íû¸ãÈËÖ¸µã
Èç¹ûÓÐÁ½¸öexeµÄ´úÂë¸Ä´úÂë¾ÍÐÐÁË,ûÓеϰ¾Í²»ÖªµÀÁË.
ÐèÒªÓõ½½ø³Ì¼äͨѶÎÊÌ⣡
{{
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......