1、 + rows);cols: + cols); if (rows = 0) continue; if (rows ROW_OF_SHEET) info.setFlag(false); info.setInfo(第 + (s + 1) + sheet中的行数: + rows + 超过最大行数限制: + ROW_OF_SHEET); return info; if (cols != COL_OF_SHEET & cols != COL_OF_SHEET_2) sheet中的列数: + cols 不符!目前列数是: + COL_OF_SHEET+或:+ROW_OF_SHEET); if(cols =
2、 COL_OF_SHEET)for (int i = 0; i rows; i+) CardBean bean = new CardBean(); bean.setCard_id(rs.getCell(0, i).getContents().trim(); bean.setCustType(rs.getCell(1, i).getContents().trim(); bean.setValid_date(rs.getCell(2, i).getContents().trim(); bean.setBank_fee(rs.getCell(3, i).getContents().trim(); b
3、ean.setSubway_fee(rs.getCell(4, i).getContents().trim(); bean.setStatus(0); bean.setCardAppStatus( temp.add(bean); else if(cols = COL_OF_SHEET_2) for (int i = 0; bean.setCustType(rs.getCell(1, i).getContents().trim(); bean.setAppNo(rs.getCell(5, i).getContents().trim(); bean.setStatus(rs.getCell(6,
4、i).getContents().trim(); bean.setCardAppStatus(rs.getCell(7, i).getContents().trim(); bean.setCardBrand(rs.getCell(8, i).getContents().trim(); bean.setVersionId(rs.getCell(9, i).getContents().trim(); bean.setIccid(rs.getCell(10, i).getContents().trim(); catch (Exception e) FileLog.errorLog(e); info.
5、setFlag(false); info.setInfo(导入卡信息文件失败! return info; info.setFlag(true); info.setInfo(导入卡信息文件成功! return info;java一款支持批量上传的代码示例2013-03-21 09:41:25 我来说两句 作者:上天入地收藏我要投稿效果图如下:该工程包含五个源文件:BackGroundService.java、BeanControler.java、EventListenerImpl.java、FileUploadListener.java和FileUploadStatus.java;以及2个jsp
6、页面。源码已提供免费下载,下载后直接部署到tomcat中运行即可。BackGroundService.java:java package liuzuochen.sample.upload;/* Title: 后台服务*Description: 为客户端提供上传及文件传输状态查询服务 0) return filePath.substring(pos + 1); else return filePath;* 从request中取出FileUploadStatus Bean public static FileUploadStatus getStatusBean( HttpServletReques
7、t request) BeanControler beanCtrl = BeanControler.getInstance(); return beanCtrl.getUploadStatus(request.getRemoteAddr();* 把FileUploadStatus Bean保存到类控制器BeanControler public static void saveStatusBean( HttpServletRequest request, FileUploadStatus statusBean) statusBean.setUploadAddr(request.getRemote
8、Addr(); beanCtrl.setUploadStatus(statusBean);* 删除已经上传的文件 private void deleteUploadedFile(HttpServletRequest request) FileUploadStatus satusBean = getStatusBean(request); for (int i = 0; satusBean.getUploadFileUrlList().size(); i+) File uploadedFile = new File(request.getRealPath(UPLOAD_DIR) + File.s
9、eparator + satusBean.getUploadFileUrlList(). get(i); uploadedFile.delete(); satusBean.getUploadFileUrlList().clear(); satusBean.setStatus(删除已上传的文件 saveStatusBean(request, satusBean);* 上传过程中出错处理 private void uploadExceptionHandle( String errMsg) throws ServletException, IOException /首先删除已经上传的文件 delet
10、eUploadedFile(request); satusBean.setStatus(errMsg);* 初始化文件上传状态Bean private FileUploadStatus initStatusBean(HttpServletRequest request) FileUploadStatus satusBean = new FileUploadStatus();正在准备处理 satusBean.setUploadTotalSize(request.getContentLength(); satusBean.setProcessStartTime(System.currentTime
11、Millis(); satusBean.setBaseDir(request.getContextPath() + UPLOAD_DIR); return satusBean;* 处理文件上传 private void processFileUpload(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException DiskFileItemFactory factory = new DiskFileItemFactory(); /设置内存缓冲区,超过后写入临时文件 f
12、actory.setSizeThreshold(10240000); /设置临时文件存储位置 factory.setRepository(new File(request.getRealPath(/upload/temp); ServletFileUpload upload = new ServletFileUpload(factory); /设置单个文件的最大上传值 upload.setFileSizeMax(5*102400000); /设置整个request的最大值 upload.setSizeMax(10*102400000); upload.setProgressListener(n
13、ew FileUploadListener(request); /保存初始化后的FileUploadStatus Bean saveStatusBean(request, initStatusBean(request); FileUploadStatus satusBean = getStatusBean(request); String forwardURL = int flag=1; try List items = upload.parseRequest(request); /获得返回url items.size(); FileItem item = (FileItem) items.g
14、et(i); if (item.isFormField() forwardURL = item.getString(); break; /处理文件上传 /取消上传 if (getStatusBean(request).getCancel() /保存文件 else if (!item.isFormField() & item.getName().length() String fileName = takeOutFileName(item.getName();File.separator + fileName); item.write(uploadedFile); flag+; /更新上传文件列
15、表 satusBean.getUploadFileUrlList().add(fileName); /Thread.sleep(500); catch (FileUploadException e) uploadExceptionHandle(request, 上传文件时发生错误: + e.getMessage(); catch (Exception e) 保存上传文件时发生错误: if (forwardURL.length() = 0) forwardURL = DEFAULT_UPLOAD_FAILURE_URL; request.setAttribute(msg, b文件上传成功!/b/font request.getRequestDispatcher().forward(request, response);* 回应上传状态查询 private void responseStatusQuery(HttpServletRequest request,
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1