Data Retrieval problem from db to jsp.

[Geo Joseph]

Hi everybody,
Im stuck with a problem, seeking your assistance. The situation is i have a link, when i click on the link a action is called, which in turn calls its respective action mapping(jsp page). All this works fine without any error. Now the only problem is when the user clicks on the link the jsp page is getting displayed, instead of displaying the result nothing is showing up. That is no data is shown. This is my code.

when the user clicks the link the action class is called. Im getting a resultset and i'm storing the resultset in a arraylist

  MismatchForm getData(ResultSet resultset)
  {
  mf=new MismatchForm();
  try
  {
  mf.setReq_Code(resultset.getString("Req_Code"));
  mf.setPublicity_Code(resultset.getString("Publicity_Code"));
  mf.setBranch(resultset.getString("Branch"));
  mf.setSub_Office(resultset.getString("Sub_Office"));
  mf.setReq_Date(resultset.getString("Req_Date"));
  mf.setTotal_Cost(resultset.getString("Total_Cost"));
  mf.setProposed_By(resultset.getString("Proposed_By"));
  mf.setApproved_By(resultset.getString("Approved_By"));
  }
  catch(SQLException e)
  {
  e.printStackTrace();
  }
return mf;
  
  }  

and in the result set im just calling it as

  for(resultset = statement.executeQuery(s2); resultset.next() :wink: 
            {
                          list.add(mf);
}
   

And in jsp page im retrieving it as--

 bean:write name="mf" property="req_Code"
        bean:write name="mf" property="publicity_Code"
and so on.....
 

Can anybody help me here in this regard, i appreciate your kind help on this matter.
regards,
Geo J.

[Geo Joseph]

Hi there,
I managed to solve the problem, bit too early to post must say. The problem was in the resultset i was doing something like list.add(mf);
instead it should had been list.add(getData(resultset));
and most importantly i messed up here, this should had been--
httpservletrequest.setAttribute("list", list);
instead of mf in place of list.
regards,
Geo J.