List<RouteRecord> listRteRec = jdbcTemplate.query(RRREF_SELECT_SQL,
new Object[] { rteGrp.getRouteGroupId() },
new RowMapper<RouteRecord>() {
public RouteRecord mapRow(ResultSet rs, int rowNum)
throws SQLException {
RouteRecord rteRec = new RouteRecord();
rteRec.setRouteRecordId(rs.getInt(1));
rteRec.setRouteRecordName(rs.getString(2));
rteRec.setPriority(rs.getShort(3));
return rteRec;
}
});
if(listRteRec.size() > 0)
{