ʲôÊÇXML¼°XMLºÍHTMLµÄÇø±ð
XML±»Éè¼ÆÓÃÀ´ÃèÊöÊý¾Ý£¬Æä½¹µãÊÇÊý¾ÝµÄÄÚÈÝ¡£
HTML±»Éè¼ÆÓÃÀ´ÏÔʾÊý¾Ý£¬Æä½¹µãÊÇÊý¾ÝµÄÍâ¹Û¡£
Ó¦¸ÃÕÆÎյĻù´¡ÖªÊ¶£º
ÔÚÄú¼ÌÐøÑ§Ï°Ö®Ç°£¬ÐèÒª¶ÔÒÔÏÂ֪ʶÓлù±¾µÄÁ˽⣺
HTML / XHTML
JavaScript or VBScript
ʲôÊÇXML?
XMLÖ¸¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨EXtensible Markup Language£©
XMLÊÇÒ»ÖÖ±ê¼ÇÓïÑÔ£¬ºÜÀàËÆHTML
XML±»Éè¼ÆÓÃÀ´ÃèÊöÊý¾Ý
XML±êǩûÓб»Ô¤¶¨Òå¡£ÄúÐèÒª×ÔÐж¨Òå±êÇ©¡£
XMLʹÓÃÎļþÀàÐÍÉùÃ÷£¨DTD£©»òÕßXML SchemaÀ´ÃèÊöÊý¾Ý¡£
´øÓÐDTD»òÕßXML SchemaµÄXML±»Éè¼ÆÎª¾ßÓÐ×ÔÎÒÃèÊöÐÔ¡£
XMLÊÇÒ»¸öW3C±ê×¼
XMLÊÇÒ»¸öW3C±ê×¼
¿ÉÀ©Õ¹±ê¼ÇÓïÑÔÓÚ1998Äê2ÔÂ10ÈÕ±»È·Á¢ÎªW3C±ê×¼¡£ www.
XMLÓëHTMLµÄÖ÷Òª²îÒì
XML±»Éè¼ÆÓÃÀ´Ð¯´øÊý¾Ý¡£
XML²»ÊÇÓÃÀ´Ìæ´úHTMLµÄ¡£
ÍøÒ³½ÌÑ§Íø
XMLºÍHTMLΪ²»Í¬µÄÄ¿µÄ¶øÉè¼Æ£º
XML±»Éè¼ÆÓÃÀ´ÃèÊöÊý¾Ý£¬Æä½¹µãÊÇÊý¾ÝµÄÄÚÈÝ¡£
HTML±»Éè¼ÆÓÃÀ´ÏÔʾÊý¾Ý£¬Æä½¹µãÊÇÊý¾ÝµÄÍâ¹Û¡£
HTMLÖ¼ÔÚÏÔʾÐÅÏ¢£¬¶øXMLÖ¼ÔÚÃèÊöÐÅÏ¢¡£
ûÓÐÈκÎÐÐΪµÄXML
XMLÊDz»×÷ΪµÄ¡£
Ò²ÐíÕâÓеãÄÑÒÔÀí½â£¬µ«ÊÇXML²»»á×öÈκÎÊÂÇé¡£XML±»Éè¼ÆÓÃÀ´½á¹¹»¯¡¢´æ´¢ÒÔ¼°´«ÊäÐÅÏ¢¡£
ÏÂÃæÊÇJaniд¸øToveµÄ±ãÇ©£¬´æ´¢ÎªXML£º
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note> www. Õâ¸ö±êÇ©ÓбêÌâÒÔ¼°ÁôÑÔ¡£ËüÒ²°üº¬ÁË·¢ËÍÕߺͽÓÊÜÕßµÄÐÅÏ¢¡£µ«ÊÇ£¬Õâ¸öXMLÎĵµÈÔȻûÓÐ×öÈκÎÊÂÇé¡£Ëü½ö½öÊǰü×°ÔÚXML±êÇ©ÖеĴ¿´âµÄÐÅÏ¢¡£ÎÒÃÇÐèÒª±àдÈí¼þ»òÕß³ÌÐò£¬²ÅÄÜ´«ËÍ¡¢½ÓÊÕºÍÏÔʾ³öÕâ¸öÎĵµ¡£
XMLÊÇÃâ·ÑµÄ¡¢¿ÉÀ©Õ¹µÄ
XML±êǩûÓб»Ô¤¶¨Òå¡£Äú±ØÐë“·¢Ã÷”×Ô¼ºµÄ±êÇ©¡£
±»ÓÃÀ´±ê¼ÇHTMLÎĵµ¼°Æä½á¹¹µÄ±êÇ©ÊÇÔ¤¶¨ÒåµÄ¡£HTMLÎĵµµÄ´´×÷ÕßÖ»ÄÜʹÓÃÔÚHTML±ê×¼Öб»¶¨ÒåµÄÄÇЩ±êÇ©£¨±ÈÈç<p>¡¢<h1>¡££©¡£
XMLÔÊÐí´´×÷Õß¶¨Òå×Ô¼ºµÄ±êÇ©ÒÔ¼°×Ô¼ºµÄÎĵµ½á¹¹¡£
ÉÏÃæµÄÀý×ÓÖеıêǩûÓÐÔÚÈκÎÒ»¸öXML±ê×¼Öб»¶¨Òå¹ý¡£ÕâЩ±êÇ©ÊÇÓÉXMLÎĵµµÄ×÷Õß·¢Ã÷µÄ¡£ ÍøÒ³½ÌÑ§Íø
XMLÊǶÔHTMLµÄ²¹³ä
XML²»ÊÇHTMLµÄÌæ´úÎï¡£
ÄúÐèÒªÀí½âXML²»ÊÇHTMLµÄÌæ´úÎÕâÒ»µã·Ç³£ÖØÒª¡£ÔÚδÀ´µÄWeb¿ª·¢ÖУ¬×îÓпÉÄܳöÏÖµÄÇé¿öÊÇ£¬XML»á±»ÓÃÀ´ÃèÊöÊý¾Ý£¬¶øHTML»á±»ÓÃÀ´¸ñʽ»
Ïà¹ØÎĵµ£º
½«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 Ó³É䣺Êý¾Ý¸ñʽ¼û±í¡£
ÏÖ´òË㽫¡ºÓû§Ãû³Æ¡»£¬¡º¿Í»§ÁªÏµÈË¡ ......
SAX£¨Simple API for XML¼ò³ÆSAX£©Ê¼þÊÇÎÞ״̬µÄ£¬Ò²¾ÍÊÇ˵£¬µ±½ÓÊÕµ½×Ö·ûÊý¾ÝµÄʼþºó£¬²¢²»ÖªµÀ¸Ã×Ö·ûÊý¾ÝÊÇÄÄÒ»¸öÔªËØµÄ
ÄÚÈÝ¡£Í¬ÑùµØ£¬µ±ÊÕµ½ÔªËØ¿ªÊ¼µÄʼþºó£¬Ò²ÎÞ·¨ÖªµÀ¸ÃÔªËØÊÇ·ñÓи¸ÔªËØ£¬ÊÇ·ñÓÐ×ÓÔªËØ£¬ÕâÊÇ
SAXºÍDOM²»Í¬µÄµØ·½¡£SAX½âÎöÆ÷±¾Éí²¢²»Ìá¹©ÔªËØµÄÉÏÏÂÎÄÐÅÏ¢£¬ËùÓÐÏà¹ØÐÅÏ¢µÄ¼Ç¼ÐèÒªÎÒÃÇ×Ô
¼º±à³ ......
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta NAME="Copyright" CONTENT="Copyright (c) 2009 LOADCOM Corporation. All Rights Reserved."> ......
jsµÄ·½·¨£º
if(document.getElementById('example')) {
// do something
}
else {
// do something else
}
jqueryµÄ·½·¨£º
if($('#example').length) {
......