СӦÓ×—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
Ïà¹ØÎĵµ£º
½ñÌì²âÊÔÈËÔ±¸øÎÒÌáÁËÒ»¸öbug£¬ËµÎÒ¿ª·¢µÄÄ£¿é±¨¿ò¼ÜµÄjs´íÎ󣬵±Ê±Ò»Ìý¾ÍãÂÁË£¬ÎÒ±¾µØ²âÊÔÍêȫûÎÊÌ⣬ÔõôÉÏÁË·þÎñÆ÷»á³öÏÖÕâ¸öÎÊÌâÄØ£¿
ÓÚÊÇÎÒÈ¥·þÎñÆ÷ÉϲâÁËÒ»ÏÂ×Ô¼ºÐ´µÄÄǸöÄ£¿é£¬½á¹û±¨µÄ´íÎ󻹺ͲâÊÔÈËÔ±Ìá¸øÎҵĴíÎó²»Ò»Ö£¬ÔÓ»ØÊ£¿ÓÚÊÇÎÒÓÖÕÒµ½Ò»ÃûͬÊ£¬ÈÃËû°ïÎÒ²âһϣ ......
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
ÏÂÃæµÄÏÔʾҳÃæ(display.JSP)¾Í³öÏÖÂÒÂ룺
¶Ô²»Í¬µÄWEB·þÎñÆ÷ºÍ²»Í¬µÄJDK°æ±¾£¬´¦Àí½á¹û¾Í²»Ò»Ñù¡£ÔÒò£º·þÎñÆ÷ʹÓõıàÂ뷽ʽ²»Í¬ºÍä¯ÀÀÆ÷¶Ô²»Í¬µÄ×Ö·ûÏÔʾ½á¹û²»Í¬¶øµ¼Öµġ£½â¾ö°ì·¨£ºÔÚJSPÒ³ÃæÖÐÖ¸¶¨±àÂë·½Ê ......
¡¡¡¡1 MySQL´æ´¢´óÈÝÁ¿µÄ¶þ½øÖÆÎļþµÄ¸ñʽÊÇblob£¬Æäʵ³ýÁËͼƬ»¹¿ÉÒÔ´æ±ðµÄ
¡¡¡¡2 ÒªÏòÊý¾Ý¿â´æ´¢¶þ½øÖƵÄÎļþÒ»¶¨Òª°ÑÒª´æ´¢µÄÊý¾Ýת»»³É¶þ½øÖÆÁ÷
¡¡¡¡·Ï»°¾Í²»¶à˵ÁË£¬´ó¼Ò¿´¿´´úÂëºÜÈÝÒ×Ã÷°×£¬ÏÈÀ´¿´Ò»¸öapp³ÌÐò£¬µ±È»Ê×ÏÈÄúÒªÔÚÊý¾Ý¿âÖÐÏȽ¨Á¢Ò»¸öÓÃÓÚ±£´æͼƬµÄ±íºÍÏàÓ¦µÄÁУ¬Êý¾Ý¸ñʽΪblob
¡¡¡¡ package ......
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 ......
ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
Ç°¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔÇ°µÄ¾Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½Î ......