ÈçºÎÔÚ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Ò³ÃæÖн«»Ø³µ»»Ðзû´æÈë±íÖз½·¨
1.ÔÚÒ»¸ötextareaÖÐÊäÈëÒ»¶ÎÎÄ×Ö£¬Óл»ÐÐʱ£¬½«»»ÐзûÒ»Æð²åÈëÊý¾Ý¿âÖÐ
ʹÓ÷½·¨ÈçÏ£º
public static String TextToHtml(String sourcestr)
{   ......
½éÉÜÍ깤¾ßºÍ»ù±¾¸ÅÄÏÖÔÚÖÕÓÚ¿ªÊ¼½éÉÜ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 ......
½ñÌì¸ÕÇÉÅöµ½ºÍJSP×¢ÊÍÓÐµã¹ØÏµµÄÒ»¸öÎÊÌâ¡£ËùÒÔ×ö¸ö±Ê¼Ç£¬ËµÃ÷Ò»ÏÂÏÔʽעÊÍ<!-- comments --> ºÍÒþʽעÊÍ<%-- comments --%> Ö®¼äµÄÁ½µã²î±ð¡£
Ôø¾ÒÔΪÏÔʽעÊͺÍÒþʽעÊͲî±ðÖ»ÓÐÔÚ´úÂëÏÔʾÉÏ£¬ÕâµãÓ¦¸Ã´ó¼Ò¶¼ÖªµÀ£¬ÏÔʽעÊÍ»áÏÔʾÔÚ¿Í»§¶ËÒ³ÃæÔ´ÂëÖУ¬¶øÒþʽעÊÍÊÇ¿´²»µ½µÄ£¬²»¹ýÕâÖ»ÊǵÚÒ»µã¡£
......