Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Êý¾ÝÑù±¾ÌùһϿÉÒÔ


Ïà¹ØÎÊ´ð£º

Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄxml - .NET¼¼Êõ / ASP.NET

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......

ÈçºÎÓÃASP¶ÁÈ¡ XML - Web ¿ª·¢ / ASP

<?xml version="1.0"?>
<root>
<status>433</status>
<msg>Õâ¸öÊǺº×Ö</msg>
<serialno>123</serialno>
</root>
ÈçºÎÓÃASP¶ÁÈ¡ statusÖµ ......

java xmlÎÄÌâ - Java / Java SE

<?xml version="1.0" encoding="utf-8" ?> 
- <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical&q ......

¹ØÓÚStruts2µÄxmlÊäÈëУÑé - Java / Java EE

ÔÚactionÖÐÖÁÉÙÓÐ4¸ö·½·¨£¬Ã¿¸ö·½·¨½ÓÊÜÒ»ÖÖÇëÇó£¬ÀýÈçËĸö·½·¨×î¼òµ¥µÄ¾ÍÊÇÔöɾ¸Ä²é£¬Ã¿Ò»ÖÖ²Ù×÷£¬ÐèҪУÑéµÄactionÊôÐÔÊDz»Í¬µÄ£¬Ð£ÑéÊôÐԵĹæÔòÒ²ÊDz»Í¬µÄ£¬ÔõôÑù²ÅÄÜʹÓÃxmlµÄÊäÈëУÑ飿
Èç¹ûÊÇʹÓÃactionName ......

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

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

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