Quering and Display set

kenp · **Joined:** Tue Apr 11, 2006 4:20 pm **Posts:** 14

I have an application, I have successfully persisted about 100 objects into a MySQL 5.0 database...

I want to write a servlet that will query the database and display the results..

I have read my book "Hibernate Quickly" (the book store didn't have Hibernate In Action). They talk about how to perform queries but now how to display them back. I have searched google and the forum and haven't found a way to display my results back... so far I have the following

a function called retrieve. inside retrieve I

Code:

// Build and configure the session factory
SessionFactory sf = HibernateFactory.buildSessionFactory();

// Create and open session
Session session = sf.openSession();

Query query = session.createQuery("from TaskForm");
List results = query.list();

How do I take results and display it???? Please forgive my ignorance.

dsm08873 · **Posted:** Mon Apr 17, 2006 5:12 pm

See the javadoc for HttpServletResponse at http://java.sun.com/j2ee/sdk_1.3/techdo ... getWriter()

You can use the getWriter() (or getOutputStream()) methods and then println's on the Writer to write out the results.

However, typically people put the results in the request (request.setAttribute()) and then loop through them in a JSP page. Using JSTL EL in the JSP page:

Code:

  <ul>
    <c:forEach var="user" items="${users}">
       <li>${user.firstName} ${user.lastName}
    </c:forEach>
  </ul>
  

Is that what you're asking for?

kenp · **Joined:** Tue Apr 11, 2006 4:20 pm **Posts:** 14

I took your advice and saved it to the http session. however, instead of writing some jsp loop, i used the display tag library. just pointed the display tag to the javabean and it works like a charm.