{"id":652,"date":"2010-12-09T00:21:08","date_gmt":"2010-12-08T16:21:08","guid":{"rendered":""},"modified":"2014-03-11T22:35:18","modified_gmt":"2014-03-11T14:35:18","slug":"aspajaxjqueryaccess","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2010\/12\/09\/652.htm","title":{"rendered":"ASP+AJAX+jQuery+ACCESS"},"content":{"rendered":"<p>AJAX\u7684\u521d\u7ea7\u5e94\u7528\u662f\u975e\u5e38\u7b80\u5355\u7684\uff0c\u901a\u4fd7\u7684\u8bf4\u5c31\u662f\u5ba2\u6237\u7aef(javascript)\u4e0e\u670d\u52a1\u7aef(asp\u6216php\u7b49)\u811a\u672c\u8bed\u8a00\u7684\u6570\u636e\u4ea4\u4e92\u3002\u5982\u679c\u518d\u7ed3\u5408jquery\uff0c\u90a3\u4e48\u66f4\u52a0\u7b80\u5355\u3002<br \/>\n\u4f60\u4e5f\u53ef\u4ee5\u76f4\u63a5\u8bbf\u95ee\uff1a<a rel=\"nofollow\" href=\"http:\/\/www.boluoge.com.cn\/test\/ajaxjquery\/\">www.boluoge.com.cn\/test\/ajaxjquery\/<\/a>\u9884\u89c8\u6b64\u7bc7ajax+jquery\u6559\u7a0b\u7684\u6e90\u7801\u793a\u4f8b\u3002<br \/>\n1\u3001\u524d\u53f0AJAX+jQuery\u7684\u521b\u5efa\u3002index.html\u6587\u4ef6<br \/>\nxml \u4ee3\u7801<br \/>\n&nbsp;<br \/>\n&lt;html&gt; <br \/>\n&lt;head&gt; <br \/>\n&lt;title&gt;ASP+AJAX+jQuery+ACCESS\u6570\u636e\u5e93\u5e94\u7528-web\u505a\u4f60\u6240\u60f3\uff01jQuery+ajax\u5b9e\u4f8b\u6559\u7a0b&lt;\/title&gt; <br \/>\n&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text\/html; charset=gb2312&quot; \/&gt; <br \/>\n&lt;script type=&quot;text\/javascript&quot; src=&quot;<br \/>\n&nbsp;&nbsp;&nbsp; if (cc1!=0) \/\/\u5224\u65ad\u9009\u62e9 <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var url=&quot;getweb.asp&quot;&nbsp; <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $.get(url,{sid:Math.random(),id:cc1},\/\/\u6dfb\u52a0 sid \u548cq 2\u4e2a\u53c2\u6570\u5230getweb.asp\uff0cmath.random()\u907f\u514d\u7f13\u5b58 <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; function(data){ <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $(&quot;#txt&quot;).html(data); <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }); <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $(&quot;#txt&quot;).html(&quot;\u8fd8\u6ca1\u9009\u62e9\uff01&quot;); <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br \/>\n} <br \/>\n&lt;\/script&gt; <br \/>\n&lt;form&gt;\u8bf7\u9009\u62e9\u7f51\u7ad9: <br \/>\n&lt;select name=&quot;webinfo&quot; id=&quot;formc&quot; onChange=&quot;show()&quot;&gt; <br \/>\n&lt;option value=&quot;0&quot;&gt;==\u8bf7\u9009\u62e9==&lt;\/option&gt; <br \/>\n&lt;option value=&quot;1&quot;&gt;web\u505a\u4f60\u6240\u60f3\uff01&lt;\/option&gt; <br \/>\n&lt;option value=&quot;2&quot;&gt;sphone\u77ed\u4fe1\u738b&lt;\/option&gt; <br \/>\n&lt;option value=&quot;3&quot;&gt;Idcmanaager&lt;\/option&gt; <br \/>\n&lt;\/select&gt; <br \/>\n&lt;\/form&gt;&lt;p&gt; <br \/>\n&lt;div id=&quot;txt&quot;&gt;&lt;b&gt;\u7f51\u7ad9\u4fe1\u606f&#8230;&lt;\/b&gt;&lt;\/div&gt; <br \/>\n&lt;\/p&gt;&lt;\/body&gt; <br \/>\n&lt;\/html&gt;<\/p>\n<p>&nbsp;<\/p>\n<p>2\u3001\u540e\u53f0asp\u6587\u4ef6\u7684\u521b\u5efa\u3002getweb.asp<\/p>\n<p>vb \u4ee3\u7801<br \/>\n&nbsp;<br \/>\n&lt;% <br \/>\n&nbsp; <br \/>\nsql=&quot;SELECT * FROM website WHERE ID=&quot; <br \/>\nsql=sql &amp; request.querystring(&quot;id&quot;) <br \/>\n&nbsp; <br \/>\nset conn=Server.CreateObject(&quot;ADODB.Connection&quot;) <br \/>\nconn.Provider=&quot;Microsoft.Jet.OLEDB.4.0&quot; <br \/>\nconn.Open(Server.Mappath(&quot;ajaxjquery.mdb&quot;)) <br \/>\nset rs = Server.CreateObject(&quot;ADODB.recordset&quot;) <br \/>\nrs.Open sql, conn <br \/>\nResponse.CharSet = &quot;GB2312&quot; <br \/>\nif not rs.EOF then <br \/>\nresponse.write &quot;&lt;li&gt;\u7f16\u53f7\uff1a&quot;&amp;rs(0)&quot;&lt;\/li&gt;&quot; <br \/>\nresponse.write &quot;&lt;li&gt;\u7f51\u7ad9\u540d\uff1a&quot;&amp;rs(1)&quot;&lt;\/li&gt;&quot; <br \/>\nresponse.write &quot;&lt;li&gt;URL\u5730\u5740\uff1a&quot;&amp;rs(2)&quot;&lt;\/li&gt;&quot; <br \/>\nresponse.write &quot;&lt;li&gt;\u4ecb\u7ecd\uff1a&quot;&amp;rs(3)&quot;&lt;\/li&gt;&quot; <br \/>\nend if <br \/>\nrs.close <br \/>\nset rs = nothing <br \/>\nconn.close <br \/>\nset conn = nothing <br \/>\n&nbsp; <br \/>\n%&gt;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>AJAX\u7684\u521d\u7ea7\u5e94\u7528\u662f\u975e\u5e38\u7b80\u5355\u7684\uff0c\u901a\u4fd7\u7684\u8bf4\u5c31\u662f\u5ba2\u6237\u7aef(javascript)\u4e0e\u670d\u52a1\u7aef(asp\u6216php\u7b49)\u811a\u672c\u8bed\u8a00\u7684\u6570\u636e\u4ea4\u4e92\u3002\u5982\u679c\u518d\u7ed3\u5408jquery\uff0c\u90a3\u4e48\u66f4\u52a0\u7b80\u5355\u3002 \u4f60\u4e5f\u53ef\u4ee5\u76f4\u63a5\u8bbf\u95ee\uff1awww.boluoge.com.cn\/test\/ajaxjq&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-652","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=652"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/652\/revisions"}],"predecessor-version":[{"id":66513,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/652\/revisions\/66513"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=652"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=652"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}