org.apache.commons.beanutils
public class ResultSetDynaClass extends JDBCDynaClass implements DynaClass
Implementation of DynaClass
for DynaBeans that wrap the
java.sql.Row
objects of a java.sql.ResultSet
.
The normal usage pattern is something like:
ResultSet rs = ...; ResultSetDynaClass rsdc = new ResultSetDynaClass(rs); Iterator rows = rsdc.iterator(); while (rows.hasNext()) { DynaBean row = (DynaBean) rows.next(); ... process this row ... } rs.close();
Each column in the result set will be represented as a DynaBean property of the corresponding name (optionally forced to lower case for portability).
WARNING - Any {@link DynaBean} instance returned by
this class, or from the Iterator
returned by the
iterator()
method, is directly linked to the row that the
underlying result set is currently positioned at. This has the following
implications:
Any database data that you wish to utilize outside the context of the current row of an open result set must be copied. For example, you could use the following code to create standalone copies of the information in a result set:
ArrayList results = new ArrayList(); // To hold copied list ResultSetDynaClass rsdc = ...; DynaProperty properties[] = rsdc.getDynaProperties(); BasicDynaClass bdc = new BasicDynaClass("foo", BasicDynaBean.class, rsdc.getDynaProperties()); Iterator rows = rsdc.iterator(); while (rows.hasNext()) { DynaBean oldRow = (DynaBean) rows.next(); DynaBean newRow = bdc.newInstance(); PropertyUtils.copyProperties(newRow, oldRow); results.add(newRow); }
Version: $Revision: 1.15 $ $Date: 2004/02/28 13:18:33 $
Field Summary | |
---|---|
protected ResultSet | resultSet The |
Constructor Summary | |
---|---|
ResultSetDynaClass(ResultSet resultSet) Construct a new ResultSetDynaClass for the specified
| |
ResultSetDynaClass(ResultSet resultSet, boolean lowerCase) Construct a new ResultSetDynaClass for the specified
|
Method Summary | |
---|---|
ResultSet | getResultSet() Return the result set we are wrapping. |
Iterator | iterator() Return an |
protected Class | loadClass(String className) Loads the class of the given name which by default uses the class loader used to load this library. |
The ResultSet
we are wrapping.
Construct a new ResultSetDynaClass for the specified
ResultSet
. The property names corresponding
to column names in the result set will be lower cased.
Parameters: resultSet The result set to be wrapped
Throws: NullPointerException if resultSet
is null
SQLException if the metadata for this result set
cannot be introspected
Construct a new ResultSetDynaClass for the specified
ResultSet
. The property names corresponding
to the column names in the result set will be lower cased or not,
depending on the specified lowerCase
value.
WARNING - If you specify false
for lowerCase
, the returned property names will
exactly match the column names returned by your JDBC driver.
Because different drivers might return column names in different
cases, the property names seen by your application will vary
depending on which JDBC driver you are using.
Parameters: resultSet The result set to be wrapped lowerCase Should property names be lower cased?
Throws: NullPointerException if resultSet
is null
SQLException if the metadata for this result set
cannot be introspected
Return the result set we are wrapping.
Return an Iterator
of {@link DynaBean} instances for
each row of the wrapped ResultSet
, in "forward" order.
Unless the underlying result set supports scrolling, this method
should be called only once.
Loads the class of the given name which by default uses the class loader used to load this library. Dervations of this class could implement alternative class loading policies such as using custom ClassLoader or using the Threads's context class loader etc.