Want to retrieve data from database using servlets and display it in jsp

Question

I want to retrieve data from database using servlet and show it into a jsp file ,but what is retrieved is only the first row of the table.I want to be retrieved all rows.Could anyone help me? Thanks,and here is my code:

Servlet:

    try{

        DBConnection connection = new DBConnection();
        Connection con = connection.Connect();
        ResultSet rs;
        Statement st = con.createStatement();
        java.sql.PreparedStatement ps=con.prepareStatement("SELECT Nume,Descriere,Ingrediente,Mod_preparare,Imagini,Total_grasimi,Total_carbohidrati,Total_proteine,Total_calorii FROM reteta");
        rs=ps.executeQuery();

        while(rs.next()){
            //name
            String Nume = rs.getString("Nume");
            request.setAttribute("Nume",Nume);

            //descripton
            String Descriere = rs.getString("Descriere");
            request.setAttribute("Descriere",Descriere);

            //images
            String Imagini = rs.getString("Imagini");
            request.setAttribute("Imagini",Imagini);


       request.getRequestDispatcher("/retete.jsp").forward(request, response);


        }

    rs.close();
    st.close();
    con.close();
    }
    catch (Exception e2)
    {
      e2.printStackTrace();
    }

    finally
    {
      out.close();
    }
}

Jsp:

        <a href="images/{Imagini} " class="gall_item"><img src="images/${Imagini}" alt=""></a>
        <div class="gall_bot">
        <div class="text1"><a href="#">${Nume} </a></div>
        ${Descriere} 
        <br>
        <button type = "submit" class = "btn" >more</button>
        </div>
      </div>
    </div>
  </div>

Answer 1

You are setting attributes and forwarding the request within the while loop: that's probably why you are not getting the result you are expecting

You should use each field to create an object and each time around the loop store the newly created object in a collection (array, arraylist, linkedlist map...the choice is yours), then outside the loop create an attribute whose value is the collection populated with the object created in the while loop and finally forward the request to the Jsp

// create a new collection be it an array, arrayList, linkedList....
YourCollection yc = new YourCollection();

while(rs.next()){
        //name
        String Nume = rs.getString("Nume");
        //descripton
        String Descriere = rs.getString("Descriere");
        //images
        String Imagini = rs.getString("Imagini");

        // create object with db data;
        YourClass yourObject = new YourClass(Nume, Descriere, Imagini);
        // add object to collection
        YourCollection.add(yourObject);
}
// create attribute from collection
request.setAttribute("YourCollection", yc);

request.getRequestDispatcher("/retete.jsp").forward(request,response);

Within the Jsp you will be able to easily access the attribute and loop through the collection with a foreach JSTL tag (for instance) and the instance variables of each object via expression language (I used the dot notation in the example)

<c:foreach var="yourVarName" items="${YourCollection}">

            <a href="images/{yourVarName.imagini} " class="gall_item"><img src="images/${yourVarName.imagini}" alt=""></a>
            <div class="gall_bot">
            <div class="text1"><a href="#">${yourVarName.nume} </a></div>
    ${yourVarName.descriere} 
            <br>
            <button type = "submit" class = "btn" >more</button>
             <!-- check closing divs.... -->
            </div>
          </div>
        </div>
      </div>

</c:foreach>

Note: the properties accessed via dot notation correspond to the instance variables of each object and need not to be capitalized in compliance with the javabean specification.