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ºÍÊý¾Ý¿âÖ®Âðɡ£
Ò»¡¢jspÁ¬½ÓOracle8/8i/9iÊý¾Ý¿â£¨ÓÃthinģʽ£©
testoracle.jspÈçÏ£º
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"java.sql.*\"%>
<html>
<body>
<%Class.forName(\"oracle.jdbc.driver.Oracl ......
JSPµÄÔËÐлúÖÆ£º
JSPÈÝÆ÷¹ÜÀíJSPÒ³ÃæÉúÃüÖÜÆÚµÄÁ½¸ö½×¶Î£º×ª»»½×¶ÎºÍÖ´Ðн׶Ρ£µ±ÓÐÒ»¸ö¶ÔJSPÒ³ÃæµÄ¿Í»§ÇëÇóµ½À´Ê±£¬JSPÈÝÆ÷¼ìÑéJSPÒ³ÃæµÄÓï·¨ÊÇ·ñÕýÈ·£¬½«JSPÒ³Ãæ×ª»»ÎªServletÔ´Îļþ£¬È»ºóµ÷ÓÃjavac¹¤¾ßÀà±àÒëServletÔ´ÎļþÉú³É×Ö½ÚÂëÎļþ£¬ÕâÒ»½×¶ÎÊÇת»»½×¶Î¡£½ÓÏÂÀ´£¬ServletÈÝÆ÷¼ÓÔØ×ª»»ºóµÄServletÀ࣬ʵÀý»¯Ò»¸ ......
ÔÀí²»ËµÁË,ÍøÉÏÓкܶà,¶¼¿ÉÒÔ×Ô¼º²éµ½,ÖÁÓÚΪʲô»á³öÏÖÂÒÂë,ÊÇÒòΪJAVAÓÐʹÓùú¼Ê»¯,Óöµ½ÖÐÎÄʱ.....
ÏÂÃæ¸ø³öһЩ¼òµ¥µÄʵÓôúÂë,Ö»¹©²Î¿¼:
public class ChangeUtf8 {
public static String getS(String Str){
try{
......
servlet--------------------------------------------JSP
HttpServletRequest request
HttpServletResponse &nbs ......
1.Ê×ÏÈÔÚjspÒ³ÃæÖÐÉú³ÉÑéÖ¤ÂëͼƬ£¬image.jsp
<%@ page contentType="image/jpeg"%>
<%@ page import="java.awt.*,java.awt.image.*,java.util.*,javax.imageio.*" %>
<%!
Color getRandColor(int fc,int bc){//¸ø¶¨·¶Î§»ñµÃËæ»úÑÕÉ«
Random random = new Random();
......