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(" ( CG04_FLG_PROVVISTA_FONDI = 'P' ) AND "); 
    query.append(" ( CG04_TP_CONTO = 'M' ) AND "); 
    query.append(" ( CG01_TP_MOVIMENTO NOT IN ('E','X') ) AND "); 
    query.append(" ( CG01_COD_CONTO = :numeroMutuo ) "); 
    Object[] args = { numeroMutuo };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importo = rs.getDouble(1); 
    }
    return importo;
  }

View Full Code Here

    query.append(" ( DATIFIN.PF01_NR_MUTUO = MUTUOPAM.PF02_NR_MUTUO ) and ");  
    query.append(" ( DATIFIN.PF01_NR_PAM = MUTUOPAM.PF02_NR_PAM ) and ");  
    query.append(" ( DATIFIN.PF01_NR_DATIFIN = GET_NR_DATIFIN( :numeroMutuo ,  DATIFIN.PF01_DT_CALC_ESTINZIONE )) AND ");
    query.append(" ( MUTUOPAM.PF02_DT_SCAD_RATA <= DATIFIN.PF01_DT_CALC_ESTINZIONE ) "); 
    Object[] args = { numeroMutuo , numeroMutuo };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      progRata = rs.getInt(1); 
    }
    return progRata;
  }

View Full Code Here

    query.append(" AND CG01_COD_MASTRO = PF01_COD_MASTRO "); 
    query.append(" AND CG01_COD_CONTO = PF01_COD_CONTO ");
    query.append(" AND PF01_NR_MUTUO = :numeroMutuo ");
    query.append(" AND 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

    query.append(" WHERE CG01_COD_GRUPPO = :codiceGruppo  AND ");  
    query.append(" CG01_COD_MASTRO = :codiceMastro  AND ");  
    query.append(" CG01_COD_CONTO = :codiceConto  AND ");
    query.append(" CG01_TP_MOVIMENTO NOT IN ('E','X') ");      
    Object[] args = { codiceGruppo, codiceMastro, codiceConto  };
    SqlRowSet rs = getJdbcTemplate().queryForRowSet(query.toString(), args);
    if(rs.next()) {
      importo = rs.getDouble(1); 
    }
    return importo;
  }

View Full Code Here

   */
  public static void getColumnNameAndColumeValue(List<String> listSQL, JdbcTemplate jdbcTemplate) throws Exception {
    if (listSQL.size() > 0) {
      insertList.clear();
      insertList.add("SET FOREIGN_KEY_CHECKS=0;");// 取消外键检查
      SqlRowSet sqlRowSet = null;
      String ls_id = "";
      for (int j = 0; j < listSQL.size(); j++) {
        String sql = String.valueOf(listSQL.get(j)); // 逐条获取sql语句
        sqlRowSet = jdbcTemplate.queryForRowSet(sql);
        SqlRowSetMetaData sqlRsmd = sqlRowSet.getMetaData();
        int columnCount = sqlRsmd.getColumnCount(); // 获得表字段个数
        String tableName = sqlRsmd.getTableName(columnCount); // 获得表名称
        if(StringUtils.isEmpty(tableName)){
          tableName = PublicUtil.getTableName(sql);
        }
        String tableId="";
        while (sqlRowSet.next()) {
          StringBuffer ColumnName = new StringBuffer();
          StringBuffer ColumnValue = new StringBuffer();


          for (int i = 1; i <= columnCount; i++) {
            String value = sqlRowSet.getString(i);
            if (value == null || "".equals(value)) {
              value = "";
            }
            Map<String, String> fieldMap = new HashMap<String, String>();
            fieldMap.put("name", sqlRsmd.getColumnName(i));

View Full Code Here

          throw new IOException("Cannot save sample - issue with naming scheme", e);
        }
      }
    }
    else {
      SqlRowSet ss = template.queryForRowSet(SAMPLE_SELECT_BY_ALIAS, new Object[]{sample.getAlias()});
      if (ss.next() && ss.getLong("sampleId") != sample.getId()) {
        throw new IOException("UPD: A sample with this alias already exists in the database");
      }
      else {
        try {
          if (sampleNamingScheme.validateField("name", sample.getName()) && sampleNamingScheme.validateField("alias", sample.getAlias())) {

View Full Code Here


  public List<Object[]> createTableData(String tablename) {
    int filedNum = getTableFieldNums(tablename);
    List<Object[]> results = new ArrayList<Object[]>();
    String sql = " select * from   " + tablename;
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      Object[] oneResult = new Object[filedNum];
      for (int i = 1; i <= filedNum; i++) {
        oneResult[i - 1] = set.getObject(i);
      }
      results.add(oneResult);
    }
    return results;
  }

View Full Code Here

  }


  public List<CmsField> listFields(String tablename) {
    String sql = " desc  " + tablename;
    List<CmsField> fields = new ArrayList<CmsField>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      CmsField field = new CmsField();
      field.setName(set.getString(1));
      field.setFieldType(set.getString(2));
      field.setNullable(set.getString(3));
      field.setFieldProperty(set.getString(4));
      field.setFieldDefault(set.getString(5));
      field.setExtra(set.getString(6));
      fields.add(field);
    }
    return fields;
  }

View Full Code Here

  }


  public List<String> listTables() {
    String sql = " show tables ";
    List<String> tables = new ArrayList<String>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      tables.add(set.getString(1));
    }
    return tables;
  }

View Full Code Here

  }
  
  public List<String> listDataBases() {
    String sql = " show  databases ";
    List<String> tables = new ArrayList<String>();
    SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
    while (set.next()) {
      tables.add(set.getString(1));
    }
    return tables;
  }

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.