ÇóÒ»¸ö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 Êý¾ÝÑù±¾ÌùһϿÉÒÔ
Ïà¹ØÎÊ´ð£º
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ <folder state="unchecked" label="È«²¿"> ¡¡¡¡<folder state="unchecked" isBra ......
<?xml version="1.0"?> <root> <status>433</status> <msg>Õâ¸öÊǺº×Ö</msg> <serialno>123</serialno> </root> ÈçºÎÓÃASP¶ÁÈ¡ statusÖµ ......
<?xml version="1.0" encoding="utf-8" ?> - <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical&q ......
ÔÚactionÖÐÖÁÉÙÓÐ4¸ö·½·¨£¬Ã¿¸ö·½·¨½ÓÊÜÒ»ÖÖÇëÇó£¬ÀýÈçËĸö·½·¨×î¼òµ¥µÄ¾ÍÊÇÔöɾ¸Ä²é£¬Ã¿Ò»ÖÖ²Ù×÷£¬ÐèҪУÑéµÄactionÊôÐÔÊDz»Í¬µÄ£¬Ð£ÑéÊôÐԵĹæÔòÒ²ÊDz»Í¬µÄ£¬ÔõôÑù²ÅÄÜʹÓÃxmlµÄÊäÈëУÑ飿 Èç¹ûÊÇʹÓÃactionName ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£ ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù. °¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿ ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......