I am setting the values from resultset to formbean which is in turn used to display table on
jsp
while(iResultSet1.next())
{
afWIPZonalRpt Objafwipzonalrpt = new afWIPZonalRpt();
Integer i=0;
Objafwipzonalrpt.setMis(iResultSet1.getString(++i));
Objafwipzonalrpt.setCentral(iResultSet1.getString(++i));
Objafwipzonalrpt.setEast(iResultSet1.getString(++i));
Objafwipzonalrpt.setFrontier(iResultSet1.getString(++i));
Objafwipzonalrpt.setNorth(iResultSet1.getString(++i));
Objafwipzonalrpt.setSouth(iResultSet1.getString(++i));
Objafwipzonalrpt.setSvv(iResultSet1.getString(++i));
Objafwipzonalrpt.setWest(iResultSet1.getString(++i));
Objafwipzonalrpt.setGrandTotal(iResultSet1.getString(++i));
expRptCol.add(Objafwipzonalrpt);
}
My question is how to get last two rows from the resultset, do the summation and add one more row at the bottom?