001    /*
002     * Licensed to the Apache Software Foundation (ASF) under one or more
003     * contributor license agreements.  See the NOTICE file distributed with
004     * this work for additional information regarding copyright ownership.
005     * The ASF licenses this file to You under the Apache License, Version 2.0
006     * (the "License"); you may not use this file except in compliance with
007     * the License.  You may obtain a copy of the License at
008     *
009     *      http://www.apache.org/licenses/LICENSE-2.0
010     *
011     * Unless required by applicable law or agreed to in writing, software
012     * distributed under the License is distributed on an "AS IS" BASIS,
013     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
014     * See the License for the specific language governing permissions and
015     * limitations under the License.
016     */
017    package org.apache.commons.dbutils.handlers;
018    
019    import java.sql.SQLException;
020    
021    import org.apache.commons.dbutils.BaseTestCase;
022    import org.apache.commons.dbutils.ResultSetHandler;
023    
024    public class ScalarHandlerTest extends BaseTestCase {
025    
026        public void testHandle() throws SQLException {
027            ResultSetHandler h = new ScalarHandler();
028            Object results = h.handle(this.rs);
029            assertNotNull(results);
030            assertEquals("1", results);
031        }
032    
033        public void testColumnIndexHandle() throws SQLException {
034            ResultSetHandler h = new ScalarHandler(2);
035            Object results = h.handle(this.rs);
036            assertNotNull(results);
037            assertEquals("2", results);
038        }
039    
040        public void testColumnNameHandle() throws SQLException {
041            ResultSetHandler h = new ScalarHandler("THree");
042            Object results = h.handle(this.rs);
043            assertNotNull(results);
044            assertEquals("3", results);
045        }
046    
047        public void testEmptyResultSetHandle() throws SQLException {
048            ResultSetHandler h = new ScalarHandler();
049            Object results = h.handle(this.emptyResultSet);
050            assertNull(results);
051        }
052    
053    }