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 org.springframework.jdbc.core.ColumnMapRowMapper

  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

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

                }
                
                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

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

        generatedKeys.clear();
        ResultSet keys = ps.getGeneratedKeys();
        if (keys != null) {
          try {
            RowMapperResultSetExtractor<Map<String, Object>> rse = new RowMapperResultSetExtractor<Map<String, Object>>(
                new ColumnMapRowMapper(), rows.length);
            generatedKeys.addAll(rse.extractData(keys));
          } finally {
            JdbcUtils.closeResultSet(keys);
          }
        }

View Full Code Here

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

          ResultSet keys = ps.getGeneratedKeys();
          if (keys != null) {
            try {
              RowMapperResultSetExtractor<Map<String, Object>> rse = 
                new RowMapperResultSetExtractor<Map<String, Object>>(
                  new ColumnMapRowMapper(), rows.length);
              generatedKeys.addAll(rse.extractData(keys));
            } finally {
              JdbcUtils.closeResultSet(keys);
            }
          }

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

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

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.