Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

58
59
60
61
62
63
64
65
66
67
68
                }
               
                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
74
75
76
77
78
79
80
81
82
83
84
                    }
                    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
64
65
66
67
68
69
70
71
72
73
74
                }
               
                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
150
151
152
153
154
155
156
157
158
159
160
        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
83
84
85
86
87
88
89
90
91
92
93
          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
61
62
63
64
65
66
67
68
69
70
71
                }
               
                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
251
252
253
254
255
256
257
258
259
260
        // 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
261
262
263
264
265
266
267
268
269
270
271
    @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
71
72
73
74
75
76
77
78
79
80
81
                    }
                    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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
  private void assertRowCount(String tableName, int rowCount) {
    assertEquals(tableName, rowCount, jdbcTemplate.queryForInt("select count(*) from " + tableName));
  }

  private void assertEventData(String title, String timeZone, String startTime, String endTime, String slug) {
    Map<String, Object> externalEventData = jdbcTemplate.queryForObject("select event, sourceId, source from ExternalEvent where sourceId=? and source='NFJS'", new ColumnMapRowMapper(), SHOW_ID);
    Long eventId = (Long) externalEventData.get("event");
    assertEquals(Long.valueOf(1), eventId);
    assertEquals(Long.valueOf(SHOW_ID), externalEventData.get("sourceId"));
    assertEquals("NFJS", externalEventData.get("source"));
   
    Map<String, Object> eventData = jdbcTemplate.queryForObject("select id,  title, timeZone, startTime, endTime, slug, description, memberGroup from Event where id=?", new ColumnMapRowMapper(), eventId);
    assertEquals(eventId, eventData.get("id"));
    assertEquals(title, eventData.get("title"));
    assertEquals(timeZone, eventData.get("timeZone"));
    assertEquals(startTime, eventData.get("startTime").toString());
    assertEquals(endTime, eventData.get("endTime").toString());
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.