Java - Read a List returned from MYSQL query with hibernate

Question

My Java class do a mysql query and it's result is stored in result list.

In the attached image you can see the structure data of one element of the list result. enter image description here My question is: how can I parse each element? How can I access to these values?

I don't want to use Object type.

String queryString = "SELECT COUNT(*),tabid FROM occurrencesnames group by tabid";
Query query = session.createSQLQuery(queryString);
List result = query.list();

Thank you so much.

michele · Accepted Answer · 2014-10-02 22:27:58Z

0

Solved!

String queryString = "SELECT COUNT(*),tabid FROM occurrencesnames group by tabid";
Query query = session.createSQLQuery(queryString);
List result = query.list();
Object[] row = (Object[]) result.get(0);
String name = (String)row[1];

edited Oct 2, 2014 at 22:27

answered Oct 2, 2014 at 18:18

michele

26.6k31 gold badges119 silver badges173 bronze badges

1

Your answer has shown up in the low quality posts queue because there is no description of the code. In general, explaining your code adds value to your answer.
– Keith Pinson
Commented Oct 2, 2014 at 18:50

Add a comment |

Collectives™ on Stack Overflow

Java - Read a List returned from MYSQL query with hibernate

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related