仓库管理启发.docVIP

仓库管理启发 导出报表: (统计每月的进出量) (统计每年的进出量) 主要在全查统计方面 public class ReportUtil { public static void getExcelInstance(HttpServletResponse response, String[] str, ListMatchine list) throws IOException, RowsExceededException, WriteException{ OutputStream os = response.getOutputStream();//从容器中，获得输出流 response.reset();//将原来流的内容情况 //设置Excel的报表头信息 response.setHeader(Content-disposition, attachment; filename=user.xls);//这里的xls的表名不能是中文的. response.setContentType(application/msexcel);//设置输出类型 WritableWorkbook wwb;//用来创建Excel表格对象 wwb = Workbook.createWorkbook(os);//创建Excel表格 WritableSheet sheet = wwb.createSheet(药品信息, 0); Label label; //将传入的数组内容作为Excel表格的列标题 for(int i=0;istr.length;i++){ label = new Label(i,0,str[i]); sheet.addCell(label); } for(int j=0;jlist.size();j++){ int k = j+1; label = new Label(0,k,String.valueOf(list.get(j).getId())); sheet.addCell(label); label = new Label(1,k,list.get(j).getName()); sheet.addCell(label); label = new Label(2,k,list.get(j).getProdate()); sheet.addCell(label); label = new Label(3,k,String.valueOf(list.get(j).getPrice())); sheet.addCell(label); label = new Label(4,k,list.get(j).getAddress()); sheet.addCell(label); label = new Label(5,k,list.get(j).getDescrip()); sheet.addCell(label); } wwb.write();//注意，一定在结束的时候，执行该句，进行真正的写入文件 wwb.close(); } } =====================================下面的好使==================================================servlet if(timeworkslistreport.equals(action)){ AccountantDAOImpl atd=new AccountantDAOImpl(); ListTimeworksVo list=atd.selectAllData(); String []str={姓名,出勤天数,出勤时数,平日工资,每小时工资,平时加班时数,平时1.5倍,平时加班工资,假期加班时数,假期2倍,假期加班工资,加班合计时间,加班合计工资,工资合计,补款,夜餐补,总计工资,所得税,代扣,实发工资,存折号,具领人签字}; try { ReportUtil.ReportTimeworkList(response, str, list); } catch (RowsExceededException e) { e.printStackTrace(); } catch (WriteException e) { e.printStackTrace(); } } =========================class public static void ReportTimeworkLi