Hi for all...

I'm trying to print (System.out) the result of a single query through the code that follows:
-------------------------------------------------------------------------------
String sqlQuery = null;
sqlQuery ="FROM AMIGO in class HIBERNA.Amigo where Amigo.nome = 'lara'";
List lista = dao.getList(sqlQuery);
for(int indice = 0; indice < lista.size(); indice++)
System.out.println(lista.get(indice));
------------------------------------------------------------------------------
The DAO method is:

public java.util.List getList(String sqlQuery) throws Exception
{
Session session = factory.openSession();
List amigos = session.find(sqlQuery);
session.flush();
session.close();
return amigos;
}
-----------------------------------------------------------------------------
The sql-show returns...

Hibernate: select AMIGO.NOME as NOME, AMIGO.ENDERECO as ENDERECO, AMIGO.TELEFONE as TELEFONE, AMIGO.CELULAR as CELULAR, AMIGO.EMAIL as EMAIL from SCOTT.AMIGOS AMIGO where (Amigo.nome='lara' )

there is just one record on ORACLE and the command
if(dao.getList(sqlQuery).isEmpty() || dao.getList(sqlQuery) == null) show me 'FALSE'.
----------------------------------------------------------------------------------
However, i dont know how to print the entire result (even it be just one).
The line System.out.println(lista.get(indice)); dont sound like correct and the system prints 'HIBERNA.Amigo@ae533a'.

Taken a look at
http://jakarta.apache.org/commons/lang/api/index.html

particularly the toStringBuilder stuff.

I use something like this in some of my unit tests to have a look at results

...
import org.apache.commons.lang.builder.*;
...
public void printObj(String msg, Object o) throws Exception {
System.out.println(objToString(msg,o));
}

public String objToString(String msg, Object o) throws Exception {
return msg + "\n" + objToString(o);
}

public String objToString(Object o) throws Exception {
return ReflectionToStringBuilder.toString(o,StandardToStringStyle.MULTI_LINE_STYLE,true);
}
....

Thanks, Khote. I had try the follow (I'm not using webserver for now), and it works but i dont know if its the best way:

String sqlQuery = null;
sqlQuery ="FROM AMIGO in class HIBERNA.Amigo";
List lista = dao.getList(sqlQuery);

Amigo amigo1 = null;
for(int i = 0; i < lista.size(); i++)
{
amigo1 = (Amigo)lista.get(i);
System.out.println(amigo1.getCelular());
}

Inside your Amigo class you can override the toString() method as:

import org.apache.commons.lang.builder.*;
public class Amigo {
....
protected int id;
protected String name;
protected String code;
protected String celular;
....
public String toString() {
return new ToStringBuilder this,StandardToStringStyle.MULTI_LINE_STYLE)
.append("-- id", id)
.append("-- name", name)
.append("-- celular", celular)
.toString();
}
....
}

use the real properties in your Amigo class of course.
I know the "import org.apache.commons.lang.builder.*;" is Bad Form, but generally we're just using this kind of thing during development and debugging.
This commons-lang package is FULL of good stuff.