struts2 spring ibatis poi开发的导出Excel的demo

package com.xdl.action; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.ServletContext; import javax.servlet.http.HttpServletResponse; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.struts2.interceptor.ServletResponseAware; import com.opensymphony.xwork2.ActionSupport; import com.xdl.biz.IUserBO; import com.xdl.dataobject.UserDO; public class UserAction extends ActionSupport implements ServletResponseAware { private static final long serialVersionUID = 7311940547161671031L; private UserDO userDO; private IUserBO userBO; private List<UserDO> userList; private HttpServletResponse response; /*** * @description 模糊查询所有用户信息 * @return */ public String queryUser() { try { userList = this.userBO.findUser(userDO); if (userList != null) { return SUCCESS; } } catch (Exception e) { e.printStackTrace(); } return null; } /**导出EXCEL*/ public String exportExcel() { return SUCCESS; } public InputStream getInputStream() throws Exception { return this.getInStream(); } public InputStream getInStream() throws Exception { HSSFWorkbook wb = new HSSFWorkbook(); //创建一个工作薄 HSSFSheet sheet = wb.createSheet("用户列表"); //创建一个表,表的名称为"用户列表" //设置表格的样式 HSSFCellStyle style = wb.createCellStyle(); HSSFFont font = wb.createFont(); font.setFontHeightInPoints((short)10); //字体高度 font.setColor(HSSFFont.COLOR_NORMAL); //字体颜色 font.setFontName("宋体"); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //宽度 style.setFont(font); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); //水平布局：居中显示 style.setWrapText(false); HSSFRow row = sheet.createRow(0); //创建第一行 HSSFCell cell = row.createCell(0); //创建第一个单元格 cell.setCellStyle(style); //设置第一个单元格的样式 cell.setCellValue("编号"); //设置第一个单元格的值 cell = row.createCell(1); //创建第二个单元格 cell.setCellStyle(style); cell.setCellValue("用户名"); cell = row.createCell(2); //创建第三个单元格 cell.setCellStyle(style); cell.setCellValue("密码"); cell = row.createCell(3); //创建第四个单元格 cell.setCellStyle(style); cell.setCellValue("真实姓名"); userList = this.userBO.findUser(userDO); System.out.println(userList.size()); if(userList != null) { for(int i=0; i<userList.size(); i++) { row = sheet.createRow(i+1); cell = row.createCell(i); row.createCell(0).setCellValue(userList.get(i).getId()); row.createCell(1).setCellValue(userList.get(i).getUsername()); row.createCell(2).setCellValue(userList.get(i).getPassword()); row.createCell(3).setCellValue(userList.get(i).getRealname()); } } String fileName = "user"; //fileName = new StringBuffer(fileName).append(".xls").toString(); StringBuffer sb = new StringBuffer(fileName); DateFormat df = new SimpleDateFormat("yyyy-MM-dd"); sb.append(df.format(new Date())); sb.append(".xls"); File file = new File(sb.toString()); try{ OutputStream os = new FileOutputStream(file); wb.write(os); os.flush(); os.close(); InputStream is = new FileInputStream(file); return is; }catch(Exception e) { e.printStackTrace(); } return null; } /*** * @Description 获取文件名 * @return */ /*public String getFileName() { StringBuffer sb = new StringBuffer(); sb.append("user-"); DateFormat df = new SimpleDateFormat("yyyy-MM-dd"); sb.append(df.format(new Date())); return sb.toString(); }*/ public UserDO getUserDO() { return userDO; } public void setUserDO(UserDO userDO) { this.userDO = userDO; } public IUserBO getUserBO() { return userBO; } public void setUserBO(IUserBO userBO) { this.userBO = userBO; } public List<UserDO> getUserList() { return userList; } public void setUserList(List<UserDO> userList) { this.userList = userList; } @Override public void setServletResponse(HttpServletResponse response) { this.response = response; } }