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º
Ïà¹ØÎĵµ£º
Core Java Volume I Fundamentals 8th Edition
Core Java Volume II Advanced Features 8th Edition
Java CAPS Basics Implementing Common EAI Patterns
Java³ÌÐòÉè¼Æ´óѧ½Ì³Ì
Ajax on Java
......
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 ......
JAVAʼþÎ޷ǾÍÊǼüÅÌʼþ£¬Êó±êʼþ£¬°´Å¥µÈʼþ¡£×¨Òµµã¿ÉÒÔ·ÖΪÓïÒåʼþ£¨°´Å¥µÈµ½Ê¼þ£©ºÍµÍ²ãʼþ£¨¼üÅÌʼþ£¬Êó±êʼþ£©£»
ÏÂÃæÎÒ¼òÒªµÄ×ܽáһϣº
1¡¢Êó±êʼþ£ºµãÊó±ê°´Å¥ÊÂËü»áµ÷ÓÃÈý¸ö¼àÌýÆ÷·½·¨£ºmousePressed,mouseReleased,mouseClicked.
Êó±êʼþÌṩÁËmousePressed,mouseClicked,mouseDragged,mouseEnter ......
ÔÚÍøÉÏÕÒÁ˵ã»ù´¡ÌâÄ¿,×Ô¼º×öÁË×ö,ÏÂÃæÊÇÌâÄ¿:
1.JavaÓÐÄÇЩ»ù±¾Êý¾ÝÀàÐÍ£¬StringÊDz»ÊÇ»ù±¾Êý¾ÝÀàÐÍ£¬ËûÃÇÓкÎÇø±ð¡£
2.×Ö·û´®µÄ²Ù×÷£º
дһ¸ö·½·¨£¬ÊµÏÖ×Ö·û´®µÄ·´×ª£¬È磺ÊäÈëabc£¬Êä³öcba
дһ¸ö·½·¨£¬ÊµÏÖ×Ö·û´®µÄÌæ»»£¬È磺ÊäÈëbbbwlirbbb£¬Êä³öbbbhhtc ......