retrieve image from database

Hi

I wants to retrieve image from database and the image wants to appear in browser. Please help me to solve my issue. But my code is worked in first time after that it is downloading as .jsp file whats problem please solve it.Its so urgent i am in edge please solve my issue.

DisplayImage.java

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DisplayImage extends  HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse  response) throws ServletException, IOException{
    String connectionURL = "jdbc:mysql://localhost:3306/jsp";
  java.sql.Connection con=null;
  try{  
  Class.forName("com.mysql.jdbc.Driver").newInstance();
  con=DriverManager.getConnection(connectionURL,"root","root");  
  Statement st1=con.createStatement();
  ResultSet rs1 = st1.executeQuery("select bImage from upload_image where iImageID='2'");
  String imgLen="";
  if(rs1.next()){
  imgLen = rs1.getString(1);
  System.out.println(imgLen.length());
  }  
  rs1 = st1.executeQuery("select bImage from upload_image where iImageID='2'");
  if(rs1.next()){
  int len = imgLen.length();
  byte [] rb = new byte[len];
  InputStream readImg = rs1.getBinaryStream(1);
  int index=readImg.read(rb, 0, len);  
  System.out.println("index"+index);
  st1.close();
  response.reset();
  response.setContentType("image/jpg");
  response.getOutputStream().write(rb,0,len);
  response.getOutputStream().flush();  
  }
  }
  catch (Exception e){
  e.printStackTrace();
  }
  }
}

But while iam running in first time its work fine but from second time its downloading pleasee help me my photo wants to appear in browser please solve my issue.

Thanks in advance.

You're going about it the wrong way, for a few reasons:

1) Don't use getString for a binary field to get its length. Binary data like an image is not a String.
2) Don't use InputStream's read(byte[]) or read(byte[], int, int) method without a loop. The method is never guaranteed to read exactly as many bytes as you want.

In your case, I would go for one of two ways. Both will do only one single query.
1) Use getBytes to get the entire content as a byte[], then write that to the response output stream.
2) Use only getInputStream, then read from the InputStream until the read method returns -1. Here is an example on how to do that.

Also, make sure you close the ResultSet in a finally block. If something goes wrong in your current code the ResultSet won't be closed.

Don't use empty exception blocks.
Don't create strings for each request.
Don't load the driver more than once.
I would start with that first.

Whenever we retrieve the image from the DB. It will be downloaded to the system. Then next time whenever
we sends the request for an image the browser will look whether there is any downloaded image and it will show the
image. So at the time of second request append some random value to the url. Then browser will try to fetch a new image.

you can refer Retrieve image from database using Servlet in Rose India for the code.

Thanks for reply,

Please can you provide some sample code to guide me. Please help me, its so urgent please , today i wants to finish my work , please no one is not there to help me, iam developing alone , please help me.

if this is the original url
http://server/myapp.php?id=10

just add
http://server/myapp.php?id=10&x='+(Math.random())

in this case every time some new random no will be added to the url and the browser
will take the request as the new one.

Where i wants to give this code, please saw my first post that is my code iam having.

http://www.roseindia.net/servlets/retreiveimage.shtml

Are you using the jsp/html for sending the request.. rt?
While "submitting" the url need to be appended.

I am using Jsp+ servlet, Iam getting Student Register number, in photo place student image wants to appear ,all the text details coming perfect except photo, i saw
http://www.roseindia.net/servlets/retreiveimage.shtml but the same code is getting download the jpg file as.jsp file please solve my issue.

P Arunkumar wrote: please solve my issue.

post the code

P Arunkumar wrote:its so urgent please

Please EaseUp. There is no such thing as "urgent" around here.

My code is in first post please go up and see, really in first time i saw the photo in my browser but it is not working for next time.. please solve my issue

P Arunkumar wrote:My code is in first post please go up and see

Please repost the code with proper indentation and UseCodeTags. Unindented code is too hard to read.

Also, what is happening on the second time? Is the servlet even running? ShowSomeEffort and find out as much as you can about how the two passes differ.

P Arunkumar wrote:but the same code is getting download the jpg file as.jsp file please solve my issue.

I'm sorry, I have no idea what this is supposed to mean. Could you explain it differently, perhaps with more detail?

I have stored some images in my database.in my database iam have id and image fields. id field varchar and image type as blob. now my task is i wants to retrieve the image from database. and the image wants to appear as output, because my project is to give student hall ticket iam right hand side image wants to appear.

Please answer the questions I posted in my reply.

You haven't said anything about the HTML which contains the link to this image servlet. Could you show that to us?

what i didn't get your point , what image servlet

P Arunkumar wrote:what i didn't get your point , what image servlet

The code you wrote is an image servlet. It's called that because it's a servlet which is designed to return an image as its response.

It seems to me that part of your problem is that you are having trouble with English. It doesn't make it any easier to ask questions about technical subjects which you are trying to learn, when you can't even find the words to ask the questions. Could I suggest that you find somebody who speaks English a bit better, and ask them to help you ask the questions?

iam having one more idea please tell me it will be possible or not. by using some condition i can open image from local system because iam going to give demo in mylap please if possible or not please me

I didn't design any page to return an image as its response.

To return an image as its response how i wants to create html page please iam beginner, if iam doing some mistake please guide me.