СӦÓ×—jspµ¼³öExcel¼òµ¥±¨±í
½ñÌì¿´µ½Á˹«Ë¾ÒÔÓеÄÏîÄ¿ÀïÃæÓÐÖ±½Óͨ¹ýjsp£¨table£©µ¼³öΪexcel±¨±íµÄÓ¦Ó㬸оõºÜÐÂÆæ£¬ÒÔÓÐ×öµ¼³öexcel¶¼»áÓÃjava´úÂëд£¬Óõ½×¨ÃŵÄÀà¿â£¬²Ù×÷excelÄ£°å£¬ºÜ¸´ÔÓ£¬ÓÃÕâ¸ö·½·¨£¬¿ÉÄܵõ½µÄ±í¸ñûÓÐÄÇô¾«È·£¬µ«¼òµ¥¸ßЧ£¬Ó¦¸ÃÊÇÒ»¸ö²»´íµÄÓ¦Óá£ÏÂÃæµÄÍøÉϱðµÄͬȥµÄһƪÎÄÕ£¬ÕâÀïÕ³Á˹ýÀ´£¬ºÃ¼Çס£¬ÌØ´ËÉùÃ÷¡£
JSPÓ¦Óõ¼³öExcel±¨±íµÄ¼òµ¥ÊµÏÖÒÔ¼°ÖÐÎÄÂÒÂë³¹µ×½â¾ö£¨HTML)
WebÓ¦Óõ¼³öExcel±¨±íµÄ¼òµ¥ÊµÏÖ£¨HTML£©
ÔÚWebÓ¦ÓÃÖУ¬ºÜ¶àÊý¾Ý¾³£Òªµ¼³ö³ÉExcelÎĵµ¡£ÓÃרÃŵÄÉú³ÉÕæÕýµÄExcelÎĵµµÄ·½Ê½±È½Ï¸´ÔÓ£¬²»Ì«ºÃÓá£ËùÒÔ¾³£ÓÃÒ»ÖÖ¼òµ¥µÄ·½Ê½À´ÊµÏÖ£¬¼´½«±¨±í±£´æÎªHTML¸ñʽ£¬È»ºóÓÃExcel´ò¿ª¡£
ʵÏÖ·½Ê½£º
µÚÒ»²½,ÓÃJSPʵÏÖHTML°æ±¾µÄ±¨±í
µÚ¶þ²½,ÔÚ¸ÃJSPÒ³ÃæÍ·²¿ÉèÖÃresponseµÄContentTypeΪExcel¸ñʽ
ÒýÓÃ
<% response.setContentType("application/vnd.ms-excel;charset=GBK"); %>
ÖÐÎÄÎÊÌ⣺
²é¿´Ô´´úÂëʱ·¢ÏÖJSPÎļþÖÐдËÀµÄÖÐÎÄΪÂÒÂ룬ÔòÔÚJSPÎļþÍ·²¿Ìí¼ÓÒ»ÐÐ
ÒýÓÃ
<%@ page contentType="text/html; charset=gb2312" %>
²é¿´Ô´´úÂëʱ·¢ÏÖÎÄ×ÖΪÖÐÎÄ£¬µ«ÊÇÓÃExcel´ò¿ªÎªÂÒÂëÔòÔÚ<html>Óë<head>ÖмÓÈë
ÒýÓÃ
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
ÓÃServletʵÏÖÒ²ÊÇÀàËÆµÄ´¦Àí·½·¨¡£
Java´úÂë
<%@ page contentType="text/html; charset=GBK" %>
<% response.setContentType("application/vnd.ms-excel;charset=GBK"); %>
<HTML>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<head><title>Test</title></head>
<body>
<TABLE borderColor=#111111 cellSpacing=0 cellPadding=2 width=1200 align=center border=1>
<TR>
<TD align=middle width="10%" height=20 rowSpan=2>ÏîÄ¿ </TD>
<TD align=middle width="2%" height=20 rowSpan=2>¼ÆÁ¿µ¥Î» </TD>
<TD align=middle width="4%" height=20>ÂúÆÚÅ⸶ÂÊ&nbs
Ïà¹ØÎĵµ£º
Ò»¡¢¸ÅÊö
»º´æµÄ˼Ïë¿ÉÒÔÓ¦ÓÃÔÚÈí¼þ·Ö²ãµÄ¸÷¸ö²ãÃæ¡£ËüÊÇÒ»ÖÖÄÚ²¿»úÖÆ£¬¶ÔÍâ½ç¶øÑÔ£¬ÊDz»¿É¸ÐÖªµÄ¡£
Êý¾Ý¿â±¾ÉíÓлº´æ£¬³Ö¾Ã²ãÒ²¿ÉÒÔ»º´æ¡££¨±ÈÈ磺hibernate£¬»¹·Ö1¼¶ºÍ2¼¶»º´æ£©
ÒµÎñ²ãÒ²¿ÉÒÔÓлº´æ£¨µ«Ò»°ãÀ´Ëµ£¬ÕâÊÇÒ»¸ö¹ý³ÌÓò£¬²»»áÉ軺´æ£©¡£
&nbs ......
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
ÏÂÃæµÄÏÔÊ¾Ò³Ãæ(display.JSP)¾Í³öÏÖÂÒÂ룺
¶Ô²»Í¬µÄWEB·þÎñÆ÷ºÍ²»Í¬µÄJDK°æ±¾£¬´¦Àí½á¹û¾Í²»Ò»Ñù¡£ÔÒò£º·þÎñÆ÷ʹÓõıàÂ뷽ʽ²»Í¬ºÍä¯ÀÀÆ÷¶Ô²»Í¬µÄ×Ö·ûÏÔʾ½á¹û²»Í¬¶øµ¼Öµġ£½â¾ö°ì·¨£ºÔÚJSPÒ³ÃæÖÐÖ¸¶¨±àÂë·½Ê ......
tomcat ĬÈÏʹÓõÄ×Ö·û¼¯ÊÇISO-8859-1£¬²»Ö§³ÖÖÐÎÄ×Ö·û£¬ËùÒÔÔÚÏÖʵÖÐÎÄʱÐèҪת»»×Ö·ûºÍÉèÖÃ×Ö·û¼¯¡£
server.mxl¸ÄΪ<Connector port="8080" protocol="HTTP/1.1" maxThreads="150" connectionTimeout="20000" redirectPort="8443" URIEncoding="UTF-8" /> £¬Ìí¼Ó´úÂëת»»×Ö·ûString.getBytes("ISO-8859-1"),"UTF-8 ......
Ò»°ãµÄÍøÒ³¶¼ÓÐÕâÖÖ¹¦ÄÜ£ºÔÚÒ³ÃæÉ϶¯Ì¬ÏÔʾµ±Ç°Ê±¼ä£¬Õâ¸öµÄʵÏÖÒ²ºÜ¼òµ¥£¬»ù±¾ÉÏÒ»ÐдúÂë¾ÍʵÏÖÁË
<span id="curTime"></span>
<script type="text/javascript"><!--
setInterval("curTime.innerHTML=new Date().toLocaleString()+' ÐÇÆÚ'+'ÈÕÒ»¶þÈýËÄÎåÁù'.charAt(new Date().getDay());",1000 ......
±àд×Ô¶¨Òå±êÇ©²½Öè
±àд±êÇ©´¦ÀíÆ÷£¨´¦Àí±êÇ©µÄJavaÀࣩ£¬ÕâЩÀàÐèҪʵÏÖһЩ¹æ·¶»¯µÄ±êÇ©½Ó¿Ú
±àд±êÇ©¿âÃèÊöÎļþ£¨TLD£©£¬Õâ¸öÎļþÃèÊöÁËÿ¸ö±êÇ©ºÍ¶ÔÓ¦µÄJava±êÇ©´¦ÀíÆ÷ÀàÖ®¼äµÄÓ³Éä¹ØÏµ
ÔÚweb.xmlÖÐÅäÖñêÇ©¿âÎļþµÄURI
ÔÚJSPÒ³ÃæÖÐÀûÓÃtaglibÖ¸Á±êÇ©¿âÒýÈëµ½Ò³ÃæÖÐ
......