org.jfree.report.modules.misc.tablemodel
Class ResultSetTableModelFactory
java.lang.Object
org.jfree.report.modules.misc.tablemodel.ResultSetTableModelFactory
Creates a
TableModel
which is backed up by a
ResultSet
. If
the
ResultSet
is scrollable, a
ScrollableResultSetTableModel
is created, otherwise all data is copied from the
ResultSet
into a
DefaultTableModel
.
The creation of a
DefaultTableModel
can be forced if the system property
"org.jfree.report.modules.misc.tablemodel.TableFactoryMode"
is set to
"simple"
.
COLUMN_NAME_MAPPING_KEY
public static final String COLUMN_NAME_MAPPING_KEY
The configuration key defining how to map column names to column indices.
createTableModel
public CloseableTableModel createTableModel(ResultSet rs)
throws SQLException
Creates a table model by using the given
ResultSet
as the backend. If
the
ResultSet
is scrollable (the type is not
TYPE_FORWARD_ONLY
), an instance of
ScrollableResultSetTableModel
is returned. This model uses the extended capabilities of scrollable resultsets to
directly read data from the database without caching or the need of copying the
complete
ResultSet
into the programs memory.
If the
ResultSet
lacks the scollable features, the data will be copied
into a
DefaultTableModel
and the
ResultSet
gets closed.
createTableModel
public CloseableTableModel createTableModel(ResultSet rs,
boolean labelMapping)
throws SQLException
Creates a table model by using the given
ResultSet
as the backend. If
the
ResultSet
is scrollable (the type is not
TYPE_FORWARD_ONLY
), an instance of
ScrollableResultSetTableModel
is returned. This model uses the extended capabilities of scrollable resultsets to
directly read data from the database without caching or the need of copying the
complete
ResultSet
into the programs memory.
If the
ResultSet
lacks the scollable features, the data will be copied
into a
DefaultTableModel
and the
ResultSet
gets closed.
rs
- the result set.labelMapping
- defines, whether to use column names or column labels to compute
the column index.
generateDefaultTableModel
public CloseableTableModel generateDefaultTableModel(ResultSet rs)
throws SQLException
Generates a
TableModel
that gets its contents filled from a
ResultSet
. The column names of the
ResultSet
will form the
column names of the table model.
Hint: To customize the names of the columns, use the SQL column aliasing (done with
SELECT nativecolumnname AS "JavaColumnName" FROM ....
generateDefaultTableModel
public CloseableTableModel generateDefaultTableModel(ResultSet rs,
boolean labelMapping)
throws SQLException
Generates a
TableModel
that gets its contents filled from a
ResultSet
. The column names of the
ResultSet
will form the
column names of the table model.
Hint: To customize the names of the columns, use the SQL column aliasing (done with
SELECT nativecolumnname AS "JavaColumnName" FROM ....
rs
- the result set.labelMapping
- defines, whether to use column names or column labels to compute
the column index.