//"SELECT NAPTRId, RteRecId, Order_, Service, Flags, ERE, ERE_Repl, Replacement, TTL, CDate, MDate FROM NAPTR WHERE RteRecId=? ;" ;
try
{
NAPTR naptr = jdbcTemplate.queryForObject(
NAPTR_SELECT_SQL,
new Object[]{rteRecId},
new RowMapper<NAPTR>() {
public NAPTR mapRow(ResultSet rs, int rowNum) throws SQLException {
NAPTR obj = new NAPTR();
obj.setNaptrId(rs.getInt(1)) ;
obj.setRouteRecordId(rs.getInt(2)) ;
obj.setOrder(rs.getShort(3)) ;
obj.setServices(rs.getString(4)) ;
obj.setFlags(rs.getString(5)) ;
obj.setEre(rs.getString(6)) ;
obj.setEre_repl(rs.getString(7)) ;
obj.setReplacement(rs.getString(8)) ;
obj.setTtl(rs.getShort(9)) ;
obj.setCreatedDateTime(rs.getDate(10)) ;
obj.setModifiedDateTime(rs.getDate(11)) ;
return obj;
}
});
return naptr ;
}catch(EmptyResultDataAccessException e)