stevencaswell    2003/01/26 08:54:49

  Added:       dbutils/src/java/org/apache/commons/dbutils/driver
                        StringTrimmedResultSet.java
  Log:
  created
  
  Revision  Changes    Path
  1.1                  
jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/driver/StringTrimmedResultSet.java
  
  Index: StringTrimmedResultSet.java
  ===================================================================
  
  package org.apache.commons.dbutils.driver;
  
  /* ====================================================================
   * The Apache Software License, Version 1.1
   *
   * Copyright (c) 2003 The Apache Software Foundation.  All rights
   * reserved.
   *
   * Redistribution and use in source and binary forms, with or without
   * modification, are permitted provided that the following conditions
   * are met:
   *
   * 1. Redistributions of source code must retain the above copyright
   *    notice, this list of conditions and the following disclaimer.
   *
   * 2. Redistributions in binary form must reproduce the above copyright
   *    notice, this list of conditions and the following disclaimer in
   *    the documentation and/or other materials provided with the
   *    distribution.
   *
   * 3. The end-user documentation included with the redistribution, if
   *    any, must include the following acknowlegement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowlegement may appear in the software itself,
   *    if and wherever such third-party acknowlegements normally appear.
   *
   * 4. The names "The Jakarta Project", "Commons", and "Apache Software
   *    Foundation" must not be used to endorse or promote products derived
   *    from this software without prior written permission. For written
   *    permission, please contact [EMAIL PROTECTED]
   *
   * 5. Products derived from this software may not be called "Apache"
   *    nor may "Apache" appear in their names without prior written
   *    permission of the Apache Software Foundation.
   *
   * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
   * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
   * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
   * DISCLAIMED.  IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
   * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
   * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
   * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
   * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
   * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
   * SUCH DAMAGE.
   * ====================================================================
   *
   * This software consists of voluntary contributions made by many
   * individuals on behalf of the Apache Software Foundation.  For more
   * information on the Apache Software Foundation, please see
   * <http://www.apache.org/>.
   */
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Statement;
  import org.apache.commons.lang.StringUtils;
  
  /**
   * Wraps a <code>ResultSet</code> to trim strings returned by the
   * <code>getString</code> methods.
   *
   * @author  <a href="[EMAIL PROTECTED]">Steven Caswell</a>
   * @version $Id: StringTrimmedResultSet.java,v 1.1 2003/01/26 16:54:49 stevencaswell 
Exp $
   */
  public class StringTrimmedResultSet extends ResultSetWrapper {
      private ResultSet rs = null;
      
      /**
       * Constructs a new instance of
       * <code>StringTrimmedResultSet</code>.
       * to wrap the specified <code>ResultSet</code>.
       */
      public StringTrimmedResultSet(ResultSet rs) {
          super(rs);
          this.rs = rs;
      }
  
      /**
       * Constructs a new instance of
       * <code>StringTrimmedResultSet</code>.
       * to wrap the specified <code>ResultSet</code> and <code>Statement</code>.
       */
      public StringTrimmedResultSet(ResultSet rs, Statement st) {
          super(rs, st);
          this.rs = rs;
      }
  
      /**
       * Gets the value of the designated column in the current row of this 
       * <code>ResultSet</code> object as a String in the Java programming 
       * language. Control characters, including whitespace, are removed from 
       * both ends of the string, handling null by returning null.
       *
       * @param column the SQL name of the column
       * @return the column value; if the value is SQL NULL, the value returned 
       * is <code>null</code>
       * @throws SQLException if a database access error occurs
       */
      public String getString(String column) throws SQLException {
          return StringUtils.trim(this.rs.getString(column));
      }
      
      /**
       * Gets the value of the designated column in the current row of this 
       * <code>ResultSet</code> object as a String in the Java programming 
       * language. Control characters, including whitespace, are removed from 
       * both ends of the string, handling null by returning null.
       *
       * @param idx the first column is 1, the second is 2, ...
       * @return the column value; if the value is SQL NULL, the value returned 
       * is <code>null</code>
       * @throws SQLException if a database access error occurs
       */
      public String getString(int idx) throws SQLException {
          return StringUtils.trim(this.rs.getString(idx));
      }
  }
  
  
  

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to