java excel ÎļþÏÂÔØ
ʹÓÃservletÀ´ÏÂÔØÎļþ£¬ÆäÔÀí·Ç³£¼òµ¥£¬Ö»ÒªµÃµ½ÎļþµÄÊäÈëÁ÷£¨»òÏàÓ¦×Ö½Ú£©£¬È»ºóдÊä³öÁ÷¼´¿É¡£ÏÖ¾ÍÆäÖеöϸ½ÚÎÊÌâÕ¹¿ª£º
1. MIMEÀàÐ͵ÄÉèÖãº
Web ä¯ÀÀÆ÷ʹÓà MIME ÀàÐÍÀ´Ê¶±ð·Ç HTML Îĵµ£¬²¢¾ö¶¨ÈçºÎÏÔʾ¸ÃÎĵµÄÚµÄÊý¾Ý¡£
ÀýÈçEXCELÎļþµÄ MIME ÀàÐÍÊÇ "application/vnd.ms-excel "¡£ÒªÓÃservlet À´´ò¿ªÒ»¸ö EXCEL Îĵµ£¬ÐèÒª½« response ¶ÔÏóÖÐ header µÄ contentType ÉèÖóɓapplication/vnd.ms-excel ”¡£
response.setContentType(contentType);
2. Content disposition
HTTP response headerÖеÄcontent-disposition ÔÊÐí servlet Ö¸¶¨Îĵµ±íʾµÄÐÅÏ¢¡£Ê¹ÓÃÕâÖÖheader £¬Äã¾Í¿ÉÒÔ½«ÎĵµÖ¸¶¨³Éµ¥¶À´ò¿ª£¨¶ø²»ÊÇÔÚä¯ÀÀÆ÷Öдò¿ª£©£¬»¹¿ÉÒÔ¸ù¾ÝÓû§µÄ²Ù×÷À´ÏÔʾ¡£
Èç¹ûÓû§Òª±£´æÎĵµ£¬Ä㻹¿ÉÒÔΪ¸ÃÎĵµ½¨ÒéÒ»¸öÎļþÃû¡£Õâ¸ö½¨ÒéÃû³Æ»á³öÏÖÔÚ Save As ¶Ô»°¿òµÄ“ÎļþÃû”À¸ÖС£Èç¹ûûÓÐÖ¸¶¨£¬Ôò¶Ô»°¿òÖоͻá³öÏÖ servlet µÄÃû×Ö¡£
servlet ÖУ¬½« header ÉèÖóÉÏÂÃæÕâÑù£º
response.setHeader("Content-disposition","attachment;filename="+ "Example.xls" );
response.setHeader("Content-Disposition", "inline; filename="fliename)
µã»÷´ò¿ª»áÔÚieÖдò¿ª¡£
ÐèҪ˵Ã÷µÄÓÐÈýµã£º
Ø ÖÐÎÄÎļþÃûÐèÒª½øÐÐiso8859-1תÂë·½¿ÉÕýÈ·ÏÔʾ£º
fileName = new String(fileName.getBytes("GBK"),"iso8859-1");
Ø ´«µÝµÄÎļþÃû£¬ÐèÒª°üº¬ºó׺Ãû£¨Èç¹û´ËÎļþÓкó׺Ãû£©£¬·ñÔò¶ªÊ§ÎļþµÄÊôÐÔ£¬¶ø²»ÄÜ×ÔÐÐÑ¡ÔñÏà¹Ø³ÌÐò´ò¿ª¡£
Ø ÓÐÏÂÔØÇ°Ñ¯ÎÊ£¨ÊÇ´ò¿ªÎļþ»¹ÊDZ£´æµ½¼ÆËã»ú£©ºÍͨ¹ýIEä¯ÀÀÆ÷Ö±½ÓÑ¡ÔñÏà¹ØÓ¦ÓóÌÐò²å¼þ´ò¿ªÁ½ÖÖ·½Ê½£¬Ç°ÕßÈçÉÏ´úÂëËùʾ£¬ºóÕßÈçÏ£º
response.setHeader("Content-disposition","filename="+ "Example.xls" );
3. ÔÚÑо¿ÎļþµÄÉÏ´«¼°ÏÂÔØ¹ý³ÌÖУ¬Óм¸µãÌå»á
³ÌÐòµÄI/O²Ù×÷ÍùÍùÊÇÐÔÄܵį¿¾±ËùÔÚ£¬java io¶¨ÒåÁËÁ½¸ö»ù±¾µÄ³éÏóÀà:InputStreamºÍOutputStream,¶ÔÓÚ²»Í¬µÄÊý¾ÝÀàÐͱÈÈç´ÅÅÌ£¬ÍøÂçÓÖÌṩÁ˲»Í¬µÄʵÏÖ£¬java.ioÒ²ÌṩÁËһЩ»º³åÁ÷(BufferedStream)£¬Ê¹Ó²ÅÌ¿ÉÒԺܿìµÄ¶Áдһ´ó¿éµÄÊý¾Ý, ¶øJava»ù±¾µÄI/OÀàÒ»´ÎÖ»ÄܶÁдһ¸ö×Ö½Ú,µ«»º³åÁ÷(BufferedStream)¿ÉÒÔÒ»´Î¶ÁдһÅúÊý¾Ý£¬,»º³åÁ÷(Buffered Stream)´ó´óÌá¸ßÁËI/OµÄÐÔÄÜ¡£ËùÒÔ:
ØÐ¡¿éС¿éµÄ¶ÁдÊý¾Ý»á·Ç³£Âý,Òò´Ë,¾¡Á¿´ó¿éµÄ¶ÁдÊý¾Ý
ØÊ¹ÓÃBufferedInputStreamº
Ïà¹ØÎĵµ£º
package com.gamvan.tools;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
public class FormatDateTime {
/**
* ÈÕÆÚÀà²Ù×÷¹¤¾ß
*/
public static String formatDateTime(String ymd){
//¸ñʽ»¯µ±Ç°Ê±¼ä
java.text ......
OOµÄ¾«Ë裬ÎÒÒÔΪ£¬ÊǶԶÔÏóµÄ³éÏó£¬×îÄÜÌåÏÖÕâÒ»µãµÄ¾ÍÊǽӿڡ£ÎªÊ²Ã´ÎÒÃÇÌÖÂÛÉè¼ÆÄ£Ê½¶¼Ö»Õë¶Ô¾ß±¸Á˳éÏóÄÜÁ¦µÄÓïÑÔ£¨±ÈÈçc++¡¢java¡¢c#µÈ£©£¬¾ÍÊÇÒòΪÉè¼ÆÄ£Ê½ËùÑо¿µÄ£¬Êµ¼ÊÉϾÍÊÇÈçºÎºÏÀíµÄÈ¥³éÏó¡££¨cowboyµÄÃûÑÔÊÇ"³éÏó¾ÍÊdzéÈ¥ÏñµÄ²¿·Ö"£¬¿´ËƵ÷Ù©£¬ÊµÄËÖÁÀí£©¡£
Éè¼ÆÄ£Ê½ÖÐ×î»ù´¡µÄÊǹ¤³§Ä£Ê½£¨Factory£©£¬ÔÚÎÒ×î ......
Java Web Start ÊǰïÖú¿Í»§»ú¶ËÓ¦ÓóÌÐò¿ª·¢µÄÒ»¸öм¼Êõ£¬ËüµÄ¶ÀÌØÖ®´¦ÔÚÓÚ½«Äú´Ó¹ØÐĿͻ§»úÊÇÈçºÎÆô¶¯µÄ£¨´Ó Web ä¯ÀÀÆ÷»òÊÇ×ÀÃæ£©Öнâ·Å³öÀ´¡£ÁíÍ⣬¸Ã¼¼ÊõÌṩÁËÒ»¸öʹ Web ·þÎñÆ÷ÄܶÀÁ¢µÄ·Ö·¢ºÍ¸üпͻ§»ú´úÂëµÄ¼¯ºÏ²¿Êð·½°¸¡£
Java Web Start ÊÇÒ»¸öÈí¼þ¼¼Êõ£¬Ëü°üº¬ÁË applet µÄ¿ÉÒÆÖ²ÐÔ¡¢Servl ......
1. Java SE£¨Java Platform£¬Standard Edition£©¡£Java SE ÒÔǰ³ÆÎª
J2SE¡£ËüÔÊÐí¿ª·¢ºÍ²¿ÊðÔÚ×ÀÃæ¡¢·þÎñÆ÷¡¢Ç¶Èëʽ»·¾³ºÍʵʱ»·¾³ÖÐʹÓÃµÄ Java Ó¦ÓóÌÐò¡£Java SE °üº¬ÁËÖ§³Ö Java Web
·þÎñ¿ª·¢µÄÀ࣬²¢Îª Java Platform£¬Enterprise Edition£¨Java EE£©Ìṩ»ù´¡¡£
2. Java EE£¨Java Platform£¬Enterprise Edition£©¡£ ......