¹ØÓÚÒÔjsp·½Ê½ÏÂÔØexcelµÄÎÊÌâ - Java / Java SE
±¾À´¹ØÓÚÒÔjsp·½Ê½ÏÂÔØexcelµÄÎÊÌâÔÚÍøÉÏ¿ÉÒÔËÑË÷µÃµ½,µ«ÊÇС°×½ñÌìÓöµ½ÁËÒ»¸öÆæ¹ÖµÄÎÊÌâ
ÎÒ֮ǰµÄʱºò¶¼×ö¹ýһЩÏÂÔØexcelµÄÄ£¿é£¬½ñÌìÒ²ÊÇÒ»ÑùµÄ×öµÄ ¶ø´ó¸ÅµÄ˼·ÈçÏ£º
1.°´Óû§ÊäÈëµÄÌõ¼þ²éѯÊý¾Ý¿â
2.»ñµÃÊý¾Ý£¬²¢µ÷ÓÃjxlÉú³Éexcel
3.°Ñexcel´æ·Åµ½±¾µØ
4.ÉèÖÃresponse contenttype filenameµÈºóÓû§±ãÄÜͨ¹ýÌáʾµÄ´°¿ÚÏÂÔØexcelÎļþ
ÎÒ֮ǰ×öµÄ¶¼ÊÇÔÚtomcat 6 Ò³ÃæcharsetΪUTF-8 jdk1.5µÄ»·¾³ÏÂÍê³É δ³öÏÖ¹ýÎÊÌâ
µ«ÊǽñÌì ÔÚweblogic Ò³ÃæcharsetΪgb2312 jdk1.4µÄ»·¾³Ï ³öÏÖÁË ÔÚ±¾µØµÄexcelÎļþÕý³£ µ«Êǵ½Óû§ÏÂÔØºóÈ´ÂÒÂë ¶øÇÒ Ö®Ç°µÄÉèÖõÄcontent length (Interger.valueOf(bis.avaliable())) ¾¹È»±¨´í(bisΪbufferedinputstream) ´íÎóÐÅϢΪexceed length.....11456 bytes
´óϺÃÇÇëÖ¸µãһϠÀ§ÈÅÁËÒ»ÌìÁË
Java code:
public static String getJTSZExcelList(String gljgdm,String qsrq,String zzrq)throws Exception{
TSQDcbReqEvent req = new TSQDcbReqEvent();
req.setDealMethod("getJTSZExcelList");
req.setGljgdm(gljgdm);
req.setQsrq(StrToDate(qsrq));
req.setZzrq(StrToDate(zzrq));
//µ÷ÓôúÀí·½·¨
ISsglyService service = new SsglyDelegate();
ResponseEvent resp = null;
try {
resp = service.invokeTask(req);
} catch (Exception e) {
e.printStackTrace();
throw e;
}
//´¦ÀíResponseEvent
TSQDcbResE
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
tableÔõô°ó¶¨Êý¾Ý¿â£¬²¢ÇÒÓÃJavaScriptʵÏÖ·Ò³¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£JavaScriptÄÜÏòJSPÒ³Ãæ´«µÝ²ÎÊýÂð
Äã˵µÄÎÊÌâÓеãÄǸö¡£¡££¬²»ºÃ»Ø´ð¡£¡£¡£¡£
jspÖÐtableÊÇÐèÒªhtml´úÂëÓëÒ³Ãæ¶Ë»ñÈ¡Êý¾Ý¿â²éѯºóµÄÐÅÏ¢½øÐÐ ......
ÔÚJSPÒ³ÃæÓÐÒ»¸ö<input type="hidden" name="index" value="0">/>¿Ø¼þ
µ±ÎÒÓÃÏÂÃæµÄJavaScriptº¯Êý¸Ä±äÆävalueµÄÖµµÄʱºò Èç¹ûÂú×ãÌõ¼þ£¨¼´i>=3µÄʱºò£©ÎªÊ²Ã´valueµÄ ......