SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
if( rs != null )
pianoIas = new ArrayList<PianoIas>(0);
while(rs.next()){
PianoIas ias = new PianoIas();
RataId rataId = new RataId();
rataId.setNumeroPam(rs.getInt("PF02_NR_PAM"));
rataId.setProgressivoRata(rs.getInt("PF02_PGR_RATA"));
ias.setRataId(rataId);
ias.setDataScadenzaRata(rs.getDate("PF02_DT_SCAD_RATA"));
ias.setImportoRata(rs.getDouble("PF02_IMP_RATA"));
ias.setQuotaCapitale(rs.getDouble("PF02_QUOTA_CAPITALE"));
ias.setQuotaInteressi(rs.getDouble("PF02_QUOTA_INTERESSI"));
ias.setQuotaCapitaleIas(rs.getDouble("PF02_QUOTA_CAPITALE_IAS"));
ias.setQuotaInteressiIas(rs.getDouble("PF02_QUOTA_INTERESSI_IAS"));
ias.setQuotaIndicizzo(rs.getDouble("PF02_QUOTA_INDICIZZO"));
ias.setQuotaDietimi(rs.getDouble("PF02_QUOTA_DIETIMI"));
ias.setQuotaCommissioni(rs.getDouble("PF02_QUOTA_COMMISSIONI"));
ias.setQuotaSpese(rs.getDouble("PF02_QUOTA_SPESE"));
ias.setQuotaCommissioniGestione(rs.getDouble("PF02_QUOTA_COMM_GEST"));
ias.setProvvigioni(rs.getDouble("provvigioni"));
ias.setMontanteResiduo(rs.getDouble("montante_res"));
ias.setCapitaleResiduoIas(rs.getDouble("CAPITALE_IAS_RESIDUO"));
ias.setCapitaleResiduo(rs.getDouble("CAPITALE_RESIDUO"));
ias.setInteresseResiduoIas(rs.getDouble("INTERESSI_IAS_RESIDUI"));
ias.setSpeseResidueIas(rs.getDouble("spese_ias_residue"));
pianoIas.add(ias);
}
return pianoIas;