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

JavaÀûÓÃxml½«´óÅúÁ¿Êý¾Ýµ¼³öµ½excelµÄÒ»¸ö·½·¨

±ÊÕßÔÚJava¿ª·¢Öг£³£»áÓöµ½½«Êý¾Ý¿âÊý¾Ýµ¼³öµ½ExcelµÄÒªÇ󣬱ÈÈçÔÚÎÒµÄÒ»¸öÏîÄ¿ÖУ¬¿Í»§ÒªÇóËùÓвéѯ½á¹û¶¼¿ÉÒÔµ¼³öµ½Excel£¬¶ÔÓÚÊý¾ÝÁ¿²»´óµÄ£¨¼¸ÍòÌõ£©£¬Õâ±È½ÏÈÝÒ×ʵÏÖ£¬µ«¶ÔÓÚÊý¾ÝÁ¿±È½Ï´óµÄ£¨¼¸Ê®Íò¼°ÒÔÉÏ£¬¾ßÌåÒª¿´µ¼³öÄÚÈݵÄ×ֶθöÊýºÍ³¤¶Ì£©£¬ÔòÔÚÊý¾Ý¿â²éѯºÍÉú³ÉexcelÎļþÉ϶¼»áÓÐÂé·³¡£
ÒÔÎÒÔÚʵ¼ÊÏîÄ¿ÖеÄÒ»¸ö±íΪÀý£¬Oracle 10gÊý¾Ý¿â£¬Õâ¸ö±íÖÐÓÐ40¶à¸ö×ֶΣ¬ÄÚÈÝÊÇÐÕÃû¡¢ÄêÁä¡¢ÐԱ𡢵ØÖ·¡¢ÉúÈÕ¡¢Ö°Òµ¡¢¹¤×÷µ¥Î»µÈ¸öÈËÐÅÏ¢£¬ÒªÇóµ¼³ö20¶à¸ö×ֶΡ£µ¼³öΪHTMLµÄ±í¸ñµÄ»°£¬¼´Êý¾Ý·ÅÔÚ<table><tr><td>ÖУ¬1ÍòÌõÊý¾Ý´óÔ¼ÐèÒª7.5-8M¡£
¶ÔÓÚÊý¾Ý¿â²éѯ£¬¿ÉÒÔͨ¹ýÒÔ϶þ¸ö·½·¨½â¾ö£º
Ò»¡¢²ÉÓ÷ÖÒ³²éѯ¡£¸ù¾ÝÊý¾Ý¿â·þÎñÆ÷ÐÔÄܺÍÊý¾Ý¿â²Ù×÷Ƶ·±³Ì¶È£¬¾ö¶¨Ã¿Ò³´óС£¬±ÈÈçÿҳ5000µ½10000ÐУ¬Ã¿´Î²éѯ³öÒ»Ò³£¬È»ºóÉú³ÉexcelÎļþ¡£ÕâÖÖ·½·¨µÄȱµãÊÇÐèÒª¶à´Î²éѯÊý¾Ý¿â£¬¶øÊý¾Ý¿â·ÖÒ³²éѯÒòÐèҪʹÓÃÁÙʱ±í£¬ËùÒԱȽϺÄÐÔÄÜ¡£
¶þ¡¢²ÉÓÃÖмä±í¡£Ò»´ÎÐÔ½«²éѯ½á¹û·Åµ½Öмä±íÖУ¬¿É²ÉÓÓselect ...into...”£¬ÔÙ´ÓÖмä±íÖÐÒ»²¿·ÖÒ»²¿·ÖµØÈ¡³öÀ´Éú³Éexcel¡£Ã¿È¡Ò»²¿·Ö£¬¾Í¿ÉÒÔɾ³ýËü£¬»òÕß±ê¼ÇΪ“Òѵ¼³ö”¡£ÕâÖÖ·½·¨ÐèÒª²Ù×÷Öмä±í£¬¹ý³ÌÂ鷳һЩ£¬µ«Ð§Âʺá£
ÏÂÃæÊÇÉú³ÉexcelµÄ¼¸ÖÖ·½·¨(Office 2000ÒÔÉÏʵÏÖ)£º
Ò»¡¢²ÉÓÃPOI»òÕßJXL×é¼þÉú³ÉEXCEL¸ñʽµÄÎļþ¡£ÕâÖÖ·½Ê½¿ÉÒԺܺõؿØÖÆÄÚÈݵĸñʽ£¬È±µãÊÇÕâ¶þÖÖ·½Ê½¶¼Êǽ«EXCELÎļþÕû¸ö¼ÓÔص½ÄÚ´æÖнøÐд¦ÀíµÄ£¬Ïòexcel×·¼ÓÊý¾Ýʱ£¬Ò²ÒªÏÈÈ«²¿¼ÓÔØÔ­Îļþ£¬µ±Êý¾ÝÁ¿´óʱ£¬Éú³ÉµÄEXCELÎļþ»áºÜ´ó£¬¿ÉÄÜ»áÒòÕ¼ÄÚ´æÌ«¶à¶øµ¼ÖÂWEB·þÎñÆ÷ÄÚ´æÒç³ö¡£
¶þ¡¢ÀûÓÃExcelÎļþÖ§³ÖHTML¸ñʽµÄ¹¦ÄÜ£¬¼´Ïµ½«htmlÎļþºó׺Ãû¸ÄΪ.xls£¬¾Í¿ÉÒÔÓÃexcel´ò¿ª¡£ÕâÊÇ×î¼òµ¥µÄ·½·¨£¬ÔÚJspÖÐÖ»Òª½«httpÍ·¸Äһϣ¬Èÿͻ§¶Ëä¯ÀÀÆ÷ÏÂÔØÉú³ÉµÄ.xlsÎļþ£¬¶ø²»ÊÇÈÃä¯ÀÀÆ÷´ò¿ªhtmlÎļþ¾Í¿ÉÒÔÁË¡£JspÎļþ´úÂëÈçÏ£º
view plaincopy to clipboardprint?
<%@ page language="java" contentType="text/html; charset=GBK" %> 
<%  
 String fileName = "export_file_name.xls";//ÏÂÔضԻ°¿òµÄ±£´æÎļþÃû  
 response.setHeader("Content-disposition", "attachment; filename="+ fileName);  
%> 
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmln


Ïà¹ØÎĵµ£º

ÀûÓÃLuceneËÑË÷JavaÔ´´úÂë

ijЩÍøÕ¾ÔÊÐíÈí¼þ¿ª·¢ÉçÍÅͨ¹ý·¢²¼¿ª·¢ÕßÖ¸ÄÏ¡¢°×ƤÊé¡¢FAQs¡¾³£¼ûÎÊÌâ½â´ð¡¿ºÍÔ´´úÂëÒÔʵÏÖÐÅÏ¢µÄ¹²Ïí¡£Ëæ×ÅÐÅÏ¢Á¿µÄÔö³¤£¬ºÍ¼¸¸ö¿ª·¢Õß¹±Ï׳ö×Ô¼ºµÄ֪ʶ¿â£¬ÓÚÊÇÍøÕ¾ÌṩËÑË÷ÒýÇæÀ´ËÑË÷Õ¾µãÉÏÏÖÓеÄËùÓÐÐÅÏ¢¡£ËäÈ»ÕâЩËÑË÷ÒýÇæ¶ÔÎı¾ÎļþµÄËÑË÷¿ÉÒÔ×öµÄºÜºÃ£¬µ«¶Ô¿ª·¢ÕßËÑË÷Ô´´úÂë×öÁ˱ȽÏÑϸñµÄÏÞÖÆ¡£ËÑË÷ÒýÇæÈÏΪԴ´úÂë ......

JavaС¼¼ÇÉ

1¡¢½«String/StringBuffer±äÁ¿µÄÖµÖÃΪnull£¬ÔòÆäËùÕ¼ÄÚ´æ»áºÜ¿ì±»»ØÊÕ¡£
2¡¢ÔËÐйý³ÌÖнöÒÀÀµÓÚÊäÈë²ÎÊýµÄ·½·¨£¬ÈçÊýѧ·½·¨£»¾²Ì¬³ÉÔ±±äÁ¿³£Îª¶¨Òå³£Êý£¬ÓÃÏÞ¶¨´Êpublic static final£»¾²Ì¬³ÉÔ±±äÁ¿¿É½ÚÊ¡ÄÚ´æ¡£
3¡¢½Ó¿Ú£ºÈôÓÐÐèÍê³É³éÏóµÄ¶¯×÷»ò¾ßÓиÅÄîÐÔµÄÊôÐÔ£¬ÔòÔÚ½Ó¿ÚÖж¨Òå¸Ã¶¯×÷»ò¸ÅÄÔÚʵÏָýӿڵÄÀàÖоßÌå» ......

ÓÃWebService´«µÝXMLÊý¾Ý

WebService£¬¼òµ¥Ò»µã˵£¬¾ÍÊǸö¶ÔÍâµÄ½Ó¿Ú,ÀïÃæÓк¯Êý¿É¹©Íⲿ¿Í»§µ÷ÓÃ(×¢Òâ:ÀïÃæͬÑùÓпͻ§²»¿Éµ÷Óõĺ¯Êý).¼ÙÈôÎÒÃÇÊÇ·þÎñ¶Ë,ÎÒÃÇдºÃÁ˸öwebservice,È»ºó°ÑËü¸øÁË¿Í»§(ͬʱÎÒÃǸøÁËËûÃǵ÷ÓùæÔò),¿Í»§¾Í¿ÉÒÔÔÚ´Ó·þÎñ¶Ë»ñÈ¡ÐÅϢʱ´¦ÓÚÒ»¸öÏà¶Ô͸Ã÷µÄ״̬.¼´ÊÇ¿Í»§²»Á˽â(Ò²²»ÐèÒª)Æä¹ý³Ì,ËûÃÇÖ»»ñÈ¡Êý¾Ý. Webservice´«µ ......

Xml Schema

Standards
"DTD" was the first formalized standard, but is rarely used anymore.
"XDR" was an early attempt by Microsoft to provide a more comprehensive standard than DTD. This standard has pretty much been abandoned now in favor of XSD.
"XSD" is currently the de facto standard for describing XML d ......

xmlµÄÓÅȱµã

Óŵ㣺ÓÉÓÚxmlÊÇ¿ÉÀ©Õ¹µÄ£¬ËùÒÔxml¿ÉÒÔÃèÊöÀ´×Ô¶àÖÖÓ¦ÓóÌÐòµÄÊý¾Ý¡£
ͨ¹ýÁ£¶È¸üÐÂÀ´Ìá¸ßÐÔÄÜ¡£XML ÔÊÐíÁ£¶È¸üС£¿ª·¢ÈËÔ±²»±ØÔÚÿ´Î¸Ä¶¯Ê±¶¼·¢ËÍÕû¸ö½á¹¹»¯Êý¾Ý¼¯¡£ÓÐÁËÁ£¶È¸üкó£¬Ö»ÓиıäµÄÔªËزŴӷþÎñÆ÷·¢Ë͵½¿Í»§»ú¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ