Examples of org.springframework.jdbc.core.JdbcOperations

org.springframework.jdbc.core.JdbcOperations
Interface specifying a basic set of JDBC operations. Implemented by {@link JdbcTemplate}. Not often used directly, but a useful option to enhance testability, as it can easily be mocked or stubbed.
Alternatively, the standard JDBC infrastructure can be mocked. However, mocking this interface constitutes significantly less work. As an alternative to a mock objects approach to testing data access code, consider the powerful integration testing support provided in the org.springframework.test package, shipped in spring-mock.jar. @author Rod Johnson @author Juergen Hoeller @see JdbcTemplate

  public void testQueryForIntWithoutArgs() {
    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);

View Full Code Here

    int expectedResult = 666;
    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);

View Full Code Here

  public void testQueryForLongWithoutArgs() {
    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

    double arg1 = 24.7;
    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

    double arg1 = 24.7;
    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

  public void testQueryForObjectWithoutArgs() throws Exception {
    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

    double arg1 = 24.7;
    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

    double arg1 = 24.7;
    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

    double arg1 = 24.7;
    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

        return new Date();
      }
    };


    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

0 1 2 3 4

TOP

Related Classes of org.springframework.jdbc.core.JdbcOperations

com.opengamma.masterdb.batch.AbstractDbBatchMasterWorkerTest

com.opengamma.masterdb.config.AbstractDbConfigMasterWorkerTest

com.opengamma.masterdb.exchange.AbstractDbExchangeMasterWorkerTest

com.opengamma.masterdb.historicaltimeseries.AbstractDbHistoricalTimeSeriesMasterWorkerTest

com.opengamma.masterdb.holiday.AbstractDbHolidayMasterWorkerTest

com.opengamma.masterdb.org.AbstractDbOrganizationMasterWorkerTest

com.opengamma.masterdb.portfolio.AbstractDbPortfolioMasterWorkerTest

com.opengamma.masterdb.position.AbstractDbPositionMasterWorkerTest

com.opengamma.masterdb.security.AbstractDbSecurityMasterWorkerTest

com.opengamma.masterdb.user.AbstractDbUserMasterWorkerTest

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.