View the images as four per row instead of long row that is never ending

Hey guys you guys did great help for me in displaying images otherwise my page would only be a blank one. Great thanks to you guys

However the problem is I would like to display the images as four by four instead of never ending. Could you guys help me with it? Thanks

<%@ 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>Display Image overall</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/ps", "root", "");
			//1c. Construct our SQL statement
        	PreparedStatement ps = con.prepareStatement("SELECT * FROM products");
			//1d.  Execute and retrieve our result
        	ResultSet rs = ps.executeQuery();
			
			//2. Base on the results returned, construct a table
        %>
        </p>
        <fieldset height="145" width="145">
<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="3"
			src="images/Beanie/<%=rs.getString("Image") %>" height="145" width="145" /></div>
			
			
			<a href="ProductDesc.jsp?ProductId=<%=rs.getString("ProductId")%>"><%=rs.getString("ProdName")%></a>
		</td>
		
		
		 <%     
                } //closing while loop bracket   
             }     
             else {     
                 //if no record is found, simply display a no record message     
         %>     
 Nothing.     
 <%     
             }     
          %>  
          
           </table> 
           </fieldset>

</body>
</html>

Hope to receive you guys reply soon

While I shudder at the wanton use of scriptlets, seems like just keeping a counter and writing a break tag every four pictures would do the trick.

Hey do you mind explaining more cause I dont seem to understand it.
Thanks

I'm not sure which part you don't understand--keep a counter, increment it for every row, when it's a multiple of four output a break tag.

As a good coding practice, try to minimize the use of scriptlets inside JSPs and definitely stay away from JDBC stuff inside Java Server Pages. All this code should be inside a Servlet or better yet a Java Bean.
To your question,
try using JSTL to iterate over your collection, see the example below

Notice the use of varStatus. This would be your actual counter that will be incremented by one(default) on each iteration. If you need 4 records per row you would need to
check for the remainder of the counter by 4 (status.count % 4 == 0). If that's the case, end the row </tr> and start a new one <tr>. That will guarantee that you only
have 4 records per row and will give you a much cleaner code

thanks

But can yoyu explain it in the form of jsp/ servlets form cause I dont quite understand it from the one you use in the codings.
Sorry

That is JSP.

Your use of scriptlets is technology that was discredited over 6 years ago. Roberto has shown you the modern way to write JSP. I'd find a modern tutorial and come up to speed if I were you.

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? Thank You for your help all this while. Ans do you guys also know how to display out the image with the specific details like there is image and beside the image there is prodname,prodcolor....

My database is called: file_image
My attribute are
id(int)
uploaded_file(blob)
file_name(varchar)

The attachment is an example of how my desired output.

Really, really thanks you guys for your help

The above code only display out the path of imags, however the one i need is to display out the real images with all the details.