java 按条件备份,怎么按照搜索条件的结果导出excel

Java codePOI code:

public static void writeExcel(OutputStream out, List beanList)

throws Exception {

HSSFWorkbook book = new HSSFWorkbook();

for(int i = 0; i < beanList.size(); i++) {

HSSFRow row = sheet.createRow(sheet.getLastRowNum() + 1);

//row.setHeight((short) 255);

cell = row.createCell(0);

cell.setCellValue(String.valueOf(beanList.get(i).getName()));

}

book.write(out);

}

download code：

protected void doPost(HttpServletRequest request,

HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

String sufix = request.getParameter("s");

String path = request.getParameter("p") + "." + sufix;

try {

String fileName = request.getParameter("f").trim();

int c = fileName.lastIndexOf(".");

String name = fileName.substring(0, c > 0 ? c : fileName.length())

+ "." + sufix;

response.setContentType("application/octet-stream");

response.setHeader("Content-Disposition", "attachement;filename="

+ new String(name.getBytes("GBK"), "ISO-8859-1"));

File file = new File(Const.getCurrentUtterlyPath() + path);

if (!file.exists()) {

throw new IOException(fileName + ",所下载的文件不存在!");

}

response.setContentLength(Integer.parseInt(file.length() + ""));

InputStream fs = new FileInputStream(file);

OutputStream os = response.getOutputStream();

byte[] buff = new byte[1024];

int readCount = 0;

while ((readCount = fs.read(buff)) != -1) {

os.write(buff, 0, readCount);

}

if (fs != null) {

fs.close();

}

if (os != null) {

os.close();

}

} catch (IOException e) {

LOG.error("error: " + e.getMessage() + ",path: " + path);

throw e;

}

response.setStatus(response.SC_OK);

response.flushBuffer();

}

------解决方案--------------------

汗！！！ 网上一大把！！ 有人贴代码，我就不贴了

------解决方案--------------------

不用那么麻烦。。我以前写过。。直接在jsp上就能写

晚上回家帮你找找代码。。。