Package org.springframework.jdbc.core

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

209
210
211
212
213
214
215
216
217
218
219
            counter[0]++;
          }
          return null;
        }
      });
      int no = jdbc.queryForInt("select count(*)" + sql);
      if (no > 0) {
        log.warn("" + no + " of data base history entries aren't fixed.");
      }
      sql = " from t_history_property_delta where property_type like '%_$$_javassist_%'";
      jdbc.query("select id, property_type" + sql, new ResultSetExtractor() {
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
            counter[0]++;
          }
          return null;
        }
      });
      no = jdbc.queryForInt("select count(*)" + sql);
      if (no > 0) {
        log.warn("" + no + " of data base history entries aren't fixed.");
      }
    } catch (final Exception ex) {
      log.error(ex.getMessage(), ex);
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
    log.info("Initializing StatisticsCache ...");
    numberOfEntitiesMap = new HashMap<Class< ? extends BaseDO< ? >>, Integer>();
    final JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    for (final RegistryEntry registryEntry : Registry.instance().getOrderedList()) {
      try {
        final int number = jdbc.queryForInt("SELECT COUNT(*) FROM " + HibernateUtils.getDBTableName(registryEntry.getDOClass()));
        numberOfEntitiesMap.put(registryEntry.getDOClass(), number);
      } catch (final Exception ex) {
        log.error(ex.getMessage(), ex);
        continue;
      }
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
  public boolean isAdminUser(final PFUserDO user)
  {
    final JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    String sql = "select pk from t_group where name=?";
    final int adminGroupId = jdbc.queryForInt(sql, new Object[] { ProjectForgeGroup.ADMIN_GROUP.getKey()});
    sql = "select count(*) from t_group_user where group_id=? and user_id=?";
    final int count = jdbc.queryForInt(sql, new Object[] { adminGroupId, user.getId()});
    if (count != 1) {
      log.info("Admin login for maintenance (data-base update) failed for user '"
          + user.getUsername()
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
  {
    final JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    String sql = "select pk from t_group where name=?";
    final int adminGroupId = jdbc.queryForInt(sql, new Object[] { ProjectForgeGroup.ADMIN_GROUP.getKey()});
    sql = "select count(*) from t_group_user where group_id=? and user_id=?";
    final int count = jdbc.queryForInt(sql, new Object[] { adminGroupId, user.getId()});
    if (count != 1) {
      log.info("Admin login for maintenance (data-base update) failed for user '"
          + user.getUsername()
          + "' (user not member of admin group).");
      return false;
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
   */
  int internalGetOpenEntries(final Integer userId)
  {
    final JdbcTemplate jdbc = new JdbcTemplate(dataSource);
    try {
      return jdbc.queryForInt("SELECT COUNT(*) FROM "
          + table.getName()
          + " where assignee_fk="
          + userId
          + " and recent=true and deleted=false");
    } catch (final Exception ex) {
View Full Code Here
740
741
742
743
744
745
746
747
748
749
750
        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
252
253
254
255
256
257
258
259
260
261
262
    String configName = "";
    String testSql = TAtomDataSourceUnitTest.TEST_SQL;
    configName = dbType;
    TAtomDataSource tAtomDataSource = createTAtomDataSource(appName, dbKey, configName);
    JdbcTemplate jtp = new JdbcTemplate(tAtomDataSource);
    int actual = jtp.queryForInt(testSql);
    Assert.assertEquals(actual, 1);
    //���ô����IP��������
    //ȫ������
    String globaStr = PropLoadTestUtil.loadPropFile2String("conf/" + configName + "/globa.properties");
    MockServer.setConfigInfo(TAtomConstants.getGlobalDataId(dbKey), globaStr);
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
    MockServer.setConfigInfo(passwdDataId, PropLoadTestUtil.convertProp2Str(change.doChange(passwdProp)));
    Thread.sleep(1200);
    //�ڴ����ִ���
    boolean result = false;
    try {
      actual = jtp.queryForInt(testSql);
    } catch (Throwable e) {
      result = true;
    }
    Assert.assertTrue(result);
    MockServer.setConfigInfo(
View Full Code Here
282
283
284
285
286
287
288
289
290
291
292
        passwdDataId,
        PropLoadTestUtil.convertProp2Str(restore.doChange(PropLoadTestUtil.loadPropFromFile("conf/"
            + configName + "/psswd.properties"))));
    Thread.sleep(1200);
    //�ڴ��������
    actual = jtp.queryForInt(testSql);
    Assert.assertEquals(actual, 1);
    tAtomDataSource.destroyDataSource();

  }
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.