Package org.springframework.jdbc.core

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

208
209
210
211
212
213
214
215
216
217
218
      public Void doInTransaction(TransactionStatus status) {
        template.queryForList("select ham from foo");
        tt2.execute(new TransactionCallback<Void>() {
          @Override
          public Void doInTransaction(TransactionStatus status) {
            template.queryForList("select 1 from eggs");
            return null;
          }
        });
        template.queryForList("select more, ham from foo");
        return null;
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
          public Void doInTransaction(TransactionStatus status) {
            template.queryForList("select 1 from eggs");
            return null;
          }
        });
        template.queryForList("select more, ham from foo");
        return null;
      }
    });
    tt.execute(new TransactionCallback<Void>() {
      @Override
View Full Code Here
219
220
221
222
223
224
225
226
227
228
229
      }
    });
    tt.execute(new TransactionCallback<Void>() {
      @Override
      public Void doInTransaction(TransactionStatus status) {
        template.queryForList("select spam from ham");
        return null;
      }
    });
    csds.stopCloseSuppression(connection);
    DataSourceUtils.releaseConnection(connection, csds);
View Full Code Here
225
226
227
228
229
230
231
232
233
234
235
        return null;
      }
    });
    csds.stopCloseSuppression(connection);
    DataSourceUtils.releaseConnection(connection, csds);
    template.queryForList("select egg from bar");

  }

  @Test(expected = IllegalArgumentException.class)
  public void delegateIsRequired() throws Exception {
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
   
    this.connUtil.doWork(new DbWork() {
      @Override
      public void execute(Connection conn) {
        JdbcTemplate jt = JuConnUtils.asJdbcTemplate(conn);
        res.setValue(jt.queryForList(sql, listType));
      }
    });
   
    return res.getValue();
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
      @Override
      public void execute(Connection conn) {
        JdbcTemplate jt = JuConnUtils.asJdbcTemplate(conn);
       
        // Reset autoincrement values
        List<Map<String, Object>> res = jt.queryForList("select c.TABLE_NAME, c.COLUMN_NAME " +
          "from information_schema.columns c " +
          "where c.EXTRA='auto_increment'"); //c.TABLE_NAME='Player'"
               
        for (Map<String, Object> row : res) {
          String tableName = row.get("TABLE_NAME").toString();
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
   */
  public List<DatabaseUpdateDO> getUpdateHistory()
  {
    accessCheck(false);
    final JdbcTemplate jdbc = new JdbcTemplate(getDataSource());
    final List<Map<String, Object>> dbResult = jdbc.queryForList("select * from t_database_update order by update_date desc");
    final List<DatabaseUpdateDO> result = new ArrayList<DatabaseUpdateDO>();
    for (final Map<String, Object> map : dbResult) {
      final DatabaseUpdateDO entry = new DatabaseUpdateDO();
      entry.setUpdateDate((Date) map.get("update_date"));
      entry.setRegionId((String) map.get("region_id"));
View Full Code Here
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
        assertFalse(userService.read(3L).getResources().contains(RESOURCE_NAME_TESTDB2));
        assertFalse(userService.read(4L).getResources().contains(RESOURCE_NAME_TESTDB2));
        assertTrue(userService.read(5L).getResources().contains(RESOURCE_NAME_TESTDB2));

        final JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);
        assertEquals(0, jdbcTemplate.queryForList("SELECT ID FROM test2 WHERE ID='puccini'").size());

        // ------------------------------------------
        // Unmatching --> Assign --> dryRuyn
        // ------------------------------------------
        execSyncTask(13L, 50, true);
View Full Code Here
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
        // ------------------------------------------
        // Unmatching --> Assign --> dryRuyn
        // ------------------------------------------
        execSyncTask(13L, 50, true);
        assertEquals(0, jdbcTemplate.queryForList("SELECT ID FROM test2 WHERE ID='vivaldi'").size());
        assertFalse(userService.read(3L).getResources().contains(RESOURCE_NAME_TESTDB2));
        // ------------------------------------------

        final Set<Long> pushTaskIds = new HashSet<Long>();
        pushTaskIds.add(13L);
View Full Code Here
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
        execSyncTasks(pushTaskIds, 50, false);

        // ------------------------------------------
        // Unatching --> Ignore
        // ------------------------------------------
        assertEquals(1, jdbcTemplate.queryForList("SELECT ID FROM test2 WHERE ID='verdi'").size());
        assertFalse(userService.read(2L).getResources().contains(RESOURCE_NAME_TESTDB2));
        // ------------------------------------------

        // ------------------------------------------
        // Unmatching --> Assign
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.