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

ʲôÊÇ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»á±»ÓÃÀ´¸ñʽ»


Ïà¹ØÎĵµ£º

5.1½«Excelת»¯ÎªXMLµ¼ÈëÊý¾Ý¿âÖ®Ò»

½«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ÔªËØ ÏÔʾ/Òþ²Ø


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 ÊôÐÔ
< ......

InstallshieldÐÞ¸ÄXMLÎļþ

ʹÓÃXML changeÐÞ¸ÄxmlÎļþµÄ»ù±¾²½Öè
(½öÏÞÓÚInstallscript MSIÏîÄ¿ÒÔ¼°Basic MSIÏîÄ¿)
1.µ¼ÈëXMLÎļþ¡£ÔÚSystem ConfigurationÊÔͼÖÐÑ¡ÔñXML File Changes£¬ÓÒ¼üXML
File¡£Ñ¡ÔñImport£¬¿ÉÒÔÆô¶¯Import XML
wizard¡£NextÖ®ºó£¬Ñ¡ÔñÐèÒªµ¼ÈëµÄXMLÎļþ£¨¿ÉÒÔÔÚÏÂÀ­¿òÖÐÑ¡ÔñÀàÐÍ£©¡£NextÖ®ºó£¬Select
ALL¡£Èç¹ûÑ¡Ôñ²¿·Ö£ ......

javaÉú³Éxml¸ñʽÊý¾Ý

//»ñÈ¡Êý¾Ý¿âÊý¾Ý·µ»Ølist
public List queryAll(int fcateId) {
List list = new ArrayList();
String sql = "select * from g_Account where fCateID=? order by fCode";
Connection con = SqlHelp.getConn();//»ñµÃÁ¬½Ó£¬sqlhelp×Ô¼ºÐ´µÄ¹¤¾ßÀà
PreparedStatement pst = null;
ResultSet rs = null;
......

¶ÁÈ¡excel£¨JXL£©¡¾Êä³öΪhtml¸ñʽ¡¿

package test;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;
import jxl.Cell;
import jxl.Range;
import jxl.Sheet;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.forma ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ