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 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:
DynaBean
instance, you should
no longer use any previous instance.DynaBean
references.DynaBean
instance may no longer be used.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); }
Modifier and Type | Field and Description |
---|---|
protected java.sql.ResultSet |
resultSet
The
ResultSet we are wrapping. |
lowerCase, properties, propertiesMap
Constructor and Description |
---|
ResultSetDynaClass(java.sql.ResultSet resultSet)
Construct a new ResultSetDynaClass for the specified
ResultSet . |
ResultSetDynaClass(java.sql.ResultSet resultSet,
boolean lowerCase)
Construct a new ResultSetDynaClass for the specified
ResultSet . |
ResultSetDynaClass(java.sql.ResultSet resultSet,
boolean lowerCase,
boolean useColumnLabel)
Construct a new ResultSetDynaClass for the specified
ResultSet . |
Modifier and Type | Method and Description |
---|---|
java.lang.Object |
getObjectFromResultSet(java.lang.String name)
Get a value from the
ResultSet for the specified
property name. |
(package private) java.sql.ResultSet |
getResultSet()
Return the result set we are wrapping.
|
java.util.Iterator<DynaBean> |
iterator()
|
protected java.lang.Class<?> |
loadClass(java.lang.String className)
Loads the class of the given name which by default uses the class loader used
to load this library.
|
createDynaProperty, getColumnName, getDynaProperties, getDynaProperty, getName, getObject, introspect, newInstance, setUseColumnLabel
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getDynaProperties, getDynaProperty, getName, newInstance
public ResultSetDynaClass(java.sql.ResultSet resultSet) throws java.sql.SQLException
Construct a new ResultSetDynaClass for the specified
ResultSet
. The property names corresponding
to column names in the result set will be lower cased.
resultSet
- The result set to be wrappedjava.lang.NullPointerException
- if resultSet
is null
java.sql.SQLException
- if the metadata for this result set
cannot be introspectedpublic ResultSetDynaClass(java.sql.ResultSet resultSet, boolean lowerCase) throws java.sql.SQLException
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.
resultSet
- The result set to be wrappedlowerCase
- Should property names be lower cased?java.lang.NullPointerException
- if resultSet
is null
java.sql.SQLException
- if the metadata for this result set
cannot be introspectedpublic ResultSetDynaClass(java.sql.ResultSet resultSet, boolean lowerCase, boolean useColumnLabel) throws java.sql.SQLException
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.
resultSet
- The result set to be wrappedlowerCase
- Should property names be lower cased?useColumnLabel
- true if the column label should be used, otherwise falsejava.lang.NullPointerException
- if resultSet
is null
java.sql.SQLException
- if the metadata for this result set
cannot be introspectedpublic java.util.Iterator<DynaBean> iterator()
Return an Iterator
of 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.
Iterator
of DynaBean
instancespublic java.lang.Object getObjectFromResultSet(java.lang.String name) throws java.sql.SQLException
ResultSet
for the specified
property name.name
- The property namejava.sql.SQLException
- if an error occursjava.sql.ResultSet getResultSet()
Return the result set we are wrapping.
protected java.lang.Class<?> loadClass(java.lang.String className) throws java.sql.SQLException
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.
loadClass
in class JDBCDynaClass
className
- The name of the class to loadjava.sql.SQLException
- if the class cannot be loadedCopyright (c) 2000-2008 - Apache Software Foundation