¹ØÓÚÒÔ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
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÌâÄ¿£º
ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......