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)

        // Make sure it's properly encoded
        return "sql:" + UnsafeUriCharactersEncoder.encode(query);
    }


    protected List<Map<String, Object>> queryForList(ResultSet rs) throws SQLException {
        ColumnMapRowMapper rowMapper = new ColumnMapRowMapper();
        RowMapperResultSetExtractor<Map<String, Object>> mapper = new RowMapperResultSetExtractor<Map<String, Object>>(rowMapper);
        List<Map<String, Object>> data = mapper.extractData(rs);
        return data;
    }

View Full Code Here


    @SuppressWarnings("unchecked")
    protected Object queryForObject(ResultSet rs) throws SQLException {
        Object result = null;
        if (outputClass == null) {
            RowMapper rowMapper = new ColumnMapRowMapper();
            RowMapperResultSetExtractor<Map<String, Object>> mapper = new RowMapperResultSetExtractor<Map<String, Object>>(rowMapper);
            List<Map<String, Object>> data = mapper.extractData(rs);
            if (data.size() > 1) {
                throw new SQLDataException("Query result not unique for outputType=SelectOne. Got " + data.size() +  " count instead.");
            } else if (data.size() == 1) {

View Full Code Here

                    }
                    exchange.getIn().setHeader(SqlConstants.SQL_UPDATE_COUNT, total);
                } else {
                    boolean isResultSet = ps.execute();
                    if (isResultSet) {
                        RowMapperResultSetExtractor<Map<String, Object>> mapper = new RowMapperResultSetExtractor<Map<String, Object>>(new ColumnMapRowMapper());
                        List<Map<String, Object>> result = 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

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

View Full Code Here

    
    // 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
    Collection<Map<?,?>> results = 
      (Collection<Map<?,?>>) template.query(sqlQuery, new ColumnMapRowMapper());
    
    // build the model
    Map<Object,Object> model = new HashMap<Object,Object>();
    model.put("results", results);

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

  }


  @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


    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

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.