Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.ResultSetHandler


* ColumnListHandlerTest
*/
public class ColumnListHandlerTest extends BaseTestCase {

    public void testHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler();

        List results = (List) h.handle(this.rs);

        assertNotNull(results);
        assertEquals(ROWS, results.size());

        assertEquals("1", results.get(0));
View Full Code Here


        assertEquals("1", results.get(0));
        assertEquals("4", results.get(1));
    }

    public void testColumnIndexHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler(2);
        List results = (List) h.handle(this.rs);

        assertNotNull(results);
        assertEquals(ROWS, results.size());

        assertEquals("2", results.get(0));
View Full Code Here

        assertEquals("2", results.get(0));
        assertEquals("5", results.get(1));
    }

    public void testColumnNameHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler("Three");
        List results = (List) h.handle(this.rs);

        assertNotNull(results);
        assertEquals(ROWS, results.size());

        assertEquals("3", results.get(0));
View Full Code Here

        assertEquals("3", results.get(0));
        assertEquals("6", results.get(1));
    }

    public void testEmptyResultSetHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler();
        List results = (List) h.handle(this.emptyResultSet);

        assertNotNull(results);
        assertTrue(results.isEmpty());
    }
View Full Code Here

import org.apache.commons.dbutils.ResultSetHandler;

public class ScalarHandlerTest extends BaseTestCase {

    public void testHandle() throws SQLException {
        ResultSetHandler h = new ScalarHandler();
        Object results = h.handle(this.rs);
        assertNotNull(results);
        assertEquals("1", results);
    }
View Full Code Here

        assertNotNull(results);
        assertEquals("1", results);
    }

    public void testColumnIndexHandle() throws SQLException {
        ResultSetHandler h = new ScalarHandler(2);
        Object results = h.handle(this.rs);
        assertNotNull(results);
        assertEquals("2", results);
    }
View Full Code Here

        assertNotNull(results);
        assertEquals("2", results);
    }

    public void testColumnNameHandle() throws SQLException {
        ResultSetHandler h = new ScalarHandler("THree");
        Object results = h.handle(this.rs);
        assertNotNull(results);
        assertEquals("3", results);
    }
View Full Code Here

        assertNotNull(results);
        assertEquals("3", results);
    }

    public void testEmptyResultSetHandle() throws SQLException {
        ResultSetHandler h = new ScalarHandler();
        Object results = h.handle(this.emptyResultSet);
        assertNull(results);
    }
View Full Code Here

* BeanHandlerTest
*/
public class BeanHandlerTest extends BaseTestCase {

  public void testHandle() throws SQLException {
    ResultSetHandler h = new BeanHandler(TestBean.class);
        TestBean results = (TestBean) h.handle(this.rs);
       
    assertNotNull(results);
    assertEquals("1", results.getOne());
    assertEquals("2", results.getTwo());
    assertEquals("3", results.getThree());
View Full Code Here

    assertEquals("3", results.getThree());
        assertEquals("not set", results.getDoNotSet());
  }
   
    public void testEmptyResultSetHandle() throws SQLException {
        ResultSetHandler h = new BeanHandler(TestBean.class);
        TestBean results = (TestBean) h.handle(this.emptyResultSet);
       
        assertNull(results);
    }
View Full Code Here

TOP

Related Classes of org.apache.commons.dbutils.ResultSetHandler

Copyright © 2018 www.massapicom. All rights reserved.
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.