python ¶ÁxmlÎļþ
def getText(self,nodelist):
rc=""
for node in nodelist:
if node.nodeType == node.TEXT_NODE or node.nodeType == node.CDATA_SECTION_NODE:
rc = rc + node.data
return rc
def parseXML(self,requesturl,xml):
dom = minidom.parse(requesturl)
for node in dom.getElementsByTagName('category'):
xml.append({
'categoryid': self.getText(node.getElementsByTagName("categoryid")[0].childNodes),
'categoryname': self.getText(node.getElementsByTagName("categoryname")[0].childNodes)
})
Ö÷º¯Êý£º
xml=[]
self.parseXML(self.file_path,xml)
Ïà¹ØÎĵµ£º
ÔÚAccess2007ÖдÓExcelµ¼Èëʱ£¬¾³£»áÅöµ½ÈçϵĴíÎóÌáʾ£º“Õë¶Ô¸Ã¼Ü¹¹½øÐеĹ淶XMLÑé֤ʧ°Ü¡£ÒÔÏÂXMLÎĵµÐÐÖдæÔÚ´íÎ󣺣ü¡£”
ÎҵĽâ¾ö·½Ê½ÊÇÓÃÁ´½Ó±í·½Ê½À´´ò¿ªExcelÎļþ£¬È»ºóÔÚ¸´ÖÆÁ´½Ó±í£¬Õ³Ìù¡£ ......
declare @XML XML
SET @XML='<root>
<OLDVALUE>
<H_Action id="1130">030</H_Action>
<D_Action>030</D_Action>
<OrderCompany>00220</OrderCompany>
<OrderNumber>10004035</OrderNumber> ......
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;
import org.jdom.output.XMLOutputter;
£¨1£©Ê¹ÓÃJDOMÊ×ÏÈÒªÖ¸¶¨Ê¹ÓÃʲô½âÎöÆ÷¡£È磺
SAXBuilder builder=new SAXBuilder(false) ......
ʲôÊÇ XML?
XML Ö¸¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨EXtensible Markup Language£©
XML ÊÇÒ»ÖÖ±ê¼ÇÓïÑÔ£¬ºÜÀàËÆ HTML
XML µÄÉè¼Æ×ÚÖ¼ÊÇ´«ÊäÊý¾Ý£¬¶ø·ÇÏÔʾÊý¾Ý
XML ±êǩûÓб»Ô¤¶¨Òå¡£ÄúÐèÒª×ÔÐж¨Òå±êÇ©¡£
XML ±»Éè¼ÆΪ¾ßÓÐ×ÔÎÒÃèÊöÐÔ¡£
XML ÊÇ W3C µÄÍƼö±ê×¼
XML Óë HTML µÄÖ÷Òª²îÒì
XML ²»ÊÇ HTML µÄÌæ´ú¡£
XML ºÍ HTML Ϊ² ......
var xmlDom; //XML DOM object
var xmlFile="ff.xml"; //xml file name
loadXML = function(fileRoute){
xmlDoc=null;
if (window.ActiveXObject){
xmlDoc = new ActiveXObject('Msxml2.DOMDocument');
xmlDoc.async=false;
xmlDoc.load(fileRoute);
}else if (document.implementation &a ......