commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dgra...@apache.org
Subject cvs commit: jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers MapHandler.java BeanListHandler.java BeanHandler.java MapListHandler.java ScalarHandler.java ArrayListHandler.java ArrayHandler.java
Date Wed, 22 Oct 2003 23:13:44 GMT
dgraham     2003/10/22 16:13:44

  Added:       dbutils/src/java/org/apache/commons/dbutils/handlers
                        MapHandler.java BeanListHandler.java
                        BeanHandler.java MapListHandler.java
                        ScalarHandler.java ArrayListHandler.java
                        ArrayHandler.java
  Log:
  Moved all ResultSetHandler implementations into new
  org.apache.commons.dbutils.handlers package because
  there are now enough of them to justify their own
  sub-package.
  
  Revision  Changes    Path
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/MapHandler.java
  
  Index: MapHandler.java
  ===================================================================
  /*
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/MapHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   *
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   *
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  import org.apache.commons.dbutils.BasicRowProcessor;
  import org.apache.commons.dbutils.ResultSetHandler;
  import org.apache.commons.dbutils.RowProcessor;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts the first
   * <code>ResultSet</code> row into a <code>Map</code>.
   * 
   * @see ResultSetHandler
   * @author Juozas Baliuka
   * @author David Graham
   */
  public class MapHandler implements ResultSetHandler {
      
      /**
       * The RowProcessor implementation to use when converting rows 
       * into Maps.
       */
      private RowProcessor convert = BasicRowProcessor.instance();
      
      /** 
       * Creates a new instance of MapHandler using a 
       * <code>BasicRowProcessor</code> for conversion.
       */
      public MapHandler() {
          super();
      }
      
      /** 
       * Creates a new instance of MapHandler.
       * 
       * @param convert The <code>RowProcessor</code> implementation 
       * to use when converting rows into Maps.
       */
      public MapHandler(RowProcessor convert) {
          super();
          this.convert = convert;
      }
  
      /**
       * Converts the first row in the <code>ResultSet</code> into a 
       * <code>Map</code>.
       * 
       * @return A <code>Map</code> with the values from the first row or 
       * <code>null</code> if there are no rows in the <code>ResultSet</code>.

       * 
       * @throws SQLException
       * 
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
  
          return rs.next() ? this.convert.toMap(rs) : null;
      }
  
  }
  
  
  
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/BeanListHandler.java
  
  Index: BeanListHandler.java
  ===================================================================
  /*
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/BeanListHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   *
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   *
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  import org.apache.commons.dbutils.BasicRowProcessor;
  import org.apache.commons.dbutils.ResultSetHandler;
  import org.apache.commons.dbutils.RowProcessor;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts a
   * <code>ResultSet</code> into a <code>List</code> of beans.
   * 
   * @see ResultSetHandler
   * 
   * @author Juozas Baliuka
   * @author David Graham
   */
  public class BeanListHandler implements ResultSetHandler {
  
      /**
       * The Class of beans produced by this handler.
       */
      private Class type = null;
      
      /**
       * The RowProcessor implementation to use when converting rows 
       * into beans.
       */
      private RowProcessor convert = BasicRowProcessor.instance();
  
      /** 
       * Creates a new instance of BeanListHandler.
       * 
       * @param type The Class that objects returned from <code>handle()</code>
       * are created from.
       */
      public BeanListHandler(Class type) {
          this.type = type;
      }
      
      /** 
       * Creates a new instance of BeanListHandler.
       * 
       * @param type The Class that objects returned from <code>handle()</code>
       * are created from.
       * @param convert The <code>RowProcessor</code> implementation 
       * to use when converting rows into beans.
       */
      public BeanListHandler(Class type, RowProcessor convert) {
          this.type = type;
          this.convert = convert;
      }
  
      /**
       * Convert the <code>ResultSet</code> rows into a <code>List</code>
of 
       * beans with the <code>Class</code> given in the constructor.
       * 
       * @return A <code>List</code> of beans (one for each row), never 
       * <code>null</code>.
       * 
       * @throws SQLException
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
              
          return this.convert.toBeanList(rs, type);
      }
  
  }
  
  
  
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/BeanHandler.java
  
  Index: BeanHandler.java
  ===================================================================
  /* 
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/BeanHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   * 
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  import org.apache.commons.dbutils.BasicRowProcessor;
  import org.apache.commons.dbutils.ResultSetHandler;
  import org.apache.commons.dbutils.RowProcessor;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts the first 
   * <code>ResultSet</code> row into a JavaBean.
   * 
   * @see ResultSetHandler
   * 
   * @author Juozas Baliuka
   * @author David Graham
   */
  public class BeanHandler implements ResultSetHandler {
  
      /**
       * The Class of beans produced by this handler.
       */
      private Class type = null;
      
      /**
       * The RowProcessor implementation to use when converting rows 
       * into beans.
       */
      private RowProcessor convert = BasicRowProcessor.instance();
  
      /** 
       * Creates a new instance of BeanHandler.
       * 
       * @param type The Class that objects returned from <code>handle()</code>
       * are created from.
       */
      public BeanHandler(Class type) {
          this.type = type;
      }
      
      /** 
       * Creates a new instance of BeanHandler.
       * 
       * @param type The Class that objects returned from <code>handle()</code>
       * are created from.
       * @param convert The <code>RowProcessor</code> implementation 
       * to use when converting rows into beans.
       */
      public BeanHandler(Class type, RowProcessor convert) {
          this.type = type;
          this.convert = convert;
      }
  
      /**
       * Convert the first row of the <code>ResultSet</code> into a bean with
the
       * <code>Class</code> given in the constructor.
       * 
       * @return An initialized JavaBean or <code>null</code> if there were no

       * rows in the <code>ResultSet</code>.
       * 
       * @throws SQLException
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
  
          return rs.next() ? this.convert.toBean(rs, this.type) : null;
      }
  
  }
  
  
  
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/MapListHandler.java
  
  Index: MapListHandler.java
  ===================================================================
  /*
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/MapListHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   *
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   *
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.util.ArrayList;
  import java.util.List;
  
  import org.apache.commons.dbutils.BasicRowProcessor;
  import org.apache.commons.dbutils.ResultSetHandler;
  import org.apache.commons.dbutils.RowProcessor;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts a
   * <code>ResultSet</code> into a <code>List</code> of <code>Map</code>s.
   * 
   * @see ResultSetHandler
   * 
   * @author David Graham
   */
  public class MapListHandler implements ResultSetHandler {
  
      /**
       * The RowProcessor implementation to use when converting rows 
       * into Maps.
       */
      private RowProcessor convert = BasicRowProcessor.instance();
  
      /** 
       * Creates a new instance of MapListHandler using a 
       * <code>BasicRowProcessor</code> for conversion.
       */
      public MapListHandler() {
          super();
      }
  
      /** 
       * Creates a new instance of MapListHandler.
       * 
       * @param convert The <code>RowProcessor</code> implementation 
       * to use when converting rows into Maps.
       */
      public MapListHandler(RowProcessor convert) {
          super();
          this.convert = convert;
      }
  
      /**
       * Converts the <code>ResultSet</code> rows into a <code>List</code>
of 
       * <code>Map</code> objects.
       * 
       * @return A <code>List</code> of <code>Map</code>s, never null.
 
       * 
       * @throws SQLException
       * 
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
  
          List results = new ArrayList();
  
          while (rs.next()) {
              results.add(this.convert.toMap(rs));
          }
  
          return results;
      }
  
  }
  
  
  
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/ScalarHandler.java
  
  Index: ScalarHandler.java
  ===================================================================
  /*
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/ScalarHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   *
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   *
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  import org.apache.commons.dbutils.ResultSetHandler;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts one
   * <code>ResultSet</code> column into an Object.
   * 
   * @see ResultSetHandler
   * @author Juozas Baliuka
   * @author David Graham
   */
  public class ScalarHandler implements ResultSetHandler {
  
      /**
       * The column number to retrieve.
       */
      private int columnIndex = 1;
  
      /**
       * The column name to retrieve.  Either columnName or columnIndex
       * will be used but never both.
       */
      private String columnName = null;
  
      /** 
       * Creates a new instance of ScalarHandler.  The first column will
       * be returned from <code>handle()</code>.
       */
      public ScalarHandler() {
          super();
      }
  
      /** 
       * Creates a new instance of ScalarHandler.
       * 
       * @param columnIndex The index of the column to retrieve from the 
       * <code>ResultSet</code>.
       */
      public ScalarHandler(int columnIndex) {
          this.columnIndex = columnIndex;
      }
  
      /** 
       * Creates a new instance of ScalarHandler.
       * 
       * @param columnName The name of the column to retrieve from the 
       * <code>ResultSet</code>.
       */
      public ScalarHandler(String columnName) {
          this.columnName = columnName;
      }
  
      /**
       * Returns one <code>ResultSet</code> column as an object via the
       * <code>ResultSet.getObject()</code> method that performs type 
       * conversions.
       * 
       * @return The column or <code>null</code> if there are no rows in
       * the <code>ResultSet</code>.
       * 
       * @throws SQLException
       * 
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
  
          if (rs.next()) {
              if (this.columnName == null) {
                  return rs.getObject(this.columnIndex);
              } else {
                  return rs.getObject(this.columnName);
              }
              
          } else {
              return null;
          }
      }
  }
  
  
  
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/ArrayListHandler.java
  
  Index: ArrayListHandler.java
  ===================================================================
  /*
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/ArrayListHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   *
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   *
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.util.ArrayList;
  import java.util.List;
  
  import org.apache.commons.dbutils.BasicRowProcessor;
  import org.apache.commons.dbutils.ResultSetHandler;
  import org.apache.commons.dbutils.RowProcessor;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts the 
   * <code>ResultSet</code> into a <code>List</code> of <code>Object[]</code>s.
   * 
   * @see ResultSetHandler
   * 
   * @author Juozas Baliuka
   * @author David Graham
   */
  public class ArrayListHandler implements ResultSetHandler {
  
      /**
       * The RowProcessor implementation to use when converting rows 
       * into Object[]s.
       */
      private RowProcessor convert = BasicRowProcessor.instance();
  
      /** 
       * Creates a new instance of ArrayListHandler using a 
       * <code>BasicRowProcessor</code> for conversions.
       */
      public ArrayListHandler() {
          super();
      }
  
      /** 
       * Creates a new instance of ArrayListHandler.
       * 
       * @param convert The <code>RowProcessor</code> implementation 
       * to use when converting rows into Object[]s.
       */
      public ArrayListHandler(RowProcessor convert) {
          super();
          this.convert = convert;
      }
  
      /**
       * Convert each row's columns into an <code>Object[]</code> and store them

       * in a <code>List</code> in the same order they are returned from the
       * <code>ResultSet.next()</code> method. 
       * 
       * @return A <code>List</code> of <code>Object[]</code>s, never

       * <code>null</code>.
       * 
       * @throws SQLException
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
  
          List result = new ArrayList();
  
          while (rs.next()) {
              result.add(this.convert.toArray(rs));
          }
  
          return result;
      }
  
  }
  
  
  
  1.1                  jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/ArrayHandler.java
  
  Index: ArrayHandler.java
  ===================================================================
  /*
   * $Header: /home/cvs/jakarta-commons-sandbox/dbutils/src/java/org/apache/commons/dbutils/handlers/ArrayHandler.java,v
1.1 2003/10/22 23:13:43 dgraham Exp $
   * $Revision: 1.1 $
   * $Date: 2003/10/22 23:13:43 $
   * 
   * ====================================================================
   *
   * 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 acknowledgement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgement may appear in the software itself,
   *    if and wherever such third-party acknowledgements 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 apache@apache.org.
   *
   * 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/>.
   *
   */
  
  package org.apache.commons.dbutils.handlers;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  
  import org.apache.commons.dbutils.BasicRowProcessor;
  import org.apache.commons.dbutils.ResultSetHandler;
  import org.apache.commons.dbutils.RowProcessor;
  
  /**
   * <code>ResultSetHandler</code> implementation that converts a 
   * <code>ResultSet</code> into an <code>Object[]</code>.
   * 
   * @see ResultSetHandler
   * 
   * @author Juozas Baliuka
   * @author David Graham
   */
  public class ArrayHandler implements ResultSetHandler {
  
      /**
       * The RowProcessor implementation to use when converting rows 
       * into arrays.
       */
      private RowProcessor convert = BasicRowProcessor.instance();
      
      /** 
       * Creates a new instance of ArrayHandler using a 
       * <code>BasicRowProcessor</code> for conversion.
       */
      public ArrayHandler() {
          super();
      }
      
      /** 
       * Creates a new instance of ArrayHandler.
       * 
       * @param convert The <code>RowProcessor</code> implementation 
       * to use when converting rows into arrays.
       */
      public ArrayHandler(RowProcessor convert) {
          super();
          this.convert = convert;
      }
  
      /**
       * Places the column values from the first row in an <code>Object[]</code>.
       * 
       * @return An Object[] or <code>null</code> if there are no rows in the
       * <code>ResultSet</code>.
       * 
       * @throws SQLException
       * @see org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet, java.lang.Object[],
java.lang.Object)
       */
      public Object handle(ResultSet rs, Object[] params, Object userObject)
          throws SQLException {
  
          return rs.next() ? this.convert.toArray(rs) : null;
      }
  
  }
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message