AccessÊý¾Ý¿âÎÊÌ⣨ÐÂÄêµÚÒ»ÎÊ£©
ÎÒ´ÓÏÂλ»ú½ÓÊÕµ½Êý¾ÝÒÔºó±£´æÔÚAccessÊý¾Ý¿âÖУ¬È»ºóÏ뽫±£´æÔÚÊý¾Ý¿âÖеÄÄÚÈÝת´¢ÔÚÎÒÖ¸¶¨µÄÎļþ¼ÐÖУ¬Í¬Ê±×ª´¢µÄÄÚÈݸñʽ¿ÉÒÔÎÒ×Ô¼º¸ü¸Ä£¬±ÈÈçAccessÊý¾Ý¿â±£´æµÄÄÚÈÝÃûΪ£ºÊý¾ÝÃû.mdb£¬×ª´¢ÍêºóµÄÄÚÈÝÃûÎÒÏë±äΪ£ºÊý¾ÝÃû.ztf¡£µ«ÊÇͨ¹ý¼ÓÔØÎÒÄÜͨ¹ýAccessÊý¾Ý¿âÔÙת»»»Ø.mdb¸ñʽ£¬Äܲ鿴¡£ÇëÎÊÕâ¸öÐèÒªÔõô²Ù×÷°¡£¿×îºÃÔÚת´¢ÊǵÄÊý¾ÝÃûÒÔµçÄÔϵͳʱ¼äÃüÃû¡£
ûÓп´Ã÷°×,²Â ת´¢Íêºó,ÊÇ·ñÏë¸ÄÊý¾Ý¿âÃûΪµ±Ç°µçÄÔµÄÃû×Ö
Èç¹ûÊÇ,¾ÍÔÙName Óï¾äÖØÐÂÃüÃû
ת´¢£º
name "Êý¾ÝÃû.mdb" as now() & ".ztf"
¼ÓÔØ£º
name "2010-10-10 10:10:10.ztf" as "Êý¾ÝÃû.mdb"
Ŷ¡£¡£¡£ÎÒÔÙ×Ðϸ˵Ï¡£¾ÍÊÇÿ´ÎÎÒ´ÓÏÂλ»ú½ÓÊÕµÄÊý¾Ý¶¼±£´æÔÚAccessÊý¾Ý¿âÖÐÁË£¬µ«ÊDZ£´æµÄÄÚ´æ±È½Ï¶à£¬Ò»´Î´ó¸ÅÓÐ2000¶àÌõ£¬ÒªÊÇÏ´ÎÔÙ´ÓÏÂλ»ú½ÓÊÕÊý¾ÝµÄ»°AccessÊý¾Ý¿â»áºÜ¿ì±äÂýµÄ¡£ËùÒÔÎÒÏëÿ´ÎÔÚ±£´æºÃÕâ2000¶àÌõÊý¾ÝÒÔºóÄÜ´ÓAccessÊý¾Ý¿âÖÐÒÆ³ý£¬È»ºóµ¥¶À±£´æÔÚÎÒÒ»¸öÖ¸¶¨µÄÎļþ¼ÐÖУ¬Ãû×Ö¾ÍÊǵ±Ê±µÄʱ¼äºó׺ÃûΪ.ztf¡£Èç¹ûÒÔºóÏë²é¿´.ztfÖеÄÄÚÈÝÄÜÔÚͨ¹ý¼ÓÔØÔÚAccessÊý¾Ý¿âÖв鿴¡£
ACESSÊý¾Ý¿â£¨2003£©Ð¡ÓÚ1Gʱ£¬ÓòåÈëµÄ·½Ê½Èë¿â£¬ËٶȲ»»áºÜÂý¡£
Òª×öµ½ÄãµÄÏëµÄÒ²²»ÄÑ£¬¾ÍÓÃfilecopy¸´ÖÆÎļþµ½ÄãµÄÎļþ¼Ð£¬ÔÙɾ³ýµ±Ç°µÄ¿â£¬ÔÙ½¨Ò»¸öп⣬ÕâЩ¶¼ÓгÌÐòÈ¥Íê³É¾ÍÐÐÁË¡£
ÎļþÃû¿ÉÒÔÕâÑùÉú³Éformat(now,"yyyymmddhhmmss") & ".ztf"
ÓÃʱÔÙÓÃname¸ÄÃû¾ÍÐÐÁË¡£
°´ÎÒµÄÀí½âÄã¿ÉÒÔ×Ô¼ºÐÞ¸ÄÎļþµÄºó׺Ãû£¬Ò²¾ÍÊÇ˵£ºÔ´Îļþ£º1.mdb Äã¿ÉÒÔÖ±½ÓÐÞ¸ÄÆäºó׺Ãû£¬ÄãÒÀÈ»¿ÉÒÔÓÃ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 ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......