获取数据导出到excel中并上传到ftp服务器.docxVIP

//总结数据导出到指定目录下的excel中并上传到ftp服务器的指定目录MaterialReceivingManagerImpl.javapublic class MaterialReceivingManagerImpl{public void askForExportAndUploadMaterialReceive(){askForExportMaterialReceive();askForFTPUploadMaterialReceive();}public void askForExportMaterialReceive(){L(this, --定时导出excel开始);Date now=new Date();SimpleDateFormat sdf=new SimpleDateFormat(yyyy-MM-dd);String dateFile=sdf.format(now);//文件名L(this, 获取当天数据列表+new Date());String title=标题1,标题2,标题3,标题4,标题5;//列名String value=item,name,workPoint,packageType,packageNum;//对应vo的属性名ListMaterialBarcodeVO dataList =new ArrayListMaterialBarcodeVO();Integer size=65000*3+1;for(int i=0;isize;i++){MaterialBarcodeVO vo=new MaterialBarcodeVO();vo.setItem(item);vo.setName(name);vo.setPackageNum(packageNum);vo.setPackageType(packageType);vo.setWorkPoint(workPoint);dataList.add(vo);}//gerDataList();L(this, 开始导出+dateFile+.xls+new Date());String path=getProjectFilePath(ConstantUtil.PROJECT_NAME);String localPath=PropertiesParser.getWebProperty(ConstantUjectFileName, localPath);if(localPath!=null !.equals(localPath)){if(!localPath.startsWith(/)){localPath=/+localPath;}if(!localPath.endsWith(/)){localPath=localPath+/;}}else{localPath=localPath+/;}File file=new File(path+localPath.substring(0,localPath.length()-1));//去掉最后一个///递归创建文件夹if(file!=null){mkDir(file);//本地创建文件夹}String filePath=path+localPath+dateFile+.xls;int sheetMaxRecodeNum=65000;//一个工作表最大记录数try {exprotExcel(filePath,title,value,dataList,sheetMaxRecodeNum);L(this, 导出+dateFile+.xls成功+new Date());} catch (MESException e) {e.printStackTrace();L(this, 导出+dateFile+.xls失败+new Date());}L(this, --定时导出excel结束);}public void askForFTPUploadMaterialReceive(){L(this, --定时触发上传excel开始);Date now=new Date();SimpleDateFormat sdf=new SimpleDateFormat(yyyy-MM-dd);String dateFile=sdf.format(now);//文件名String path=getProjectFilePath(ConstantUtil.PROJECT_NAME);String localPath=PropertiesParser.getWebProperty(ConstantUjectFileName, localPath);if(localPath!=null !.equals(localPath)){if(!localPath.star