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º
Ïà¹ØÎĵµ£º
×î½ü½ÓÊÖ¸ù¾ÝÆ´ÒôÊ××ÖĸÀ´¼ìË÷ÖÐÎĵÄС¹¦ÄÜ£¬ ±ÈÈçÊäÈëA ¿ÉÒ԰ѿͻ§ÐÕÊϵĵÚÒ»¸ö×ֵį´ÒôÊ××ÖĸΪAµÄÈ«²¿¼ìË÷³öÀ´
ÏàÐÅ»ù±¾ÔÚһЩӦÓÃÕ¾µãÉ϶¼¿ÉÒÔ¿´µÄµ½¡£
֮ǰûÓÐд¹ýÀàËÆµÄ¹¦ÄÜ¡£¸ÕÄõ½µÄʱºòÒ²ºÜÓôÃÆ¡£¡£ ÕâÔõôд£¬ ÓÖ²»ÄÜÏñÕý³£²éѯһÑù select * from Ta ......
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
......
²»¿É±äString
String¶ÔÏóÊDz»¿É±äµÄ£¬²é¿´JDKÎĵµÄã»á·¢ÏÖ£¬StringÀàÖÐÿһ¸ö¿´ÆðÀ´»áÐÞ¸ÄStringÖµµÄ·½·¨£¬Êµ¼ÊÉ϶¼ÊÇ´´½¨ÁËÒ»¸öȫеÄString¶ÔÏó£¬
ÒÔ°üº¬Ð޸ĺóµÄ×Ö·û´®ÄÚÈÝ¡£¶ø×î³õµÄString¶ÔÏóÔòË¿ºÁδ¶¯¡£
public class trys {
public static String upcase(String s){
return s.toUpperCase() ......
JFCÊÇÒ»¸öÇáÁ¿¼¶µÚÈý·½¿ªÔ´×é¼þ,²»ÒÀÀµÆäËû×é¼þ,ʹÓÃProject¼´¿É¡£
×÷ÓãºÒÔͼ±í·½Ê½Õ¹Ê¾Êý¾Ý
꿅᣼www.jfree.org
Àà¿â£ºJFreeChart¡¢JCommon(JFreeReportºÍJFreeChartµÄ¹«¹²Àà¿â)
Ö¸ÄÏ£º jfreechart-1.0.13-install.pdf
API: jfreechart-1.0.13-javadocs.zip
ѹËõ°ü£ºjfreechart-1.0.13
ant ......
ÕâÆªÎÄÕ¶ԳéÏóÀàºÍ½Ó¿Ú˵µÄºÜÏêϸ£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú.
¡¡¡¡abstract classºÍinterfaceÊÇJavaÓïÑÔÖжÔÓÚ³éÏóÀඨÒå½øÐÐÖ§³ÖµÄÁ½ÖÖ»úÖÆ£¬ÕýÊÇÓÉÓÚÕâÁ½ÖÖ»úÖÆµÄ´æÔÚ£¬²Å¸³ÓèÁËJavaÇ¿´óµÄÃæÏò¶ÔÏóÄÜÁ¦¡£abstract classºÍinterfaceÖ®¼äÔÚ¶ÔÓÚ³éÏóÀඨÒåµÄÖ§³Ö·½Ãæ¾ßÓкܴóµÄÏàËÆÐÔ£¬ÉõÖÁ¿ÉÒÔÏà»¥Ìæ»»£¬Òò´ËºÜ¶à¿ª·¢ÕßÔÚ½øÐг ......