Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

JSPÎļþÏÂÔØ

֮ǰ,д¹ýÒ»¸öDownload.jspÎļþ,Äܽâ¾öÏÂÔØÎļþÂÒÂëÎÊÌâ(ÖîÈç:DOC,XSLÎļþµÈµÈ).
ºóÀ´·¢ÏÖ,Óö¼ûÖÐÎÄÃûµÄÎļþµÄʱºò,ÎļþÏÂÔØ½«»á±¨´í~~~~
½ñÌì,ͨ¹ý¸ÄдԭDownload.jspÎļþÒÑÍêÈ«½â¾öÁËÕâ¸öÎÊÌâ~
Ŀǰ,°ÑÒ»ÕûÌ×µÄÎļþÉÏ´«ÏÂÔØµÄ·½·¨¸øÌù³öÀ´~~~ÒÔ±ã´ó¼Ò½è¼ø!~!~!~!~! 
×÷Õß:¹Å°£¼°·¨ÀÏ
------------------------ ......

JSP(JSTL)ÖÐʹÓó£Á¿·ÀÖ¹Ó²±àÂë

this.state="01";ͨ³£µÄ×ö·¨ÊÇдһ¸öÀࣨ½Ó¿Ú£©À´´æ·Å³£Á¿
public interface MyConstant
{
public static final String STATE_01= "01";
}
È»ºóÔÚ³ÌÐòÖÐÕâÑùд¾Í¿ÉÒÔÁË
this.state=MyConstant.STATE_01;
ÔÚJava³ÌÐòÖÐÕâÑù¾Í¿ÉÒÔ±ÜÃâÓ²±àÂëÁË¡£¿ÉÊÇJSPÖÐÄØ£¿µ±È»£¬Èç¹ûJSPÖÐÔÊÐíʹÓÃScripletµÄ»°µ±È»Ò²¿ÉÒÔÖ±½ÓʹÓó ......

JSPÖÐÀûÓÃÊý¾ÝÔ´¶ÔÏó½¨Á¢Êý¾Ý¿âÁ¬½Ó

ÅäÖóÌÐòµÄÔËÐÐĿ¼Óë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Ò³ÃæµÄÓï·¨ÊÇ·ñÕýÈ·£¬½«JSPÒ³Ãæ×ª»»ÎªServletÔ´Îļþ£¬È»ºóµ÷ÓÃjavac¹¤¾ßÀà±àÒëServletÔ´ÎļþÉú³É×Ö½ÚÂëÎļþ£¬ÕâÒ»½×¶ÎÊÇת»»½×¶Î¡£½ÓÏÂÀ´£¬ServletÈÝÆ÷¼ÓÔØ×ª»»ºóµÄServletÀ࣬ʵÀý»¯Ò»¸ ......

jsp·ÖÒ³

ÉÏ¿ÎÀÏʦ½²½âÁËjsp·ÖÒ³ £¬¹ØÓÚ¼ÆËã×ÜÒ³Êý
 
 ËûµÄËã·¨ÊÇ  totalPage=(totalRecords+pageSize-1)/pageSize;  Ëû˵Èç¹û²»ºÃÀí½â£¬¾ÍÓà i f  else Åжϡ£
 
Ï¿ο´Êé
 
 Å¼È»ÏëÆðÁËÒÔǰ£¬µÄÒ»¸öËã·¨
 
totalPage=(totalRecords%pageSize==0)?  (totalRecords/page ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ