XML½âÎö·½·¨½²½â
XMLÏÖÔÚÒѾ³ÉΪһÖÖͨÓõÄÊý¾Ý½»»»¸ñʽ,ËüµÄƽ̨ÎÞ¹ØÐÔ,ÓïÑÔÎÞ¹ØÐÔ,ϵͳÎÞ¹ØÐÔ,¸øÊý¾Ý¼¯³ÉÓë½»»¥´øÀ´Á˼«´óµÄ·½±ã¡£¶ÔÓÚXML±¾ÉíµÄÓ﷨֪ʶÓë¼¼Êõϸ½Ú,ÐèÒªÔĶÁÏà¹ØµÄ¼¼ÊõÎÄÏ×,ÕâÀïÃæ°üÀ¨µÄÄÚÈÝÓÐDOM(Document Object Model),DTD(Document Type Definition),SAX(Simple API for XML),XSD(Xml Schema Definition),XSLT(Extensible Stylesheet Language Transformations),¾ßÌå¿É²ÎÔÄw3c¹Ù·½ÍøÕ¾Îĵµhttp://www.w3.org»ñÈ¡¸ü¶àÐÅÏ¢¡£
XMLÔÚ²»Í¬µÄÓïÑÔÀï½âÎö·½Ê½¶¼ÊÇÒ»ÑùµÄ,Ö»²»¹ýʵÏÖµÄÓï·¨²»Í¬¶øÒÑ¡£»ù±¾µÄ½âÎö·½Ê½ÓÐÁ½ÖÖ,Ò»ÖÖ½ÐSAX£¬ÁíÒ»ÖÖ½ÐDOM¡£SAXÊÇ»ùÓÚʼþÁ÷µÄ½âÎö,DOMÊÇ»ùÓÚXMLÎĵµÊ÷½á¹¹µÄ½âÎö¡£¼ÙÉèÎÒÃÇXMLµÄÄÚÈݺͽṹÈçÏÂ:
<?xml version="1.0" encoding="UTF-8"?>
<employees>
<employee>
<name>ddviplinux</name>
<sex>m</sex>
<age>30</age>
</employee>
</employees>
±¾ÎÄʹÓÃJAVAÓïÑÔÀ´ÊµÏÖDOMÓëSAXµÄXMLÎĵµÉú³ÉÓë½âÎö¡£
Ê×Ïȶ¨ÒåÒ»¸ö²Ù×÷XMLÎĵµµÄ½Ó¿ÚXmlDocument Ëü¶¨ÒåÁËXMLÎĵµµÄ½¨Á¢Óë½âÎöµÄ½Ó¿Ú¡£
package com.alisoft.facepay.framework.bean;
/**
*
* @author hongliang.dinghl
* ¶¨ÒåXMLÎĵµ½¨Á¢Óë½âÎöµÄ½Ó¿Ú
*/
public interface XmlDocument {
/**
* ½¨Á¢XMLÎĵµ
* @param fileName Îļþȫ·¾¶Ãû³Æ
*/
public void createXml(String fileName);
/**
* ½âÎöXMLÎĵµ
* @param fileName Îļþȫ·¾¶Ãû³Æ
*/
public void parserXml(String fileName);
}
1.DOMÉú³ÉºÍ½âÎöXMLÎĵµ
Ϊ XML ÎĵµµÄÒѽâÎö°æ±¾¶¨ÒåÁËÒ»×é½Ó¿Ú¡£½âÎöÆ÷¶ÁÈëÕû¸öÎĵµ£¬È»ºó¹¹½¨Ò»¸öפÁôÄÚ´æµÄÊ÷½á¹¹£¬È»ºó´úÂë¾Í¿ÉÒÔʹÓà DOM ½Ó¿ÚÀ´²Ù×÷Õâ¸öÊ÷½á¹¹¡£Óŵ㣺Õû¸öÎĵµÊ÷ÔÚÄÚ´æÖУ¬±ãÓÚ²Ù×÷£»Ö§³Öɾ³ý¡¢Ð޸ġ¢ÖØÐÂÅÅÁеȶàÖÖ¹¦ÄÜ£»È±µã£º½«Õû¸öÎĵµµ÷ÈëÄڴ棨°üÀ¨ÎÞÓõĽڵ㣩£¬ÀË·Ñʱ¼äºÍ¿Õ¼ä£»Ê¹Óó¡ºÏ£ºÒ»µ©½âÎöÁËÎĵµ»¹Ðè¶à´Î·ÃÎÊÕâЩÊý¾Ý£»Ó²¼þ×ÊÔ´³ä×㣨ÄÚ´æ¡¢CPU£©¡£
package com.alisoft.facepay.framework.bean;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.
Ïà¹ØÎĵµ£º
½«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 Ó³É䣺Êý¾Ý¸ñʽ¼û±í¡£
ÏÖ´òË㽫¡ºÓû§Ãû³Æ¡»£¬¡º¿Í»§ÁªÏµÈË¡ ......
ʹÓÃ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¡£Èç¹ûÑ¡Ôñ²¿·Ö£ ......
//»ñÈ¡Êý¾Ý¿âÊý¾Ý·µ»Ø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;
......
XMLÊDZ»Éè¼ÆΪ´æ´¢¡¢´«ÊäÒÔ¼°½»»»Êý¾ÝµÄ¡£XML²»ÊDZ»Éè¼ÆΪÓÃÀ´ÏÔʾÊý¾ÝµÄ¡£
¡¡¡¡XML¿ÉÒÔ½«HTMLÓëÊý¾Ý·ÖÀë
¡¡¡¡Í¨¹ýʹÓÃXML£¬ÄúµÄÊý¾Ý¿É´æ´¢ÓÚHTMLÖ®Íâ¡£
¡¡¡¡µ±ÎÒÃÇʹÓÃHTMLÀ´ÏÔʾÊý¾Ýʱ£¬Êý¾Ý´æ´¢ÓÚHTMLÖС£Í¨¹ýʹÓÃXML£¬Êý¾Ý¿ÉÒÔ±»´æ´¢ÔÚµ¥¶ÀµÄXMLÎļþÖС£ÕâÑù×öµÄ»°£¬Äú¾Í¿ÉÒÔ°Ñ×¢ÒâÁ¦¼¯ÖÐÔÚʹÓÃHTML½øÐÐÊý¾Ý²¼¾Öº ......
ÈçºÎ¼ÓÔØÓÐÍâ¹úºÍÌØÊâ×Ö·ûµÄÎĵµ£¿
¡¡¡¡Îĵµ¿ÉÒÔ°üº¬Íâ¹ú×Ö·û£¬ÀýÈ磺
¡¡¡¡foreign characters (úóí?)
¡¡¡¡ÀýÈç íá µÄÍâ¹ú×Ö·û±ØÐëÔÚÇ°Ãæ¼ÓÉÏ escape ÐòÁС£Íâ¹ú×Ö·û¿ÉÒÔÊÇ UTF-8 ±àÂë»òÓò»Í¬±àÂëÖ¸¶¨£¬ÈçÏÂËùʾ£º
¡¡¡¡foreign characters (íá)
¡¡¡ ......