XMLÎļþÈçÏ£º
<Item>
<Status>Pass </Status>
</Item>
<Item>
<Status>Pass </Status>
</Item>
<Item>
<Status>Fail </Status>
</Item>
ÔõÑùʹÓÃxslͳ¼Æ³öPassºÍFailµÄ´ÎÊý£¿ÒÔ¼°PassºÍFailÕ¼×ÜÊýµÄ ......
sql2008 Êý¾Ý¿â£º
±í t Óиö xml ×Ö¶ÎÃûΪ f£¬ÄÚÈÝΪ
<root>
<id>1 </id>
<name>a </name>
</root>
ÏÖÔÚÒªÕÒµ½ËùÓÐ f ÀïµÄ id=1 µÄ¼Ç¼£¬ÇëÎÊÒªÔõôÕÒ£¬Ð»Ð»£¡
ллÄãÃÇ!~~~~~~~~~~
......
ÈçÌâ¡£
²»Àí½âÄãÕâÊÇʲôÒâ˼
Ïñt-sqlÄÇÑù¶¨Òåint identity(1,1).
xml±¾Éí²»ÊÇÊý¾Ý¿â£¬Ö»ÊÇÒ»ÖÖ¸ñʽ¶øÒÑ¡£Äã¿ÉÒÔ×Ô¼º¿ØÖÆ
Óа취ÄÜ¿ØÖƵ½×ÔÔöÂð£¿
ÏÖÔÚÒ²ÕýÔÚѧxml£¬µ½Ä¿Ç°ÎªÖ¹»¹Ã»Óöµ½
xml¼òµ¥ËµÊÇÒ»ÖÖÎļþµÄ¸ñʽ
¾ÍÈçÄãÉú³ÉÒ»¸ö¸ötxtÎı¾Îļþ£¬×ÔÔöʲô£¬ÎļþÃûô,Ôõô×ÔÔöÄØ£¿
5¡¢Ð´Ò»¸öXMLÎĵµ£¬ÒÔ ......
±ÈÈç˵£¬
ÏÖÔÚÓÐÒ»¸ö¹æ·¶µÄxml£¬
´ò¿ªÒ»¸öеÄexcel£¬
Ö±½Ó°ÑxmlÍϽøexcelÀïÈ¥£¨¼´×÷ΪexcelµÄÊý¾ÝÔ´´ò¿ª£©£¬
ÕâʱºòµÄexcelÏÔʾ»áÖ±½Ó¶ÔxmlµÄÄÚÈÝÕûÆëÕ¹¿ª£¬²¢ÇÒ¼ä¸ôÐбäÉ«£¬¶øÇÒÖ±½Ó¾Í´øÓÐɸѡµÄ¹¦ÄÜ£¬
²¢ÇÒÿһÁеÄÁпíÒÔ¼°Êý¾Ý¸ñʽҲÊDZȽϷûºÏʵ¼ÊÇé¿ö¡£
ÎÒÏëÓÃC#ʵÏÖÕâ¸ö¹¦ÄÜ£¬
Èç¹ûÊÇÔÚ³ÌÐòÀïÖ±½Ó°Ñxmlת³ÉDa ......
with ClientDataSet1 do
begin
insert;
FieldByName('Year').AsInteger:=2010;
FieldByName('Month').AsInteger:=2;
FieldByName('Day').AsInteger:=20;
post;
end;
ÕâÑùµÄÓï¾ä¿ÉÒÔ°ÑÊý¾Ý²åÈëÄÚ´æÖУ¬µ«²»Äܽ«Êý¾ÝдÈëXMLÎļþÖУ¬Èô¼ÓÈëÏÂÁÐÓï¾ä£ ......
SAXBuilder sb = new SAXBuilder();
Document myDocument = sb.build(¡°/some/directory/app cs.xml¡±);
Ò»µ«ÎļþÃû³ÆÖдø¿Õ¸ñ£¬½âÎöµÄʱºò¾ÍÅ×Òì³££¬Õâ¸öÒªÔõô½â¾öÄØ£¿
Çë¸ßÊÖÖ¸µã
×îºÃµÄ·½Ê½ÊÇ£º
½«ÎļþÖØÐÂÃüÃû
Èç¹ûÎÒûÓмǴíµÄ»°
ºÃÏñ Îļþ¼ÐÖÐÓпոñ Ò²²»ÐÐ
¿Õ¸ñ¿ÉÒÔÓÃ×Öĸ´ ......