Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.ColumnMapRowMapper

64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
  public void test_����i() {
    JdbcTemplate jt = new JdbcTemplate(createGroupDataSource("ds0:rw, ds1:r, ds2:r, ds3:r"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(1);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds1", "select 1 from dual"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(2);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds2", "select 1 from dual"));
  }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
  public void test_�赥��in() {
    JdbcTemplate jt = new JdbcTemplate(createGroupDataSource("ds0:rwi5, ds1:ri6, ds2:ri7, ds3:ri8"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(6);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds1", "select 1 from dual"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(8);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds3", "select 1 from dual"));
  }
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
  public void test_1��ds����i() {
    JdbcTemplate jt = new JdbcTemplate(createGroupDataSource("ds0:rwi0, ds1:ri0i1, ds2:ri1, ds3:r, ds4:ri3"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(0);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds0", "select") || MockDataSource.hasTrace("", "ds1", "select"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(1);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds1", "select") || MockDataSource.hasTrace("", "ds2", "select"));

    MockDataSource.clearTrace();
    GroupDataSourceRouteHelper.executeByGroupDataSourceIndex(3);
    jt.query("select 1 from dual", new Object[] {}, new ColumnMapRowMapper());
    MockDataSource.showTrace();
    Assert.assertTrue(MockDataSource.hasTrace("", "ds3", "select") || MockDataSource.hasTrace("", "ds4", "select"));
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
  /**
   * @param tableName Сд����
   */
  private ColumnMapRowMapper getRowMapper(String tableName) {
    ColumnMapRowMapper rowMapper = rowMappers.get(tableName);
    if (rowMapper == null) {
      rowMapper = new CachedColumnMapRowMapper(tableName);
      rowMappers.putIfAbsent(tableName, rowMapper);
      return rowMappers.get(tableName);
    }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
                    }
                    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
88
89
90
91
92
93
94
95
96
97
98
                log.debug("Executing query: {}", preparedQuery);
                ResultSet rs = preparedStatement.executeQuery();
                try {
                    log.trace("Got result list from query: {}", rs);

                    RowMapperResultSetExtractor<Map<String, Object>> mapper = new RowMapperResultSetExtractor<Map<String, Object>>(new ColumnMapRowMapper());
                    List<Map<String, Object>> data = mapper.extractData(rs);

                    // create a list of exchange objects with the data
                    if (useIterator) {
                        for (Map<String, Object> item : data) {
View Full Code Here
481
482
483
484
485
486
487
488
489
490
   **/
  private RowMapper<Map<String,Object>> getColumnMapRowMapper() {
    if(getKeyType().equalsIgnoreCase(LOWER_KEY)){
      return new MiniColumnMapRowMapper();
    }else if(getKeyType().equalsIgnoreCase(UPPER_KEY)){
      return new ColumnMapRowMapper();
    }else{
      return new MiniColumnOriginalMapRowMapper();
    }
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
            }
        }
        // 返回多列的，用Bean对象、集合、映射、数组来表示每一行的
        else {
            if (rowType == Map.class) {
                rowMapper = new ColumnMapRowMapper();
            } else if (rowType.isArray()) {
                rowMapper = new ArrayRowMapper(rowType);
            } else if ((rowType == List.class) || (rowType == Collection.class)) {
                rowMapper = new ListRowMapper(modifier);
            } else if (rowType == Set.class) {
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.