List of queryForInt() Examples

Examples of 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()


        connection = dataSource.getConnection();
        strategy.recordMigration(DatabaseType.H2, connection, v2, new Date(), 231);
        connection.close();


        assertThat(jdbcTemplate.queryForInt("select count(*) from " + TABLE_NAME), is(2));


        connection = dataSource.getConnection();
        Set<String> appliedMigrations = strategy.appliedMigrations(DatabaseType.H2, connection);
        assertThat(appliedMigrations, hasSize(2));
        assertThat(appliedMigrations, hasItems(v1, v2));

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.

Examples of queryForInt()

Examples of org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForInt()