Examples of org.springframework.jdbc.support.rowset.SqlRowSet

Package org.springframework.jdbc.support.rowset

Examples of org.springframework.jdbc.support.rowset.SqlRowSet

org.springframework.jdbc.support.rowset.SqlRowSet
Mirror interface for javax.sql.RowSet, representing disconnected java.sql.ResultSet data.
The main difference to the standard JDBC RowSet is that an SQLException is never thrown here. This allows a SqlRowSet to be used without having to deal with checked exceptions. A SqlRowSet will throw Spring's org.springframework.jdbc.InvalidResultSetAccessException instead (when appropriate).
Note: This interface extends the java.io.Serializable marker interface. Implementations, which typically hold disconnected data, are encouraged to be actually serializable (as far as possible). @author Thomas Risberg @author Juergen Hoeller @since 1.2 @see javax.sql.RowSet @see java.sql.ResultSet @see org.springframework.jdbc.InvalidResultSetAccessException @see org.springframework.jdbc.core.JdbcTemplate#queryForRowSet

    query.append(" ( DATIFIN.PF01_NR_PAM = MUTUOPAM.PF02_NR_PAM ) ");
    query.append(" ORDER BY MUTUOPAM.PF02_DT_SCAD_RATA ASC   ");
    
    Object[] args = {numeroPam, numeroPam};
    
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if( rs != null )
      pianoEstinzione = new ArrayList<PianoAmmortamentoPerVariazionePiani>(0);
    
    while(rs.next()){
      PianoAmmortamentoPerVariazionePiani ratapam = new PianoAmmortamentoPerVariazionePiani();
      
      RataId rataId = new RataId();
      rataId.setNumeroPam(rs.getInt("PF02_NR_PAM"));
      rataId.setProgressivoRata(rs.getInt("PF02_PGR_RATA"));
      ratapam.setRataId(rataId);
      ratapam.setFlagInsoluto(rs.getString("flagInsoluto"));
      ratapam.setDataScadenzaRata(rs.getDate("PF02_DT_SCAD_RATA"));
      ratapam.setImportoRata(rs.getDouble("PF02_IMP_RATA"));
      ratapam.setImportoSaldoRata(rs.getDouble("saldoRata"));
      ratapam.setQuotaCapitale(rs.getDouble("PF02_QUOTA_CAPITALE"));
      ratapam.setQuotaInteressi(rs.getDouble("PF02_QUOTA_INTERESSI"));
      ratapam.setQuotaIndicizzo(rs.getDouble("PF02_QUOTA_INDICIZZO"));
      ratapam.setQuotaSpese(rs.getDouble("PF02_QUOTA_SPESE"));
      ratapam.setCapitaleResiduo(rs.getDouble("PF02_CAPITALE_RESIDUO"));
      ratapam.setDataValuta(rs.getDate("dataValuta"));
      ratapam.setTipoFormaPagamento(rs.getString("SM13_TP_FORMA_PAG"));
      ratapam.setCodicePosizioneRata(rs.getInt("PF02_COD_POSIZIONE_RATA"));
      ratapam.setDataAddebitoCliente(rs.getDate("PF02_DT_ADDEBITO_CLIENTE"));
      ratapam.setQuotaCommissioni(rs.getDouble("PF02_QUOTA_COMMISSIONI"));
      ratapam.setQuotaDietimi(rs.getDouble("PF02_QUOTA_DIETIMI"));
      ratapam.setTipoRata(rs.getString("PF02_TP_RATA"));
      
      ratapam.setImportoRataOriginale(rs.getDouble("importoRataOriginale"));
      ratapam.setImportoDebitoResiduoReale(rs.getDouble("debitoResiduoReale"));
      ratapam.setImportoRimborsi(rs.getDouble("importoRimborsi"));
      ratapam.setCodiceTipoRata(rs.getString("PF01_COD_TP_RATA")); // datifin
      ratapam.setTassoIndicizzazione(rs.getDouble("PF02_TASSO_INDICIZ"));
      
      pianoEstinzione.add(ratapam);
    }
    
    return pianoEstinzione;

View Full Code Here

    query.append(" WHERE CA09_NR_MUTUO = :numeroMutuo AND ");
    query.append(" SM45_COD_CALCOLO = CA09_BASE_PENALE_EST_ANTIC AND ");
    query.append(" PENALI.CA09_DT_INIZIO_VALIDITA <= :dataCalcoloEstinzione AND ");
    query.append(" ( PENALI.CA09_DT_FINE_VALIDITA IS NULL OR PENALI.CA09_DT_FINE_VALIDITA >= :dataCalcoloEstinzione ) ");
    Object[] args = { numeroMutuo, dataCalcoloEstinzione, dataCalcoloEstinzione };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if (rs != null) {
      listace = new ArrayList<StrutturaCalcoloEstinzione>(0);
      while( rs.next() ){
        StrutturaCalcoloEstinzione ce = new StrutturaCalcoloEstinzione();
        ce.setBaseCalcoloPenale(rs.getString(1));
        ce.setTassoEstinzioneAnticipata(rs.getDouble(2));
        ce.setTipoTrattamento(rs.getString(3));
        listace.add(ce);
      }
    }
    return listace;
  }

View Full Code Here

    query.append(" FROM MUTUOPAM ");
    query.append(" WHERE ( PF02_NR_MUTUO = :numeroMutuo ) AND ");
    query.append(" ( PF02_NR_PAM = :numeroPam ) AND ");
    query.append(" ( PF02_DT_SCAD_RATA > :dataCalcEst ) ");
    Object[] args = { tassoAttuale, pgrUltRataScaduta, numeroMutuo, numeroPam, dataCalcEst };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      capitaleAttuale = rs.getDouble(1); 
    }
    return capitaleAttuale;
  }

View Full Code Here

    query.append(" FROM PARTITE "); 
    query.append(" WHERE ( CG08_TP_CONTO = 'M' ) AND "); 
    query.append(" ( CG08_COD_CONTO = :numeroMutuo ) AND "); 
    query.append(" ( CG08_COD_GRUPPO = 24 ) ");
    Object[] args = { numeroMutuo };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importoPF = rs.getDouble(1); 
    }
    return importoPF;
  }

View Full Code Here

    query.append(" ( CG08_COD_CONTO = :numeroMutuo ) AND  "); 
    query.append(" ( ( CG08_TP_PAM = 'PA' ) AND "); 
    query.append(" ( CG08_NR_PAM = :numeroPam ) AND "); 
    query.append(" ( CG08_PGR_RATA = 0 or CG08_PGR_RATA is null) ) "); 
    Object[] args = { numeroMutuo ,  numeroPam};
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importoPartiteIndicizz = rs.getDouble(1); 
    }
    return importoPartiteIndicizz;
  }

View Full Code Here

    query.append(" WHERE PF01_DT_FINE_VALIDITA IS NULL "); 
    query.append(" AND CA01_NR_MUTUO = CA07_NR_MUTUO ");
    query.append(" AND CA01_NR_MUTUO = PF01_NR_MUTUO "); 
    query.append(" AND CA01_NR_MUTUO = :numeroMutuo ");
    Object[] args = { dataCalcolo, dataCalcolo, dataCalcolo, dataCalcolo, dataCalcolo, numeroMutuo };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importoSpeseEstinzioneGraduati = rs.getDouble(1); 
    }
    return importoSpeseEstinzioneGraduati;
  }

View Full Code Here

  public Double getCalcolaMora(long numeroMutuo, Date dataCalcolo) {
    Double importoMora = 0d;
    StringBuffer query = new StringBuffer();
    query.append(" SELECT calcola_mora_mutuo(:numeroMutuo,  :dataCalcolo) FROM DUAL ");   
    Object[] args = { numeroMutuo ,  dataCalcolo};
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importoMora = rs.getDouble(1); 
    }
    return importoMora;
  }

View Full Code Here

//    query.append(" ( PF02_TP_RATA = 'I' ) AND ");
//    query.append(" ( SM13_FLG_TP_INCASSO <> 'B' ) AND ");
//    query.append(" ( SALDO <> PF02_IMP_RATA ) AND ");
//    query.append(" ( PF02_NR_PAM = :numeroPam ) ");
    Object[] args = { numeroPam, numeroMutuo, dataCalcolo, numeroPam };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importoIncassiNonBancabiliAScadere = rs.getDouble(1); 
    }
    return importoIncassiNonBancabiliAScadere;
  }

View Full Code Here

//    query.append(" ( ( ( SALDO < PF02_IMP_RATA ) AND ");
//    query.append(" ( PF02_DT_ADDEBITO_CLIENTE IS NOT NULL ) ) OR ");
//    query.append(" ( SALDO < 0 ) ) AND ");
//    query.append(" ( PF02_NR_PAM = :numeroPam ) ");
    Object[] args = { numeroPam, numeroMutuo, dataCalcolo, numeroPam };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importoIncassiBancabiliAScadere = rs.getDouble(1); 
    }
    return importoIncassiBancabiliAScadere;
  }

View Full Code Here

    query.append(" WHERE PF01_NR_CONTAB_PAM_EST = PF07_NR_CONTAB_PAM AND ");
    query.append(" PF01_NR_MUTUO = :numeroMutuo AND ");
    query.append(" PF07_COD_FAMIGLIA = 'INTULT' AND ");  
    query.append(" PF01_DT_FINE_VALIDITA IS NULL ");
    Object[] args = { numeroMutuo };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importo = rs.getDouble(1); 
    }
    return importo;
  }

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.springframework.jdbc.support.rowset.SqlRowSet

cn.org.rapid_framework.spring.beans.factory.config.JdbcPlaceholderConfigurer

com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl

com.jeecms.cms.dao.assist.impl.CmsDataDaoImpl

com.jverstry.Controller.MyController

com.salesforce.dataloader.dao.database.DatabaseTestUtil

com.services.otg.db.TrackingTemplate

it.pdor.gestionePratica.dao.jdbc.GestionePraticaDaoJdbcImpl

org.beangle.ems.avatar.service.DataBaseAvatarBase

org.beangle.webapp.avatar.service.DataBaseAvatarBase

org.geoserver.jdbcconfig.internal.DbMappings

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.