1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 package org.apache.commons.dbutils.handlers;
18
19 import java.sql.SQLException;
20 import java.util.Iterator;
21 import java.util.List;
22
23 import org.apache.commons.dbutils.BaseTestCase;
24 import org.apache.commons.dbutils.ResultSetHandler;
25
26 /**
27 * ArrayListHandlerTest
28 */
29 public class ArrayListHandlerTest extends BaseTestCase {
30
31 /**
32 * Constructor for ArrayListHandlerTest.
33 */
34 public ArrayListHandlerTest(String name) {
35 super(name);
36 }
37
38 public void testHandle() throws SQLException {
39 ResultSetHandler h = new ArrayListHandler();
40 List results = (List) h.handle(this.rs);
41
42 assertNotNull(results);
43 assertEquals(ROWS, results.size());
44
45 Iterator iter = results.iterator();
46 Object[] row = null;
47 while (iter.hasNext()) {
48 row = (Object[]) iter.next();
49 assertEquals(COLS, row.length);
50 }
51
52 assertEquals("4", row[0]);
53 assertEquals("5", row[1]);
54 assertEquals("6", row[2]);
55 }
56
57 public void testEmptyResultSetHandle() throws SQLException {
58 ResultSetHandler h = new ArrayListHandler();
59 List results = (List) h.handle(this.emptyResultSet);
60
61 assertNotNull(results);
62 assertTrue(results.isEmpty());
63 }
64
65 }