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

Êý¾Ý¿â²éѯXML½á¹¹£¬FOR XML PATH Óï¾äµÄÓ¦ÓÃ


/*
Êý¾Ý¿â²éѯXML½á¹¹£¬FOR XML PATH Óï¾äµÄÓ¦ÓÃ
*/
FOR XML PATH Óï¾äµÄÓ¦ÓÃ:
CREATE  TABLE TempTable(UserID int , UserName nvarchar(50));
insert into TempTable (UserID,UserName) values (1,'a')
insert into TempTable (UserID,UserName) values (2,'b')
select UserID,UserName from TempTable FOR XML PATH
-----ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
<row>
<UserID>1</UserID>
<UserName>a</UserName>
</row>
<row>
<UserID>2</UserID>
<UserName>b</UserName>
</row>
----´ó¼Ò¿ÉÒÔ¿´µ½Á½ÐÐÊý¾ÝÉú³ÉÁËÁ½¸ö½Úµã£¬ÐÞ¸ÄÒ»ÏÂPATHµÄ²ÎÊý£º
select UserID,UserName from TempTable FOR XML PATH('lzy')
----ÔÙ´ÎÔËÐÐÉÏÊö½Å±¾£¬½«Éú³ÉÈçϵĽá¹û£º
<lzy>
<UserID>1</UserID>
<UserName>a</UserName>
</lzy>
<lzy>
<UserID>2</UserID>
<UserName>b</UserName>
</lzy>
----¿ÉÒÔ¿´µ½½Úµã±ä³É£¬ÆäʵPATH() À¨ºÅÄڵIJÎÊýÊÇ¿ØÖƽڵãÃû³ÆµÄ£¬ÕâÑùµÄ»°´ó¼Ò¿ÉÒÔ¿´Ò»ÏÂÈç¹ûÊÇ¿Õ×Ö·û´®£¨²»ÊÇûÓвÎÊý£©»áÊÇʲô½á¹û?
select UserID,UserName from TempTable FOR XML PATH('')
----Ö´ÐÐÉÏÃæÕâ¶Î½Å±¾½«Éú³É½á¹û£º
<UserID>1</UserID>
<UserName>a</UserName>
<UserID>2</UserID>
<UserName>b</UserName>
---ÕâÑù¾Í²»ÏÔʾÉϼ¶½ÚµãÁË£¬
---´ó¼ÒÖªµÀÔÚ PATH ģʽÖУ¬ÁÐÃû»òÁбðÃû±»×÷Ϊ XPath ±í´ïʽÀ´´¦Àí£¬
---Ò²¾ÍÊÇ˵£¬ÊÇÁеÄÃû×Ö£¬ÕâÑù´óµ¨ÊÔÑéһϲ»¸øÖ¸¶¨ÁÐÃûºÍ±ðÃû»áÊÇÔõôÑù£¿
select cast(userid as varchar) +','+ username from TempTable for xml path('')
select CAST(UserID AS varchar) + '',UserName + '' from TempTable FOR XML PATH('')
---ÔËÐÐÉÏÃæÕâ¾ä½«Éú³É½á¹û
----1a2b
----ËùÓÐÊý¾Ý¶¼Éú³ÉÒ»ÐУ¬¶øÇÒ»¹Ã»ÓÐÁ¬½Ó×Ö·û£¬ÕâÑùµÄÊý¾Ý¿ÉÄܶԴó¼ÒûÓÐÓô¦£¬»¹¿ÉÒÔÔٱ仯һÏ£º
select CAST(UserID AS varchar) + ',',UserName + '',';' from TempTable FOR XML PATH('')
select CAST(userid as varchar) +',' +username +';' from TempTable for xml path('')
----Éú³É½á¹û
1,a;2,b;
----´ó¼ÒÏÖÔÚÃ÷°×Á˰ɣ¬¿ÉÒÔͨ¹ý¿ØÖƲÎÊýÀ´Éú³É×Ô¼ºÏëÒªµÄ½á¹û£¬ÀýÈ磺
select '{' + CAST(UserID A


Ïà¹ØÎĵµ£º

XML ²éѯ¡¢Ìí¼Ó¡¢Ð޸ġ¢É¾³ý

Query:
XmlDocument doc = new XmlDocument();
  
doc.Load(Server.MapPath(".\\db\\dbGuest.xml"));
           
//UserÊÇXML¸ù½Úµã,Name×Ö½Úµã
      lbEmail.Text =
doc.SelectSingleNode("//User ......

ÔõôÓÃXML´«ËÍͼÏñÊý¾Ý

DelphiÖÐÓÐÒ»¸öEncdDecdµ¥Ôª,uses   Ëü,ÒÔϵĺ¯Êý³ö×ÔÕâ¸öµ¥Ôª  
   
  1.ÓÃTBitmap¶ÔÏóLoadͼƬ  
    TBitmap.LoadfromFile  
  2.°ÑTBitmap´æÈëÒ»¸öStreamÖÐ    
TBitmap.SaveToStream(mapStream)  
  3.°ÑͼƬÁ÷½øÐÐbase64±àÂë,É ......

XMLTextReader¶ÔXMLÎļþµÄ¶ÁÈ¡

using System;
using System.Xml;
namespace ReadXMLfromFile
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class Class1
{
static void Main(string[] args)
{
XmlTextReader reader = new XmlTextReader ("books.xml");
......

DataTable.Select½øÐÐXMLÊý¾ÝµÄ²éѯ

×î½üÔÚ²©¿ÍÔ°´úÂëµÄÖØ¹¹ÖÐ, ÎÒ·¢¾õÓÃDataTable.Select½øÐÐXMLÊý¾ÝµÄ²éѯҲÊÇͦ·½±ãµÄ¡£
±ÈÈçÎÒÃǸù¾ÝUrlÖвÎÊýÖµ²éѯXMLÊý¾ÝÖÐÏàÓ¦½ÚµãµÄÊý¾Ý¡£
¼ÙÈçÎÒÃÇÓÐÕâÑùµÄXmlÊý¾ÝÎļþCatalog.xml:
<Navigation>
      <Catalog title="·Ç¼¼ÊõÇø" url="default.aspx?cate=2" rss="MainFeed.as ......

ʹÓÃVelocity+zip+xml¿ìËÙ¹¹½¨word2007Îĵµ

¼¼Êõ½éÉÜ
     ÔÚÒ»°ãµÄJavaÏîÄ¿ÖÐ,Éú³ÉwordÎĵµµÄʱºò,ÎÒÃÇ»áʹÓõ½jacobÀ´×÷ΪÎÒÃÇÉú³ÉwordÎĵµµÄ¹¤¾ß,µ«ÊÇjacobÊÇͨ¹ýʹÓÃJNIµ÷ÓÃdllÎļþÀ´ÊµÏÖ,ÕâÑùµÄ¹¤×÷·½Ê½´øÀ´Á˼«´óµÄÐÔÄÜ¿ªÏú.ÕâÀïÎÒÃDzÉÓÃVelocity+zip+xml¿ìËÙ¹¹½¨word2007Îĵµ,ËùÒÔ˵Õâ¸ö¼¼ÊõʵÏÖÓÐÒ»¶¨µÄ¾ÖÏÞÐÔ,Éú³ÉµÄ±ØÐëÊÇword2007Îĵµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ