Examples of org.springframework.jdbc.core.JdbcOperations.queryForLong()

Class org.springframework.jdbc.core.JdbcOperations

Examples of org.springframework.jdbc.core.JdbcOperations.queryForLong()

org.springframework.jdbc.core.JdbcOperations.queryForLong()
Execute a query that results in a long 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 queryForLong 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 a long value. @param sql SQL query to execute @return the long 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 #queryForLong(String,Object[])

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


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);
    long result = jth.queryForLong(sql);

View Full Code Here

    String arg2 = "foo";
    Object arg3 = new Object();


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

    String arg2 = "foo";
    Object arg3 = new Object();


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

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


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);
    long result = jth.queryForLong(sql);

View Full Code Here

    String arg2 = "foo";
    Object arg3 = new Object();


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

    String arg2 = "foo";
    Object arg3 = new Object();


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

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.