jspÏÂÔØ xlsÄÚÈÝÂÒÂë - Java / Web ¿ª·¢
ÎÒдÁËÒ»¸öjspÏÂÔØexcelÎļþµÄ¹¦ÄÜ£¬µ«·¢ÏÖÏÂÔØºóÎļþµÄÄÚÈÝÈ«ÊÇÂÒÂ룬
ÎÒÎļþ µÄÄÚÈÝÈçÏ£º
head value
5600 hhhssMMMM123
7600 12345sdfsfsf
8600 12345sdfsfsf
jsp´úÂëÈçÏ£º
<%
String filename = "test.xls"
if(null==filepath){
filepath = "d:\\";
}
int i = 0;
response.setContentType("application/octet-stream;charset=uft-8");
response.setHeader("Content-Disposition",
"attachment;filename = "+filename);
java.io.FileInputStream fileInputStream = new java.io.FileInputStream(filepath+filename);
while((i= fileInputStream.read()) != -1){
out.write(i);
}
fileInputStream.close();
%>
ÏÂÔØºó´ò¿ªÈ«ÊÇÕâЩ¶«Î÷£º
Sheet0聦ü聵 Topup ReportAmountMsisdn5600hhhssMMMM123760012345sdfsfsf8600ÿú
Çë¸ßÊÖ°ï½â¾öһϣ¬Ð»Ð»
response.setContentType("application/vnd.ms-excel;charset=uft-8");
Äã´ò¿ªÉú³ÉµÄexcel£¬¿´¿´ÄÇÀïÃæÊÇÂÒÂëÂð
response.setContentType("application/vnd.ms-excel;charset=uft-8");
¸Ä³ÉÕâÑù
response.setContentTy
Ïà¹ØÎÊ´ð£º
ÎÒ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& ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......