ʲôÊÇ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 Ó³É䣺Êý¾Ý¸ñʽ¼û±í¡£
ÏÖ´òË㽫¡ºÓû§Ãû³Æ¡»£¬¡º¿Í»§ÁªÏµÈË¡ ......
javascript ¿ØÖÆ htmlÔªËØ ÏÔʾ/Òþ²Ø
1¡£±àдjsº¯Êý
<script type="text/javascript">
function display(y){$(y).style.display=($(y).style.display=="none")?"":"none";}
function $(s){return document.getElementById(s);}
</script>
2. ÒªÏÔʾ/Òþ²ØµÄhtmlÔªËؼÓÉÏ id ÊôÐÔ
< ......
<!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."> ......
using System;
using System.Data;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Xml;
using FilmOnLine.Model;
namespace FilmOnLine.DAL
{
public static class FilmService
{
/// <summary>
/// Ìí¼ÓµçÓ°
/// </summary ......