com.mockrunner.example.jdbc.OrderDBTest Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of mockrunner-jdk1.3-j2ee1.3 Show documentation

Mockrunner is a lightweight framework for unit testing applications in the J2EE environment. It supports servlets, filters, tag classes and Struts actions. It includes a JDBC a JMS and a JCA test framework and can be used to test EJB based applications.

The newest version!

package com.mockrunner.example.jdbc;

import java.sql.Date;
import java.util.List;

import com.mockrunner.jdbc.BasicJDBCTestCaseAdapter;
import com.mockrunner.jdbc.CallableStatementResultSetHandler;
import com.mockrunner.mock.jdbc.MockResultSet;

/**
 * Example test for {@link OrderDB}. Demonstrates the usage of 
 * {@link com.mockrunner.jdbc.JDBCTestModule} 
 * and {@link com.mockrunner.jdbc.BasicJDBCTestCaseAdapter} with
 * stored procdures.
 */
public class OrderDBTest extends BasicJDBCTestCaseAdapter
{
    private CallableStatementResultSetHandler statementHandler;
    
    protected void setUp() throws Exception
    {
        super.setUp();
        statementHandler = getJDBCMockObjectFactory().getMockConnection().getCallableStatementResultSetHandler();
    }
    
    private void prepareResult()
    {
        MockResultSet result = statementHandler.createResultSet();
        result.addColumn("name", new String[] {"MyName1", "MyName2", "MyName3"});
        statementHandler.prepareResultSet("call getnames", result);
    }
    
    public void testCallStoredProc() throws Exception
    {
        prepareResult();
        List result = OrderDB.getNames(Date.valueOf("2004-01-01"));
        assertEquals("MyName1", result.get(0));
        assertEquals("MyName2", result.get(1));
        assertEquals("MyName3", result.get(2));
        verifyCallableStatementParameter("call getnames", 1, Date.valueOf("2004-01-01"));
        verifyCallableStatementClosed("call getnames");
        verifyAllResultSetsClosed();
        verifyConnectionClosed();
    }
}