HTMLµ÷ÓÃXMLÊý¾ÝʵÀý
ÎÄÕÂת×Ô¡¾PHP̽·Õß¡¿
XML Ó¦ÓÃÓÚ web ¿ª·¢µÄÐí¶à·½Ã棬³£ÓÃÓÚ¼ò»¯Êý¾ÝµÄ´æ´¢ºÍ¹²Ïí¡£
Èç¹ûÐèÒªÔÚ HTML ÎĵµÖÐÏÔʾ¶¯Ì¬Êý¾Ý£¬ÄÇôÿµ±Êý¾Ý¸Ä±äʱ½«»¨·Ñ´óÁ¿µÄʱ¼äÀ´±à¼ HTML£¬
XML ¿ÉÒÔ°ÑÊý¾Ý´Ó HTML ÖзÖÀ뿪À´¡£
ͨ¹ý XML£¬Êý¾ÝÄܹ»´æ´¢ÔÚ¶ÀÁ¢µÄ XML ÎļþÖС£ÕâÑùÄã¾Í¿ÉÒÔרעÓÚʹÓà HTML ½øÐв¼¾ÖºÍÏÔʾ£¬²¢È·±£Ð޸ĵײãÊý¾Ý²»ÔÙÐèÒª¶Ô HTML ½øÐÐÈκεĸı䡣
ͨ¹ýʹÓü¸ÐÐ JavaScript£¬¾Í¿ÉÒÔ¶Áȡһ¸öÍⲿ XML Îļþ£¨XML½âÎö£©£¬È»ºó¸üРHTML ÖеÄÊý¾ÝÄÚÈÝ¡£
´ó¶àÊýä¯ÀÀÆ÷¶¼ÓжÁÈ¡ºÍ²Ù×÷ XML µÄÄÚ½¨ XML ½âÎöÆ÷¡£
½âÎöÆ÷°Ñ XML ת»»Îª JavaScript ¿É·ÃÎʵĶÔÏó¡£
ÔÚ HTML ÖÐÒÔ±í¸ñÐÎʽÏÔʾXMLÊý¾Ý¾ßÌåʵÀýÈçÏ£º
ÔÎĵØÖ·£ºhttp://www.phpwell.com/?p=71
Ïà¹ØÎĵµ£º
±¾ÎÄÒ»¹²½éÉÜÁËÆßÖÖ·½·¨£º
Ò»£º×î¼òµ¥µÄ¼ÓÃܽâÃÜ
¶þ£º×ªÒå×Ö·û""µÄÃîÓÃ
Èý£ºÊ¹ÓÃMicrosoft³öÆ·µÄ½Å±¾±àÂëÆ÷Script EncoderÀ´½øÐбàÂë £¨×Ô´´¼òµ¥½âÂ룩
ËÄ£ºÈÎÒâÌí¼ÓNUL¿Õ×Ö·û£¨Ê®Áù½øÖÆ00H£© £¨×Ô´´£©
Î壺ÎÞÓÃÄÚÈÝ»ìÂÒÒÔ¼°»»ÐпոñTAB´ó·¨
Áù£º×Ôд½âÃܺ¯Êý·¨
Æß£º´íÎóµÄÀûÓà £¨×Ô´´£©
¡¡¡¡ÔÚ×öÍøÒ³Ê±£¨ ......
·½·¨Ò»£º
<html:select property="id"> //ÕâÀïÒ»¶¨²»ÄÜÔÙÓÃvlueÊôÐÔÁË£¬Ö»ÓÃÒ»¸öproperty¾Í¿ÉÒÔÁË
<c:forEach var="row" item="${rs.rows}">
<html:option value="row.id">
......
½«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;
......