How to insert and retrieve image database using jsp/Servlet?

Question

I have got a Form Page index.jsp :

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
<style>
fieldset
{
      width: 70px;
}
</style>
</head>
<body>
<form action="Upload" method="post" enctype="multipart/form-data">
<fieldset>
<table>
<tr>
<td>Name</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>Select Photo</td>
<td><input type="file" name="photo"></td>
</tr>
<td><input type="submit" value="Upload"></td>
</tr>
</table>
</fieldset>
</form>
</body>
</html>

MyServlet Page Upload.java:

import java.sql.*;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.DriverManager;
import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;

@WebServlet(name = "Upload", urlPatterns = {"/Upload"})
@MultipartConfig(maxFileSize = 169999999)   // upload file's size up to 16MB
public class Upload extends HttpServlet 
{ 
private static final long serialVersionUID = 1L;
PrintWriter out;
InputStream inputStream = null; 
int allField = 0;
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse      response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try 
{
out = response.getWriter();
String name=request.getParameter("name");
Part filePart = request.getPart("photo");
if (filePart != null) 
{
System.out.println(filePart.getName());
System.out.println(filePart.getSize());
System.out.println(filePart.getContentType());
inputStream = filePart.getInputStream();
}
Class.forName("com.mysql.jdbc.Driver");  
Connection    con=DriverManager.getConnection("jdbc:mysql://localhost:3306/db","root","root") 
PreparedStatement ps = con.prepareStatement("insert into    PhotoDetails(Name,Images)values(?,?)");
ps.setString(1,name);
ps.setBlob(2,inputStream);
ps.executeUpdate();
out.println("Image Inserted");
}
catch(Exception e)
{
out.println(e);
}   
}
}

I am using mysql database and here is my table:

create table PhotoDetails
(
Name varchar(100),
Images blob
)

After filling all the form and when I click on the Update button then I get this error :

HTTP Status 500 - Servlet execution threw an exception

How could I resolve this problem?

500 is an internal Server error.So you have to look into the Server logfile to find out what is happend — Jens, Aug 30 '16 at 13:42
Not sure what is your problem. you can check this link :http://stackoverflow.com/questions/2340406/how-to-retrieve-and-display-images-from-a-database-in-a-jsp-page — soorapadman, Aug 30 '16 at 13:47
sir , is there any mistake in my code while inserting image into database? or you have any solution for the same? — Dharmesh Mourya, Aug 31 '16 at 05:01

Ravi Thapa · Answer 1 · 2016-09-02T08:56:28.290

This is the best way to show image in jsp file.

Just create showLogo.jsp and include where ever you want it.

<%@ page trimDirectiveWhitespaces="true" %>
<%@ page import="java.sql.*,java.io.*,org.apache.struts2.ServletActionContext"%>
<%@ page language="java" import="java.util.*, com.abc.util.dbutil.*,javax.servlet.http.HttpServletRequest" %>
<%

try{
    InputStream sImage;
    ResultSet resultSet = null;
    PreparedStatement pstmt = null;

    DBConnection dbConnection= null;
    dbConnection= new DBConnection();
    Connection con = null;
    con= dbConnection.getConnection();

    ServletInputStream sInIm = null;

      Statement st=con.createStatement();
      String company_id = request.getParameter("company_id");    

      resultSet=st.executeQuery("select logo from company where company_id='" + company_id + "'");

      if(resultSet.next()){
      byte[] bytearray = new byte[1048576];
      int size=0;
      sImage = resultSet.getBinaryStream(1);    
      response.reset();
      response.setContentType("image/jpeg");
      while((size=sImage.read(bytearray))!= -1){
        response.getOutputStream().write(bytearray,0,size);
      }
      response.getOutputStream().flush();
      response.getOutputStream().close();
}
 con.close();
}     
catch(Exception ex){

}
%>

I am getting it like this.

/company/showLogo.jsp?company_id=" id="blah_s" class="logo-small">

Get image from file to FileInputStream

FileInputStream fs = null;
        try {
            fs = new FileInputStream(getUserImage());
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }


.................


ps.setBinaryStream(8, fs, fs.available());

insert into table(logo) values (?)

This is for mysql with blob column.

Ravi Thapa Sir can i also know Insertion process of image i mean "Code for insert image into database" and also show your Table. — Dharmesh Mourya, Sep 01 '16 at 16:17

How to insert and retrieve image database using jsp/Servlet?

1 Answers1