Examples of ColumnMapRowMapper

liquibase.executor.jvm.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.
@author Spring Framework
net.hasor.db.jdbc.core.mapper.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)
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)

Examples of liquibase.executor.jvm.ColumnMapRowMapper


        protected List<CachedRow> extract(ResultSet resultSet, final boolean informixIndexTrimHint) throws SQLException {
            List<Map> result;
            List<CachedRow> returnList = new ArrayList<CachedRow>();
            try {
                result = (List<Map>) new RowMapperResultSetExtractor(new ColumnMapRowMapper() {
                  @Override
                  protected Object getColumnValue(ResultSet rs, int index) throws SQLException {
                    Object value = super.getColumnValue(rs, index);
                    if (value != null && value instanceof String) {

View Full Code Here

Examples of net.hasor.db.jdbc.core.mapper.ColumnMapRowMapper

    //
    //
    //
    /** Create a new RowMapper for reading columns as key-value pairs. */
    protected RowMapper<Map<String, Object>> getColumnMapRowMapper() {
        return new ColumnMapRowMapper() {
            @Override
            protected Map<String, Object> createColumnMap(final int columnCount) {
                return JdbcTemplate.this.createResultsMap();
            }
        };

View Full Code Here

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

        // 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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper


    @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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

                    }
                    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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

                }
                
                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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

    
    // 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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

                }
                
                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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

  }


  @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

Examples of org.springframework.jdbc.core.ColumnMapRowMapper


    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

0 1 2 3 4 5

TOP

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.