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)

  }


  @Override
  public SqlParameter createDefaultOutParameter(String parameterName, CallParameterMetaData meta) {
    if (meta.getSqlType() == Types.OTHER && REF_CURSOR_NAME.equals(meta.getTypeName())) {
      return new SqlOutParameter(parameterName, getRefCursorSqlType(), new ColumnMapRowMapper());
    }
    else {
      return super.createDefaultOutParameter(parameterName, meta);
    }
  }

View Full Code Here

  }


  @Override
  public SqlParameter createDefaultOutParameter(String parameterName, CallParameterMetaData meta) {
    if (meta.getSqlType() == Types.OTHER && "refcursor".equals(meta.getTypeName())) {
      return new SqlOutParameter(parameterName, getRefCursorSqlType(), new ColumnMapRowMapper());
    }
    else {
      return super.createDefaultOutParameter(parameterName, meta);
    }
  }

View Full Code Here

  public Object queryForObject(String sql, Map paramMap, Class requiredType) throws DataAccessException {
    return queryForObject(sql, paramMap, new SingleColumnRowMapper(requiredType));
  }


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

View Full Code Here

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


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

View Full Code Here

  public List queryForList(String sql, Map paramMap, Class elementType) throws DataAccessException {
    return queryForList(sql, new MapSqlParameterSource(paramMap), elementType);
  }


  public List queryForList(String sql, SqlParameterSource paramSource) throws DataAccessException {
    return query(sql, paramSource, new ColumnMapRowMapper());
  }

View Full Code Here

  }


  @Override
  public SqlParameter createDefaultOutParameter(String parameterName, CallParameterMetaData meta) {
    if (meta.getSqlType() == Types.OTHER && REF_CURSOR_NAME.equals(meta.getTypeName())) {
      return new SqlOutParameter(parameterName, getRefCursorSqlType(), new ColumnMapRowMapper());
    }
    else {
      return super.createDefaultOutParameter(parameterName, meta);
    }
  }

View Full Code Here

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


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

View Full Code Here

  public List queryForList(String sql, Map paramMap, Class elementType) throws DataAccessException {
    return queryForList(sql, new MapSqlParameterSource(paramMap), elementType);
  }


  public List queryForList(String sql, SqlParameterSource paramSource) throws DataAccessException {
    return query(sql, paramSource, new ColumnMapRowMapper());
  }

View Full Code Here

  public Object queryForObject(String sql, Map paramMap, Class requiredType) throws DataAccessException {
    return queryForObject(sql, paramMap, new SingleColumnRowMapper(requiredType));
  }


  public Map queryForMap(String sql, SqlParameterSource paramSource) throws DataAccessException {
    return (Map) queryForObject(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

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.