资源描述:
《仓库管理启发(warehouse management implications)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、仓库管理启发(Warehousemanagementimplications)Exportstatements:(statisticsmonthlyimportandexportvolume)(Statisticsoftheannualimportandexportvolume),mainlyinthewholecheckstatisticsPublic,class,ReportUtil{Public,static,void,getExcelInstance(HttpServletResponse,response,Str
2、ing[],STR,List,list),throws,IOException,RowsExceededException,WriteException{OutputStream=response.getOutputStream(OS);//fromthecontainer,toobtaintheoutputstream(response.reset);//theoriginalflowofcontentSettheExcelheaderinformation/ReportResponse.setHea
3、der("Content-disposition","attachment;filename=user.xls");//theXLStablenamecannotbeChinese.Response.setContentType("application/msexcel");//settheoutputtypeWritableWorkbookWWB;//ExcelformisusedtocreateobjectsWWB=Workbook.createWorkbook(OS);//createtableExcelWritab
4、leSheetsheet=wwb.createSheet("druginformation",0);Labellabel;Thecontentsofthearray/incomingExceltableascolumnheadingsFor(inti=0;i5、lueOf(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)
6、;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,someattheendoftheexecutionofthesentence,writetherealfileWwb.close();}}=====================================
7、followingthat==================================================servletIf("timeworkslistreport",.Equals(action)){AccountantDAOImpl,atd=new,AccountantDAOImpl();List,list=atd.selectAllData();String[]str={"name","attendancedays","attendancenumber","dailyw
8、ages","hourlywage","overtimehours","usually1.5times","overtimewages","holidayovertimehours","holiday2times","holidayovertimethecapital","totalovertimeti