¹ØÓÚÒÔ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Ò³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë
¼òµ¥µã¾Íµ÷ÓÃwindow.print()
ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ:
<html>
<head>
<title> ......