How can I resize an image from database table and show it

Hi, I am trying to select an image from the table and change it to a thumbnail. On clicking the thumbnail, the original sized image will appear.

How can I do that ? Here's my code.

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"  import="java.sql.*,java.io.*,java.awt.image.BufferedImage,java.awt.Graphics2D,javax.swing.*,java.awt.*"  %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>:: Show the uploaded photo from database  ::</title>

<%

/* Create string of connection url within specified format with machine 
name, port number and database name. Here machine name id localhost 
and database name is mahendra. */

String connectionURL = "jdbc:db2://localhost:50000/DB2_TEST";
/*declare a resultSet that works as a table resulted by execute a specified 
sql query. */
ResultSet rs = null;
Connection connection=null;
// Declare statement.
PreparedStatement psmnt = null;
// declare InputStream object to store binary stream of given image.
InputStream sImage;
try {
// Load JDBC driver "com.mysql.jdbc.Driver"
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
/* Create a connection by using getConnection() method that takes 
parameters of string type connection url, user name and password to 
connect to database. */
 connection = DriverManager.getConnection(connectionURL, "db2inst1", "9231827765");
/* prepareStatement() is used for create statement object that is 
used for sending sql statements to the specified database. */
psmnt = connection.prepareStatement("SELECT BINARYFILE FROM UPLOADS WHERE UPLOADID = ?");
psmnt.setString(1, request.getParameter("id")); // here integer number '11' is image id from the table
rs = psmnt.executeQuery();
if(rs.next()) {
byte[] bytearray = new byte[1024];
int size=0;
sImage = rs.getBinaryStream(1);
response.reset();
response.setContentType("image/jpeg");

//Container content = getContentPane();

while((size=sImage.read(bytearray))!= -1 )
		{

response.getOutputStream().write(bytearray,0,size);
	//BufferedImage thumbnail = new BufferedImage(50, 50, BufferedImage.TYPE_INT_ARGB);
	//Graphics2D g2d = thumbnail.createGraphics(); 
	
	
	
		}
	}
else
{
	out.println("<br> No photo to show ");
}

}
catch(Exception ex){
out.println("error :"+ex);
}
finally {
// close all the connections.
rs.close();
psmnt.close();
connection.close();
}

//out.println("<br><a href=\"http://localhost:8080/new_test/photoshow.jsp\">Go to previous page</a>");
%>

</ul>

<hr>
<form name="photoform" action="photoshow.jsp" method="GET" >
Give a UploadID : <input type="text" name="id" id="id"/>
<input type="submit" value="Show me the picture from Table"/>
</form>
<hr>

</body>

</html>

You can see, I have tried to use BufferedImage, but could not. Can you help me ?

Well, first of all you'll want to get that code out of a JSP and into a servlet where it belongs. By putting it in a JSP you are mixing the output of your Java code with the output of the JSP -- all that HTML code. That's guaranteed to produce garbage instead of an image.

Actually , I am getting the images properly.
Now, I am trying to convert it first to a thumbnail, and then on clicking the thumbnail it'll show the original image.

How can I do that ?

You use <img> tags to show images. The src of the tags reference servlets that serve the image data.

Bang on target dude. This part of code produces the image :

How can I put this within an <img src=""> ? Because , I have tried this , just to end up showing an error ....

But it is showing error , when I am giving the scriplet tag ...

In HTML do put the image data into the HTML page? Of course not. Why are you trying to do that with a JSP, which just creates an HTML page to send to the client?

The image data is useless in the JSP. The JSP will use the <img> tag, as I have already said, whose src attribute is the URL of a servlet that supplies the image response.

Ok. So, are you trying to say to do something like this :

Create a jsp page. In that page, create an <img> tag, something like this:

And in the servlet :

Are you sure , this is gonna work ? Because , the image will not be scaled down , right ?

If the image needs processing, it can be done in the servlet.

Bear Bibeault said,

If the image needs processing, it can be done in the servlet.

How can I process an image that I get from database ?

I am new to all these , please guide me.

There is nothing in the JSP or servlet realm for this. Look into JAI or other Java APIs for image manipulation.