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
Ïà¹ØÎÊ´ð£º
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëÄ¿Ç°×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
Java code:
......
synchronized(user){
int loginNum = Integer.parseInt(Main_Client_Dia.jtf2.getText().trim());
Main_Client_Dia.jtf2.setText("");
loginNum++;
......