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 import java.util.Map;
23
24 import org.apache.commons.dbutils.BaseTestCase;
25 import org.apache.commons.dbutils.ResultSetHandler;
26
27 /**
28 * MapListHandlerTest
29 */
30 public class MapListHandlerTest extends BaseTestCase {
31
32 /**
33 * Constructor for MapListHandlerTest.
34 */
35 public MapListHandlerTest(String name) {
36 super(name);
37 }
38
39 public void testHandle() throws SQLException {
40 ResultSetHandler h = new MapListHandler();
41 List results = (List) h.handle(this.rs);
42
43 assertNotNull(results);
44 assertEquals(ROWS, results.size());
45
46 Iterator iter = results.iterator();
47 Map row = null;
48 while (iter.hasNext()) {
49 row = (Map) iter.next();
50 assertEquals(COLS, row.keySet().size());
51 }
52
53 assertEquals("4", row.get("one"));
54 assertEquals("5", row.get("TWO"));
55 assertEquals("6", row.get("Three"));
56 }
57
58 public void testEmptyResultSetHandle() throws SQLException {
59 ResultSetHandler h = new MapListHandler();
60 List results = (List) h.handle(this.emptyResultSet);
61
62 assertNotNull(results);
63 assertTrue(results.isEmpty());
64 }
65
66 }