Please help me !!
Its really urgent....
I have to display diffrent images from the database mysql having same imageid say imgid=1 in a jsp page.Please tell me the proper code for it.


<%@ page import="java.sql.*" %>
<%@ page import= "java.io.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:3306/modelval?user=modval;password=modval";
Connection connection = null;
Statement statement = null;
%>

<%
int Id=request.Parameter("id");
Class.forName("com.mysql.jdbc.Driver").newInstance ();
connection = DriverManager.getConnection(connectionURL, "modval", "modval");
statement = connection.createStatement();
ResultSet rs = statement.executeQuery( "SELECT Photo FROM tab_photos where CountryID= " + Id + " ");

rs.next();
byte [] barray = rs.getBytes("Photo");
rs.close();
statement.close();
response.setContentType("image/gif");
response.getOutputStream().write(barray);
rs.close();
%>

this display only one image .But i have to retrieve three diffrent images in html td tags by applying a while loop.... how can it be possible... please get the code for me....

consultant

HI,

<table>
<tr>
response.setContentType("image/gif");
while(rs.next())
{
byte [] barray = rs.getBytes("Photo");
%>
<td><%response.getOutputStream().write(barray); %></td>
<%
}
rs.close();
statement.close();
%>
</tr>
</table>

i dont tested,
try something like this,

Cheers,

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

Thanx Jomet,It was very nice to talk to you...

The problem has been sought....Actuallly I had to display the images dynamically ...so I passed the parameter like CountryId.Something like this....MyPhoto.jsp?CountryId=<%=rs.getString("CountryId") %> where Country Id is the id which has different images in the database table name tab_photos.


the Code is something like this...

<%@ page import="java.sql.*" %>
<%@ page import= "java.io.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:3306/modelval?user=modval;password=modval";
Connection connection = null;
Statement statement = null;
%>
<%
String Id=request.getParameter("CountryId");
Class.forName("com.mysql.jdbc.Driver").newInstance ();
connection = DriverManager.getConnection(connectionURL, "modval", "modval");
statement = connection.createStatement();
ResultSet rs = statement.executeQuery( "SELECT * FROM tab_photos where CountryId= '" + Id + "' ");
rs.next();
byte [] barray = rs.getBytes("Photo");
rs.close();
statement.close();
response.setContentType("image/jpeg");
response.getOutputStream().write(barray);
%>

i had writen tis code in MyPhoto.jsp and call this code from ---.jsp page through the given parameter MyPhoto.jsp?CountryId=<%=rs.getString("CountryId") %>


consultant

HI!
 I am getting some problem...Can anyone please tell what's the code to convert tinyblobs to images in jsp...as tinyblobs is the dataype of image field of table tab_name in Mysql.

when I give the datatype as blob and write the code

rs.next();
byte [] barray = rs.getBytes("Photo");
rs.close();
statement.close();
response.setContentType("image/jpeg");
response.getOutputStream().write(barray);

The image is being dispalyed but when i change it to tinyblob then no image is there..Is this the right code for tinyblobs....
I need your help.Thanx in advance...

Amit Srivastava