Get values from list object

Question

I have code like this...

Query query = em.createQuery("select CM.salesAreaId, SM.salesAreaDesc, count(CM.salesAreaId), sum(CM.openBal), " +
                    "sum(CM.netSales) from CustomerMaster CM, SalesAreaMaster SM where CM.salesAreaId=SM.salesAreaCode and CM.companyId=SM.companyId" +
                    " and CM.companyId=:companyId group by CM.salesAreaId, SM.salesAreaDesc");
query.setParameter("companyId", companyId);
List list = query.getResultList();

From above code how can i get the list values?(list.get() values prints objects)

Suggestion : use Eclipse Debugger to find such stuff - as what is the Data Structure that is returned — user1428716, Mar 01 '13 at 13:32

score 2 · Accepted Answer · answered Mar 01 '13 at 13:26

Try this

Query query = em.createQuery("select CM.salesAreaId, SM.salesAreaDesc, count(CM.salesAreaId), sum(CM.openBal), " +
                    "sum(CM.netSales) from CustomerMaster CM, SalesAreaMaster SM where CM.salesAreaId=SM.salesAreaCode and CM.companyId=SM.companyId" +
                    " and CM.companyId=:companyId group by CM.salesAreaId, SM.salesAreaDesc");
query.setParameter("companyId", companyId);
List list = query.getResultList();
for(Object o : list) {
    Object[] obj = (Object[])o;

}

And the value of CM.salesAreaId should be in obj[0]

score 1 · Answer 2 · answered Mar 01 '13 at 13:26

1

You could use a for loop to iterate through, providing the index each time.

for (int i = 0; i < list.size(); i++)
{
    Object x = list.get(i);
    ...
}

http://docs.oracle.com/javase/6/docs/api/java/util/List.html#get(int)

answered Mar 01 '13 at 13:26

clicky

865
2
14
31

score 1 · Answer 3 · edited May 23 '17 at 12:07

as JPA is an ORM spec, query result will necessary be a set of Objects. There is a workaround with hibernate if you're using this last as JPA implementation (see How to fetch hibernate query result as associative array of list or hashmap) but your code will be heavily coupled to hibernate then.
If you want to retrieve result as a resultSet (set of primitive values) you should use jdbc directly.

If your problematic is just to print the result in an human readable way you should override toString() method for all your JPA entities.

Get values from list object

3 Answers3