XMLHttpRequest Òì²½´¦ÀíXMLµäÐÍÓ¦ÓÃ
ÉùÃ÷¶ÔÏóʵÀý
var xmlhttp = false;
//²úÉúÒ»¸öXMLHttpRequest¶ÔÏóʵÀý
getHTTPRequestObject();
function getHTTPRequestObject()
{
try
{
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e)
{
try
{
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
catch(E)
{
xmlhttp = false;
}
}
if(!xmlhttp && typeof XMLHttpRequest!= 'undefined')
{
xmlhttp = new XMLHttpRequest();
}
}
//»Øµ÷´¦Àí
function callback()
{
if(xmlhttp.readyState == 4)
{
if(xmlhttp.status == 200)
{
var xmlresponse = xmlhttp.responseXML.documentElement; //»ñÈ¡xml²Ù×÷¶ÔÏó
document.getElementById("divResponse").innerText = xmlhttp.responseText; //È«ÎÄÒýÓÃ
alert(xmlresponse.getElementsByTagName("message")[0].firstChild.data);//½ÚµãÊý¾ÝÒýÓÃ
}
}
}
//´¥·¢Ê¼þ
function btnClick()
{
xmlhttp.open("GET", "XMLFile.xml", true);
xmlhttp.onreadystatechange = callback;
xmlhttp.send(null);
}
XMLFile.xmlÎļþÄÚÈÝ£º
<?xml version="1.0" encoding="utf-8" ?>
<messages>
<message>
Hello!
</message>
</messages>
Ïà¹ØÎĵµ£º
1£®Ê²Ã´ÊÇXML£¿
XML ¿ª·¢ÕßÃÇ»á¸æËßÄ㣬ÊÂʵÉÏXML²¢²»ÊÇÒ»ÖÖÓïÑÔ£¬¶øÊÇÒ»ÖÖÓÃÀ´¶¨ÒåÆäËüÓïÑÔµÄϵͳ¡£¿ÉÄÜÄãÒѾÌý¹ý£¬»òÐíÉõÖÁ×Ô¼º³¢ÊÔ¹ýһЩÕâÑùµÄÓïÑÔ??±ÈÈç΢ÈíÎªÍÆ£¨push£©¼¼ÊõËùÍÆ³öµÄƵµÀ¶¨Òå¸ñʽ£¨Channel Definition Format£©¡£
W3CÊÇ»¥Á¬ÍøÉÏһЩ¹«Óñê×¼µÄ¿ª·¢Õߣ¬ËûÍÆ³öÁËһϵÁкÍXMLÏà¹ØµÄ±ê× ......
sql2005ÖÐÒ»¸öxml¾ÛºÏµÄÀý×Ó ÊÕ²Ø
¸ÃÎÊÌâÀ´×ÔÂÛ̳ÌáÎÊ£¬ÑÝʾSQL´úÂëÈçÏÂ
--½¨Á¢²âÊÔ»·¾³
set nocount on
create table test(ID varchar(20),NAME varchar(20))
insert into test select '1','aaa'
insert into test select '1','bbb'
insert into test select '1','ccc'
insert into test select '2','ddd'
inser ......
ÔÚ
SQLServer2005
ÖжÔ
XML
µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË
query(),value(),exist(),modify(),nodes()
µÈº¯Êý¡£
¹ØÓÚ
xml
£¬ÄÑÒÔÀí½âµÄ²»ÊÇ
SQLServer
ÌṩµÄº¯Êý£¬¶øÊǶÔ
xml
±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»Êdzõ̽һ϶øÒÑ¡£
Ïê¼û
SQLServer
Áª»ú°ïÖú£º
Ö÷Ìâ
˵ ......
ÔÚXMLÊý¾ÝÖУ¬Ò»Ð©ÌØÊâ×Ö·û±ØÐëÓÃתÒå·ûºÅÀ´´úÌæ£¬¶ø»Ø³µ»»ÐÐ×Ö·û¾ÍÊÇÊôÓÚÌØÊâ·ûºÅ¡£
¿Õ¸ñ ( )
Tab (	)
»Ø³µ (
)
»»ÐÐ (
)
ÏÂÃæÊÇÒ»¸ö±¨±íXMLÊý¾Ý£¬ÀïÃæ°üÀ¨Óлسµ»»ÐÐ×Ö·û£º
<report>
<NewDataSet>
<Table>
<CustomerID>BLONP</CustomerID& ......