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
21 import org.apache.commons.dbutils.BaseTestCase;
22 import org.apache.commons.dbutils.ResultSetHandler;
23
24 public class ScalarHandlerTest extends BaseTestCase {
25
26 public void testColumnIndexHandle() throws SQLException {
27 final ResultSetHandler<String> h = new ScalarHandler<>(2);
28 final Object results = h.handle(this.rs);
29 assertNotNull(results);
30 assertEquals("2", results);
31 }
32
33 public void testColumnNameHandle() throws SQLException {
34 final ResultSetHandler<Integer> h = new ScalarHandler<>("intTest");
35 final Object results = h.handle(this.rs);
36 assertNotNull(results);
37 assertEquals(Integer.valueOf(1), results);
38 }
39
40 public void testEmptyResultSetHandle() throws SQLException {
41 final ResultSetHandler<String> h = new ScalarHandler<>();
42 final Object results = h.handle(this.emptyResultSet);
43 assertNull(results);
44 }
45
46 public void testHandle() throws SQLException {
47 final ResultSetHandler<String> h = new ScalarHandler<>();
48 final Object results = h.handle(this.rs);
49 assertNotNull(results);
50 assertEquals("1", results);
51 }
52
53 }