Class RowSetDynaClass
- All Implemented Interfaces:
Serializable
,DynaClass
Implementation of DynaClass
that creates an in-memory collection
of DynaBean
s representing the results of an SQL query. Once the
DynaClass
instance has been created, the JDBC ResultSet
and Statement
on which it is based can be closed, and the
underlying Connection
can be returned to its connection pool
(if you are using one).
The normal usage pattern is something like:
Connection conn = ...; // Acquire connection from pool Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT ..."); RowSetDynaClass rsdc = new RowSetDynaClass(rs); rs.close(); stmt.close(); ...; // Return connection to pool List rows = rsdc.getRows(); ...; // Process the rows as desired
Each column in the result set will be represented as a DynaBean
property of the corresponding name (optionally forced to lower case
for portability). There will be one DynaBean
in the
List
returned by getRows()
for each
row in the original ResultSet
.
In general, instances of RowSetDynaClass
can be serialized
and deserialized, which will automatically include the list of
DynaBean
s representing the data content. The only exception
to this rule would be when the underlying property values that were
copied from the ResultSet
originally cannot themselves
be serialized. Therefore, a RowSetDynaClass
makes a very
convenient mechanism for transporting data sets to remote Java-based
application components.
- Version:
- $Id$
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected int
Limits the size of the returned list.The list ofDynaBean
s representing the contents of the originalResultSet
on which thisRowSetDynaClass
was based.Fields inherited from class org.apache.commons.beanutils.JDBCDynaClass
lowerCase, properties, propertiesMap
-
Constructor Summary
ConstructorsConstructorDescriptionRowSetDynaClass
(ResultSet resultSet) Construct a newRowSetDynaClass
for the specifiedResultSet
.RowSetDynaClass
(ResultSet resultSet, boolean lowerCase) Construct a newRowSetDynaClass
for the specifiedResultSet
.RowSetDynaClass
(ResultSet resultSet, boolean lowerCase, boolean useColumnLabel) Construct a newRowSetDynaClass
for the specifiedResultSet
.RowSetDynaClass
(ResultSet resultSet, boolean lowerCase, int limit) Construct a newRowSetDynaClass
for the specifiedResultSet
.RowSetDynaClass
(ResultSet resultSet, boolean lowerCase, int limit, boolean useColumnLabel) Construct a newRowSetDynaClass
for the specifiedResultSet
.RowSetDynaClass
(ResultSet resultSet, int limit) Construct a newRowSetDynaClass
for the specifiedResultSet
. -
Method Summary
Modifier and TypeMethodDescriptionprotected void
protected DynaBean
Create and return a newDynaBean
instance to be used for representing a row in the underlying result set.getRows()
Return aList
containing theDynaBean
s that represent the contents of eachRow
from theResultSet
that was the basis of thisRowSetDynaClass
instance.Methods inherited from class org.apache.commons.beanutils.JDBCDynaClass
createDynaProperty, getColumnName, getDynaProperties, getDynaProperty, getName, getObject, introspect, loadClass, newInstance, setUseColumnLabel
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface org.apache.commons.beanutils.DynaClass
getDynaProperties, getDynaProperty, getName, newInstance
-
Field Details
-
limit
protected int limitLimits the size of the returned list. The call to
getRows()
will return at most limit number of rows. If less than or equal to 0, does not limit the size of the result. -
rows
The list of
DynaBean
s representing the contents of the originalResultSet
on which thisRowSetDynaClass
was based.
-
-
Constructor Details
-
RowSetDynaClass
Construct a new
RowSetDynaClass
for the specifiedResultSet
. 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
- ifresultSet
isnull
SQLException
- if the metadata for this result set cannot be introspected
-
RowSetDynaClass
Construct a new
IfRowSetDynaClass
for the specifiedResultSet
. The property names corresponding to column names in the result set will be lower cased.limit
is not less than 0, maxlimit
number of rows will be copied into the list.- Parameters:
resultSet
- The result set to be wrappedlimit
- The maximum for the size of the result.- Throws:
NullPointerException
- ifresultSet
isnull
SQLException
- if the metadata for this result set cannot be introspected
-
RowSetDynaClass
Construct a new
IfRowSetDynaClass
for the specifiedResultSet
. The property names corresponding to the column names in the result set will be lower cased or not, depending on the specifiedlowerCase
value.limit
is not less than 0, maxlimit
number of rows will be copied into the resultset.- Parameters:
resultSet
- The result set to be wrappedlowerCase
- Should property names be lower cased?- Throws:
NullPointerException
- ifresultSet
isnull
SQLException
- if the metadata for this result set cannot be introspected
-
RowSetDynaClass
Construct a new
RowSetDynaClass
for the specifiedResultSet
. The property names corresponding to the column names in the result set will be lower cased or not, depending on the specifiedlowerCase
value.WARNING - If you specify
false
forlowerCase
, 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 wrappedlowerCase
- Should property names be lower cased?limit
- Maximum limit for theList
ofDynaBean
- Throws:
NullPointerException
- ifresultSet
isnull
SQLException
- if the metadata for this result set cannot be introspected
-
RowSetDynaClass
public RowSetDynaClass(ResultSet resultSet, boolean lowerCase, boolean useColumnLabel) throws SQLException Construct a new
RowSetDynaClass
for the specifiedResultSet
. The property names corresponding to the column names in the result set will be lower cased or not, depending on the specifiedlowerCase
value.WARNING - If you specify
false
forlowerCase
, 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 wrappedlowerCase
- Should property names be lower cased?useColumnLabel
- true if the column label should be used, otherwise false- Throws:
NullPointerException
- ifresultSet
isnull
SQLException
- if the metadata for this result set cannot be introspected- Since:
- 1.8.3
-
RowSetDynaClass
public RowSetDynaClass(ResultSet resultSet, boolean lowerCase, int limit, boolean useColumnLabel) throws SQLException Construct a new
RowSetDynaClass
for the specifiedResultSet
. The property names corresponding to the column names in the result set will be lower cased or not, depending on the specifiedlowerCase
value.WARNING - If you specify
false
forlowerCase
, 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 wrappedlowerCase
- Should property names be lower cased?limit
- Maximum limit for theList
ofDynaBean
useColumnLabel
- true if the column label should be used, otherwise false- Throws:
NullPointerException
- ifresultSet
isnull
SQLException
- if the metadata for this result set cannot be introspected- Since:
- 1.8.3
-
-
Method Details
-
getRows
Return a
List
containing theDynaBean
s that represent the contents of eachRow
from theResultSet
that was the basis of thisRowSetDynaClass
instance. TheseDynaBean
s are disconnected from the database itself, so there is no problem with modifying the contents of the list, or the values of the properties of theseDynaBean
s. However, it is the application's responsibility to persist any such changes back to the database, if it so desires.- Returns:
- A
List
ofDynaBean
instances
-
copy
Copy the column values for each row in the specified
ResultSet
into a newly createdDynaBean
, and add this bean to the list ofDynaBean
s that will later by returned by a call togetRows()
.- Parameters:
resultSet
- TheResultSet
whose data is to be copied- Throws:
SQLException
- if an error is encountered copying the data
-
createDynaBean
Create and return a new
DynaBean
instance to be used for representing a row in the underlying result set.- Returns:
- A new
DynaBean
instance
-