(¼±)xml¶ÁÈ¡½ÚµãµÄ±êÇ©ÃûµÄÎÊÌ⣬Çë¸ßÊÖÖ¸µãÃÔ½ò...
ÏëÒª¶ÁÈ¡³öxmlÎļþÖУ¬ËùÓеĽڵãµÄ±êÇ©Ãû£¬ÈçÏÂxmlÎļþ£º
XML code:
<?xml version="1.0" encoding="gb2312"?>
<?xml-stylesheet type='text/xsl' href='data.xsl'?>
<COMMODITYROOT>
<COMMODITY>
<ID>1</ID>
<Name>bag</Name>
<Price>180.000</Price>
<Amount>11</Amount>
<Remark>hello</Remark>
</COMMODITY>
<COMMODITY>
<ID>3</ID>
<Name>pen</Name>
<Price>1.800</Price>
<Amount>11</Amount>
<Remark>hello</Remark>
</COMMODITY>
</COMMODITYROOT>
Òª×öµÄÊÇͨ¹ý½âÎöxmlÎļþµÃµ½ÕâЩ³É¶ÔµÄ±êÇ©Ãû
xlt½âÎöÂ𣿠ҪµÃµ½Ê²Ã´ÑùµÄ½á¹û£¿
ÎÒÒª×öµÄÊÇдһ¸ö·½·¨£¬½âÎöÈÎÒâ¸öÒ»¸öxmlÎļþ£¬Êý¾ÝÎÒÈ«²¿Ð´½øÈ¥ÁË£¬ÏÖÔÚ¾ÍÊÇÏë¸øÕâЩxmlÖеÄÊý¾ÝÈ¡¸öÁÐÃû£¬±ÈÈç1Â¥¸ø¶¨µÄÄÇЩxmlÎļþ£¬ÎÒÏëÖ±½ÓµÃµ½ID,Name,Price,Amount,RemarkÕ⼸¸ö¾Í¹»ÁË
DOM·½Ê½µÄ»°, ¿ÉÓÃXPATH ±éÀú /*[1]/*[1]/* µÃµ½×ӽڵ㣬¶ÁÈ¡½ÚµãµÄ xxxx.nodeName
ÓÃxpathÕÒµ½½Úµã¡£È¡ÏëÒª½ÚµãµÄnodeName
×Ô¼ºÓÃSAX½âÎö¸ã¶¨
XPath½âÎöϾͺÃÁË¡£
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
ÈçÌ⣬ÓÐûÓÐÕâÑùµÄphp´úÂë¡£ÎÒÏÖÔÚÏ뽫excelµÄÄÚÈݲåÈëmysqlÊý¾Ý¿â£¬Ï£Íû¿ÉÒÔ½«excelת³Éxml,È»ºó½âÎöxml²åÈëÊý¾Ý¿âÖС£Èç¹ûÓÐÕâÑùµÄ´úÂ룬ÉõÖÁÊÇÓÐÃûµÄ´úÂ룬һ¶¨Òª¸æËßÎÒ°¡¡£
ÏȶÁ excel => È»ºóÉú³É xml = ......
Java code:
/**
* ÉèÖÃÖ¸¶¨µÄÔªËØÃûºÍ½ÚµãË÷ÒýËù¶ÔÓ¦½ÚµãµÄÄÚÈÝ
* @param ÔªËØÃû
* @param ½ÚµãË÷Òý
* @param ÄÚÈÝ
*/
public void setElementContent(String elementName,in ......
<XML>
<FLAG>1</FLAG>
<REASON></REASON>
<ADVERT><ADID>64</ADID><ADNAME>Ó¢»ÊÓéÀÖËÄ</ADNAME><ADCONTENT>ÄÚÈÝÒ»</ADCONTENT><ADT ......
²ÉÓÃDOM ½øÐнâÎöxml¡£ÒªÇó½«xml×Ö´®²åÈëÖ¸¶¨½Úµã×÷ΪÆä×Ó½Úµã
±ÈÈ磺
Ôxml
<root>
</root>
Òª²åÈëµÄxml×Ö´®
<a>test</a>
Ä¿µÄxml£º
<root>
<a> ......