package?org.hnylj.poi;

import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;

import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFRichTextString;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;

public?class?BuildExcelServlet?extends?HttpServlet?{

	protected?void?doGet（HttpServletRequest?request
			HttpServletResponse?response）?throws?ServletException?IOException?{
		StudentResultSet?stuResultSet?=?new?StudentResultSet（）;
		ResultSet?rs?=?stuResultSet.query（）;
		String?xlsName?=?“test.xls“;
		String?sheetName?=?“sheetName“;

		HSSFWorkbook?workbook?=?new?HSSFWorkbook（）;
		HSSFSheet?sheet?=?workbook.createSheet（）;
		workbook.setSheetName（0?sheetName）;
		HSSFRow?row?=?sheet.createRow（（short）?0）;
		HSSFCell?cell;
		try?{
			ResultSetmetaData?md?=?rs.getmetaData（）;
			int?nColumn?=?md.getColumnCount（）;

			for?（int?i?=?1;?i?<=?nColumn;?i++）?{
				cell?=?row.createCell（（short）?（i?-?1））;
				cell.setCellType（HSSFCell.CELL_TYPE_STRING）;
				cell.setCellValue（new?HSSFRichTextString（md.getColumnLabel（i）））;
			}
			int?iRow?=?1;
			while?（rs.next（））?{
				row?=?sheet.createRow（（short）?iRow）;
				;
				for?（int?j?=?1;?j?<=?nColumn;?j++）?{
					cell?=?row.createCell（（short）?（j?-?1））;
					cell.setCellType（HSSFCell.CELL_TYPE_STRING）;
					cell.setCellValue（new?HSSFRichTextString（rs.getobject（j）
							.toString（）））;
				}
				iRow++;
			}
			String?filename?=?request.getRealPath（“/“）?+?xlsName;
			request.setAttribute（“filename“?filename）;
			FileOutputStream?fOut?=?new?FileOutputStream（filename）;
			workbook.write（fOut）;
			fOut.flush（）;
			fOut.close（）;
			request.getRequestDispatcher（“OpenExcelServlet“）.forward（request
					response）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}

	protected?void?doPost（HttpServletRequest?request
			HttpServletResponse?response）?throws?ServletException?IOException?{
		this.doGet（request?response）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????505??2008-02-27?19:16??poi\.classpath

?????目錄??????????0??2008-02-27?15:38??poi\.myeclipse

?????文件????????282??2008-02-27?15:38??poi\.mymetadata

?????文件???????1221??2008-02-27?15:40??poi\.project

?????文件???????2324??2008-02-27?20:22??poi\src\org\hnylj\poi\BuildExcelServlet.java

?????文件???????1220??2008-02-27?20:38??poi\src\org\hnylj\poi\OpenExcelServlet.java

?????文件????????931??2008-02-27?21:21??poi\src\org\hnylj\poi\StudentResultSet.java

?????文件???????1834??2008-02-27?20:17??poi\src\org\hnylj\poi\Test.java

?????目錄??????????0??2008-02-27?20:17??poi\src\org\hnylj\poi

?????目錄??????????0??2008-02-27?15:59??poi\src\org\hnylj

?????目錄??????????0??2008-02-27?15:59??poi\src\org

?????目錄??????????0??2008-02-27?15:59??poi\src

?????文件???????6144??2008-02-27?19:16??poi\test.xls

?????文件????????361??2008-02-27?21:01??poi\WebRoot\index.jsp

?????文件?????????39??2008-02-27?15:38??poi\WebRoot\meta-INF\MANIFEST.MF

?????目錄??????????0??2008-02-27?15:38??poi\WebRoot\meta-INF

?????文件????????696??2008-02-27?21:20??poi\WebRoot\sql.sql

?????文件???????3755??2008-02-27?20:22??poi\WebRoot\WEB-INF\classes\org\hnylj\poi\BuildExcelServlet.class

?????文件???????1830??2008-02-27?20:38??poi\WebRoot\WEB-INF\classes\org\hnylj\poi\OpenExcelServlet.class

?????文件???????1468??2008-02-27?21:21??poi\WebRoot\WEB-INF\classes\org\hnylj\poi\StudentResultSet.class

?????文件???????2774??2008-02-27?20:20??poi\WebRoot\WEB-INF\classes\org\hnylj\poi\Test.class

?????目錄??????????0??2008-02-27?20:17??poi\WebRoot\WEB-INF\classes\org\hnylj\poi

?????目錄??????????0??2008-02-27?19:16??poi\WebRoot\WEB-INF\classes\org\hnylj

?????目錄??????????0??2008-02-27?19:16??poi\WebRoot\WEB-INF\classes\org

?????目錄??????????0??2008-02-27?19:16??poi\WebRoot\WEB-INF\classes

?????文件?????493105??2008-02-27?19:16??poi\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.3-bin.jar

?????文件?????909270??2008-02-27?15:38??poi\WebRoot\WEB-INF\lib\poi-3.0.1.jar

?????目錄??????????0??2008-02-27?19:16??poi\WebRoot\WEB-INF\lib

?????文件????????932??2008-02-27?21:00??poi\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2008-02-27?15:38??poi\WebRoot\WEB-INF

............此處省略5個文件信息