1   /*
2    * Licensed to the Apache Software Foundation (ASF) under one or more
3    * contributor license agreements.  See the NOTICE file distributed with
4    * this work for additional information regarding copyright ownership.
5    * The ASF licenses this file to You under the Apache License, Version 2.0
6    * (the "License"); you may not use this file except in compliance with
7    * the License.  You may obtain a copy of the License at
8    *
9    *      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  }