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:useBean>¶¯×÷ÓÃÓÚʵÀý»¯JavaBean£¬»òÕß¶¨Î»Ò»¸öÒѾ´æÔÚµÄJavaBeanʵÀý£¬²¢°ÑʵÀýµÄÒýÓø³¸øÒ»¸ö±äÁ¿¡£
Óï·¨ÈçÏ£º
<jsp:useBean id="cart" scope="session" class="org.sunxin.lesson.jsp.bookstore.CartBean">
<jsp:setProperty>¶¯×÷ºÍ<jsp:useBean>Ò»ÆðʹÓã¬ÓÃÀ´ÉèÖÃJavaBeanµÄ¼òµ¥ÊôÐ ......
¡¡¡¡¸÷´óÍøÂç±à³ÌÓïÑÔµÄ10Äê·ÜÕ½£¬¸÷ÓÐËù³¤¡¢¸÷ÁìǧÇï¡£½ñÈÕ¶ÔÓÚÎÒÃǵÄÍøÕ¾±à³ÌÓïÑÔ:ASP¡¢JSP¡¢PHP¡¢ASP.NET½øÐÐʵ¼ÊÓ¦ÓÃͳ¼Æ:
¡¡¡¡ASP:50%
¡¡¡¡JSP:10%
¡¡¡¡PHP:20%
¡¡¡¡ASP.NET:20%
¡¡¡¡¸ù¾ÝÒÔÉÏͳ¼ÆÀ´×öÒ»ÏÂÌÖÂÛ¡£ASP¼¼ÊõÈç½ñÌì¿ÉÒÔ˵ÒѳÉΪ¹ýÈ¥£¬µ«ÈÔÕ¼Êг¡µÄ50%£¬ÒòΪµ±Ê±ASP¼¼ÊõµÄÐËÆð£¬¶Ô´ó²¿·Ö±à³Ì ......
JSP ÈçºÎʵÏÖÍøÒ³¶¨Ê±Ìø×ª:
<script language="javascript">
<!--
setTimeout("document.location.href='http://www.163.com'",3000);
//-->
</script>
ˢУº
<meta http-equiv="Refresh" content ......