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

Sql Server ¶ÔxmlÀàÐ͵IJÙ×÷

 declare @XML XML
SET @XML='<root>
 <OLDVALUE>
  <H_Action id="1130">030</H_Action>
  <D_Action>030</D_Action>
  <OrderCompany>00220</OrderCompany>
  <OrderNumber>10004035</OrderNumber>
  <OrderType>SO</OrderType>
  <LineNumber>10.100</LineNumber>
 </OLDVALUE>
 <NEWVALUE>
  <H_Action>040</H_Action>
  <D_Action>040</D_Action>
  <OrderCompany>00220</OrderCompany>
  <OrderNumber>10004035</OrderNumber>
  <OrderType>SO</OrderType>
  <LineNumber>10.100</LineNumber>
  <LineType>CS</LineType>
  <LoadNumber>8811</LoadNumber>
 </NEWVALUE>
</root>'
select c.value('H_Action[1]','varchar(20)') as H_Action,
c.value('D_Action[1]','varchar(20)') as D_Action,
c.value('OrderCompany[1]','varchar(20)') as OrderCompany,
c.value('OrderNumber[1]','varchar(20)') as OrderNumber,
c.value('OrderType[1]','varchar(20)') as OrderType,
c.value('LineNumber[1]','varchar(20)') as LineNumber
from @XML.nodes('//OLDVALUE') as T(C)
select c.value('H_Action[1]','varchar(20)') as H_Action,
c.value('D_Action[1]','varchar(20)') as  D_Action,
c.value('OrderCompany[1]','varchar(20)') as OrderCompany,
c.value('OrderNumber[1]','varchar(20)') as OrderNumber,
c.value('OrderType[1]','varchar(20)') as OrderType,
c.value('LineNumber[1]','varchar(20)') as LineNumber,
c.value('LineType[1]','varchar(20)') as LineType,
c.value('LoadNumber[1]','varchar(20)') as LoadNumber
from @XML.nodes('//NEWVALUE') as T(C)
CREATE TABLE [dbo].[T_XML](
 [ID] [int] NULL,
 [DOC] [xml] NULL
)
--query
select doc.query('//NEWVALUE') from t_xml
select doc.query('(root/OLDVALUE/H_Action[@id="1130"])') from t_xml
--


Ïà¹ØÎĵµ£º

D Busѧϰ£¨Æߣ©£ºÀûÓÃXML¶¨ÒåD BusÖ®ClientµÄÀý×Ó


¡¡¡¡¼ÌÐøѧϰD-Bus¡£Ö®Ç°Ñ§Ï°ÁËʹÓõײãµÄAPIÀ´·¢ËÍ£¬¼àÌýÏûÏ¢µÄ·½Ê½¡£ÔÚ
D-
Busѧϰ£¨ËÄ£©£º»ù´¡Ð¡Àý×Ó£¨Í¬²½ºÍÒì²½£©
Ö®ÖУ¬ÎÒÃǸø³öÁËÀûÓÃproxy½øÐз¢ËÍmethod_call£¬²¢µÈ´ýmethod_reply»òÕßerrorµÄclientÇé¿ö¡£ÔÚD-BusÖУ¬¿ÉÒÔ½«D-Bus½Ó¿Ú¶¨ÒåÓÃXML¸ñʽ±íÊö´¦Àí£¬²¢ÀûÓù¤¾ß£¬×Ô¶¯Éú³ÉÍ·Îļþ£¬¸ø³ö¹¤ÕûµÄµ÷Ó÷½Ê½¡ ......

XML³£ÓòÙ×÷

 XMLÔÚÎÒÃǵijÌÐòÖÐÓõ½µÄÔ½À´Ô½¶à£¬ÒòΪËü´æ´¢¡¢¶ÁÈ¡¡¢Ð޸Ķ¼±È½Ï·½±ã¡£
ÏÂÃæÎÒÀ´·ÖÏíÒ»ÏÂXMLµÄ³£ÓòÙ×÷(Ôöɾ¸Ä²é)£¬ÏÂÃæÊdzÌÐòÔËÐÐЧ¹û£º
Ôö(Ôö¼Ó½Úµã°üÀ¨´´½¨XML):
/// <summary>
/// ´´½¨XMLÎĵµ
/// </summary>
/// <param name="path"></param>
......

ʹÓÃJOX ½øÐÐJavaBeanºÍXMLµÄת»»

½ñÌìÊÔÁ˸öXMLºÍJavaBeanת»»µÄÈí¼þJOX£¬Ö®Ç°Ò»Ö±ÓÐÕâÑùµÄÐèÇ󣬵«±È½ÏÀ´±È½ÏÈ¥»¹ÊÇÕâ¸ö±È½Ï¼òµ¥ÊµÓá£ÎÒÏë³ý·ÇÎÒÓÐWSµÄÐèÇ󣬷ñÔòÏóJIBXºÍAPACHE µÄWS¹¤¾ß¶ÔÎÒÀ´Ëµ¶¼ÊÇÖØÁ¿¼¶µÄ¡£
ÏÈ¿´¿´Êä³ö½á¹û£º
<?xml version="1.0" encoding="ISO-8859-1"?>
<ApproxItem java-class="com.greatwall.csi.np.model.Approx ......

Spring XMLÅäÖõÄ12¸ö¼¼ÇÉ

 
1 ÔÚActionʵÏÖÀà·½ÃæµÄ¶Ô±È£ºStruts 1ÒªÇóActionÀà¼Ì³ÐÒ»¸ö³éÏó»ùÀࣻStruts 1µÄÒ»¸ö¾ßÌåÎÊÌâÊÇʹÓóéÏóÀà±à³Ì¶ø²»Êǽӿڡ£Struts 2 ActionÀà¿ÉÒÔʵÏÖÒ»¸öAction½Ó¿Ú£¬Ò²¿ÉÒÔʵÏÖÆäËû½Ó¿Ú£¬Ê¹¿ÉÑ¡ºÍ¶¨ÖƵķþÎñ³ÉΪ¿ÉÄÜ¡£Struts 2Ìṩһ¸öActionSupport»ùÀàȥʵÏÖ³£ÓõĽӿڡ£¼´Ê¹Action½Ó¿Ú²»ÊDZØÐëʵÏֵģ¬Ö»ÓÐÒ» ......

Õë¶Ô¸Ã¼Ü¹¹½øÐеĹ淶XMLÑé֤ʧ°Ü

ÔÚAccess2007ÖдÓExcelµ¼Èëʱ£¬¾­³£»áÅöµ½ÈçϵĴíÎóÌáʾ£º“Õë¶Ô¸Ã¼Ü¹¹½øÐеĹ淶XMLÑé֤ʧ°Ü¡£ÒÔÏÂXMLÎĵµÐÐÖдæÔÚ´íÎ󣺣ü¡£”
ÎҵĽâ¾ö·½Ê½ÊÇÓÃÁ´½Ó±í·½Ê½À´´ò¿ªExcelÎļþ£¬È»ºóÔÚ¸´ÖÆÁ´½Ó±í£¬Õ³Ìù¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ