Forum:

Need to display data on jsp, above table containing the recordset

Ranch Hand

Posts: 54

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I want to display this

Error summary for
source ${errors.sourceCd} on ${errors.loadDate},
load id = ${errors.errorsId}

above this

errors Description
1,305 MED_COV Dup Found
670 MEM_MEMB_TEFRA Dup Found
12 MEM_MEMB_WHCR Dup Found
36 MEM_OTH_INS_CARR Dup Found
8 MEM_SUB_GRP_PRODT Dup Found
2 MEM_XREF Dup Found

but I'm not sure how to get the data for the header (what I have prints blank). The data in the table retrieved in a loop, but apparently I can't use that as constructed.

The data I'm trying to display is in the recordset, I only display the two columns errors and Description

Below is the jsp and the DAO Impl

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>

<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
    <title>Error summary for load # [add # here] </title>
	<link rel="stylesheet" href="css/tablesorter.css" type="text/css" id="" media="print, projection, screen" />
	<link rel="stylesheet" href="css/thickbox.css" type="text/css" media="print,screen" />
	<link rel="stylesheet" href="css/edw.css" type="text/css" media="print,screen" />

</script>
</head>
<body>

<h2>Error summary for <br />source ${errors.sourceCd} on ${errors.loadDate},
load id = ${errors.errorsId} </h2>
  <a class="cancel"  rel="nofollow">
    <span class="btn_lbg">
      <span class="btn_rbg">Close</span>
    </span>
  </a>
<table class="tablesorter" id="statusEDW">
 <thead>
 <tr>	
    <th># errors</th>
    <th>Description</th>
 </tr>
 </thead>
 <tbody>
 <c:forEach var="errors" items="${model.list}">
   <tr>
  	<td ><fmt:formatNumber type="number"> ${errors.errorCount}</fmt:formatNumber></td>
     <td >${errors.errorDescr}</td>
   </tr>
 </c:forEach>
 </tbody>
 </table>
</body>
</html>

/*************************************/
package com.carefirst.edw.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.List;

import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;

import com.carefirst.edw.domain.ErrorListSummaryItem;

public class ErrorListSummaryDAOImpl extends NamedParameterJdbcDaoSupport implements ErrorListSummaryDAO {
	private static final String LIST_SQL = "" +
	"select et.srce_sys_cd, trunc(et.load_dt) as date_loaded, count(*) as num_errors, et.fld_nm, " +
	"et.mtrcs_errs_linkg_id  " +
	"from stage3i.err_tbl et where et.mtrcs_errs_linkg_id = to_number(:linkingId) " + 
	"group by et.srce_sys_cd, trunc(et.load_dt), et.mtrcs_errs_linkg_id, et.fld_nm, " +
	"et.err_cd, et.err_sqlcode order by et.fld_nm ";
	
	public List getLoadList(String errorsId) {
		
		MapSqlParameterSource map = new MapSqlParameterSource();
		map.addValue("linkingId", errorsId, Types.VARCHAR);
		
		List history = getNamedParameterJdbcTemplate().query(LIST_SQL, map, new ListRowMapper()); 
		
		return history;
	}

private class ListRowMapper implements RowMapper {
        public Object mapRow(ResultSet rs, int arg1) throws SQLException {
        	ErrorListSummaryItem item = new ErrorListSummaryItem();
        	item.setSourceCd(rs.getString("srce_sys_cd"));
        	item.setLoadDate(rs.getDate("date_loaded"));
        	item.setErrorCount(rs.getInt("num_errors"));
        	item.setErrorDescr(rs.getString("fld_nm"));
        	item.setErrorsId(rs.getInt("mtrcs_errs_linkg_id"));
        	return item;
        }
    }
}

Bill in Baltimore

Wouter Oet

Bartender

Posts: 2700

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Moved to the JSP forum.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.

William Peck

Ranch Hand

Posts: 54

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I resolved this from a local colleague.

I used a "forEach" for my header (in addition to the forEach in my main data table), plus limiting this to the first row via "begin ="0" end="0"

<c:forEach var="errors" items="${model.list}" begin="0" end="0">
<h2>Error summary for
source ${errors.sourceCd} on <fmt:formatDate value="${errors.loadDate}" pattern="E, MMM dd"/>,
load id = ${errors.errorsId } </h2>
</c:forEach>

Bill in Baltimore

Don't get me started about those stupid light bulbs.