¹ØÓÚÒÔ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µÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
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& ......
ÔÚJSPÒ³ÃæÓÐÒ»¸ö<input type="hidden" name="index" value="0">/>¿Ø¼þ
µ±ÎÒÓÃÏÂÃæµÄJavaScriptº¯Êý¸Ä±äÆävalueµÄÖµµÄʱºò Èç¹ûÂú×ãÌõ¼þ£¨¼´i>=3µÄʱºò£©ÎªÊ²Ã´valueµÄ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë
¼òµ¥µã¾Íµ÷ÓÃwindow.print()
ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ:
<html>
<head>
<title> ......
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......
Èç¹ûÖ±½ÓÒýÓýøÈ¥
¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö
лл¸÷λÁË£¬¿´À´Î ......