Examples of org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations.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)

    MockControl mc = MockControl.createControl(NamedParameterJdbcOperations.class);
    NamedParameterJdbcOperations npjo = (NamedParameterJdbcOperations) mc.getMock();
    Map args = new HashMap(2);
    args.put("id", arg1);
    args.put("xy", arg2);
    npjo.queryForInt(sql, args);
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(npjo);

View Full Code Here

    String arg2 = "foo";


    MockControl mc = MockControl.createControl(NamedParameterJdbcOperations.class);
    NamedParameterJdbcOperations npjo = (NamedParameterJdbcOperations) mc.getMock();
    SqlParameterSource args = new MapSqlParameterSource().addValue("id", arg1).addValue("xy", arg2);
    npjo.queryForInt(sql, args);
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(npjo);

View Full Code Here

    MockControl mc = MockControl.createControl(NamedParameterJdbcOperations.class);
    NamedParameterJdbcOperations npjo = (NamedParameterJdbcOperations) mc.getMock();
    Map args = new HashMap(2);
    args.put("id", arg1);
    args.put("xy", arg2);
    npjo.queryForInt(sql, args);
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(npjo);

View Full Code Here

    String arg2 = "foo";


    MockControl mc = MockControl.createControl(NamedParameterJdbcOperations.class);
    NamedParameterJdbcOperations npjo = (NamedParameterJdbcOperations) mc.getMock();
    SqlParameterSource args = new MapSqlParameterSource().addValue("id", arg1).addValue("xy", arg2);
    npjo.queryForInt(sql, args);
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(npjo);

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.