01: /*
02: * Licensed to the Apache Software Foundation (ASF) under one or more
03: * contributor license agreements. See the NOTICE file distributed with
04: * this work for additional information regarding copyright ownership.
05: * The ASF licenses this file to You under the Apache License, Version 2.0
06: * (the "License"); you may not use this file except in compliance with
07: * the License. You may obtain a copy of the License at
08: *
09: * http://www.apache.org/licenses/LICENSE-2.0
10: *
11: * Unless required by applicable law or agreed to in writing, software
12: * distributed under the License is distributed on an "AS IS" BASIS,
13: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14: * See the License for the specific language governing permissions and
15: * limitations under the License.
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: }
|