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
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÈçÌâ¡£¡£
ÏÖÔÚСµÜ ¸Õ¸Õ½Ó´¥ flex ÏëÕÒÒ»¸ö ¾ßÌåµÄÀý×Ó £¨Èç µÇ½ ×¢²áµÄ ¹¦ÄÜʵÏÖ £©¡£¡£
java ºÍ flex ͨÐŵÄ
ÅäÖÃÎļþ java ´úÂë flex ǰ̨ AS ½Å±¾ ×îºÃ ¶¼ дÉÏÈ¥¡£¡£¡£¡£
СµÜ ÏîÑо¿Ñо¿¡£¡£¡£ ......