ÈçºÎÔÚ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
Ïà¹ØÎĵµ£º
½éÉÜÍ깤¾ßºÍ»ù±¾¸ÅÄÏÖÔÚÖÕÓÚ¿ªÊ¼½éÉÜServletµÄ±àд·½·¨ÁË¡£ÎªÁ˱ãÓÚÀí½â£¬ÎÒÃǽ«²ÉÓÃeclipse+Lomboz×÷Ϊ¿ª·¢»·¾³£¬Ò»ÇеIJÙ×÷¶¼¿ÉÒÔÔÚeclipseÖÐÍê³É¡£Èç¹ûÄ㻹ûÓа²×°ºÃLomboz£¬Çë²Î¿¼Ç°¼¸ÆªÎÄÕÂÅäÖúû·¾³¡£
tomcatºÍeclipseµÄ°²×°
»ù´¡ÖªÊ¶
Lomboz½éÉÜ+°²×°·½·¨
ÎÒÃǽ«½¨Á¢Ò»¸öÃûΪ com.idv2.learnjsp µÄ°ü£¬Ó ......
Ò»¡¢JSP×Ô¶¨Òå±êÇ©¼ò½é
±êÇ©ÊÇÒ»ÖÖXMLÔªËØ£¬Í¨¹ý±êÇ©¿ÉÒÔʹJSPÍøÒ³±äµÃ¼ò½à²¢ÇÒÒ×ÓÚά»¤£¬»¹¿ÉÒÔ·½±ãµØÊµÏÖͬһ¸öJSPÎļþÖ§³Ö¶àÖÖÓïÑÔ°æ±¾¡£ÓÉÓÚ±êÇ©ÊÇXMLÔªËØ£¬ËùÒÔËüµÄÃû³ÆºÍÊôÐÔ¶¼ÊÇ´óСдÃô¸ÐµÄ
±ê×¼JSP±êÇ©ÊÇÓÃÀ´µ÷ÓÃJavaBean×é¼þµÄ²Ù×÷£¬´¦Àí¶¨ÏòÇëÇóÒÔ¼ò»¯JSPÒ³Ãæ¿ª·¢Óëά»¤¡£JSP¼¼ÊõÌṩÁËÒ»ÖÖ·â×°ÆäËü¶¯Ì¬ÀàÐÍ ......
´Ó×òÌ쿪ʼ¾ÍÒ»Ö±ÔÚÍøÉϲéÕÒÊý¾Ý¿âΪSQL server 2000 µÄJSP¿ª·¢»·¾³µÄ´î½¨£¬µ½ÏÖÔÚΪֹÖÕÓÚÄܹ»Õý³£Áª½Ó²¢·ÃÎÊ¡£ÒÔÏÂÊǴµÄ²½Ö裺
1¡¢´ÓÍøÉÏÏÂÔØÒ»¸öSQL server 2000 ¸öÈ˰æµÄ°²×°°ü£¬°´ÕÕÌáʾ²Ù×÷£¬µ±ÔÚÉí·ÖÑé֤ʱ£¬Ñ¡Ôñ»ìºÏģʽ£¬Óû§saµÄÃÜÂë¿ÉÒÔΪ¿Õ£¬Ò²¿ÉÒÔ²»Îª¿Õ¡£
2¡¢´ÓÍøÉÏÏÂÔØÒ»¸öSQ ......
ËäÈ»×öÁË´ó°ëÄêµÄweb¿ª·¢ÁË£¬µ«Ò»Ö±¸¡ÓÚ±íÃæ£¬¶«Î÷»á×ö£¬µ«ºÜ¶àÔÀí²»Í¨£¬ÒªÏë³ÉΪ¼¼ÊõÅ£È˹â»á×öÊÇÔ¶Ô¶²»Ðеģ¬ÒòΪ¼´Ê¹»á×öµ«²»»á½²ÇÒ²»ÄܾÙÒ»·´Èý£¬°¥£¬Ïëµ±Äê¸ßÖÐÊýѧ֮ËùÒÔÕâôºÃ¾ÍÊÇÒòΪ¸ßÖÐÊýѧÔÀíÎÒ¶¼Ò»Çå¶þ³þ£¬¾ÙÒ»·´Èý£¬ÐËÊÖÄíÀ´£¬·´¶øµ½ÁËÏÖÔÚÓе㼱¹¦½üÀû£¬¼±ÓÚÇó³É£¬ÎÒÕâ²»Êǵ¹ÍËÁË ......
Ðí¾ÃûÓеǼ×Ô¼ºµÄУÄÚÍøÁË£¬½ñÌìµÇ¼ÁËһϣ¬ºöÈ»·¢ÏÖУÄÚµÄÉÏ´«ÕÕÆ¬Í¦ÓÐÒâ˼µÄ£¬ÓÚÊǺõ¾Í´ÓÍøÉÏÕÒÁËһϣ¬Ð£ÄÚÓ¦¸ÃÊÇʹÓÃjspдµÄ¡£ÔÚÍøÉÏÕÒµ½Á˸öFileUpload¿Ø¼þ£¬¿ÉÒԺܷ½±ãµÄÉÏ´«Îļþ¡£ÔÚÍøÉÏÕÒµ½Ò»ÆªÏêϸ½éÉÜÕâ¸ö¿Ø¼þʹÓõģ¬ÊÔÑéÁËһϣ¬¸ãÁ˺þòÅʵÏÖÏÖÔÚÕûÀí³öÀ´¡£
Ò»¡¢Ê× ......