Example usage for org.springframework.jdbc.object SqlFunction SqlFunction

Introduction

In this page you can find the example usage for org.springframework.jdbc.object SqlFunction SqlFunction.

Prototype

public SqlFunction() 

Source Link

Document

Constructor to allow use as a JavaBean.

Usage

From source file:org.springframework.jdbc.object.SqlFunctionTests.java

public void testFunction() throws SQLException {
    ctrlResultSetMetaData = MockControl.createControl(ResultSetMetaData.class);
    mockResultSetMetaData = (ResultSetMetaData) ctrlResultSetMetaData.getMock();
    mockResultSetMetaData.getColumnCount();
    ctrlResultSetMetaData.setReturnValue(1);

    mockResultSet.getMetaData();/*  w  ww .j av a2  s. com*/
    ctrlResultSet.setReturnValue(mockResultSetMetaData, 1);
    mockResultSet.next();
    ctrlResultSet.setReturnValue(true);
    mockResultSet.getObject(1);
    ctrlResultSet.setReturnValue(new Integer(14));
    mockResultSet.next();
    ctrlResultSet.setReturnValue(false);
    mockResultSet.close();
    ctrlResultSet.setVoidCallable();

    mockPreparedStatement.executeQuery();
    ctrlPreparedStatement.setReturnValue(mockResultSet);
    if (debugEnabled) {
        mockPreparedStatement.getWarnings();
        ctrlPreparedStatement.setReturnValue(null);
    }
    mockPreparedStatement.close();
    ctrlPreparedStatement.setVoidCallable();

    mockConnection.prepareStatement(FUNCTION);
    ctrlConnection.setReturnValue(mockPreparedStatement);

    replay();

    SqlFunction function = new SqlFunction();
    function.setDataSource(mockDataSource);
    function.setSql(FUNCTION);
    function.compile();

    int count = function.run();
    assertTrue("Function returned value 14", count == 14);
}

---