Re: Struts - Getter method

On Jul 2, 8:27 pm, "Joe Blow" <nob...@noplace.com> wrote:

Hi Joe,

  Thanks again for the reply. Hope that you're doing well.

  I tried several different variation of things to get the code
working. So far
I haven't succeeded.

  Below is the change that I made to the BookListAction.java in order
to get the
value of the items returned from the Query. I understand that it's a
list, but the
list (basically rows with data) seems to have an Object in each index.
So it's a
list of Objects where every Object has the 4 values retrieved for a
record in the
database.

  To make things simple I added a where clause (for id = 1) so that i=

matches only
one row. I'm able to display that the size of books2 is 1, but I can't
get to the
values somehow.

  I'll appreciate your help or any ideas regarding this problem. The
new code for
the BookListAction.java is shown below. The other files have no
changes.

Thanks again,

Ruben

========================

BookListAction.java

BookListAction.java

package com.mycompany.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.text.html.HTMLDocument.Iterator;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mycompany.Book;
import com.mycompany.struts.form.BookListForm;
import com.mycompany.hibernate.*;
import org.hibernate.*;
import org.hibernate.criterion.Projections;

import java.util.*;

public class BookListAction extends Action {

        public ActionForward execute(ActionMapping mapping, ActionForm =

                        HttpServletRequest request, HttpServletResponse=

                BookListForm bookListForm = (BookListForm) form;

                SessionFactory factory = null;
            Session session = null;
            Collection <Book> books = new ArrayList<Book>();
            List <Object> books2 = new ArrayList<Object>();
            Object books3 = null;
            Book book1 = null;

              try {

                  factory = HibernateUtil.getSessionFactory();

                  session = (Session) factory.openSession();

                  // The line below works and I can see the values in
debug mode. I added the
                  // where clause to limit the resultset, but it works
without it too

                  books2 = (List <Object>) session.createQuery("selec=

title, author, available from Book where id = 1 ").list();

                  // The line below prints the total rows returned
from the query. With the
                  // where clause, it prints the value 1 since only
one row matches that criteria

                  System.out.println("Query Size = " + books2.size())=

                  // Below are the different things that I tried in
order to get the value from
                  // books2. Nothing works.

                  Object[] firstResult = (Object[]) books2.get(0);

                  // int id = ((Integer) firstResult[0]).intValue();
                  String title = ((String) firstResult[1]).toString()=

                  System.out.println(id);
                  System.out.println(title);

                  // Criteria crit = session.createCriteria(Book.clas=

                  // System.out.println("Query Size = " + books2.size=

                  // for (int i = 0; i < books2.size(); i++) {
                  // Book book = (Book) books2.getInt(0);
                  // }

                  // for (int i = 0; i < books2.size(); i++) {
                  // books3 = books2.get(i);
                  // System.out.println(books3);
                  // }

// for (int i = 0; i < books2.size(); i++) {
// System.out.println(books2);
// book1 = null;
// book1 = (Book) books2.get(i);
// System.out.println(book1.getTitle());
// }

                  bookListForm.setBooks(books2);

          } finally {
                  session.close();
              }

          return mapping.findForward("showList");

        }

}

========================