jsp + servlet +jxl ʵÏÖ export excel
дһ¸öjspÎļþ,È»ºó°ÑÒª´ÓÊý¾Ý¿âÈ¡³öÊý¾ÝµÄsqlÓï¾ä´«µ½servlet ÖÐ.
java ´úÂë:
package exportExcel;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
public class exportExcel extends HttpServlet{
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
try {
String sqlStr = (String) req.getParameter("exSql").toLowerCase();
String sqlS = sqlStr.split("from")[0];
String sqls = sqlS.split("select")[1];
//System.out.println(sqls);
String[] Sql;
List list = new ArrayList();
String excelName = req.getParameter("exName");
HttpSession session = req.getSession();
String jdbc_driver=(String) session.getAttribute("jdbc_driver");
String jdbc_url = (String) session.getAttribute("jdbc_url");
String jdbc_username= (String)session.getAttribut
Ïà¹ØÎĵµ£º
֮ǰ,д¹ýÒ»¸öDownload.jspÎļþ,Äܽâ¾öÏÂÔØÎļþÂÒÂëÎÊÌâ(ÖîÈç:DOC,XSLÎļþµÈµÈ).
ºóÀ´·¢ÏÖ,Óö¼ûÖÐÎÄÃûµÄÎļþµÄʱºò,ÎļþÏÂÔØ½«»á±¨´í~~~~
½ñÌì,ͨ¹ý¸ÄдÔDownload.jspÎļþÒÑÍêÈ«½â¾öÁËÕâ¸öÎÊÌâ~
Ŀǰ,°ÑÒ»ÕûÌ×µÄÎļþÉÏ´«ÏÂÔØµÄ·½·¨¸øÌù³öÀ´~~~ÒÔ±ã´ó¼Ò½è¼ø!~!~!~!~!
×÷Õß:¹Å°£¼°·¨ÀÏ
------------------------ ......
this.state="01";ͨ³£µÄ×ö·¨ÊÇдһ¸öÀࣨ½Ó¿Ú£©À´´æ·Å³£Á¿
public interface MyConstant
{
public static final String STATE_01= "01";
}
È»ºóÔÚ³ÌÐòÖÐÕâÑùд¾Í¿ÉÒÔÁË
this.state=MyConstant.STATE_01;
ÔÚJava³ÌÐòÖÐÕâÑù¾Í¿ÉÒÔ±ÜÃâÓ²±àÂëÁË¡£¿ÉÊÇJSPÖÐÄØ£¿µ±È»£¬Èç¹ûJSPÖÐÔÊÐíʹÓÃScripletµÄ»°µ±È»Ò²¿ÉÒÔÖ±½ÓʹÓó ......
ÅäÖóÌÐòµÄÔËÐÐĿ¼ÓëJDBCÊý¾ÝÔ´:
<Context path="/test" docBase="F:\JSPLesson\test" reloadable="true">
<Resource name="jdbc/bookstore" auth="Container" type="javax.sql.DataSource"
maxActive="1 ......
JSPµÄÔËÐлúÖÆ£º
JSPÈÝÆ÷¹ÜÀíJSPÒ³ÃæÉúÃüÖÜÆÚµÄÁ½¸ö½×¶Î£º×ª»»½×¶ÎºÍÖ´Ðн׶Ρ£µ±ÓÐÒ»¸ö¶ÔJSPÒ³ÃæµÄ¿Í»§ÇëÇóµ½À´Ê±£¬JSPÈÝÆ÷¼ìÑéJSPÒ³ÃæµÄÓï·¨ÊÇ·ñÕýÈ·£¬½«JSPÒ³Ãæ×ª»»ÎªServletÔ´Îļþ£¬È»ºóµ÷ÓÃjavac¹¤¾ßÀà±àÒëServletÔ´ÎļþÉú³É×Ö½ÚÂëÎļþ£¬ÕâÒ»½×¶ÎÊÇת»»½×¶Î¡£½ÓÏÂÀ´£¬ServletÈÝÆ÷¼ÓÔØ×ª»»ºóµÄServletÀ࣬ʵÀý»¯Ò»¸ ......
ÉÏ¿ÎÀÏʦ½²½âÁËjsp·ÖÒ³ £¬¹ØÓÚ¼ÆËã×ÜÒ³Êý
ËûµÄËã·¨ÊÇ totalPage=(totalRecords+pageSize-1)/pageSize; Ëû˵Èç¹û²»ºÃÀí½â£¬¾ÍÓà i f else Åжϡ£
Ï¿ο´Êé
żȻÏëÆðÁËÒÔǰ£¬µÄÒ»¸öËã·¨
totalPage=(totalRecords%pageSize==0)? (totalRecords/page ......