ÇóÒ»¸ö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 Êý¾ÝÑù±¾ÌùһϿÉÒÔ
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦ ²»½èÖúDataSet µ¼Èë¶ÁÈ¡TXTÎļþ È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.) ½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ ¹ý·ºÃºº °ï¸öæÈö^^ ²»»á£¬°ïÂ¥Ö÷ ......
ÒÑÖªÎļþ1.xmlºÍÊý¾ÝÎļþdb.xml£¬ÈçºÎÓÃjava±àд³ÌÐò£¬µÃ³ö2.xmlÎļþ£¿ 1.ÒÑÖªxmlÎļþ 1.xml½á¹¹ÈçÏ£º <cs> <cs name="cs1" details="This is cs1" country="China&q ......
²ÉÓÃDOM ½øÐнâÎöxml¡£ÒªÇó½«xml×Ö´®²åÈëÖ¸¶¨½Úµã×÷ΪÆä×ӽڵ㠱ÈÈ磺 Ôxml <root> </root> Òª²åÈëµÄxml×Ö´® <a>test</a> Ä¿µÄxml£º <root> <a> ......
ÒýÓõÄÎļþ°üº¬´íÎó£¨XXXXX.xsd£©¡£Óйظü¶àÐÅÏ¢£¬ÓÒ¼üµ¥»÷ÏûÏ¢²¢Ñ¡Ôñ¡°ÏÔʾÏêϸÐÅÏ¢...¡± ÇëÎÊÕâÊÇÄijö´íÁË£¿£¿£¿ÎÒÔÚelipseÀïû´í Äõ½myelipseÀïxmlÈ«ÊÇÕâ¸ö´íÎ󡣡£¡£¡£ ÊDz»ÊÇÉÙ°ü°¡£¿ °ü¶¼ÔÚÄØÑ½¡£¡£¡£ ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£ ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù. °¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿ ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......