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

Class org.springframework.jdbc.core.JdbcOperations

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

org.springframework.jdbc.core.JdbcOperations.queryForObject()
Execute a query given static SQL, mapping a single result row to a Java object via a RowMapper.
Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForObject method with null as argument array. @param sql SQL query to execute @param rowMapper object that will map one object per row @return the single mapped object @throws IncorrectResultSizeDataAccessException if the query does notreturn exactly one row @throws DataAccessException if there is any problem executing the query @see #queryForObject(String,Object[],RowMapper)

    String sql = "SELECT SYSDATE FROM DUAL";
    Date expectedResult = new Date();


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);
    Date result = jth.queryForObject(sql, Date.class);

View Full Code Here

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


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForObject(sql, new Object[]{arg1, arg2, arg3}, Date.class);
    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.queryForObject(sql, new Object[]{arg1, arg2, arg3}, Date.class);
    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.queryForObject(sql, new Object[]{arg1, arg2, arg3}, Date.class);
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

      }
    };


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);
    Date result = jth.queryForObject(sql, rm);

View Full Code Here

      }
    };


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

      }
    };


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

    String sql = "SELECT SYSDATE FROM DUAL";
    Date expectedResult = new Date();


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


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);
    Date result = jth.queryForObject(sql, Date.class);

View Full Code Here

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


    MockControl mc = MockControl.createControl(JdbcOperations.class);
    JdbcOperations jo = (JdbcOperations) mc.getMock();
    jo.queryForObject(sql, new Object[]{arg1, arg2, arg3}, Date.class);
    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.queryForObject(sql, new Object[]{arg1, arg2, arg3}, Date.class);
    mc.setDefaultMatcher(new ArrayMatcher());
    mc.setReturnValue(expectedResult);
    mc.replay();


    SimpleJdbcTemplate jth = new SimpleJdbcTemplate(jo);

View Full Code Here

0 1 2

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.