| java.lang.Object org.apache.commons.beanutils.JDBCDynaClass org.apache.commons.beanutils.RowSetDynaClass
RowSetDynaClass | public class RowSetDynaClass extends JDBCDynaClass implements DynaClass,Serializable(Code) | | 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.
author: Craig R. McClanahan version: $Revision: 556233 $ $Date: 2007-07-14 07:37:06 +0100 (Sat, 14 Jul 2007) $ |
Field Summary | |
protected int | limit Limits the size of the returned list. | protected List | rows |
limit | protected int limit(Code) | | Limits 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.
|
RowSetDynaClass | public RowSetDynaClass(ResultSet resultSet) throws SQLException(Code) | | Construct a new
RowSetDynaClass 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 exception: NullPointerException - if resultSet is null exception: SQLException - if the metadata for this result setcannot be introspected |
RowSetDynaClass | public RowSetDynaClass(ResultSet resultSet, int limit) throws SQLException(Code) | | Construct a new
RowSetDynaClass for the specified
ResultSet . The property names corresponding
to column names in the result set will be lower cased.
If limit is not less than 0, max limit
number of rows will be copied into the list.
Parameters: resultSet - The result set to be wrapped Parameters: limit - The maximum for the size of the result. exception: NullPointerException - if resultSet is null exception: SQLException - if the metadata for this result setcannot be introspected |
RowSetDynaClass | public RowSetDynaClass(ResultSet resultSet, boolean lowerCase) throws SQLException(Code) | | Construct a new
RowSetDynaClass 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.
If limit is not less than 0, max limit
number of rows will be copied into the resultset.
Parameters: resultSet - The result set to be wrapped Parameters: lowerCase - Should property names be lower cased? exception: NullPointerException - if resultSet is null exception: SQLException - if the metadata for this result setcannot be introspected |
RowSetDynaClass | public RowSetDynaClass(ResultSet resultSet, boolean lowerCase, int limit) throws SQLException(Code) | | Construct a new
RowSetDynaClass 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 Parameters: lowerCase - Should property names be lower cased? Parameters: limit - Maximum limit for the List of DynaBean exception: NullPointerException - if resultSet is null exception: SQLException - if the metadata for this result setcannot be introspected |
copy | protected void copy(ResultSet resultSet) throws SQLException(Code) | | Copy the column values for each row in the specified
ResultSet into a newly created
DynaBean , and add
this bean to the list of
DynaBean s that will later by
returned by a call to getRows() .
Parameters: resultSet - The ResultSet whose data is to becopied exception: SQLException - if an error is encountered copying the data |
createDynaBean | protected DynaBean createDynaBean()(Code) | | Create and return a new
DynaBean instance to be used for
representing a row in the underlying result set.
A new DynaBean instance |
getRows | public List getRows()(Code) | | Return a List containing the
DynaBean s that
represent the contents of each Row from the
ResultSet that was the basis of this
RowSetDynaClass instance. These
DynaBean 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 these
DynaBean s. However, it is the application's
responsibility to persist any such changes back to the database,
if it so desires.
A List of DynaBean instances |
|
|