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.List;
21
22 import org.apache.commons.dbutils.BaseTestCase;
23 import org.apache.commons.dbutils.ResultSetHandler;
24
25
26
27
28 public class ColumnListHandlerTest extends BaseTestCase {
29
30 public void testHandle() throws SQLException {
31 ResultSetHandler h = new ColumnListHandler();
32
33 List results = (List) h.handle(this.rs);
34
35 assertNotNull(results);
36 assertEquals(ROWS, results.size());
37
38 assertEquals("1", results.get(0));
39 assertEquals("4", results.get(1));
40 }
41
42 public void testColumnIndexHandle() throws SQLException {
43 ResultSetHandler h = new ColumnListHandler(2);
44 List results = (List) h.handle(this.rs);
45
46 assertNotNull(results);
47 assertEquals(ROWS, results.size());
48
49 assertEquals("2", results.get(0));
50 assertEquals("5", results.get(1));
51 }
52
53 public void testColumnNameHandle() throws SQLException {
54 ResultSetHandler h = new ColumnListHandler("Three");
55 List results = (List) h.handle(this.rs);
56
57 assertNotNull(results);
58 assertEquals(ROWS, results.size());
59
60 assertEquals("3", results.get(0));
61 assertEquals("6", results.get(1));
62 }
63
64 public void testEmptyResultSetHandle() throws SQLException {
65 ResultSetHandler h = new ColumnListHandler();
66 List results = (List) h.handle(this.emptyResultSet);
67
68 assertNotNull(results);
69 assertTrue(results.isEmpty());
70 }
71
72 }