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À´´ò¿ªÐ޸ĺó׺ÃûºóµÄÎļþ£¬ÎÒ¾³£Õâô¸É¡£
{{--
Ïà¹ØÎÊ´ð£º
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......