jQuery »ñÈ¡xmlÊý¾ÝÔÚIEÖÐÎÞЧµÄÎÊÌâ
ǰ¶Îʱ¼äÓÃjQuery×öÁ˸öСÁ·Ï°£¬»ñÈ¡±¾µØµÄxmlÊý¾Ý£¬ÔÚfirefoxÏÂÃæ²âÊÔûÎÊÌ⣬µ«ÊÇÔÚIEÏÂÃæ×ÜÊÇ»ñÈ¡Êý¾Ýʧ°Ü£¬ÉÏÍøÕÒÁ˺ܾÃҲûÕÒµ½ÊÇÔõô»ØÊ¡£ÓôÃÆÁ˺ܳ¤Ò»¶Îʱ¼ä£¬½ñÌìÓпÕÓÖ°ÑÕâ¸öÎÊÌâÄóöÀ´Ñо¿ÁËÏ£¬×îºóÖÕÓÚÕÒµ½ÔÒòÁË£¬°ÑÒ³Ãæ·Åµ½·þÎñÆ÷È¥ä¯ÀÀ¾ÍOKÁË¡£ÄѵÀÊÇȨÏÞÎÊÌ⣿²»ÖªµÀÔõô»ðºüÔÚ±¾µØÄ¿Â¼¿ÉÒÔ»ñÈ¡Êý¾Ý³É¹¦¡£¶ÔÓÚ²Ù×÷xmlÎĵµÒª·Åµ½·þÎñÆ÷È¥£¬Òª²»È»»áûÓÐȨÏÞ¡£
//html
<h1>¼ÓÔØxmlÊý¾Ý</h1>
<input type="button" value="¼ÓÔØxmlÊý¾Ý" id="loadXml"/>
<div class="xmldata">ÕâÀïÏÔʾXMLÊý¾Ý</div>
//js
$(function(){
$("#loadXml").click(function(){
$.ajax({
type:'get',
url:'xml.xml',
dataType:"xml",
success:function(data){
$(".xmldata").empty();
$("user",data).each(function(){
var users=$(this);
var html='<div class="name">';
html+=users.find("name").text();
html+='</div>';
html+='<div class="age">';
html+=users.find("age").text();
html+='</div>';
html+='<div class="sex">';
html+=users.find("sex").text();
html+='</div>';
$(".xmldata").append($(html));
})
}
})
})
})
//xml
<?xml version="1.0" encoding="gb2312"?>
<userInfo>
<user>
<name>haohao</name>
<age>18</age>
<sex>man</sex>
</user>
<user>
<name>do
Ïà¹ØÎĵµ£º
Parsing XML from the Net - Using the SAXParser
http://www.anddev.org/parsing_xml_from_the_net_-_using_the_saxparser-t353.html
What you learn:
You will learn how to properly parse XML
(here: from the net
) using a SAXParser
.
What it will look like:
Description:
0.)
In this tutorial we ......
/*--´æÎªXML
½«±í/²éѯ´æ´¢Îª±ê×¼µÄXMLÎļþ
--*/
/*--µ÷ÓÃʾÀý
--ÓÃSQLÓÃwinowsÉí·ÝÑéÖ¤µÄÇé¿ö
exec p_savexml @sql='µØÇø×ÊÁÏ',@fname='c:\µØÇø×ÊÁÏ.xml'
--ÓÃÖ¸¶¨µÄÓû§
exec p_savexml @sql='µØÇø×ÊÁÏ',@fname='c:\µØÇø×ÊÁÏ.xml',@userid='sa'
--*/
if exists (select * from db ......
XMLDocumentÀàÌṩÁ˷ḻµÄÊôÐԺͷ½·¨£¬¿ÉÒÔ°ïÖúÎÒÃÇÇáËÉÍê³ÉxmlµÄ±à¼¡£µ«ÊÇ£¬Íê³ÉºóµÄxmlºÜ¶àÇé¿öÏ¿ÉÄÜ»¹ÊÇÐèÒªÒÔ×Ö·û´®ÐÎʽ´«µÝ¡£XMLDocumentÓиöSave·½·¨£¬²»½ö¿ÉÒÔ±£´æXMLÎļþÖÁ´ÅÅÌ£¬»¹Äܽ«Æä±£´æÖÁÖ¸¶¨µÄÁ÷£¬È»ºó£¬¾ÍÄÜ´ÓÕâ¸öÁ÷£¨stream£©¶ÁÈ¡ËùÐèÒªµÄ×Ö·û´®ÁË¡£
XmlDocument doc = new XmlDocument();
...
.../ ......
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡ÔÚ¾ÙÀý˵Ã÷ÈçºÎ·Ö½âÉÏһƪÎÄÕÂÖеÄÊý¾Ýʱ£¬ÎÒÃÇÊ×ÏÈÁ˽âÒ»ÏÂXQueryºÍËüÔÚSQL Server 2005ÖÐΪ¿ª·¢ÕßÌṩµÄ¹¦ÄÜ¡£
¡ ......