Displaying images dynamically from database

Hey guys do you know whether is there any samples of displaying 100 images dynamically from database(Sql query browser) on the jsp path.
My data type for image is called 'varchar'.

In here I had declare a folder in my web content called images and there is a sub folder called Beanie with all the image im it like 1120.jpg..... and in my database i enter the record for image is called 1120.jpg. So that the string can be get

Thanks

Loh,
Welcome to JavaRanch!

It's good practice to keep the JDBC code out of the JSP. So you would write the JDBC code to get a list of image names and stick them in a request attribute. Then the JSP would loop through that attribute list and display them.

Are you having trouble with a specific part of the code you posted?

Icic. Thanks for welcoming me

Oh ya but i did put the jdbc above the jsp as for the looping is it it indicate at the jsp paga or?

My code is for the project page i am doing is:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h1>PRODUCTS DETAILS</h1>
<p>
<%
				//Retrieve the id of the product selected by the user
				//the product id is sent via the URL as a parameter
				int ProductId = -1;
				String strProductId = request.getParameter("ProductId");
				if(strProductId != null) {
					//Convert from string to int
					ProductId = Integer.parseInt(strProductId);
				}
				
				//Load the database driver
		       	Class.forName("com.mysql.jdbc.Driver");
				//Create a connection to our database
		       	Connection con = DriverManager.getConnection("jdbc:mysql://localhost/peisze", "root", "");
				//create an SQL statement
		       	PreparedStatement ps = con.prepareStatement("SELECT * FROM products WHERE ProductId=?");
				//set the ID to be the id above
		       	ps.setInt(1, ProductId);
				//Execute and retrieve our result
		       	ResultSet rs = ps.executeQuery();
			%>
</p>
<%
        	//if there is a result, rs.next() will be true
        	//else it will be false
			if(rs.next()) {
		%>
<fieldset>
<legend>Product Information</legend>
<table border="0">
	<tr>
		<td>
		<div style=""><img border="1"
			src="images/Beanie/<%=rs.getString("Image") %>" height="160" width="160" /></div>
		</td>
		<td>Product Name: <%=rs.getString("ProdName")+"\t" %>

<div align="left">Product Color: <%=rs.getString("ProdColor")+"\t" %></div>

<div align="left">Product Description: <%=rs.getString("ProdDesc")+"\t" %></div>

<div align="left">Product Price: <%=String.format("$%.2f",rs.getDouble("UnitPrice"))+"\t" %></div>

<div align="left">Quantity: <%=rs.getString("Quantity")+"\t" %></div>

</td>
	</tr>
</table>
</fieldset>

<%
			}
			else {
				//if no record is found, simply display a no record message
		%>
No record found.
<%
			}
		 %>
<p> </p>

</body>
</html>

Thanks

Hope to receive your reply soon!

hi loh,
what you can do is just put a while loop inside your for loop and iterate over the result set.
your code slightly modified ADDED while loop
eg.

<%
if(rs.next()) {  
rs.beforeFirst();  // for making sure you dont miss the first record.
while(rs.next())
{                        // opening while loop brackets.

%>  
 <fieldset>  
 <legend>Product Information</legend>  
 <table border="0">  
     <tr>  
         <td>  
         <div style=""><img border="1"  
             Image") %>" height="160" width="160" /></div>  
         </td>  
         <td>Product Name: <%=rs.getString("ProdName")+"\t" %>  
   
         <div align="left">Product Color: <%=rs.getString("ProdColor")+"\t" %></div>  
   
         <div align="left">Product Description: <%=rs.getString("ProdDesc")+"\t" %></div>  
   
         <div align="left">Product Price: <%=String.format("$%.2f",rs.getDouble("UnitPrice"))+"\t" %></div>  
   
         <div align="left">Quantity: <%=rs.getString("Quantity")+"\t" %></div>  
           
           
   
         </td>  
     </tr>  
 </table>  
 </fieldset>  
   
 <%  
                } //closing while loop bracket
             }  
             else {  
                 //if no record is found, simply display a no record message  
         %>  
 No record found.  
 <%  
             }  
          %>

Hey great thanks to you guys. I'll try it asap

Thanks

Hey is it we have to add something like <% around here cause it seems to be in error.
Thanks

hey loh,
Oops sorry for the inconvience, actually i copied the code of yours and pasted i guess it did not paste properly you should write the img tag for that
e.g:

i guess this should solve the problem..
hope it works
bye

Hey hey I try the codes that you gave me but it ends up no record.

Hope to receive your reply soon

Hey sorry I have decided to stick to the String

Instead of blob. Sorry.

Oh ya I had made a mistake, i had change to a page whereby all the images is display out at one time. When I click on a certain picture it will hyperlink to the description of that certain product .Example: when click on the Yellow beanie it will go to the specific description of the product and when click on pink beanie if will go to the specific description of the pink beanie

However I could not hyperlink it.

What happen?

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    <%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h1>Products</h1>

<p>
          <%
        	//1. Retrieve all products from database
        	
        	//1a.  Load the Driver
        	Class.forName("com.mysql.jdbc.Driver");
    		//1b.  Get a connection to the database
        	Connection con = DriverManager.getConnection("jdbc:mysql://localhost/peisze", "root", "");
			//1c. Construct our SQL statement
        	PreparedStatement ps = con.prepareStatement("SELECT Image FROM products");
			//1d.  Execute and retrieve our result
        	ResultSet rs = ps.executeQuery();
			
			//2. Base on the results returned, construct a table
        %>
        </p>
        <fieldset>
<legend>Product</legend>
        <table border="0"> 
         <%  
         
if(rs.next()) {     
rs.beforeFirst();  // for making sure you dont miss the first record.   
while(rs.next())   
{                        // opening while loop brackets.   
  
         %>     
    
   
 
 <td>
		<div style=""><img border="1"
			src="images/Beanie/<%=rs.getString("Image") %>" height="160" width="160" /></div>
			<a href="ProductDesc.jsp?Image=<%=rs.getString("Image")%>"></a>
		</td>
		
		
<%     
                } //closing while loop bracket   
             }     
             else {     
                 //if no record is found, simply display a no record message     
         %>     
 Nothing.     
 <%     
             }     
          %>  
          
           </table> 
           </fieldset>

</body>
</html>

Thanks

Hey guys do you have any example to display blob images store in database(my sql server) and dispaly it on jsp whereby they call the images from the servlets and display it on jsp four by four in a row?

And the image can also be display with its details like the prod color, prod name, prod price,etc.

My database is called : save_image

My attributes are:

id(int)
prodname(varchar)----name of image
prodcolor
prodImage(blob)

Thank you

There only needs to be one topic discussing this.