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