gloox xmlµÄ½âÎöÄ£¿é
gloox×Ô¼ºÊµÏÖÁËxmlµÄ½âÎöÄ£¿é£¬Ã»ÓÐÓõ½µÚÈý·½µÄ¿â(tinyXML£¬expat )
Ö÷ÒªÉæ¼°µÄÎļþ:
tag.h (tag.cpp)
taghandler.h
parser.h (parser.cpp)
1. TagÒ»¸öTag¾ÍÊÇÒ»¸öXMLÔªËØ
ÀýÈç:
a.
<book kind='computer'>
<store id='23'/>
<author>
qiang
</author>
</book>
b. <book id='32'/>
c. <book>name1</book>
Ê×ÏȽéÉÜÒ»¸ö¸ÅÄî: escape-string£¬ºÎΪescape-string?
ÔÚescape-stringÖÐ:
'&'ת»»³É&, '<'ת»»³É<, '>'ת»»³É>.
±àÂë±íÈçÏÂ:
//////////////////////////////////////////////////////////////////////////
// ±àÂë±í £¨ÖмäµÄ¿Õ¸ñÈ¥µô£¬ÕâÀïÖ»ÊÇΪÁË·½±ãÏÔʾ£©:
// -------------------------------------------------------
// | ×Ö·û | Ê®½øÖÆ | Ê®Áù½øÖÆ | THML×Ö·û¼¯ | Unicode |
// -------------------------------------------------------
// | " Ë«ÒýºÅ | & # 34; | & # x22; | " | \u0022 |
// -------------------------------------------------------
// | ' µ¥ÒýºÅ | & # 39; | & # x27; | & apos; | \u0027 |
// -------------------------------------------------------
// | & Óë | & # 38; | & # x26; | & amp; | \u0026 |
// -------------------------------------------------------
// | < СÓںŠ| & # 60; | & # x3C; | & lt; | \u003c |
// -------------------------------------------------------
// | > ´óÓںà | & # 62; | & # x3E; | & gt; | \u003e |
// -------------------------------------------------------
gloox - APIs
Tag::escape() ¹¦ÄÜ: string -> escape-string
Tag::relax() ¹¦ÄÜ: escape-string -> string
Ö÷Òª³ÉÔ±±äÁ¿:
attributes - ËùÓÐÊôÐÔµÄlist
name - ½ÚµãÃû×Ö
cdata - ½ÚµãÊý¾Ý£¬ÀýÈç<name>cdata</name>ÖеÄcda
Ïà¹ØÎĵµ£º
±êÇ©£ºÊý¾Ý·ÃÎÊ LINQ to XML
LINQ to XML²¢²»´òËãÌæ´ú±ê×¼µÄXML API£¬Ö»ÊDz¹³äÁËÕâЩ±ê×¼XMLÀà ......
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
±£´æºÍ¼ÓÔØXMLÎĵµ ......
ͨ¹ýAsp.net(C#)Ó¦ÓóÌÐò¶ÁÈ¡±¾µØÉÏ´«µÄExcleÎļþ,´æ·Åµ½DataSetÖÐ,ͨ¹ýDataSetÖеķ½·¨Ö±½ÓÉú³ÉXMLÎļþ.
C# Code
if (this.FileUpload1.PostedFile != null)
{
string filename = this.FileUpl ......
½«Excelת»¯ÎªXML¡£ÒÔExcel2003ΪÀý˵Ã÷ÈçºÎ½«Êý¾Ýµ¼ÈëMS SQLÊý¾Ý¿â
˵ÏÈ°³µÄϵͳÅäÖãº
ϵͳ£ºWindows Server 2003 R2 X64
¿ª·¢Èí¼þ£ºMicrosoft VS 2008 Team
Office°æ±¾£ºExcel 2003 Excel2007
Êý¾Ý¿â£ºMS SQL 2008
5.1.1½¨Á¢Excel XML Ó³É䣺Êý¾Ý¸ñʽ¼û±í¡£
ÏÖ´òË㽫¡ºÓû§Ãû³Æ¡»£¬¡º¿Í»§ÁªÏµÈË¡ ......
ÓÃTXT±à¼ÁËÒ»¸öXMLÎĵµ
<?xml version="1.0" encoding="utf-8"?>
<TEST>"
<Test Value="ÕâÊÇÒ»¸ö²âÊÔ" />
</TEST>
ÓÃIE´ò¿ªµÄʱºòÒ»Ö±ÏÔʾÓдíÎó£¬ÏÔʾººÓï×Ö·û²»Ö§³Ö¡£
¸ÄΪencoding=“gb2312”ºóÏÔʾÕý³£ÁË¡£
µ«Õâ¸ö½á¹ûÓë³õÖÔÎ¥±³£¬ÒòΪUTF-8ÊÇÖ§³ÖËùÓÐÓïÑԵġ£
ºóÀ´²éÕÒÔÒ ......