How to test simple java method using StrutsTestCase

[Sree Reddy]

Hi,
I have got a method in java file like this:
public boolean inserDB(String name, String Address){
// Gets the DB connection
// insers one record into Database and returns true/false
return boolean;
}
How can i write a test scrpt in StrutsTestCase?
We have got many similar methods, to perform all sorts of DB operations.
Now we need to write automated unit test cases. We thought of using StutsTestCase frame work.
Can any one help me.
Thanks,
Sripathi.

[Lasse Koskela]

How about separating the two "comments" into separate methods so that you can replace the JDBC Connection object for testing purposes?
Something like this:

public class ClassUnderTest {
    public boolean insertDB(String name, String address) {
        Connection connection = getConnection();
        return insertDB(connection, name, address);
    }
    Connection getConnection() {
        Connection connection = ...
        return connection;
    }
    boolean inserDB(Connection connection, String name, String Address) {
    // insers one record into Database and returns true/false
        return boolean;
    }
}

and

public MyTest extends TestCase {
    public void testInsertDB() {
        // use a mock implementation of the java.sql.Connection interface
        // (take a look at MockObjects.com, EasyMock.org, or JMock.org)
        MockConnection connection = createMockConnection();
        
        ClassUnderTest target = new ClassUnderTest();
        boolean result = target.insertDB(connection, "Lasse", "Home Street 1");
        assertTrue(result);
        // verify that the mock Connection object received the expected
        // number of method calls from the ClassUnderTest
        connection.verify();
    }
}

[Sree Reddy]

Thank you very much,
I will try to follow the same.
Bye,
Sree