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
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......