Examples of org.springframework.jdbc.core.ColumnMapRowMapper

org.springframework.jdbc.core.ColumnMapRowMapper
{@link RowMapper} implementation that creates a java.util.Mapfor each row, representing all columns as key-value pairs: one entry for each column, with the column name as key.
The Map implementation to use and the key to use for each column in the column Map can be customized through overriding {@link #createColumnMap} and {@link #getColumnKey}, respectively.
Note: By default, ColumnMapRowMapper will try to build a linked Map with case-insensitive keys, to preserve column order as well as allow any casing to be used for column names. This requires Commons Collections on the classpath (which will be autodetected). Else, the fallback is a standard linked HashMap, which will still preserve column order but requires the application to specify the column names in the same casing as exposed by the driver. @author Juergen Hoeller @since 1.2 @see JdbcTemplate#queryForList(String) @see JdbcTemplate#queryForMap(String)

  public Map<String, Object> queryForMap(String sql, SqlParameterSource paramSource) throws DataAccessException {
    return queryForObject(sql, paramSource, new ColumnMapRowMapper());
  }


  public Map<String, Object> queryForMap(String sql, Map<String, ?> paramMap) throws DataAccessException {
    return queryForObject(sql, paramMap, new ColumnMapRowMapper());
  }

View Full Code Here

  }


  public List<Map<String, Object>> queryForList(String sql, SqlParameterSource paramSource)
      throws DataAccessException {


    return query(sql, paramSource, new ColumnMapRowMapper());
  }

View Full Code Here

                }
                
                boolean isResultSet = ps.execute();
                
                if (isResultSet) {
                    RowMapperResultSetExtractor mapper = new RowMapperResultSetExtractor(new ColumnMapRowMapper());
                    List<?> result = (List<?>) mapper.extractData(ps.getResultSet());
                    exchange.getOut().setBody(result);
                    exchange.getIn().setHeader(SqlConstants.SQL_ROW_COUNT, result.size());
                    // preserve headers
                    exchange.getOut().setHeaders(exchange.getIn().getHeaders());

View Full Code Here

            DataSource ds = (DataSource) getApplicationContext().getBean(dsName);
            JdbcTemplate template = new JdbcTemplate(ds);


            // Execute the SQL query and build a results object.  This result will consist of one
            // rowname -> rowvalue map for each row in the result set
            results = template.query(spelSqlQuery, new ColumnMapRowMapper());
            log.debug("found {} results for query {}", results.size(), spelSqlQuery);


            if (cache != null) {
                log.debug("Adding SQL results to cache {}, query: {}, substituted query: {}", cache.getName(),
                        sqlQuery, spelSqlQuery);

View Full Code Here

                    ps.setObject(argNumber++, i.next());
                }
                boolean isResultSet = ps.execute();
                if (isResultSet) {
                    RowMapperResultSetExtractor mapper = new RowMapperResultSetExtractor(
                                                                                         new ColumnMapRowMapper());
                    List<?> result = (List<?>)mapper.extractData(ps.getResultSet());
                    exchange.getOut().setBody(result);
                } else {
                    exchange.getIn().setHeader(UPDATE_COUNT, ps.getUpdateCount());
                }

View Full Code Here

    /**
     * {@inheritDoc}
     */
    @Override
    public CloseableIterator<Map<String, Object>> queryForIter(String sql, SqlParameterSource paramSource) throws DataAccessException {
        return queryForIter(sql, paramSource, new ColumnMapRowMapper());
    }

View Full Code Here


    return queryForObject(sql, paramMap, new SingleColumnRowMapper<T>(requiredType));
  }


  public Map<String, Object> queryForMap(String sql, SqlParameterSource paramSource) throws DataAccessException {
    return queryForObject(sql, paramSource, new ColumnMapRowMapper());
  }

View Full Code Here

  public Map<String, Object> queryForMap(String sql, SqlParameterSource paramSource) throws DataAccessException {
    return queryForObject(sql, paramSource, new ColumnMapRowMapper());
  }


  public Map<String, Object> queryForMap(String sql, Map<String, ?> paramMap) throws DataAccessException {
    return queryForObject(sql, paramMap, new ColumnMapRowMapper());
  }

View Full Code Here

  }


  public List<Map<String, Object>> queryForList(String sql, SqlParameterSource paramSource)
      throws DataAccessException {


    return query(sql, paramSource, new ColumnMapRowMapper());
  }

View Full Code Here

    /**
     * {@inheritDoc}
     */
    @Override
    public CloseableIterator<Map<String, Object>> queryForIter(String sql, SqlParameterSource paramSource) throws DataAccessException {
        return queryForIter(sql, paramSource, new ColumnMapRowMapper());
    }

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of org.springframework.jdbc.core.ColumnMapRowMapper

com.alexkasko.springjdbc.iterable.IterableNamedParameterJdbcTemplate

com.skyline.base.dao.impl.BaseDaoImpl

com.skyline.energy.provider.spring.PreparedStatementCallbackCreator

com.springsource.greenhouse.events.load.NFJSLoaderTest

com.taobao.tddl.common.jdbc.MetaDataQueryForMapHandler

com.taobao.tddl.jdbc.group.index.ThreadLocalDataSourceIndexTest

net.paoding.rose.jade.rowmapper.DefaultRowMapperFactory

org.apache.camel.component.sql.SqlConsumer

org.apache.camel.component.sql.SqlEndpoint

org.apache.camel.component.sql.SqlProducer

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.