ÓÃDOM´´½¨XMLÎĵµµÄÎÊÌâ - .NET¼¼Êõ / .NET¼¼Êõǰհ
ÀûÓÃDOM´´½¨ÈçϽṹµÄXMLÎĵµ£¬ÎļþÃûΪstu_data.xml¡£Æä´óÖÂÎĵµ½á¹¹ÈçÏ£º
<?xml version="1.0" encoding="gb2312"?>
<ѧÉú×÷ÒµÁбí>
<ѧÉú id="001">
<ÐÕÃû>ÕÅÎÞ¼É</ÐÕÃû>
<ѧºÅ>2007213101</ѧºÅ>
<°à¼¶>ÐÅÏ¢¹ÜÀí°à</°à¼¶>
<¿Î³ÌÃû³Æ>XMLÓïÑÔ³ÌÐòÉè¼Æ</¿Î³ÌÃû³Æ>
<Åú´Î>6</Åú´Î>
<×÷ÒµÄÚÈÝ><![CDATA[data]]></×÷ÒµÄÚÈÝ>
</ѧÉú>
</ѧÉú×÷ÒµÁбí>
±»ÕâµÀÌâŪ·èÁË,¹òÇó¸÷λ¸ßÊÖ°ïæ,ÏÈллÁË
¸øÄã·¢¸öÀý×Ó£º
C# code:
<%
on error resume next
Dim SQL,RS
Set RS = Server.CreateObject("ADODB.RecordSet")
Set conn = server.createobject("adodb.connection")
OpenDBConn conn
SQL = "SELECT f1,f2,f3 from table1 WHERE f1=xx"
RS.Open SQL,Conn,1,1
RS.MoveFirst
Dim xmldoc
Set xmldoc = server.CreateObject("Msxml2.domdocument")
Dim version
Set version = xmldoc.createProcessingInstruction("xml","version='1.0' encoding='GB2312'")
xmldoc.appendchild
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......
<UserModel xmlns="http://tempuri.org/">
<Name>Liu</Name>
<Age>23</Age>
</UserModel>
ÔõôÓÃlinq to xml ²éѯ°ÑÉÏÃæµÄÒ»¸ö×Ö·û´® ͶӰ³ÉÒ»¸ ......
package com.javabean.xml;
import java.net.MalformedURLException;
import java.net.URL;
import org.dom4j.io.SAXReader;
import org.dom4j.Attribute;
import org.dom4j.Document;
import org.dom4j.Docum ......