Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»¸öxmlÀàÐÍ×ֶεIJéѯ

ÒÑÖª±íAÀïÓиöxmlÀàÐ͵Ä×Ö¶Îdefinition£¬Ïë²éѯ·ûºÏÌõ¼þµÄ¼Ç¼£¬Ìõ¼þΪdefinitionÖÐ <ID>½ÚµãµÄvalueΪ123£¬ÕâÑùµÄ²éѯ¸ÃÔõÑùд£¿
Õâ¸öÕë¶ÔdefinitionÓÃXML²éѯ¾Í¿ÉÒÔ.
select
  ´ýÑ¡ÔñµÄ×Ö¶Î
from
  ±í
where
  definition.value('/½Úµã·¾¶/ID') = '123'

ÕâÀïµÄ½Úµã·¾¶ÊÇ·ûºÏxPath·½Ê½µÄ·¾¶²éѯ·½Ê½.

ÒýÓÃ
Õâ¸öÕë¶ÔdefinitionÓÃXML²éѯ¾Í¿ÉÒÔ.
select
  ´ýÑ¡ÔñµÄ×Ö¶Î
from
  ±í
where
  definition.value('/½Úµã·¾¶/ID') = '123'

ÕâÀïµÄ½Úµã·¾¶ÊÇ·ûºÏxPath·½Ê½µÄ·¾¶²éѯ·½Ê½.


±ÈÈçÎÒµÄxml¸ñʽÈçÏ£º
<Tittle xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ID>1001 </ID>
</Tittle>

ËùÒÔ
select
  ´ýÑ¡ÔñµÄ×Ö¶Î
from
  ±í
where
  definition.value('Tittle/ID') = '1001'
ÊÇÕâ¸öÒâ˼ô£¿



SQL code:

select * from tab where definition.exist('\\ID[value=123]')=1



ÒýÓÃ
SQL codeselect*from tabwhere definition.exist('\\ID[value=123]')=1



Õâ¸öҲûÓгɹ¦£¬¡°\\¡±Ã²ËÆÓ¦¸ÃÊÇ¡°//¡±°É

½« xml Êý¾ÝÑù±¾ÌùһϿÉÒÔ


Ïà¹ØÎÊ´ð£º

ÀûÓÃC#±àдtxtת»¯µ½xmlµÄ³ÌÐò

txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔ­Êý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......

ÇóJavaÈçºÎʵÏÖxmlÎļþ

ÒÑÖªÎļþ1.xmlºÍÊý¾ÝÎļþdb.xml£¬ÈçºÎÓÃjava±àд³ÌÐò£¬µÃ³ö2.xmlÎļþ£¿
1.ÒÑÖªxmlÎļþ 1.xml½á¹¹ÈçÏ£º
<cs>
  <cs name="cs1" details="This is cs1" country="China&q ......

[vc] ÈçºÎ½«XML×Ö´®²åÈëµ½Ö¸¶¨µÄNode

²ÉÓÃDOM ½øÐнâÎöxml¡£ÒªÇó½«xml×Ö´®²åÈëÖ¸¶¨½Úµã×÷ΪÆä×Ó½Úµã
±ÈÈ磺 
Ô­xml 
<root>
</root>
Òª²åÈëµÄxml×Ö´®
<a>test</a> 
Ä¿µÄxml£º
<root>
<a> ......

Ò»¸ödtdÒýÓõÄxmlС´íÎ󡣡£¡£ - Java / Web ¿ª·¢

ÒýÓõÄÎļþ°üº¬´íÎó£¨XXXXX.xsd£©¡£Óйظü¶àÐÅÏ¢£¬ÓÒ¼üµ¥»÷ÏûÏ¢²¢Ñ¡Ôñ¡°ÏÔʾÏêϸÐÅÏ¢...¡±
ÇëÎÊÕâÊÇÄijö´íÁË£¿£¿£¿ÎÒÔÚelipseÀïû´í Äõ½myelipseÀïxmlÈ«ÊÇÕâ¸ö´íÎ󡣡£¡£¡£

ÊDz»ÊÇÉÙ°ü°¡£¿

°ü¶¼ÔÚÄØÑ½¡£¡£¡£ ......

Ϊʲôxml²»ÄÜÏÔʾ°¢À­²®ÎÄ - C/C++ / C++ ÓïÑÔ

ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À­²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À­²®ÎĵÄ×Ö¿âÄãÓÐô£¿

ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ