I have no idea how to start displaying a picture in a JSP page from the database.
I started off with these codes..

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

public class ImageServlet extends HttpServlet {

    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        try {

            String filename = request.getParameter("filename");
            filename = "baby.gif";
            //execute you sql to get the clob here
            String url = "jdbc:mysql://localhost/test";
            String userID="root";
            String PWD="";
            Connection c = null;
            String classPath= "com.mysql.jdbc.Driver";

            try{
                Class.forName(classPath).newInstance();
                conn = DriverManager.getConnection(url,userID,PWD);
            }catch(Exception exc){
                out.println(exc.toString());
            }
            Statement s = null;
            ResultSet rst = null;

            // Connection c = ...
            Statement s = c.createStatement();
            String strSQL = "SELECT binaryfile FROM uploads WHERE filename='" +filename +"'";
            rst = stm.executeQuery(strSQL);
            byte [] barray = rst.getBytes("binaryfile");
            rst.close();
            s.close();
            response.setContentType("image/gif");
            response.getOutputStream().write(barray);

        } catch (Exception sqle) {

        }

    }

}



in my JSp page, i used this
<embed src="http://localhost:8080/servlet/ImageServlet" content="image/gif">

However, no picture was displayed...
What went wrong? Please advise me. Thanks to all.

There is mistakes in :
/********************* mistake **********************/
Connection c = null;

conn = DriverManager.getConnection(url,userID,PWD);//conn mistake

Statement s = c.createStatement();

rst = stm.executeQuery(strSQL);//stm mistake
/********************* mistake **********************/

would be:
Connection c = null;
c = DriverManager.getConnection(url,userID,PWD);
Statement s = c.createStatement();
rst = s.executeQuery(strSQL);

Cash has already pointed out that your source contains several typos so I'm won't comment on them. Have a look at this URL, which has examples of what you are trying to do: http://jguru.com/faq/view.jsp?EID=159

Cheers

Martyn

Hi, i am facing problems so hope you guys can help me out! I did try out many different solutions. What i want is to retrieve the BLOB image in mysql and display it in jsp.

I tried out the code. But there is no image displayed out. I have no idea what went wrong.
I embed the servlet in one of the tags so i am not sure if i am right. If not, please guide me. Thanks.

---comments.jsp---

table border="1" borderColor="#ffe9bf" cellPadding="0" cellSpacing="0" width="428" height="63">
<tbody>
<td bgColor="#008080" width="28" align="center" height="19"><b>No.</b></td>
<td bgColor="#008080" width="126" align="center" height="19"><b>Name</b></td>
<td bgColor="#008080" width="224" align="center" height="19"><b>Picture</b></td>
<td bgColor="#008080" width="270" align="center" height="19"><b>Comments</b></td>



<%

 String DRIVER = "com.mysql.jdbc.Driver";
 Class.forName(DRIVER).newInstance();

 Connection conn = null;
 Statement stmt = null;


 try{

    String dbUrl = "jdbc:mysql://localhost/homepage?user=root&password=mysql";

  int i=1;
  conn = DriverManager.getConnection(dbUrl);
  stmt = conn.createStatement();
  String query = "Select * FROM Comments";
  ResultSet rst = stmt.executeQuery(query);
  while(rst.next()){

  if(i==(i/2)*2){
  %>

  <tr>
  <td width="28" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><%=i%></td>
  <td width="126" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><%=rst.getString(3)%></td>
 <td width="224" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"> <embed src="http://localhost:8080/servlet/ImageServlet" content="image/jpeg"></embed></td></td>
  <td width="270" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><%=rst.getString(4)%></td>
  </tr>

  <%
  }else{
  %>
  <tr>
  <td width="28" height="19" align="center" vAlign="top" bgColor="#ffcc68" class="title"><%=i%></td>
  <td width="126" height="19" align="center" vAlign="top" bgColor="#ffcc68" class="title"><%=rst.getString(3)%></td>
   <td width="224" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><embed src="http://localhost:8080/servlet/ImageServlet" content="image/jpeg"></embed> </td>
  <td width="270" height="19" align="center" vAlign="top" bgColor="#ffcc68" class="title"><%=rst.getString(4)%></td>

  </tr>
  <% }

  i++;
  }
  rst.close();
  stmt.close();
  conn.close();
  }catch(Exception e){
  System.out.println(e.getMessage());
  }
  %>
  </tbody>
  </table>


<---ImageServlet.java-->

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

public class ImageServlet extends HttpServlet {

    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        try {

            String filename = request.getParameter("name");
            //filename = "baby.gif";
            //execute you sql to get the clob here
            String url = "jdbc:mysql://localhost/homepage";
            String userID="root";
            String PWD="mysql";
            Connection conn = null;
            String classPath= "com.mysql.jdbc.Driver";

            try{
                Class.forName(classPath).newInstance();
                conn = DriverManager.getConnection(url,userID,PWD);
            }catch(Exception exc){
                out.println(exc.toString());
            }
            Statement stmt = null;
            ResultSet rst = null;

            // Connection c = ...
              stmt = conn.createStatement();
            //String strSQL = "SELECT Picture FROM comments WHERE name='" +filename +"'";
            String strSQL = "SELECT Picture1 FROM comments WHERE name='" +filename+"'";
            rst = stmt.executeQuery(strSQL);

            byte [] barray = rst.getBytes("binaryfile");
            rst.close();
            stmt.close();
            response.setContentType("image/jpeg");
            response.getOutputStream().write(barray);

        } catch (Exception sqle) {

        }

    }

}

You can just use simple <img> tag and src of this tag should be the servlet you've written. And set the content type in the servlet itself. That would be very simple.

- Rakesh

Try also by calling the flush() method on the output stream.


- Rakesh

Hi
this forum has been of much help
I was facing a similar problem
Regards and thanx to all



---------------------------

Also visit my site for
Software testing software testing tutorial software testing interview questions
________________________________________
Softwareqatestings.com TelecomFYI.com