Hibernate Returning two Pojo's and display the results on jsp using jstl

Question

I have my pojo classes

Master:

public class Master extends RecordSet{

private String empcode;
private String empname;
private String dept;

public String getEmpcode() {
    return empcode;
}
public void setEmpcode(String empcode) {
    this.empcode = empcode;
}
public String getEmpname() {
    return empname;
}
public void setEmpname(String empname) {
    this.empname = empname;
}
public String getDept() {
    return dept;
}
public void setDept(String dept) {
    this.dept = dept;
}

DateRange:

public class DateRange extends RecordSet {
    private String  ddate;

    public String getDdate() {
        return ddate;
    }

    public void setDdate(String ddate) {
        this.ddate = ddate;
    }
}

RecordSet:

public class RecordSet {
    private DateRange daterange;
    private Master master;  

public DateRange getDaterange() {
        return daterange;
    }
    public void setDaterange(DateRange daterange) {
        this.daterange = daterange;
    }
    public Master getMaster() {
        return master;
    }
    public void setMaster(Master master) {
        this.master = master;
    }

}

I have my HibernateCode:

 SQLQuery query = session
                    .createSQLQuery("CALL AbsentReportproc(:_fromdate,:_todate)");
            query.addEntity(Master.class);
            query.addEntity(DateRange.class);
            query.setParameter("_fromdate", "2012-12-03");
            query.setParameter("_todate", "2012-12-04");

            List<Object[]> obj = query.list();
            System.out.println(obj);
            List<RecordSet> recordset = new ArrayList<RecordSet>();
            Iterator it = obj.iterator();
            while (it.hasNext()) {
                Object[] object = (Object[]) it.next();
                for (int i = 0; i < object.length; i++) {

    RecordSet set = (RecordSet) object[i];
     recordset.add(set);
        System.out.println(set);
//Here I am able to print
//edu.model.Master@15093f1
//edu.model.DateRange@e6f7d2
//edu.model.Master@19836ed
//edu.model.DateRange@3e0ebb
//edu.model.Master@39443f
//edu.model.DateRange@e6f7d2 etc................

                }
            }

    }

My Requirement is to display the results from both(Master and DateRange) in a jsp using JSTL Tags

Could any one How can I get final List object to iterate and display results from both pojo's

I want to display EmployeeName,Code,Dept from Master Pojo and ddate from DateRange Pojo?

when I iterate the RecordSet list then I'm not able to print the values(getting Null Pointer Exception)?

AxxA Osiris · Accepted Answer · 2013-02-07T10:30:48.817

1

You could do something like this:

<c:forEach var="record" items="${recordset}">
    <c:out value="${record.master.empcode}" />
    <c:out value="${record.master.empname}" />
    <c:out value="${record.master.dept}" />
    <c:out value="${record.daterange.ddate}" />
</c:forEach>

EDIT:

List<Object[]> obj = query.list(); 
List<RecordSet> recordset = new ArrayList<RecordSet>(); 
for (Object[] item: obj) {
    Master master = null;
    DateRange dateRange = null;
    if (item[0] instanceof Master) {
        Master master = (Master) item[0];
        DateRange dateRange = (DateRange) item[1];
    } else if (item[0] instanceof DateRange) {
        DateRange dateRange = (DateRange) item[0];
        Master master = (Master) item[1];
    }
    RocordSet record = new RecordSet();
    record.setMaster(master);
    record.setDateRange(dateRange);
    recordset.add(record);
}

And the return the recordset object to the jsp.

Hope this helps.

edited Feb 07 '13 at 10:30

answered Feb 07 '13 at 07:51

AxxA Osiris

1,219
17
26

But when I do like you answered,I am getting null values – String Feb 07 '13 at 08:32
@Kumar What object are you returning to the jsp? – AxxA Osiris Feb 07 '13 at 08:52
I am returning recordset list obj to the jsp like you done in your answer – String Feb 07 '13 at 08:54
From what I can tell from your code, recordset is empty. You can try passing the obj list to the recordset constructor: `List recordset = new ArrayList(obj);`. Let me know if this works. – AxxA Osiris Feb 07 '13 at 08:58
Thanks i will try and let you know the result – String Feb 07 '13 at 09:15
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/24107/discussion-between-kumar-and-axxa-osiris) – String Feb 07 '13 at 09:20

Hibernate Returning two Pojo's and display the results on jsp using jstl

1 Answers1

Linked