ÈçºÎÔÚjspÖжÁÈ¡¿Í»§¶ËµÄexcelÎļþÖеÄÊý¾Ý
ÎÒÒªµ÷ÓÃJExcelApi ¶ÁÈ¡Óû§ÔÚ¿Í»§¶ËÑ¡ÔñµÄExcelÖеÄÎļþÖеÄÊý¾Ý£¬
ÎÒÊÇÕâÑù×öµÄ£º
Ê×ÏÈ×öÒ»¸öÒ³ÃæupLoadExcel.jspÈÃÓû§Ñ¡Ôñ±¾µØµÄExcelÎļþ£¬ÎÒ¾ÍÊÇÓõÄÉÏ´«µÄÄǸöÒ³Ãæ£º
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY bgColor=#e6e6e6><BR>
<FORM action="upToDataBase.jsp" encType=multipart/form-data method=post>
<TABLE>
<TBODY>
<TR>
<TD><FONT color=#000000 face=helv,helvetica size=1> File : </FONT> <INPUT size=60 type=file name="file">
</TD>
</TR>
<TR>
<TD align=right><INPUT type=submit value=Send name="send">
</TD>
</TR>
</TBODY>
</TABLE>
</FORM>
</BODY>
</HTML>
¶øÔÚupToDataBase.jsp ÖУº¶ÁÈ¡ÄÇÊäÈëÁ÷
InputStream ins = request.getInputStream();
Workbook &n
Ïà¹ØÎĵµ£º
Õâ¶Îʱ¼äÔÚѧϰJSP£¬×ÜÌåÀ´Ëµ£¬JSPѧϰÆðÀ´¸Ð¾õ»¹²»´í£¬²»ÖªµÀÊDz»ÊÇÓÐÁËJAVAµÄ¹¦µ×£¬Ã»¸Õ¸Õ¿ªÊ¼Ñ§Ï°CÓïÑÔµÄʱºòÄÇô³ÔÁ¦¡£²»¹ÜÊÇҪѧϰJSP»¹ÊÇÆäËû±à³ÌÓïÑÔ£¬ÎÒÃǶ¼Ó¦¸ÃÄÜѧ»á×Ô¼ºÊìÁ·µÄ°²×°ºÍÅäÖÃÐèÒªÓõ½µÄ¿ª·¢Èí¼þ¡£ÓÐÁË¿ª·¢Èí¼þ¾Í»áʰ빦±¶¡£Ð´´úÂëÒ²»á¸ü¿ì½ÝºÍ·½±ã£¬ÓÐЩ¹Ø¼ü´Ê»ò´íÎ ......
´Ó×òÌ쿪ʼ¾ÍÒ»Ö±ÔÚÍøÉϲéÕÒÊý¾Ý¿âΪSQL server 2000 µÄJSP¿ª·¢»·¾³µÄ´î½¨£¬µ½ÏÖÔÚΪֹÖÕÓÚÄܹ»Õý³£Áª½Ó²¢·ÃÎÊ¡£ÒÔÏÂÊǴµÄ²½Ö裺
1¡¢´ÓÍøÉÏÏÂÔØÒ»¸öSQL server 2000 ¸öÈ˰æµÄ°²×°°ü£¬°´ÕÕÌáʾ²Ù×÷£¬µ±ÔÚÉí·ÖÑé֤ʱ£¬Ñ¡Ôñ»ìºÏģʽ£¬Óû§saµÄÃÜÂë¿ÉÒÔΪ¿Õ£¬Ò²¿ÉÒÔ²»Îª¿Õ¡£
2¡¢´ÓÍøÉÏÏÂÔØÒ»¸öSQ ......
Ðí¾ÃûÓеǼ×Ô¼ºµÄУÄÚÍøÁË£¬½ñÌìµÇ¼ÁËһϣ¬ºöÈ»·¢ÏÖУÄÚµÄÉÏ´«ÕÕÆ¬Í¦ÓÐÒâ˼µÄ£¬ÓÚÊǺõ¾Í´ÓÍøÉÏÕÒÁËһϣ¬Ð£ÄÚÓ¦¸ÃÊÇʹÓÃjspдµÄ¡£ÔÚÍøÉÏÕÒµ½Á˸öFileUpload¿Ø¼þ£¬¿ÉÒԺܷ½±ãµÄÉÏ´«Îļþ¡£ÔÚÍøÉÏÕÒµ½Ò»ÆªÏêϸ½éÉÜÕâ¸ö¿Ø¼þʹÓõģ¬ÊÔÑéÁËһϣ¬¸ãÁ˺þòÅʵÏÖÏÖÔÚÕûÀí³öÀ´¡£
Ò»¡¢Ê× ......
<%
Cookie[] cooks = request.getCookies();
String cookieName = "Mycookie";
boolean flag = false;
for(Cookie cook : cooks)
{
if(cook.getName().equals(cookieName))
{
flag = true;
break;
}
}
if(!flag){
String str=System.currentTimeMillis()+"";
Cook ......