List of usage examples for org.apache.commons.fileupload.servlet ServletFileUpload ServletFileUpload
public ServletFileUpload(FileItemFactory fileItemFactory)
FileItem instances. From source file:Admin.products.ProductS.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w w w . j ava2 s . c o m * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out = response.getWriter()) { String brand = request.getParameter("sel01n"); String category_1 = request.getParameter("sel02n"); String category_2 = request.getParameter("sel03n"); String category_3 = request.getParameter("sel04n"); String product_name = request.getParameter("txf01n"); String description = request.getParameter("txa01n"); String specifications = request.getParameter("spe00n"); try { String Name = null; String Price = null; String QTY = null; FileItemFactory item = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(item); List<FileItem> list = upload.parseRequest(request); for (FileItem fileItem : list) { if (fileItem.isFormField()) { //form field // fileItem.getFieldName().equals("sel01n")) { Name = fileItem.getString(); if (fileItem.getFieldName().equals("spe01n")) { System.out.println("NAME-----:" + Name); } else if (fileItem.getFieldName().equals("spe02n")) { System.out.println("VALUE-----:" + Name); } } else { System.out.println("---------------" + fileItem.getName()); // String n = new File(fileItem.getName()).getName(); System.out.println(request.getServletContext().getRealPath("/04_admin/product/img/") + "\\" + System.currentTimeMillis() + ".jpg"); fileItem.write(new File(request.getServletContext().getRealPath("/04_admin/product/img/") + "\\" + System.currentTimeMillis() + ".jpg")); } } } catch (Exception e) { throw new ServletException(e); } } }
From source file:controlador.SerCiudadano.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w ww . j av a 2s . co m * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); //Procesando el archivo .sql con los datos del cnr //en esta ruta se guarda temporalmente el archivo .sql Bitacora b = new Bitacora(); String ruta = getServletContext().getRealPath("/") + "pages/procesos/"; if (ServletFileUpload.isMultipartContent(request)) { FileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); DiskFileItemFactory diskFileItemFactory = new DiskFileItemFactory(); diskFileItemFactory.setSizeThreshold(40960); File repositoryPath = new File("/temp"); diskFileItemFactory.setRepository(repositoryPath); ServletFileUpload servletFileUpload = new ServletFileUpload(diskFileItemFactory); servletFileUpload.setSizeMax(81920); // bytes upload.setSizeMax(307200); // 1024 x 300 = 307200 bytes = 300 Kb List listUploadFiles = null; FileItem item = null; try { listUploadFiles = upload.parseRequest(request); Iterator it = listUploadFiles.iterator(); while (it.hasNext()) { item = (FileItem) it.next(); //este es el archivo que se envia en el campo file if (!item.isFormField()) { if (item.getSize() > 0) { String nombre = item.getName(); String tipo = item.getContentType(); long tamanio = item.getSize(); String extension = nombre.substring(nombre.lastIndexOf(".")); File archivo = new File(ruta, nombre); item.write(archivo); if (archivo.exists()) { String script = ruta + "" + nombre; //consulta para importar registros if (ConsultasDTO.ejecutar( "copy padronelectoral from '" + script + "' with (delimiter ',')")) { out.print("Registros importados correctamente"); } else { out.print("Hubo un error"); } } else { out.println("FALLO AL GUARDAR. NO EXISTE " + archivo.getAbsolutePath() + "</p>"); } } } else { //ac recogemos los duis de los magistrados if (item.getFieldName().equals("dui1")) { b.setMagistrado1(item.getString()); } if (item.getFieldName().equals("dui2")) { b.setMagistrado2(item.getString()); } if (item.getFieldName().equals("dui3")) { b.setMagistrado3(item.getString()); } } } //registramos en la base de datos los duis de los magistrados //que autorizaron la insercion de datos CNR b.setAccion("Registro de datos CNR"); if (BitacoraDTO.agregarBitacora(b)) { out.print("<br>Bitacora agregada"); } else { out.print("<br>Hubo un error al agregar la bitacora"); } } catch (FileUploadException e) { out.println("Error Upload: " + e.getMessage()); e.printStackTrace(); } catch (Exception e) { out.println("Error otros: " + e.getMessage()); e.printStackTrace(); } } }
From source file:com.shyshlav.functions.filework.download_image.java
public String download(HttpServletRequest request, HttpServletResponse response) throws IOException { request.setCharacterEncoding("UTF-8"); // response.setCharacterEncoding("UTF-8"); filePath = request.getSession().getServletContext().getInitParameter("avathars"); System.out.println(filePath); isMultipart = ServletFileUpload.isMultipartContent(request); System.out.println(isMultipart); response.setContentType("text/html"); PrintWriter out = response.getWriter(); if (!isMultipart) { return " "; }//from ww w .j a v a 2s . c o m DiskFileItemFactory factory = new DiskFileItemFactory(); // maximum size that will be stored in memory factory.setSizeThreshold(maxMemSize); // Location to save data that is larger than maxMemSize. factory.setRepository(new File("c:\test")); // Create a new file upload handler ServletFileUpload upload = new ServletFileUpload(factory); upload.setHeaderEncoding("UTF-8"); // maximum file size to be uploaded. upload.setSizeMax(maxFileSize); try { // Parse the request to get file items. List<FileItem> fileItems = upload.parseRequest(request); // Process the uploaded file items Iterator i = fileItems.iterator(); //String name,String password,String email,String surname,String link_to_image,String about_me,String id String name = null; String password = null; String re_password = null; String surname = null; String about_me = null; String id = null; String link_to_server = null; String email = null; while (i.hasNext()) { FileItem fi = (FileItem) i.next(); if (fi.isFormField()) { String fieldname = fi.getFieldName(); String fieldvalue = fi.getString(); if (fieldname.equals("name")) { name = fi.getString("UTF-8"); } else if (fieldname.equals("surname")) { surname = fi.getString("UTF-8"); } else if (fieldname.equals("password")) { password = fi.getString("UTF-8"); } else if (fieldname.equals("re_password")) { re_password = fi.getString("UTF-8"); } else if (fieldname.equals("about_me")) { about_me = fi.getString("UTF-8"); } else if (fieldname.equals("id")) { id = fi.getString("UTF-8"); } else if (fieldname.equals("email")) { email = fi.getString("UTF-8"); } System.out.println(fieldname + fieldvalue); if (fieldname == null || fieldvalue == null) { return "? ? ? "; } } if (!fi.isFormField()) { if (!password.equals(re_password)) { System.out.println(password + " - " + re_password); return " ?"; } // Get the uploaded file parameters String fileName = email + ".png"; link_to_server = "/musicbox/avathars/" + email + ".png".trim(); // Write the file if (fileName.lastIndexOf("\\") >= 0) { file = new File(filePath + fileName.substring(fileName.lastIndexOf("\\"))); } else { file = new File(filePath + fileName.substring(fileName.lastIndexOf("\\") + 1)); } fi.write(file); System.out.println("Uploaded Filename: " + filePath + fileName); } } System.out.println(link_to_server); updateUser um = new updateUser(); um.updateUser(name, password, surname, link_to_server, about_me, id); } catch (Exception ex) { System.out.println(ex); return " 1 "; } return "ok"; }
From source file:Emporium.Servlet.ServImportarDestinatario.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w ww . jav a 2 s . c o m*/ * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws IOException { HttpSession sessao = request.getSession(); String nomeBD = (String) sessao.getAttribute("nomeBD"); if (nomeBD != null) { boolean isMultiPart = FileUpload.isMultipartContent(request); int idCliente = 0; int idDepartamento = 0; if (isMultiPart) { try { FileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(1024 * 1024 * 2); List items = upload.parseRequest(request); Iterator iter = items.iterator(); FileItem itemImg = null; while (iter.hasNext()) { FileItem item = (FileItem) iter.next(); if (item.isFormField()) { if (item.getFieldName().equals("idCliente")) { idCliente = Integer.parseInt(item.getString()); } if (item.getFieldName().equals("idDepartamento")) { idDepartamento = Integer.parseInt(item.getString()); } } if (!item.isFormField()) { if (item.getName().length() > 0) { itemImg = item; } } } if (!itemImg.getName().toUpperCase().endsWith(".CSV") && !itemImg.getName().toUpperCase().endsWith(".TXT")) { response.sendRedirect( "Cliente/Cadastros/destinatario_lista.jsp?msg=Escolha um arquivo para importacao !"); } else { //CONSULTA DADOS DO CLIENTE/DEPARTAMENTO/CONTRATO Clientes cli = contrCliente.consultaClienteById(idCliente, nomeBD); if (cli != null) { String condicao = ContrDestinatarioImporta.importaPedido(itemImg, idCliente, idDepartamento, nomeBD); response.sendRedirect("Cliente/Cadastros/destinatario_lista.jsp?msg=" + condicao); } else { response.sendRedirect( "Cliente/Cadastros/destinatario_lista.jsp?msg=Cliente nao encontrado no banco de dados!"); } } } catch (FileUploadException ex) { response.sendRedirect( "Cliente/Cadastros/destinatario_lista.jsp?msg=Falha no Upload do Arquivo de Importacao!\n" + ex); } catch (Exception ex) { response.sendRedirect( "Cliente/Cadastros/destinatario_lista.jsp?msg=Falha na importacao!\n" + ex); } } } else { response.sendRedirect("Cliente/Cadastros/destinatario_lista.jsp?msg=Sua sessao expirou!"); } }
From source file:com.sishistorico.sv.SvCadastraEleitor.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w w w .j a v a 2s.co m*/ * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF8"); response.setContentType("text/html;charset=UTF-8"); List<FileItem> items = null; byte[] foto = null; try { items = new ServletFileUpload(new DiskFileItemFactory()).parseRequest(request); for (FileItem item : items) { if (!item.isFormField()) { InputStream imageInput = item.getInputStream(); Image image = ImageIO.read(imageInput); BufferedImage thumb = Imagem.redimensionar(image, 400, 500); ByteArrayOutputStream baos = new ByteArrayOutputStream(); ImageIO.write(thumb, "JPG", baos); baos.flush(); foto = baos.toByteArray(); baos.close(); } } //dados do formulrio e metodos para salvar DateFormat formatter; Date date; formatter = new SimpleDateFormat("dd/MM/yyyy"); date = (Date) formatter.parse(items.get(1).getString()); // fim do tratamento Eleitor el = new Eleitor(); Endereco end = new Endereco(); el.setNome(items.get(0).getString("UTF-8").trim()); el.setData_nascimento(date); el.setCpf(items.get(2).getString("UTF-8").replaceAll("\\.|\\-|\\ ", "").trim()); el.setRg(items.get(3).getString("UTF-8").replaceAll("\\.|\\-|\\ ", "").trim()); el.setSus(items.get(4).getString("UTF-8").replaceAll("\\.|\\-|\\ ", "").trim()); el.setEmail(items.get(5).getString("UTF-8")); el.setTelefone(items.get(6).getString("UTF-8").replaceAll("\\(|\\)|\\-|\\ ", "").trim()); el.setWhats(items.get(7).getString("UTF-8").replaceAll("\\(|\\)|\\-|\\ ", "").trim()); el.setObs(items.get(8).getString("UTF-8").trim()); el.setReferencia_pessoal(items.get(9).getString("UTF-8").trim()); end.setRua(items.get(11).getString("UTF-8").trim()); end.setBairro(items.get(12).getString("UTF-8").trim()); end.setN(items.get(13).getString("UTF-8").trim()); end.setCidade(items.get(14).getString("UTF-8").trim()); end.setCep(items.get(15).getString("UTF-8").trim()); end.setLocalidade(Integer.parseInt(items.get(16).getString("UTF-8").trim())); el.setTipo(Integer.parseInt(items.get(17).getString("UTF-8").trim())); el.setPertence(Integer.parseInt(items.get(18).getString("UTF-8").trim())); el.setEnd(end); DaoEleitor daoEleitor = new DaoEleitor(); DaoFoto daoFoto = new DaoFoto(); int idretorno = daoEleitor.Eleitor_Salvar(el); daoFoto.inserirImagem(foto, idretorno); response.sendRedirect("cadastro_eleitor.jsp?msgok"); } catch (FileUploadException ex) { Logger.getLogger(SvCadastraEleitor.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(SvCadastraEleitor.class.getName()).log(Level.SEVERE, null, ex); } catch (ClassNotFoundException ex) { Logger.getLogger(SvCadastraEleitor.class.getName()).log(Level.SEVERE, null, ex); } catch (Exception ex) { Logger.getLogger(SvCadastraEleitor.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:hd.controller.AddImageToIdeaBookServlet.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w ww.j a v a 2 s . c o m*/ * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); try { boolean isMultipart = ServletFileUpload.isMultipartContent(request); if (!isMultipart) { //to do } else { FileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); List items = null; try { items = upload.parseRequest(request); } catch (FileUploadException e) { e.printStackTrace(); } Iterator iter = items.iterator(); Hashtable params = new Hashtable(); String fileName = null; while (iter.hasNext()) { FileItem item = (FileItem) iter.next(); if (item.isFormField()) { params.put(item.getFieldName(), item.getString("UTF-8")); } else if (!item.isFormField()) { try { long time = System.currentTimeMillis(); String itemName = item.getName(); fileName = time + itemName.substring(itemName.lastIndexOf("\\") + 1); String RealPath = getServletContext().getRealPath("/") + "images\\" + fileName; File savedFile = new File(RealPath); item.write(savedFile); String localPath = "D:\\Project\\TestHouseDecor-Merge\\web\\images\\" + fileName; // savedFile = new File(localPath); // item.write(savedFile); } catch (Exception e) { e.printStackTrace(); } } } String ideaBookIdTemp = (String) params.get("txtIdeabookId"); int ideaBookId = Integer.parseInt(ideaBookIdTemp); IdeaBookDAO ideabookDao = new IdeaBookDAO(); String tilte = (String) params.get("newGalleryName"); String description = (String) params.get("GalleryDescription"); String url = "images/" + fileName; IdeaBookPhotoDAO photoDAO = new IdeaBookPhotoDAO(); IdeaBookPhoto ideaBookPhoto = photoDAO.insertIdeaBookPhoto(tilte, description, url, ideaBookId); HDSystem system = new HDSystem(); system.setNotificationIdeaBook(request); response.sendRedirect("MyIdeaBookDetailServlet?txtIdeabookId=" + ideaBookId); } } catch (Exception e) { e.printStackTrace(); } finally { out.close(); } }
From source file:com.globalsight.everest.webapp.pagehandler.administration.config.xmldtd.FileUploader.java
public File upload(HttpServletRequest request) throws Exception { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setSizeThreshold(1024000);/* w w w. j a va2s . co m*/ ServletFileUpload upload = new ServletFileUpload(factory); List<FileItem> fileItems = upload.parseRequest(request); outFile = saveTmpFile(fileItems); return outFile; }
From source file:com.sishistorico.sv.SvEditarEleitor.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.// w w w . ja v a 2s . c om * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF8"); response.setContentType("text/html;charset=UTF-8"); List<FileItem> items = null; byte[] foto = null; long vazio = 0; try { items = new ServletFileUpload(new DiskFileItemFactory()).parseRequest(request); for (FileItem item : items) { if (!item.isFormField()) { vazio = item.getSize(); System.out.println("tamanho/:::::::::::::::::::: " + vazio); InputStream imageInput = item.getInputStream(); Image image = ImageIO.read(imageInput); BufferedImage thumb = Imagem.redimensionar(image, 400, 500); ByteArrayOutputStream baos = new ByteArrayOutputStream(); ImageIO.write(thumb, "JPG", baos); baos.flush(); foto = baos.toByteArray(); baos.close(); } } //dados do formulrio e metodos para salvar DateFormat formatter; Date date; formatter = new SimpleDateFormat("dd/MM/yyyy"); date = (Date) formatter.parse(items.get(1).getString()); // fim do tratamento Eleitor el = new Eleitor(); Endereco end = new Endereco(); el.setId(Integer.parseInt(items.get(19).getString("UTF-8").trim())); el.setNome(items.get(0).getString("UTF-8").trim()); el.setData_nascimento(date); el.setCpf(items.get(2).getString("UTF-8").replaceAll("\\.|\\-|\\ ", "").trim()); el.setRg(items.get(3).getString("UTF-8").replaceAll("\\.|\\-|\\ ", "").trim()); el.setSus(items.get(4).getString("UTF-8").replaceAll("\\.|\\-|\\ ", "").trim()); el.setEmail(items.get(5).getString("UTF-8")); el.setTelefone(items.get(6).getString("UTF-8").replaceAll("\\(|\\)|\\-|\\ ", "").trim()); el.setWhats(items.get(7).getString("UTF-8").replaceAll("\\(|\\)|\\-|\\ ", "").trim()); el.setObs(items.get(8).getString("UTF-8").trim()); el.setReferencia_pessoal(items.get(9).getString("UTF-8").trim()); end.setRua(items.get(11).getString("UTF-8").trim()); end.setBairro(items.get(12).getString("UTF-8").trim()); end.setN(items.get(13).getString("UTF-8").trim()); end.setCidade(items.get(14).getString("UTF-8").trim()); end.setCep(items.get(15).getString("UTF-8").trim()); end.setLocalidade(Integer.parseInt(items.get(16).getString("UTF-8").trim())); el.setTipo(Integer.parseInt(items.get(17).getString("UTF-8").trim())); el.setPertence(Integer.parseInt(items.get(18).getString("UTF-8").trim())); el.setEnd(end); DaoEleitor daoEleitor = new DaoEleitor(); DaoFoto daoFoto = new DaoFoto(); int idretorno = daoEleitor.Eleitor_Editar(el); if (vazio > 1) { daoFoto.atualizarImagem(foto, idretorno); } response.sendRedirect("editar_eleitor.jsp?id=" + el.getId() + "&msgok=Editado com sucesso!"); } catch (FileUploadException ex) { Logger.getLogger(SvEditarEleitor.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(SvEditarEleitor.class.getName()).log(Level.SEVERE, null, ex); } catch (ClassNotFoundException ex) { Logger.getLogger(SvEditarEleitor.class.getName()).log(Level.SEVERE, null, ex); } catch (Exception ex) { Logger.getLogger(SvEditarEleitor.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:com.eufar.asmm.server.UploadImage.java
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("UploadImage - the function started"); DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setSizeThreshold(MAX_MEMORY_SIZE); String uploadFolder = getServletContext().getRealPath("") + DATA_DIRECTORY; ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(MAX_REQUEST_SIZE); double maxSize = (MAX_REQUEST_SIZE / 1024) / 1024; System.out.println("UploadImage - max image size: " + maxSize + " Mbytes"); try {// w w w .ja v a 2 s . com @SuppressWarnings("rawtypes") List items = upload.parseRequest(request); @SuppressWarnings("rawtypes") Iterator iter = items.iterator(); while (iter.hasNext()) { Object obj = iter.next(); org.apache.commons.fileupload.FileItem item = (org.apache.commons.fileupload.FileItem) obj; String fileExt = FilenameUtils.getExtension(item.getName()); if (fileExt.matches("(jpg|jpeg|bmp|png|JPG|JPEG|BMP|PNG)")) { System.out.println("UploadImage - image accepted"); if (!item.isFormField()) { File uploadedFile = File.createTempFile("tmp_", "." + fileExt, new File(uploadFolder)); item.write(uploadedFile); double fileSize = item.getSize(); fileSize = (fileSize / 1024) / 1024; response.setCharacterEncoding("UTF-8"); response.setContentType("text/html"); response.getWriter().write(uploadedFile.getName()); System.out.println("UploadImage - " + uploadedFile.getPath() + ": upload ok..."); System.out.println("UploadImage - " + uploadedFile.getPath() + ": " + fileSize + " MBytes"); if (new File(uploadedFile.getPath()).isFile()) { System.out.println("PrintFunction - picture (webapps): the file exists."); } else { System.out.println("PrintFunction - picture (webapps): the file doesn't exist."); } if (new File(uploadedFile.getPath()).isFile()) { System.out.println("PrintFunction - picture (webapps): the file can be read."); } else { System.out.println("PrintFunction - picture (webapps): the file can't be read."); } } else { System.out.println("UploadImage - a problem occured with the file format"); } } else { System.out.println("UploadImage - image rejected: wrong format"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html"); response.getWriter().write("format"); } } } catch (Exception ex) { System.out.println("UploadImage - a problem occured: " + ex); response.getWriter().write("ERROR:" + ex.getMessage()); } }
From source file:com.ts.control.UploadFile.java
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String campo1 = ""; String campo2 = ""; String campo3 = ""; String campo4 = ""; String campo5 = ""; String campo6 = ""; String campo7 = ""; int c = 1;//from w w w. ja v a2 s. c om try { boolean ismultipart = ServletFileUpload.isMultipartContent(request); if (!ismultipart) { } else { FileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); List items = null; try { items = upload.parseRequest(request); } catch (Exception e) { } Iterator itr = items.iterator(); while (itr.hasNext()) { FileItem item = (FileItem) itr.next(); if (item.isFormField()) { } else { String itemname = item.getName(); if ((itemname == null || itemname.equals(""))) { continue; } String filename = FilenameUtils.getName(itemname); System.out.println("ruta---------------" + saveFile + filename); File f = checkExist(filename); item.write(f); //////// List cellDataList = new ArrayList(); try { FileInputStream fileInputStream = new FileInputStream(f); XSSFWorkbook workBook = new XSSFWorkbook(fileInputStream); XSSFSheet hssfSheet = workBook.getSheetAt(0); Iterator rowIterator = hssfSheet.rowIterator(); while (rowIterator.hasNext()) { XSSFRow hssfRow = (XSSFRow) rowIterator.next(); Iterator iterator = hssfRow.cellIterator(); List cellTempList = new ArrayList(); while (iterator.hasNext()) { XSSFCell hssfCell = (XSSFCell) iterator.next(); cellTempList.add(hssfCell); } cellDataList.add(cellTempList); } } catch (Exception e) { e.printStackTrace(); } out.println("<table border='3' class='table table-bordered table-striped table-hover'>"); for (int i = 1; i < cellDataList.size(); i++) { List cellTempList = (List) cellDataList.get(i); out.println("<tr>"); for (int j = 0; j < cellTempList.size(); j++) { XSSFCell hssfCell = (XSSFCell) cellTempList.get(j); String dato = hssfCell.toString(); out.print("<td>" + dato + "</td>"); switch (c) { case 1: campo1 = dato; c++; break; case 2: campo2 = dato; c++; break; case 3: campo3 = dato; c++; break; case 4: campo4 = dato; c++; break; case 5: campo5 = dato; c++; break; case 6: campo6 = dato; c++; break; case 7: campo7 = dato; c = 1; break; } } //model.Consulta.addRegistros(campo1,campo2,campo3,campo4,campo5,campo6,campo7); } out.println("</table><br>"); ///////// } } } } catch (Exception e) { } finally { out.close(); } }