Advertisement
Kenjireita

Java servlet upload csv

May 3rd, 2018
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.79 KB | None | 0 0
  1. package doLoad;
  2.  
  3. import java.io.IOException;
  4. import java.io.BufferedReader;
  5. import java.io.InputStream;
  6. import java.io.InputStreamReader;
  7. import java.io.PrintWriter;
  8. import java.sql.Connection;
  9. import java.sql.DriverManager;
  10. import java.sql.Statement;
  11. import java.util.Iterator;
  12. import java.util.List;
  13. import java.util.Map;
  14. import java.util.Map.Entry;
  15. import javax.servlet.ServletException;
  16. import javax.servlet.annotation.WebServlet;
  17. import javax.servlet.http.HttpServlet;
  18. import javax.servlet.http.HttpServletRequest;
  19. import javax.servlet.http.HttpServletResponse;
  20.  
  21. import org.apache.commons.fileupload.FileItem;
  22. import org.apache.commons.fileupload.FileItemFactory;
  23. import org.apache.commons.fileupload.disk.DiskFileItemFactory;
  24. import org.apache.commons.fileupload.servlet.ServletFileUpload;
  25. import javax.servlet.Servlet;
  26.  
  27. @WebServlet("/uploadcsv")
  28. public class UploadCsv  extends HttpServlet implements Servlet {
  29.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  30.        
  31.          response.setContentType("text/html");  
  32.          PrintWriter out=response.getWriter();
  33.         try {
  34.  
  35.                  String category = "";
  36.                  InputStream csvfile = null;
  37.    
  38.                  FileItemFactory factory = new DiskFileItemFactory();
  39.    
  40.                  boolean isMultipart = ServletFileUpload.isMultipartContent(request);
  41.                  
  42.                  ServletFileUpload upload = new ServletFileUpload(factory);
  43.                  Map<String, List<FileItem>> file = upload.parseParameterMap(request);
  44.                  
  45.                  Iterator entries = file.entrySet().iterator();
  46.                  while (entries.hasNext()) {
  47.                       Entry thisEntry = (Entry) entries.next();
  48.                       List<FileItem> value = (List) thisEntry.getValue();
  49.                         for (FileItem uploadItem : value) {
  50.                             csvfile = uploadItem.getInputStream();
  51.                           }  // end of for loop
  52.                  }//while
  53.    
  54.                 InputStreamReader isr = new InputStreamReader(csvfile);
  55.                 BufferedReader reader = new BufferedReader(isr);
  56.                
  57.                 String text = "";
  58.                 reader.readLine();
  59.    
  60.                     // We read the file line by line and later will be displayed on the browser page.
  61.                 while ((text = reader.readLine()) != null) {
  62.                     String[] columns = text.split(",");
  63.                     System.out.println("count columns" + columns.length);
  64.                     String rowdata = "";
  65.                         for (String value : columns) {
  66.                             rowdata += "'" + value + "',";
  67.                         }
  68.                        rowdata = rowdata.substring(0, rowdata.length() - 1);
  69.                        String select = category;
  70.                          try {
  71.                                Class.forName("oracle.jdbc.driver.OracleDriver");
  72.                                Connection  con=DriverManager.getConnection("jdbc:oracle:thin:@//10.250.193.103:1521/optunai", "TUNAIREPORT", "TUNAIREPORT#2015");
  73.                                Statement stmt=con.createStatement();
  74.                                String query = "insert into csvfile(name,mail) values(" + rowdata + ")";
  75.                                stmt.executeUpdate(query);
  76.                                 out.println("Successfully uploaded");
  77.                               }//try
  78.                               catch (Exception e) {
  79.                                out.println("Error Try Again"+e.getMessage());
  80.                                } //catch
  81.                      }
  82.  
  83.            }// try
  84.           catch (Exception e) {
  85.               out.println("Error Try Again"+e.getMessage());
  86.         }
  87.     }
  88.  
  89.    
  90. }
  91.  
  92.  
  93. <form action="uploadcsv" enctype="multipart/form-data" method="post">
  94. <input name="file" type="file">
  95. <input type="submit" value="submit">
  96. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement