Class RowSetDynaClass

java.lang.Object

org.apache.commons.beanutils.JDBCDynaClass

org.apache.commons.beanutils.RowSetDynaClass

All Implemented Interfaces:

Serializable, DynaClass

public class RowSetDynaClass
extends JDBCDynaClass

Implements DynaClass to create an in-memory collection of DynaBeans 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 DynaBeans 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.

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
protected int	limit	Limits the size of the returned list.
protected List<DynaBean>	rows	The list of DynaBeans representing the contents of the original ResultSet on which this RowSetDynaClass was based.
private static final long	serialVersionUID

Fields inherited from class JDBCDynaClass

lowerCase, properties, propertiesMap

Constructor Summary

Constructors

Constructor	Description
RowSetDynaClass(ResultSet resultSet)	Construct a new RowSetDynaClass for the specified ResultSet.
RowSetDynaClass(ResultSet resultSet, boolean lowerCase)	Construct a new RowSetDynaClass for the specified ResultSet.
RowSetDynaClass(ResultSet resultSet, boolean lowerCase, boolean useColumnLabel)	Construct a new RowSetDynaClass for the specified ResultSet.
RowSetDynaClass(ResultSet resultSet, boolean lowerCase, int limit)	Construct a new RowSetDynaClass for the specified ResultSet.
RowSetDynaClass(ResultSet resultSet, boolean lowerCase, int limit, boolean useColumnLabel)	Construct a new RowSetDynaClass for the specified ResultSet.
RowSetDynaClass(ResultSet resultSet, int limit)	Construct a new RowSetDynaClass for the specified ResultSet.

Method Summary

Modifier and Type	Method	Description
protected void	copy(ResultSet resultSet)	Copy the column values for each row in the specified ResultSet into a newly created DynaBean, and add this bean to the list of DynaBeans that will later by returned by a call to getRows().
protected DynaBean	createDynaBean()	Create and return a new DynaBean instance to be used for representing a row in the underlying result set.
List<DynaBean>	getRows()	Return a List containing the DynaBeans that represent the contents of each Row from the ResultSet that was the basis of this RowSetDynaClass instance.

Methods inherited from class JDBCDynaClass

createDynaProperty, getColumnName, getDynaProperties, getDynaProperty, getName, getObject, introspect, loadClass, newInstance, setUseColumnLabel

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

serialVersionUID

private static final long serialVersionUID

See Also:

• Constant Field Values

limit

protected int limit

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.

rows

protected List<DynaBean> rows

The list of DynaBeans representing the contents of the original ResultSet on which this RowSetDynaClass was based.

Constructor Details

RowSetDynaClass

public RowSetDynaClass(ResultSet resultSet)
                throws SQLException

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

Throws:

NullPointerException - if resultSet is null

SQLException - if the metadata for this result set cannot be introspected

RowSetDynaClass

public RowSetDynaClass(ResultSet resultSet,
 boolean lowerCase)
                throws SQLException

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

lowerCase - Should property names be lower cased?

Throws:

NullPointerException - if resultSet is null

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 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?

useColumnLabel - true if the column label should be used, otherwise false

Throws:

NullPointerException - if resultSet is null

SQLException - if the metadata for this result set cannot be introspected

Since:

1.8.3

RowSetDynaClass

public RowSetDynaClass(ResultSet resultSet,
 boolean lowerCase,
 int limit)
                throws SQLException

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

lowerCase - Should property names be lower cased?

limit - Maximum limit for the List of DynaBean

Throws:

NullPointerException - if resultSet is null

SQLException - if the metadata for this result set cannot be introspected

RowSetDynaClass

public RowSetDynaClass(ResultSet resultSet,
 boolean lowerCase,
 int limit,
 boolean useColumnLabel)
                throws SQLException

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

lowerCase - Should property names be lower cased?

limit - Maximum limit for the List of DynaBean

useColumnLabel - true if the column label should be used, otherwise false

Throws:

NullPointerException - if resultSet is null

SQLException - if the metadata for this result set cannot be introspected

Since:

1.8.3

RowSetDynaClass

public RowSetDynaClass(ResultSet resultSet,
 int limit)
                throws SQLException

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

limit - The maximum for the size of the result.

Throws:

NullPointerException - if resultSet is null

SQLException - if the metadata for this result set cannot be introspected

Method Details

copy

protected void copy(ResultSet resultSet)
             throws SQLException

Copy the column values for each row in the specified ResultSet into a newly created DynaBean, and add this bean to the list of DynaBeans that will later by returned by a call to getRows().

Parameters:

resultSet - The ResultSet whose data is to be copied

Throws:

SQLException - if an error is encountered copying the data

createDynaBean

protected DynaBean 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

getRows

public List<DynaBean> getRows()

Return a List containing the DynaBeans that represent the contents of each Row from the ResultSet that was the basis of this RowSetDynaClass instance. These DynaBeans 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 DynaBeans. However, it is the application's responsibility to persist any such changes back to the database, if it so desires.

Returns:

A List of DynaBean instances