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 }