<table>
    <%
        Connection con = DBConnect.getConnection();

        String strSQL = "select id from tb_photo";
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery(strSQL);
         while  (rs.next()) {
    %>
    <tr>
        <td><img src="/sell/photo/image.jsp?imgID=<%=rs.getInt(1)%>" width="115" border="0"/></td>
    </tr>
    <%
        }
        stmt.close();
        rs.close();
       
    %>

</table>

<% Connection conn = DBConnect.getConnection();
    String query = "select ph_photo from tb_photo where ph_id="+request.getParameter("imgID");
    Statement st = conn.createStatement();
    ResultSet rs = st.executeQuery(query);
    rs.next();
     byte [] bytearray =  new   byte [ 4096 ];
     int  size =  0 ;
    InputStream sImage;
    sImage = rs.getBinaryStream( 1 );
    response.reset();
    response.setContentType("image/jpeg");
    response.addHeader("Content-Disposition", "filename=getimage.jpeg");
     while  ((size = sImage.read(bytearray)) != - 1 ) {
        response.getOutputStream().write(bytearray,  0 , size);
    }
    response.flushBuffer();
    sImage.close();
    rs.close();
    conn.close();
%>