dom4j½âÎöxml³ö´í£¬ÇëÇóÖ§Ô® - Web ¿ª·¢ / XML/SOAP
String strXML="<all><student><name>ΰ¸ç</name><sex>ÄÐ</sex><age>27</age></student><student><name>qiaoqiao</name><sex>ÄÐ</sex><age>26</age></student></all>";
db.excute("aa", "add",strXML, sb);//·½·¨µ÷ÓÃ
public void excute(String tableName,String option,String xmlData,StringBuffer strBuffer) {
DOMDocument doc = new DOMDocument(xmlData);
NodeList list = doc.getChildNodes();
System.out.println(list.getLength());
}
ÓÃstringÐÍÓ¦¸ÃÒ²¿ÉÒÔ¹¹½¨Ò»¸ö dom Îĵµ°É£¿
ÎÒдÁËÒ»¸ö¼òµ¥µÄ·½·¨£¬ÏÖÔÚ µÃ²»µ½×Ö½ÚµãµÄ³¤¶È£¬ÎªÊ²Ã´°¡£¿{{
Ïà¹ØÎÊ´ð£º
Private Sub Command1_Click()
Dim MyString() As String
Open "a.xml" For Binary As #1 ' ´ò¿ª¸Õ´´½¨µÄÎļþ¡£
ReDim MyString(LOF(1) - 1)
Put #1, , MyRecord ' ¶ÁÈëËùÓÐ×Ö·ûµ½±äÁ¿ÖÐ ......
ÎÒÓÐÒ»¸öÀàËƵÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎĶ¼¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......