Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.JdbcTemplate.query()

57
58
59
60
61
62
63
64
65
66
67
  }

  public List<Node> loadAll() {
    JdbcTemplate t = getJdbcTemplate();
    ArrayList<Node> results = new ArrayList<Node>();
    for (Object result : t.query("SELECT * FROM node_metadata",
        new NodeRowMapper())) {
      results.add((Node)result);
    }
    return results;
  }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
  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);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    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"));
  }

  @Test
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
  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);
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
    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"));
  }

  @Test
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
  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);
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
    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);
View Full Code Here
138
139
140
141
142
143
144
145
146
147
    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
112
113
114
115
116
117
118
119
120
121
122
  }

  public <T> List<T> loadData(DataSource dataSource, final String query,
      final RowMapper<T> mapper, final Object... queryParams) {
    final JdbcTemplate select = new JdbcTemplate(dataSource);
    return select.query(query, queryParams, mapper);
  }

  @Override
  public String getName() {
    // TODO Auto-generated method stub
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
 
  public Set<Object> queryForSet(String dataSourceBean, String sql) {
    DataSource dataSource = beanFactory.getBean(dataSourceBean, DataSource.class);
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    final Set<Object> result = new HashSet<Object>();
    jdbcTemplate.query(sql, new RowCallbackHandler(){
      @Override
      public void processRow(ResultSet rs) throws SQLException {
        Object value = rs.getObject(1);
        if (value == null) return;
        result.add(value);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.