Examples of org.springframework.jdbc.core.JdbcOperations.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[])

    String sql = "SELECT COUNT(0) FROM BAR";
    int expectedResult = 666;


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql);
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

    int arg1 = 24;
    String arg2 = "foo";


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql, new Object[]{arg1, arg2});
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

    String sql = "SELECT COUNT(0) FROM BAR";
    int expectedResult = 666;


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql);
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

    int arg1 = 24;
    String arg2 = "foo";


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForInt(sql, new Object[]{arg1, arg2});
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

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.