ACCESS Êý¾Ý¿â²éѯµÄÎÊÌâ
ÈçÉÏͼ£¬Õâ¸öÊÇÎÒÔÚACCESSÊý¾Ý¿âÖн¨Á¢µÄÒ»¸ö²éѯ£¬±íÃûΪddcx
ÓÃsql="select * from ddcx order by id desc"
<%=rs("userid")%>¿ÉÒÔÏÔʾ£¬
µ«ÊÇÓÃ<%=rs("chanpin.name")%>ºÍ<%=rs("danhao.name")%>È´ÔõôҲÏÔʾ²»³öÀ´
ÓÐûÓиßÊÖ¸æËßÎÒΪʲôѽ£¿
ÓÑÇéÖ§³Ö
Â¥Éϵģ¬¿ÉÒÔÁË£¬ÇëÎÊÕâ¸öÊÇΪʲôѽ
×ֶδÓ0¿ªÊ¼£¬2¾ÍÊÇchanpin.name£¬ÓÐÖØÃû£¬×îºÃÓÃSELECT ASÈ¡±ðÃû
Ïà¹ØÎÊ´ð£º
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......