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
28
29 public class ArrayListHandlerTest extends BaseTestCase {
30
31 public void testEmptyResultSetHandle() throws SQLException {
32 final ResultSetHandler<List<Object[]>> h = new ArrayListHandler();
33 final List<Object[]> results = h.handle(this.emptyResultSet);
34
35 assertNotNull(results);
36 assertTrue(results.isEmpty());
37 }
38
39 public void testHandle() throws SQLException {
40 final ResultSetHandler<List<Object[]>> h = new ArrayListHandler();
41 final List<Object[]> results = h.handle(this.rs);
42
43 assertNotNull(results);
44 assertEquals(ROWS, results.size());
45
46 final Iterator<Object[]> iter = results.iterator();
47 assertTrue(iter.hasNext());
48 Object[] row = iter.next();
49 assertEquals(COLS, row.length);
50 assertEquals("1", row[0]);
51 assertEquals("2", row[1]);
52 assertEquals("THREE", row[2]);
53
54 assertTrue(iter.hasNext());
55 row = iter.next();
56 assertEquals(COLS, row.length);
57
58 assertEquals("4", row[0]);
59 assertEquals("5", row[1]);
60 assertEquals("SIX", row[2]);
61
62 assertFalse(iter.hasNext());
63 }
64
65 }