ÈçºÎÔÚ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/ServletµÄÖØ¶¨Ïò¼¼Êõ×ÛÊöÈçÏÂ
1.RequestDispatcher.forward()
ÊÇÔÚ·þÎñÆ÷¶ËÆð×÷ÓÃ,µ±Ê¹ÓÃforward()ʱ,Servlet engine´«µÝHTTPÇëÇó´Óµ±Ç°µÄServlet or JSPµ½ÁíÍâÒ»¸öServlet,JSP »òÆÕͨHTMLÎļþ,Ò²¼´ÄãµÄformÌá½»ÖÁa.jsp,ÔÚa.jspÓõ½ÁËforward()ÖØ¶¨ÏòÖÁb.jsp,´ËʱformÌá½»µÄËùÓÐÐÅÏ¢ ......
ËäÈ»×öÁË´ó°ëÄêµÄweb¿ª·¢ÁË£¬µ«Ò»Ö±¸¡ÓÚ±íÃæ£¬¶«Î÷»á×ö£¬µ«ºÜ¶àÔÀí²»Í¨£¬ÒªÏë³ÉΪ¼¼ÊõÅ£È˹â»á×öÊÇÔ¶Ô¶²»Ðеģ¬ÒòΪ¼´Ê¹»á×öµ«²»»á½²ÇÒ²»ÄܾÙÒ»·´Èý£¬°¥£¬Ïëµ±Äê¸ßÖÐÊýѧ֮ËùÒÔÕâôºÃ¾ÍÊÇÒòΪ¸ßÖÐÊýѧÔÀíÎÒ¶¼Ò»Çå¶þ³þ£¬¾ÙÒ»·´Èý£¬ÐËÊÖÄíÀ´£¬·´¶øµ½ÁËÏÖÔÚÓе㼱¹¦½üÀû£¬¼±ÓÚÇó³É£¬ÎÒÕâ²»Êǵ¹ÍËÁË ......
±¾ÎĽéÉÜJSPÖÐrequestÊôÐÔµÄÓ÷¨£¬ÒÔ¼°request.getParameter() ºÍrequest.getAttribute() Çø±ð¡£
Ò»¡¢request.getParameter() ºÍrequest.getAttribute() Çø±ð
1.request.getParameter()È¡µÃÊÇͨ¹ýÈÝÆ÷µÄʵÏÖÀ´È¡µÃͨ¹ýÀàËÆpost£¬getµÈ·½Ê½´«ÈëµÄÊý¾Ý£¬request.setAttribute()ºÍgetAttribute()Ö»ÊÇÔÚwebÈÝÆ÷ÄÚ²¿Á÷ת£¬½ ......
<%
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 ......