仓库管理启发（Warehouse management implications）.doc

仓库管理启发（Warehouse management implications） Export statements: (statistics monthly import and export volume) (Statistics of the annual import and export volume), mainly in the whole check statistics Public, class, ReportUtil { Public, static, void, getExcelInstance (HttpServletResponse, response, String[], STR, ListMatchine, list), throws, IOException, RowsExceededException, WriteException{ OutputStream = response.getOutputStream (OS); / / from the container, to obtain the output stream (response.reset); / / the original flow of content Set the Excel header information / Report Response.setHeader (Content-disposition, attachment; filename=user.xls); / / the XLS table name cannot be Chinese. Response.setContentType (application/msexcel); / / set the output type WritableWorkbook WWB; / / Excel form is used to create objects WWB = Workbook.createWorkbook (OS); / / create table Excel WritableSheet sheet = wwb.createSheet (drug information, 0); Label label; The contents of the array / incoming Excel table as column headings 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); / / note, some at the end of the execution of the sentence, write the real file Wwb.close (); } } ===================================== following that ==================================================servlet If (timeworkslistreport,.Equals (action)) { AccountantDAOImpl, atd=new, AccountantDAOImpl (); ListTime