Package org.springframework.jdbc.core

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

140
141
142
143
144
145
146
147
148
149
150
            schemaPrefix, schemaPrefix, schemaPrefix, key);
    Assert.assertTrue(query, jt.queryForInt(query) == 1);
    query = String
        .format("select count(*) from %sdocument d inner join %sanno_base ab on ab.document_id = d.document_id inner join %sanno_sentence s on s.anno_base_id = ab.anno_base_id where d.instance_id=%s",
            schemaPrefix, schemaPrefix, schemaPrefix, key);
    Assert.assertTrue(query, jt.queryForInt(query) > 1);
    query = String
        .format("select count(*) from %sdocument d inner join %sanno_base ab on ab.document_id = d.document_id inner join %sanno_token s on s.anno_base_id = ab.anno_base_id where d.instance_id=%s",
            schemaPrefix, schemaPrefix, schemaPrefix, key);
    Assert.assertTrue(query, jt.queryForInt(query) > 1);
  }
View Full Code Here
144
145
146
147
148
149
150
151
152
            schemaPrefix, schemaPrefix, schemaPrefix, key);
    Assert.assertTrue(query, jt.queryForInt(query) > 1);
    query = String
        .format("select count(*) from %sdocument d inner join %sanno_base ab on ab.document_id = d.document_id inner join %sanno_token s on s.anno_base_id = ab.anno_base_id where d.instance_id=%s",
            schemaPrefix, schemaPrefix, schemaPrefix, key);
    Assert.assertTrue(query, jt.queryForInt(query) > 1);
  }

}
View Full Code Here
743
744
745
746
747
748
749
750
751
752
753
        assertTrue(userTO.getPropagationTOs().isEmpty());

        Exception exception = null;
        try {
            jdbcTemplate.queryForInt("SELECT id FROM test WHERE id=?", userTO.getUsername());
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
      }
    } finally {
      DataSourceUtils.releaseConnection(con, ds);
    }

    int count = jdbcTemplate.queryForInt("select count(*) from records");
    Assert.assertEquals("Did not load the data correctly", 200, count);

    stopTunnelServer();
    removeService(VCAP_MYSQL_SERVICE);
    logger.info("Time elapsed: " + (System.currentTimeMillis() - start) / 1000.0d + " sec");
View Full Code Here
214
215
216
217
218
219
220
221
222
223
224
      }
    } finally {
      DataSourceUtils.releaseConnection(con, ds);
    }

    int count = jdbcTemplate.queryForInt("select count(*) from records");
    Assert.assertEquals("Did not load the data correctly", 200, count);

    stopTunnelServer();
    removeService(VCAP_POSTGRES_SERVICE);
    logger.info("Time elapsed: " + (System.currentTimeMillis() - start) / 1000.0d + " sec");
View Full Code Here
684
685
686
687
688
689
690
691
692
693
694
        assertTrue(userTO.getPropagationTOs().isEmpty());

        Exception exception = null;
        try {
            jdbcTemplate.queryForInt("SELECT id FROM test WHERE id=?", userTO.getUsername());
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);
View Full Code Here
685
686
687
688
689
690
691
692
693
694
695
        assertTrue(userTO.getPropagationTOs().isEmpty());

        Exception exception = null;
        try {
            jdbcTemplate.queryForInt("SELECT id FROM test WHERE id=?", userTO.getUsername());
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
        JdbcTemplate jt = JuConnUtils.asJdbcTemplate(conn);

        jt.execute(String.format("DROP SCHEMA `%s`", schemaInfo.getName()));
       
        for (String user : users) {
          int cnt = jt.queryForInt(String.format("select count(*) from mysql.user where user = '%s'", user));
          if (cnt > 0) {
            jt.execute(String.format("DROP USER `%s`", user));
          }
        }
      }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
   */
  int internalGetRecentMEBEntries(final Integer userId)
  {
    final JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    try {
      int counter = jdbc.queryForInt("SELECT COUNT(*) FROM t_meb_entry where owner_fk=" + userId + " and status='RECENT'");
      if (accessChecker.isLoggedInUserMemberOfAdminGroup() == true) {
        counter += jdbc.queryForInt("SELECT COUNT(*) FROM t_meb_entry where owner_fk is null");
      }
      return counter;
    } catch (final Exception ex) {
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
  {
    final JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    try {
      int counter = jdbc.queryForInt("SELECT COUNT(*) FROM t_meb_entry where owner_fk=" + userId + " and status='RECENT'");
      if (accessChecker.isLoggedInUserMemberOfAdminGroup() == true) {
        counter += jdbc.queryForInt("SELECT COUNT(*) FROM t_meb_entry where owner_fk is null");
      }
      return counter;
    } catch (final Exception ex) {
      log.error(ex.getMessage(), ex);
      return 0;
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.