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 ScalarHandlerTest(String name) {
27 super(name);
28 }
29
30 public void testHandle() throws SQLException {
31 ResultSetHandler h = new ScalarHandler();
32 Object results = h.handle(this.rs);
33 assertNotNull(results);
34 assertEquals("1", results);
35 }
36
37 public void testColumnIndexHandle() throws SQLException {
38 ResultSetHandler h = new ScalarHandler(2);
39 Object results = h.handle(this.rs);
40 assertNotNull(results);
41 assertEquals("2", results);
42 }
43
44 public void testColumnNameHandle() throws SQLException {
45 ResultSetHandler h = new ScalarHandler("THree");
46 Object results = h.handle(this.rs);
47 assertNotNull(results);
48 assertEquals("3", results);
49 }
50
51 public void testEmptyResultSetHandle() throws SQLException {
52 ResultSetHandler h = new ScalarHandler();
53 Object results = h.handle(this.emptyResultSet);
54 assertNull(results);
55 }
56
57 }