📄 ajax_responsexml.asp
字号:
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}</pre>
</td>
</tr>
</table>
<p>The showCustomer() and GetXmlHttpObject() functions above are the same as in
previous chapters. The stateChanged() function is also used earlier in this
tutorial, however; this time we return the result as an XML document (with
responseXML) and uses the DOM to
extract the values we want to be displayed.</p><hr />
<h2>The AJAX Server Page</h2>
<p>The server page called by the JavaScript, is a simple ASP file called
"getcustomer_xml.asp".</p>
<p>The page is written in VBScript for an Internet Information Server (IIS). It
could easily be rewritten in PHP, or some other server language.
<a href="../php/php_ajax_responsexml.asp">Look at a corresponding example in PHP</a>.</p>
<p>The code runs an SQL query against a database and returns the result as an XML
document:</p>
<table class="ex" id="table8" border="1" width="100%">
<tr>
<td>
<pre><%
response.expires=-1
response.contenttype="text/xml"</pre>
<pre>sql="SELECT * FROM CUSTOMERS "
sql=sql & " WHERE CUSTOMERID='" & request.querystring("q") & "'"
on error resume next
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
rs.Open sql, conn</pre>
<pre>if err <> 0 then
response.write(err.description)
set rs=nothing
set conn=nothing
else
response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
response.write("<company>")
response.write("<compname>" &rs.fields("companyname")& "</compname>")
response.write("<contname>" &rs.fields("contactname")& "</contname>")
response.write("<address>" &rs.fields("address")& "</address>")
response.write("<city>" &rs.fields("city")& "</city>")
response.write("<country>" &rs.fields("country")& "</country>")
response.write("</company>")
end if
on error goto 0
%></pre>
</td>
</tr>
</table>
<p>Notice the second line in the ASP code above: response.contenttype="text/xml".
The ContentType property sets the HTTP content type for the response object. The
default value for this property is "text/html". This time we want the content
type to be XML.</p>
<p>Then we select data from the database, and builds an XML document with the
data. </p>
<hr />
<a href="ajax_xmlfile.asp"><img border="0" src="../images/btn_previous.gif" width="100" height="20" alt="Previous" /></a>
<a href="ajax_examples.asp"><img border="0" src="../images/btn_next.gif" width="100" height="20" alt="Next" /></a>
<br />
<hr />
<!-- **** SPOTLIGHTS 1 **** -->
<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="2" bgcolor="#dae6f2"><a href="../../www.ektron.com/cms400-web-cms.aspx@id=5748&cpid=BAC-3183&campaignid=3183" target="_blank">
<img src="../images/061608-w3schools_box.gif" width="161" height="232" alt="Ektron CMS400.NET" border="0" /></a></td>
<td><a href="../../www.ektron.com/index.aspx@cpid=BAC-3183&campaignid=3183" target="_blank"><img src="../images/061608-w3schools_logo.gif" width="339" height="108" alt="Ektron - What do you want your website to do?" border="0" /></a></td>
</tr>
<tr>
<td><a href="../../www.ektron.com/cms400-web-cms.aspx@id=5748&cpid=BAC-3183&campaignid=3183" target="_blank"><img src="../images/061608-w3schools_eintranet.gif" width="339" height="124" alt="The Ektron Intranet" border="0" /></a></td>
</tr>
<tr>
<td colspan="2"><a href="../../www.ektron.com/instant_demo.cfm@flash=6134&type=5&cpid=BAC-3183&campaignid=3183" target="_blank"><img src="../images/061608-w3schools_taketour.gif" alt="Take the video tour" width="500" height="33" border="0" /></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF">
<p style="padding: 10px; margin:0px;"><a href="../../www.ektron.com/cms400-web-cms.aspx@id=5748&cpid=BAC-3183&campaignid=3183" target="_blank"><strong>The Ektron Intranet</strong></a>
lets you do everything you need to do on your corporate intranet and everything you want to do<strong>... all with just one application</strong>.</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>
<table cellspacing="0" cellpadding="4" width="100%" border="0" bgcolor="#FFFFFF">
<tr>
<td bgcolor="#dae6f2"><p><strong>What can you do with the Ektron Intranet? </strong></p></td>
</tr>
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="0">
<tr>
<td><img src="../images/061608-w3schools_icon_search.jpg" width="32" height="32" alt="Ektron" /></td>
<td valign="top"><p>Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with <strong>enterprise search</strong></p></td>
</tr>
<tr>
<td><img src="../images/061608-w3schools_icon_communication.jpg" width="32" height="32" alt="Ektron" /></td>
<td valign="top"><p>Communicate with friends and colleagues with forums, message boards and corporate blogging using the new <strong>Social Networking Platform</strong> </p></td>
</tr>
<tr>
<td><p><img src="../images/061608-w3schools_icon_open.gif" width="32" height="32" alt="Ektron" /></p></td>
<td valign="top"><p>Utilize the extensive out-of-the box features or <strong>customize</strong> your site through Ektron CMS400.NET's <strong>open architecture</strong></p></td>
</tr>
<tr>
<td><img src="../images/061608-w3schools_icon_collaboration.jpg" width="32" height="32" alt="Ektron" /></td>
<td valign="top"><p>Promote collaboration in your organization through project <strong>workspaces</strong> where others can efficiently find information and work together</p></td>
</tr>
<tr>
<td><img src="../images/061608-w3schools_icon_docflow.jpg" width="32" height="32" alt="Ektron" /></td>
<td valign="top"><p>Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed <strong>Content Management</strong> </p></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td align="center" style="padding: 0px 10px 10px 10px; line-height: 14pt;">
<p>See why there are 20,000+ Ektron integrations worldwide.</p>
</td>
</tr>
</table> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><a href="../../www.ektron.com/instant_demo.cfm@flash=6134&type=5&cpid=BAC-3183&campaignid=3183" target="_blank">
<img src="../images/061608-w3schools_buttontop.gif" width="161" height="27" alt="Take the Video Tour" border="0" /></a></td>
<td bgcolor="#FFFFFF"><a href="../../www.ektron.com/instant_demo.cfm@flash=6134&type=5&cpid=BAC-3183&campaignid=3183" target="_blank"><strong>TAKE THE VIDEO TOUR</strong></a></td>
</tr>
<tr>
<td bgcolor="#dae6f2"><a href="../../www.ektron.com/instant_demo.cfm@flash=6134&type=5&cpid=BAC-3183&campaignid=3183" target="_blank">
<img src="../images/061608-w3schools_buttonbottom.gif" width="161" height="35" alt="Take the Video Tour" border="0" /></a></td>
<td bgcolor="#dae6f2">or download a <a href="../../www.ektron.com/download.cfm@product_id=363&purchase=0&cpid=BAC-3183&campaignid=3183" target="_blank"><strong>FREE TRIAL</strong></a> today.</td>
</tr>
</table>
<hr />
<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />
<center>
<iframe style="background-color:#ffffff" src="../banners/oddcastbannerframe.asp"
height="60" width="468" marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
</center>
<hr />
<!-- **** END SPOTLIGHTS **** -->
</td></tr>
<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='ajax_responsexml.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>
</table>
</td></tr>
</table>
</td>
<td width="145" align="center" valign="top">
<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=ajax" height="1500" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>
</td>
</tr></table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -