problem in getting data from database
Hi all...
<c:forEach items="${resultDto.servicelist}" var="item" varStatus="count">
<tr>
<td align="center" class="center"><input type="checkbox" value="${item.serviceid}" name="dto(check${count.count})" onclick="selectcheckbox()"/></td>
<td align="left" class="center"><c:out value="${item.servicename} : ${item.servicedesc}"/></td>
<td align="center" class="center"><c:out value="${item.costofservice}"/></td>
<td align="center" class="center"><c:out value="${item.item.status}"/></td>
<td align="center" class="center">
<html:text property="dto(lastchanged${count.count})" size="4" value="${item.lastchanged}" styleClass="input_textadmin"/>
<input type="image" src="pages/jsp/images/calendar.gif" value="..." id='button1' height="16" width="16" valign="center">
<script type="text/javascript">
var cal = new Zapatec.Calendar.setup({
inputField:"dto(veh_dop)",
ifFormat:"%d-%m-%Y",
button:"button1",
showsTime:false
});
</script> </td>
<td align="center" class="center"><html:text property="dto(timeinterval${count.count})" size="4" value="${item.timeinterval}"/> </td>
<td align="center" class="center"><html:text property="dto(kminterval${count.count})" size="4" value="${item.kminterval}"/> </td>
</tr>
</c:forEach>
this is my jsp page where i have to get the service details from service master database . i need to get all the data like id,name,costof service,status from database with out taking any id into consideration.
AND this is my .java file
public DTO getServiceDetails(DTO params) throws DAOException
{
System.out.println(">>>>>>>>>>.");
List list = new ArrayList();
DTO resultDto=super.get("SELECT * FROM SERVICEMASTER",list);
//List serlist=resultDto.getDataList();
resultDto.put("servicelist",list);
System.out.println("<<<<<<<<<<<<<<<"+list);
if(null != resultDto.getDataList())
{
list = resultDto.getDataList();
Map map = (Map)list.get(0);
resultDto.put("serviceid",map.get("serviceid"));
resultDto.put("servicename",map.get("servicename"));
for(int i=0;i<list.size();i++)
{
map = (Map)list.get(i);
map.put("serviceid",map.get("serviceid"));
map.put("servicename",map.get("servicename"));
map.put("costofservice",map.get("costofservice"));
map.put("status",map.get("status"));
String serviceid = (String) map.get("serviceid");
String servicename = (String) map.get("servicename");
String costofservice = (String) map.get("costofservice");
String status = (String) map.get("status");
resultDto.put("serviceid",serviceid);
resultDto.put("servicename",servicename);
resultDto.put("costofservice",costofservice);
resultDto.put("status",status);
}
}
return resultDto;
}
iam not able to get the data displayed...
can any one help me
thanx in
advance>
