List of queryForInt() Examples

Examples of queryForInt()

liquibase.executor.Executor.queryForInt()
net.hasor.db.jdbc.core.JdbcTemplate.queryForInt()
org.springframework.jdbc.core.JdbcOperations.queryForInt()
Execute a query that results in an int value, given static SQL.
Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array.
This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in an int value. @param sql SQL query to execute @return the int value, or 0 in case of SQL NULL @throws IncorrectResultSizeDataAccessException if the query does not returnexactly one row, or does not return exactly one column in that row @throws DataAccessException if there is any problem executing the query @see #queryForInt(String,Object[])
org.springframework.jdbc.core.JdbcTemplate.queryForInt()
org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations.queryForInt()
Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in an int value.
The query is expected to be a single row/single column query that results in an int value. @param sql SQL query to execute @param paramSource container of arguments to bind to the query @return the int value, or 0 in case of SQL NULL @throws org.springframework.dao.IncorrectResultSizeDataAccessException if the query does not returnexactly one row, or does not return exactly one column in that row @throws org.springframework.dao.DataAccessException if the query fails @see org.springframework.jdbc.core.JdbcTemplate#queryForInt(String)
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForInt()

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


        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

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

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

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

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

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


        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

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


        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

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

        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

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

   */
  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

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

  {
    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

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

            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

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

            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

0 1 2 3 4 5

TOP

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.