Retrieve and display an image from and to the database

<%@page contentType="text/html"%>

<%@page pageEncoding="UTF-8"%>

<%@ page language="java" %>

<%@ page import="java.awt.image.*"%>

<%@ page import="java.io.*"%>

<%@ page import="java.sql.*"%>

<%@ page import="javax.servlet.*"%>

<%@ page import="javax.servlet.http.*"%>

<%@ page import="java.io.File"%>

<%@ page import="javax.imageio.ImageIO"%>

<%@ page import="java.awt.image.BufferedImage,java.util.*"%>

<%@ page import="java.awt.*"%>







<%

try

{

javax.servlet.http.HttpServletResponse res=null;;

int returnValue = 0;

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

InputStream in = null;

OutputStream os = null;

Blob blob = null;

String text;

text=request.getParameter("text");

Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb","root","password");

final String query = "SELECT image FROM tablename";

conn.setAutoCommit(false);

stmt = conn.createStatement();

rs = stmt.executeQuery(query);

int i=1;

if(rs.next())

{

String len1 = rs.getString("image");

int len = len1.length();

byte [] b = new byte[len];

in = rs.getBinaryStream("image");

int index = in.read(b, 0, len);

OutputStream outImej = new FileOutputStream("C:/Documents and Settings/Desktop/photo/img"+i+".JPG");

while (index != -1)

{

outImej.write(b, 0, index);

index = in.read(b, 0, len);

System.out.println(index);

System.out.println(outImej);

}

outImej.close();

i++;

}

else

{

returnValue = 1;

}

}

catch(Exception e)

{

out.println(e);

}

%>