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]>
