JSP±¨±í´òÓ¡µÄÒ»ÖÖ¼òµ¥½â¾ö·½°¸
1. ÔÚWord»òExcelÖÐÖÆ×÷±¨±íµÄÑùʽ¡£
¡¡¡¡ExcelµÄÐиߺÍÁÐ¿íµ¥Î»ÎÞ·¨ÓÃmm»òcm±íʾ¡£
¡¡¡¡ÐèÒª¼ÆËã¡£ÔÚ1024*768Ï£¬1CMԼΪ38ÏñËØ¡£
¡¡¡¡ÒÔ´ËΪ»ù×¼£¬¿É¼ÆËã²¢¿ØÖƱ¨±íµÄÐÐÁÐλÖá£
¡¡¡¡2. ÔÚWordÖÐÉèÖÓ±í¸ñ——±êÌâÐÐÖØ¸´”¡£
¡¡¡¡ÔÚExcelÖÐÉèÖÓÎļþ——Ò³ÃæÉèÖ×—¹¤×÷±í——´òÓ¡±êÌ┡£
¡¡¡¡3. Áí´æÎªÍøÒ³£¬¸Äºó׺Ãû“htm”Ϊ“jsp”¡£
¡¡¡¡4. Word±¨±íÎļþͷΪ£º
£¼%@page contentType="application/msword;charset=GBK" language="java"%£¾
¡¡¡¡Excel±¨±íÎļþͷΪ£º
£¼% @page contentType="application/vnd.ms-excel;charset=GBK" language="java"%£¾
¡¡¡¡5. ÔÚÎļþÍ·²¿·Ö¶¨Òå´òÓ¡²ÎÊý±äÁ¿ÈçÏ£¨ÒÔExcelΪÀý£©£º
£¼%
//ÐèÒª´òÓ¡µÄ¼Ç¼ÌõÊý
int PrintRowCount=RowCount;
//ÿҳ´òÓ¡µÄ¼Ç¼ÌõÊý
int PageRowCount=16;
//×îºóÒ»Ò³ÐèÒª´òÓ¡µÄ¿ÕÐеÄÊýÄ¿
int LoopNum=PageRowCount-PrintRowCount%PageRowCount;
//´òÓ¡ÇøÓòµÄ¸ß¶È£¬ÆäÖÐ2µÄÒâ˼ÊÇÿҳÐèÒªÖØ¸´µÄ±êÌâÐеÄÊýÄ¿
int PrintAreaHeight=(PrintRowCount%PageRowCount==0)?PrintRowCount+2:PrintRowCount+LoopNum+2;
%£¾
¡¡¡¡6. ÔÚ£¼style£¾£¼/style£¾ºó£¬¸Ä¶¯£¼!--[if gte mso 9]Ó룼![endif]--£¾±êÇ©ÖеÄXML±êÇ©ÄÚÈÝ£¬Ö÷ÒªÊÇÉèÖö¯Ì¬´òÓ¡ÇøÓò£¨ÒÔExcelΪÀý£©£º
£¼%
out.print(" ......
"£¼x:ExcelName£¾"+
"£¼x:Name£¾Print_Area£¼/x:Name£¾"+
"£¼x:SheetIndex£¾1£¼/x:SheetIndex£¾"+
"£¼x:Formula£¾=Sheet1!$A$1:$G$"+PrintAreaHeight+"£¼/x:Formula£¾"+
"£¼/x:ExcelName£¾"+
...... ");
%£¾
¡¡¡¡7. JSPÆäËû±àÂë¡£
¡¡¡¡ÏÂÃæÊÇÖ÷ÌåÑ»·´òÓ¡²¿·Ö£¨ÒÔExcelΪÀý£©£º
£¼%
for (int i=1;i£¼=PrintRowCount; i++)
{
out.print("£¼tr£¾"£¼td£¾"+i+"£¼/td£¾£¼/tr£¾"); //ÓÐÄÚÈÝ
}
if (LoopNum!=PageRowCount) //ÓпÕÐÐÔò´òÓ¡¿ÕÐв¹Æë×îĩһҳ
for (int j=1;j£¼=LoopNum; j++)
{
out.print("£¼tr£¾£¼td£¾¡¡£¼/td£¾£¼/tr£¾");//ÎÞÄÚÈÝ
}
%£¾
¡¡¡¡8. ²âÊÔ²¢¼ÌÐøÐ޸ġ£
ÎÄÕÂÀ´×Ô: ºÃϲ°®Ñ§Ï°Íø(http://www.haoxiai.net) ÍøÖ·£ºhttp://www.haoxiai.net/bianchengyuyan/jspjiaocheng/58877.html
Ïà¹ØÎĵµ£º
<%@ page language="java" import="kg.TestBean2;" %>
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<title>HelloBean</title>
</head>
<body>
<%--
<%
kg.TestBean2 testbean=(kg.TestBean2)session.setAttribute("testbean");
if ......
Ëæ×ż¼ÊõµÄÈÕÐÂÔÂÒì £¬JSPµÄм¼ÊõÒ²²ã³ö²»ÇΪÁË·½Ãæ´ó¼ÒµÄѧϰÓ빤×÷£¬ÏÂÃæ½«¼òµ¥µÄ½éÉÜÒ»ÏÂJSP¼Ü¹¹¡¢JSP¿ª·¢¹¤¾ß¡¢Web·þÎñÆ÷¼°Æäîñȱµã¡£
JSP¼Ü¹¹£º
struts£º Struts¸úTomcat¡¢TurbineµÈÖî¶àApacheÏîĿһÑù£¬ÊÇ¿ªÔ´Èí¼þ£¬ÕâÊÇËüµÄÒ»´óÓŵ㣬ʹ¿ª·¢ÕßÄܸüÉ ......
ʹÓÃRandomAccessFileÀàÌṩµÄ¹¦ÄÜÀ´ÊµÏÖÎļþÉÏ´«¡£µ±ÎÒÃÇÏë¶ÔÒ»¸öÎļþ½øÐжÁд²Ù×÷ʱ£¬¿ÉÒÔ´´½¨Ò»¸öÖ¸Ïò¸ÃÎļþµÄRandomAccessFileÁ÷¼´¿É£¬ÕâÑù¼È¿ÉÒÔ´ÓÕâ¸öÁ÷ÖжÁÈ¡Õâ¸öÎļþµÄÊý¾Ý£¬Ò²Í¨¹ýÕâ¸öÁ÷дÈëÊý¾Ý¸øÕâ¸öÎļþ¡£
ÀûÓÃJavaBean¸ºÔð½«Óû§Ñ¡ÔñµÄÎļþÉÏ´«µ½·þÎñÆ÷¡£bean¿ÉÒÔÈÃÄÚÖöÔÏórequestµ÷Ó÷½·¨getInputStream£ ......
Ò»¡¢
ÔÚÒ»¸öÉè¼ÆÁ¼ºÃµÄWebÓ¦ÓÃÖУ¬¶¼»á×ÛºÏʹÓÃServletºÍJSP¼¼Êõ¡£Servlet¿ØÖÆÒµÎñÁ÷ת£¬JSPÔò¸ºÔðÒµÎñ´¦Àí½á¹ûµÄÏÔʾ¡£´Ëʱ£¬½«´óÁ¿Óõ½Öض¨Ïò¼¼Êõ¡£
¡¡¡¡Öض¨Ïò¼¼Êõ¿ÉÒÔ·ÖΪÁ½À࣬һÀàÊǿͻ§¶ËÖØ¶¨Ïò£¬Ò»ÀàÊ ......
JSP¹²ÓÐÒÔÏÂ9ÖÖ»ù±¾ÄÚÖÃ×é¼þ£¨¿ÉÓëASPµÄ6ÖÖÄÚ²¿×é¼þÏà¶ÔÓ¦£©£º
¡¡1.request Óû§¶ËÇëÇ󣬴ËÇëÇó»á°üº¬À´×ÔGET/POSTÇëÇóµÄ²ÎÊý¡£
2. response ÍøÒ³´«»ØÓû§¶ËµÄ»ØÓ¦ ¡£
3.pageContext ÍøÒ³µÄÊôÐÔÊÇÔÚÕâÀï¹ÜÀí ¡£
4.session ÓëÇëÇóÓйصĻỰÆÚ¡£
5.ap ......