{"id":227,"date":"2008-12-05T09:48:57","date_gmt":"2008-12-05T01:48:57","guid":{"rendered":""},"modified":"2014-02-27T23:00:23","modified_gmt":"2014-02-27T15:00:23","slug":"asp%e5%9c%a8%e7%bb%93%e6%9e%9c%e4%b8%ad%e6%90%9c%e7%b4%a2","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2008\/12\/05\/227.htm","title":{"rendered":"ASP\u5728\u7ed3\u679c\u4e2d\u641c\u7d22"},"content":{"rendered":"

\u6211\u4eec\u7ecf\u5e38\u7528GOOGLE\u6765\u641c\u7d22\u4e1c\u4e1c\uff0c\u4e5f\u770b\u5230\u4e86\u5b83\u7684\u5728\u7ed3\u679c\u4e2d\u641c\u7d22\u7684\u529f\u80fd\u3002<\/p>\n

\u5728\u8bba\u575b\u4e2d\u66fe\u6709\u4eba\u95ee\u5230\uff0c\u5982\u679c\u7528 ASP \u5728\u641c\u7d22\u7ed3\u679c\u4e2d\u518d\u6b21\u641c\u7d22\u7684\u95ee\u9898\u3002<\/p>\n

\u4e0b\u9762\u5c31\u662f\u4e00\u4e2a\u5b8c\u6574\u7684\u89e3\u51b3\u65b9\u6848\u3002<\/p>\n

\u8bbe\u8ba1\u601d\u8def\uff1a<\/p>\n

\u628a\u641c\u7d22\u7684\u5185\u5bb9\u4f20\u9012\u8fc7\u6765\uff0c\u4e2d\u95f4\u7528“,”\u53f7\u9694\u5f00\uff0c\u7edf\u8ba1\u51fa\u641c\u7d22\u7684\u5173\u952e\u5b57\uff0c\u7136\u540e\u7528sql\u8bed\u6cd5\u7684“and”\u8fde\u63a5\u8d77\u6765\u5f62\u6210\u4e00\u4e2a\u65b0\u7684\u67e5\u8be2\u8bed\u53e5\u3002<\/p>\n

ASP\u4ee3\u7801\uff0c\u4e0b\u9762\u7684\u4ee3\u7801\u4e0d\u63d0\u4f9b\u6570\u636e\u5e93\u4e0b\u8f7d\uff0c\u5982\u679c\u4f60\u8981\u8fdb\u884c\u6d4b\u8bd5\uff0c\u53ef\u4ee5\u65b0\u5efa\u4e00\u4e2aACCESS\u6570\u636e\u5e93\uff0c\u5728\u91cc\u9762\u65b0\u5efa\u4e00\u4e2a“capital”\u5b57\u6bb5\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n

\u4ee3\u7801\u62f7\u8d1d\u6846<\/p>\n\n\n\n
\u4ee5\u4e0b\u662f\u5f15\u7528\u7247\u6bb5\uff1a<\/font><\/p>\n

<title>\u5728\u7ed3\u679c\u4e2d\u518d\u641c\u7d22<\/title>
\n <body bgcolor="#FFFFFF">
\n <%
\n u_search=request.form("u_search")
\n u_prev_search=request.form("u_prev_search")
\n u_search_within=request.form("u_search_within")<\/font><\/p>\n

<\/p>\n

\n if u_search <> "" then<\/p>\n

 if u_prev_search = "" then
\n   u_prev_search=u_search
\n else<\/p>\n

 u_prev_search=u_prev_search &","& u_search
\n  g_prev_search=split(u_prev_search,",")
\n  num_inputted=ubound(g_prev_search)
\n end if<\/p>\n

sql= "select * from states where (capital like ‘%%"& u_search & "%%’) "<\/p>\n

if u_search_within = "Yes" then
\n  for counter =0 to num_inputted-1
\n   sql=sql& "and (capital like ‘%%"& g_prev_search(counter) & "%%’) "
\n  next
\n end if<\/p>\n

accessdb="state_info"
\n cn="DRIVER={Microsoft Access Driver (*.mdb)};"
\n cn=cn & "DBQ=" & server.mappath(accessdb)<\/p>\n

Set rs = Server.CreateObject("ADODB.Recordset")
\n rs.Open sql, cn
\n ‘ \u5982\u679c\u6ca1\u6709\u627e\u5230\u76f8\u5e94\u7684\u4fe1\u606f
\n if rs.eof then
\n %>
\n  \u6ca1\u6709\u4efb\u4f55\u8bb0\u5f55<\/p>\n

<%’ \u6709\u76f8\u5e94\u7684\u4fe1\u606f\u5c31\u5217\u51fa\u6765
\n else
\n  rs.movefirst
\n  do while Not rs.eof
\n %>
\n   <%= rs("capital") %><br>
\n <%
\n  rs.movenext
\n  loop
\n end if
\n end if
\n %>
\n <!– Begin Form Input Area –>
\n <form action="<%= request.servervariables("script_name") %>" method="post">
\n <input type="text" name="u_search" value="<%= u_search %>">
\n <br>
\n <%
\n if u_search <> "" then %>
\n <input type = "radio" name="u_search_within" checked value="No"> \u91cd\u65b0\u641c\u7d22 &nbsp;
\n <input type = "radio" name="u_search_within" value="Yes"> \u5728\u7ed3\u679c\u4e2d\u641c\u7d22
\n <%
\n if u_search_within = "Yes" then %>
\n <input type = "hidden" name="u_prev_search" value="<%= u_prev_search %>">
\n <%
\n else %>
\n <input type = "hidden" name="u_prev_search" value="<%= u_search %>">
\n <% end if%>
\n <br>
\n <% end if%>
\n <input type="submit" value="\u641c\u7d22">
\n <\/form>
\n <!– End Form Input Area –>
\n <p>&nbsp;<\/p>
\n <%= sql %><\/p>\n

<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\u6211\u4eec\u7ecf\u5e38\u7528GOOGLE\u6765\u641c\u7d22\u4e1c\u4e1c\uff0c\u4e5f\u770b\u5230\u4e86\u5b83\u7684\u5728\u7ed3\u679c\u4e2d\u641c\u7d22\u7684\u529f\u80fd\u3002 \u5728\u8bba\u575b\u4e2d\u66fe\u6709\u4eba\u95ee\u5230\uff0c\u5982\u679c\u7528 ASP \u5728\u641c\u7d22\u7ed3\u679c\u4e2d\u518d\u6b21\u641c\u7d22\u7684\u95ee\u9898\u3002 \u4e0b\u9762\u5c31\u662f\u4e00\u4e2a\u5b8c\u6574\u7684\u89e3\u51b3\u65b9\u6848\u3002 \u8bbe\u8ba1\u601d\u8def\uff1a \u628a\u641c\u7d22\u7684\u5185\u5bb9\u4f20\u9012\u8fc7\u6765\uff0c\u4e2d\u95f4\u7528“,”\u53f7\u9694\u5f00…<\/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-227","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/227","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=227"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":66076,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/227\/revisions\/66076"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=227"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}