ÇóÖú access ÎÞȨÏÞ´ò¿ª±í
°²×° SkyÓªÏú¹ÜÀíϵͳ ºó
ÓÐÎļþ Sample.sky , ÎÒ°ÑÕâÎļþ Ð޸ijÉSample.mdb
È»ºóÓÃaccess´ò¿ªSample.mdb £¨ÐèÒªÃÜÂ룩
È»ºó¿ÉÒÔ¿´µ½ËùÓбíµÄÁбíÒ³£¬
µ«ÊÇ´ò¿ª±íÌáʾ£º²»ÄܶÁÈ¡¶¨Ò壻¶Ô±í»ò²éѯ ¡®××ס¯Ã»ÓжÁÈ¡¶¨ÒåȨÏÞ
Çó¸÷λ°ï棡£¡£¡£¡
»¹Óиö System.mdwÎļþ Ó¦¸ÃÊÇ¿ØÖÆÈ¨Ï޵İÉ
²»ÊÇÖ»¶ÁÎļþ£¬
ÄÜÔÚaccess´ò¿ª Sample.mdb µ«ÊÇûÓÐÈκÎȨÏÞ ÈçÓÒ¼ü ¸´ÖÆ¡¢µ¼³ö¡¢É¾³ýµÈµÈ¶¼ÊDz»¿ÉÒ﵀ £¬
ÔÚÏëÊDz»ÊÇ¿ÉÒÔÈà Sample.mdb ºÍ System.mdw È¡Ïû°ó¶¨ »òÕßÓÐû±ðµÄ·½·¨ ÔÚËÑË÷ÄØ
{{
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......