Javascript read operation XML fields in SQL _javascript tips

In a project, we need to put the information in the XML fields in the database in the page, if we use SQL to read. In this case, the inevitable result is too complex, so I thought, if the XML field first read out, and then use JS to operate, so it is not a lot simpler, so the Internet to find some information. The method of reading XML field information by JS is realized.

First we put a textbox in the page to put the XML field in. Remember: Do not use label, because if the XML field information has "" This symbol, the page will produce a JS error.

Next, that's the point. To pay the JS code:

function Createxml (str) { 
if (document.all) { 
var xmldom=new activexobject ("Microsoft.XMLDOM") 
XMLDOM.L Oadxml (str) return 
xmldom 
} 
else return 
to New Domparser (). parsefromstring (str, "Text/xml") 

The above method is to instantiate a string as XML

The last thing I do is manipulate this XML.

Window.onload=function () { 
var Str=document.getelementbyid ("Ctl00_contentplaceholder1_textbox1"). Value; 
var obj=createxml (str); 

The root node 
var root_node=obj.documentelement was obtained. 

var yh1= ""; 
for (i=0;i< root_node.childnodes[0].childnodes.length-1;i++) 
{ 
yh1+= "" + (i+1) + "," +root_node.childnodes [0].childnodes[i].getattribute ("remark") + ":" +root_node.childnodes[0].childnodes[i].firstchild.nodevalue; 


yh1+= "<br/>" 

} 
document.getElementById ("Ctl00_contentplaceholder1_lblcontent"). innerhtml=yh1; 
} 

}

Pay in XML format:

<info remark= "file template" ><common remark= "Generic Configuration" ><discopy remark= "photocopy discount" >100</DisCopy>< Disoriginal remark= "Discount" >100</disoriginal><arrearagelimit remark= "up to the limit of fees" >0</ArrearageLimit> <yearprice remark= "annual fee, Yuan/year" >0</YearPrice></Common></Info>