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 testColumnIndexHandle() throws SQLException {
31 final ResultSetHandler<List<String>> h = new ColumnListHandler<>(2);
32 final List<String> results = h.handle(this.rs);
33
34 assertNotNull(results);
35 assertEquals(ROWS, results.size());
36
37 assertEquals("2", results.get(0));
38 assertEquals("5", results.get(1));
39 }
40
41 public void testColumnNameHandle() throws SQLException {
42 final ResultSetHandler<List<Integer>> h = new ColumnListHandler<>("intTest");
43 final List<Integer> results = h.handle(this.rs);
44
45 assertNotNull(results);
46 assertEquals(ROWS, results.size());
47
48 assertEquals(Integer.valueOf(1), results.get(0));
49 assertEquals(Integer.valueOf(3), results.get(1));
50 }
51
52 public void testEmptyResultSetHandle() throws SQLException {
53 final ResultSetHandler<List<String>> h = new ColumnListHandler<>();
54 final List<String> results = h.handle(this.emptyResultSet);
55
56 assertNotNull(results);
57 assertTrue(results.isEmpty());
58 }
59
60 public void testHandle() throws SQLException {
61 final ResultSetHandler<List<String>> h = new ColumnListHandler<>();
62 final List<String> results = h.handle(this.rs);
63
64 assertNotNull(results);
65 assertEquals(ROWS, results.size());
66
67 assertEquals("1", results.get(0));
68 assertEquals("4", results.get(1));
69 }
70
71 }