ResultSet Only Pulls Out Last Row Of The Table

Ok here i am trying to pull out all the items in my Product table but all it does it last the row in the table. I have tried using do while but it still does not retrieve the information

Here the the Bean

public class Pageitem {
private int id;
private String name;
private double price;
private String description;
private Date modifyDate;
private int category;}//Has getter Setters and ToString methods for the items

[Code] .....