java中导出数据到Excel中例子.docx

packagenet.risesoft.formula;importjava.io.FileOutputStream;importjava.io.OutputStream;importjava.io.PrintWriter;importjava.util.ArrayList;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.hssf.util.HSSFColor;importcom.oreilly.servlet.MultipartRequest;importnet.coin.db.DBManager;importnet.coin.db.result.Result;importnet.coin.servlet.Context;importnet.risesoft.formulamanager.ChkFormulaCode;importnet.risesoft.system.InstitutionHelper;importnet.risesoft.task.TaskHelper;public class FormulaExportServlet extends HttpServlet {static final private String CONTENT_TYPE = application/vnd.ms-excel;charset=gbk;private String[] fieldName = null;private String report_code = null;private String taskId = null;private String formualTableName = null;private String system_code = null;private String tjStr=;private String colStr=;/***************************************************************************** *****************************************************************************/public void doPost(HttpServletRequest request, HttpServletResponse response) {doPerform(request, response);}/***************************************************************************** *****************************************************************************/public void doGet(HttpServletRequest request, HttpServletResponse response) {doPerform(request, response);}private String getFileName(HttpServletRequest request, String report_code) throws Exception {String reportTableName=rpt_report_+this.taskId;String tableName=DBManager.query(select t.report_name from +reportTableName+ t where t.report_code=+report_code+ ).forFirstString(report_name);returntableName;}/*****************