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½çÃæÖÐʹÓÃÏÂÀ¿ò£¬ÈÕÆڿؼþ£¬·ÖÒ³¿Ø¼þ¡£ÈôÄܽ«´ËÀà¿Ø¼þ³éÏó³öÀ´£¬×ö³ÉÒ»¸öJspTagµÄ»°£¬ÄÇʹÓÃÆðÀ´¾Í·½±ã¶àÁË¡£Í¬Ê±±ãÓÚJSPµÄÔĶÁ£¬¸üÖ÷ÒªµÄÊÇ·½±ãÁËÏîÄ¿µÄ¹ÜÀíÓëά»¤¡£
ÏÂÃæÒÔÐÐÒµÏÂÀ¿ò¿Ø¼þΪÀý½éÉÜ×Ô¶¨ÒåJspTag£¬ÓÈÆä×¢ÒâºìÉ«±ê×¢´¦£¬´Ó¶ÔÓ¦¹Øϵ¿ÉÒÔÕÒµ½ÔËÓùæÂÉ£º
Ê×ÏȽ¨Á¢/WEB-INF/tags/my-t ......
JSPµÄÔËÐлúÖÆ£º
JSPÈÝÆ÷¹ÜÀíJSPÒ³ÃæÉúÃüÖÜÆÚµÄÁ½¸ö½×¶Î£º×ª»»½×¶ÎºÍÖ´Ðн׶Ρ£µ±ÓÐÒ»¸ö¶ÔJSPÒ³ÃæµÄ¿Í»§ÇëÇóµ½À´Ê±£¬JSPÈÝÆ÷¼ìÑéJSPÒ³ÃæµÄÓï·¨ÊÇ·ñÕýÈ·£¬½«JSPÒ³Ãæת»»ÎªServletÔ´Îļþ£¬È»ºóµ÷ÓÃjavac¹¤¾ßÀà±àÒëServletÔ´ÎļþÉú³É×Ö½ÚÂëÎļþ£¬ÕâÒ»½×¶ÎÊÇת»»½×¶Î¡£½ÓÏÂÀ´£¬ServletÈÝÆ÷¼ÓÔØת»»ºóµÄServletÀ࣬ʵÀý»¯Ò»¸ ......
ºÍJavaÒ»Ñù£¬JSPÊÇÄ¿Ç°±È½ÏÈÈÃŵÄÒ»¸ö»°Ìâ¡£ËüÊÇÒ»ÖÖÔÚ·þÎñÆ÷¶Ë±àÒëÖ´ÐеÄWebÉè¼ÆÓïÑÔ£¬ÒòΪ½Å±¾ÓïÑÔ²ÉÓÃÁËJava£¬ËùÒÔJSP¼Ì³ÐÁËJavaµÄËùÓÐÓŵ㡣¿ÉÊÇÔÚʹÓÃJSP³ÌÐòµÄ¹ý³ÌÖУ¬³£Óöµ½ÖÐÎÄÂÒÂëÎÊÌ⣬ºÜ¶àÈËΪ´ËÍ·ÌÛ²»ÒÑ£¬±ÊÕß¾ÍÉîÊÜÆ亦£¬¶øÇÒʹÓÃƽ̨²»Í¬£¬ÖÐÎÄÂÒÂëÎÊÌâµÄ½â¾ö·½·¨Ò²²»Í¬£¬ÎÞÐÎÖÐÔö¼ÓÁËѧϰJSPµÄÄѶȡ£Æäʵ£¬Ô ......
ÉÏ¿ÎÀÏʦ½²½âÁËjsp·ÖÒ³ £¬¹ØÓÚ¼ÆËã×ÜÒ³Êý
ËûµÄËã·¨ÊÇ totalPage=(totalRecords+pageSize-1)/pageSize; Ëû˵Èç¹û²»ºÃÀí½â£¬¾ÍÓà i f else Åжϡ£
Ï¿ο´Êé
żȻÏëÆðÁËÒÔÇ°£¬µÄÒ»¸öËã·¨
totalPage=(totalRecords%pageSize==0)? (totalRecords/page ......
JSP ʵÔÚservlet Ö®ºó·¢Õ¹ÆðÀ´µÄ¼¼Êõ¡£
ÔËÐлúÖÆ£º
1£ºjspÎļþÌá½»·þÎñÆ÷£¬·þÎñÆ÷ £¨Tomcat£©£¬³õʼ»¯ ÇëÇóºÍÏìÓ¦¶ÔÏó £¬È»ºóÅжÏjspÎļþÊÇ·ñ´æÔÚ £¬Èç¹û²»´æÔÚ 404 ´íÎ󣬴æÔÚ £¬±àÒë³ÉΪ ¡£java Îļþ ----¡·¡£class Îļþ ¡£¾ÍÊÇÒ»¸öjavaµÄÀà £¬Õâ¸öÀà £¬¼Ì³Ð×Ô httpjspbase £¬Õâ¸öhttpjsppageÀà ÓÖ ÊµÏÖÁË» ......