return multiple columns ?

czy11421 · **Joined:** Mon Jul 09, 2007 9:32 am **Posts:** 17

if I have a query, like "select c1, c2, c3 from myTable", then which method I should use to return multiple columns ?

Thanks.

sreedhar.en · **Joined:** Fri Sep 05, 2008 2:08 am **Posts:** 7

@ czy11421

List result = session.createQuery("select c1, c2, c3 from myTableBean").list();
It will working fine.In my application i have written code for similar task.

Code:

public List listAllEmp(){
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        
        List result = session.createQuery("from empBean.Employee").list();
        session.getTransaction().commit();
        System.out.println("end of listAllEmp method");
        return result;
    }

sunilk · **Posted:** Mon Nov 02, 2009 3:28 am

select c1, c2, c3 from myTable
returns in object array
Object[] arrObjQuerydtls
arrObjQuerydtls[0] -- c1 value, arrObjQuerydtls[1] -- c2 value, arrObjQuerydtls[2] -- c3 value

You can use query interface uniqueResult() or list() methods

List result = session.createQuery("select empid,empname,sal from empBean.Employee").list();
returns list of object arrays

Regards
Sunil K