JSP SERVLET 导出数据库内容到EXCEL

// Java Document package test; 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; import java.io.*; import java.sql.*; import test.DBConnection; public class POIExcel { private DBConnection con; public POIExcel() { con=new DBConnection(); } //@SuppressWarnings("deprecation") @SuppressWarnings("deprecation") public void exportExcel(String name,OutputStream out,String sql){ HSSFWorkbook wb=new HSSFWorkbook(); HSSFSheet sheet=wb.createSheet(name); HSSFRow row=sheet.createRow(0); HSSFCell cell=row.createCell((short)0); cell.setCellValue("姓名"); cell=row.createCell((short)1); cell.setCellValue("电子邮件"); int nRow=1; try{ ResultSet rs=con.execQuery(sql); while(rs.next()){ row=sheet.createRow(nRow++); cell=row.createCell((short)0); cell.setCellValue(rs.getString(1)); cell=row.createCell((short)1); cell.setCellValue(rs.getString(2)); } rs.close(); }catch(SQLException e){ System.out.println("POIExcel.exportExcel()"+e.getMessage()); } try{ wb.write(out); }catch(Exception e){ System.out.println("POIExcel.exportExcel()"+e.getMessage()); } } }