Hibernate Community • View topic - returning selected fields from table

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

returning selected fields from table

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

tt_linux

Post subject: returning selected fields from table

Posted: Tue Oct 24, 2006 3:33 am

Newbie

Joined: Mon Jan 09, 2006 8:17 am
Posts: 19

hi,

how can access the selected fields returned from a query ?

eg.

sql_str = "select distinct v.name, v.title from Vendor as v"
Query query = session.createQuery(sql_str);
list = (ArrayList) query.list();

how do i use java code to extract name and title from the list ?

thanks.

Hibernate version: 3.1

Top

jaikiran

Post subject:

Posted: Tue Oct 24, 2006 3:53 am

Regular

Joined: Wed Jul 27, 2005 2:33 am
Posts: 118

Code:

String queryString = "select distinct v.name, v.title from Vendor as v" 
Query query = session.createQuery(queryString); 
List list =  query.list(); 

Iterator resultsIterator = list.iterator();

while (resultsIterator.hasNext()) {

Object [] objects = (Object[]) resultsIterator.next();

//assuming that v.name and v.title are of type java.lang.String
String name = (String) objects[0];

String title = (String) objects[1];

} //end of while

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum