How to upload an image and save it in database? [duplicate]

by

For the file upload part, you need to set enctype="multipart/form-data" on the HTML form so that the webbrowser will send the file content and you’d like to use request.getPart() in servlet’s doPost() method to get the file as an InputStream. For a concrete code example, see also How to upload files to server using JSP/Servlet?

Then, to save this InputStream in the DB, just use PreparedStatement#setBinaryStream() on a BLOB/varbinary/bytea column or whatever column represents “binary data” in your favorite DB engine. 

preparedStatement = connection.prepareStatement("INSERT INTO user (name, email, logo) VALUES (?, ?, ?)");
preparedStatement.setString(1, name);
preparedStatement.setString(2, email);
preparedStatement.setBinaryStream(3, logo);
// ...

You don’t necessarily need to convert this InputStream to byte[], it would not have been memory efficient either. Imagine that 100 user simultaneously upload images of 10MB, then 1GB of server memory would have been allocated at that point.

More Related Contents:

  1. Dynamic Drop down values based on another dropdown [closed]
  2. How can I upload files to a server using JSP/Servlet?
  3. Simple calculator with JSP/Servlet and Ajax
  4. calling a java servlet from javascript [duplicate]
  5. How to check a uploaded file whether it is an image or other file?
  6. sending variable from one jsp to another jsp
  7. Java Http Client to upload file over POST
  8. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  9. How to read and copy the HTTP servlet response output stream content for logging
  10. How to specify the default error page in web.xml?
  11. Servlet for serving static content
  12. Can I exclude some concrete urls from inside ?
  13. Spring JSON request getting 406 (not Acceptable)
  14. How to access static resources when mapping a global front controller servlet on /*
  15. Java equivalent to JavaScript’s encodeURIComponent that produces identical output?
  16. How do I correctly decode unicode parameters passed to a servlet
  17. java.lang.NoSuchMethodError: javax.servlet.ServletContext.getContextPath()Ljava/lang/String;
  18. Ways to save enums in database
  19. How are Servlet url mappings in web.xml used?
  20. Javascript parser for Java [closed]
  21. How to send an email from jsp/servlet?
  22. Display Pdf in browser using java servlet
  23. How to deploy a JAX-RS application?
  24. The ultimate Java version table (J2EE, Java EE, Servlet, JSP, JSTL)
  25. Spring MVC – AngularJS – File Upload – org.apache.commons.fileupload.FileUploadException
  26. Save child objects automatically using JPA Hibernate
  27. Can I serve JSPs from inside a JAR in lib, or is there a workaround?
  28. Reliable data serving
  29. How to set session timeout dynamically in Java web applications?
  30. How to listen for Firebase setValue completion

Leave a Comment