1. /*
  2. * $Header: /home/cvs/jakarta-commons/dbutils/src/java/org/apache/commons/dbutils/ResultSetIterator.java,v 1.1 2003/11/02 19:15:23 dgraham Exp $
  3. * $Revision: 1.1 $
  4. * $Date: 2003/11/02 19:15:23 $
  5. *
  6. * ====================================================================
  7. *
  8. * The Apache Software License, Version 1.1
  9. *
  10. * Copyright (c) 2002-2003 The Apache Software Foundation. All rights
  11. * reserved.
  12. *
  13. * Redistribution and use in source and binary forms, with or without
  14. * modification, are permitted provided that the following conditions
  15. * are met:
  16. *
  17. * 1. Redistributions of source code must retain the above copyright
  18. * notice, this list of conditions and the following disclaimer.
  19. *
  20. * 2. Redistributions in binary form must reproduce the above copyright
  21. * notice, this list of conditions and the following disclaimer in
  22. * the documentation and/or other materials provided with the
  23. * distribution.
  24. *
  25. * 3. The end-user documentation included with the redistribution, if
  26. * any, must include the following acknowledgement:
  27. * "This product includes software developed by the
  28. * Apache Software Foundation (http://www.apache.org/)."
  29. * Alternately, this acknowledgement may appear in the software itself,
  30. * if and wherever such third-party acknowledgements normally appear.
  31. *
  32. * 4. The names "The Jakarta Project", "Commons", and "Apache Software
  33. * Foundation" must not be used to endorse or promote products derived
  34. * from this software without prior written permission. For written
  35. * permission, please contact apache@apache.org.
  36. *
  37. * 5. Products derived from this software may not be called "Apache"
  38. * nor may "Apache" appear in their names without prior written
  39. * permission of the Apache Software Foundation.
  40. *
  41. * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
  42. * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
  43. * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  44. * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
  45. * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  46. * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  47. * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
  48. * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  49. * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
  50. * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
  51. * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
  52. * SUCH DAMAGE.
  53. * ====================================================================
  54. *
  55. * This software consists of voluntary contributions made by many
  56. * individuals on behalf of the Apache Software Foundation. For more
  57. * information on the Apache Software Foundation, please see
  58. * <http://www.apache.org/>.
  59. *
  60. */
  61. package org.apache.commons.dbutils;
  62. import java.sql.ResultSet;
  63. import java.sql.SQLException;
  64. import java.util.Iterator;
  65. /**
  66. * <p>
  67. * Wraps a <code>ResultSet</code> in an <code>Iterator</code>. This is useful
  68. * when you want to present a non-database application layer with domain
  69. * neutral data.
  70. * </p>
  71. *
  72. * <p>
  73. * This implementation requires the <code>ResultSet.isLast()</code> method
  74. * to be implemented.
  75. * </p>
  76. *
  77. * @author Henri Yandell
  78. * @author David Graham
  79. */
  80. public class ResultSetIterator implements Iterator {
  81. /**
  82. * The wrapped <code>ResultSet</code>.
  83. */
  84. private ResultSet rs = null;
  85. /**
  86. * The processor to use when converting a row into an Object[].
  87. */
  88. private RowProcessor convert = BasicRowProcessor.instance();
  89. /**
  90. * Constructor for ResultSetIterator.
  91. * @param rs Wrap this <code>ResultSet</code> in an <code>Iterator</code>.
  92. */
  93. public ResultSetIterator(ResultSet rs) {
  94. this.rs = rs;
  95. }
  96. /**
  97. * Constructor for ResultSetIterator.
  98. * @param rs Wrap this <code>ResultSet</code> in an <code>Iterator</code>.
  99. * @param convert The processor to use when converting a row into an
  100. * <code>Object[]</code>. Defaults to a
  101. * <code>BasicRowProcessor</code>.
  102. */
  103. public ResultSetIterator(ResultSet rs, RowProcessor convert) {
  104. this.rs = rs;
  105. this.convert = convert;
  106. }
  107. public boolean hasNext() {
  108. try {
  109. return !rs.isLast();
  110. } catch (SQLException e) {
  111. // TODO Logging?
  112. //e.printStackTrace();
  113. return false;
  114. }
  115. }
  116. /**
  117. * Returns the next row as an <code>Object[]</code>.
  118. * @return An <code>Object[]</code> with the same number of elements as
  119. * columns in the <code>ResultSet</code>.
  120. * @see java.util.Iterator#next()
  121. */
  122. public Object next() {
  123. try {
  124. rs.next();
  125. return this.convert.toArray(rs);
  126. } catch (SQLException e) {
  127. // TODO Logging?
  128. //e.printStackTrace();
  129. return null;
  130. }
  131. }
  132. /**
  133. * Deletes the current row from the <code>ResultSet</code>.
  134. * @see java.util.Iterator#remove()
  135. */
  136. public void remove() {
  137. try {
  138. this.rs.deleteRow();
  139. } catch (SQLException e) {
  140. // TODO Logging?
  141. //e.printStackTrace();
  142. }
  143. }
  144. }