image displaying from database with some other information

hi, in the following section of code when i am not displaying the image it is working properly but when i tried to display the image nothing is displayed on browser only a cross mark is shows. same code runs if i am not retriveing any data from admin table my image table has two entries img blob and and id rest have admin table entries.

<%@ page import="java.io.*"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
</head>
<body>
    <form>
        <%@page import="java.sql.*" %>

        <%
        HttpSession ses=request.getSession(false);

         int admin_id=Integer.parseInt(ses.getAttribute("admin").toString());

            Connection con=null;
            PreparedStatement smt1 = null;
            ResultSet rs1 = null;           
try{

    Class.forName("com.mysql.jdbc.Driver");
               con=DriverManager.getConnection("jdbc:mysql://localhost:3306/online","root","root");
          // smt=con.prepareStatement("select aname,aemail from admin where admin_id=?");
               // smt.setInt(1,admin_id);
                //rs=smt.executeQuery();
byte[ ] imgData = null ;

Blob image = null;

  smt1=con.prepareStatement("select img,aname,aemail from image inner join admin on image.id=admin.admin_id where admin.admin_id=?");

  smt1.setInt(1,admin_id);

                rs1=smt1.executeQuery();
               if(rs1!=null && rs1.next())
                {
image = rs1.getBlob(1);

imgData = image.getBytes(1,(int)image.length());

       %>
 <table width="628" height="573" border="0">
    <tr>
      <th width="591" scope="col"><table width="324" border="0">
        <tr>
          <th width="168" scope="col"><font color="white">Name</font></th>
          <th width="146" scope="col">
              <input type="hidden" name="hiddenField"><font color="red"><%=(rs1.getString("aname"))%>
       </font>
        </tr>
        <tr>
          <th scope="row"><font color="white">Admin ID </th>
          <th scope="row"></font>
               <input type="hidden" name="hiddenField"><font color="red"><%=admin_id%>
</font>
</th>
        </tr>
        <tr>
          <th scope="row"><font color="white">Email ID</th>
          <th scope="row"></font>
          <input type="hidden" name="hiddenField"><font color="red"><%=(rs1.getString("aemail"))%>
</font>
          </th>
        </tr>
        <table width="500" border="0">

<td colspan="5" style="background-color:#FFA500;">
<img src="">
<%response.setContentType("image/gif");

OutputStream o = response.getOutputStream();

o.write(imgData);

o.flush();

o.close();
 %>
</td>

        </table>
      </table>
        <p>
</div>
<%
    }
            }
            catch(ClassNotFoundException e)
            {
                out.println("class not found"+e.getMessage());
            }
            catch(SQLException e)
            {
                out.println("sql excep"+e.getMessage());
            }
            finally
            {
                try{
                    if(con!=null)
                        con.close();
                    }
                 catch(Exception e)
                    {
                    }
            }
%>
</form>
</body>
</html>

View Answers