com.sciapp.table.db
Class MSAccessPivotTableModel
java.lang.Object
javax.swing.table.AbstractTableModel
com.sciapp.table.db.AbstractDatabaseTableModel
com.sciapp.table.db.DefaultPivotTableModel
com.sciapp.table.db.MSAccessPivotTableModel
- All Implemented Interfaces:
- CacheableTableModel, DatabaseTableModel, PivotTableModel, Serializable, TableModel
public class MSAccessPivotTableModel
- extends DefaultPivotTableModel
MSAccessPivotTableModel is a pivot table model that is customized for MS Access databases.
- See Also:
- Serialized Form
Fields inherited from class com.sciapp.table.db.DefaultPivotTableModel |
aggregateDefinition, c, converter, cursors, functionDefinition, havingSQL, joinStatement, nonPivotDefinition, orderSQL, pivotColumns, pivotDefinition, pivotStatement, pivotValues, whereSQL |
Method Summary |
protected String |
readRowCountStatement()
Retrieves the sql statement for the readRowCount method. |
List |
retrieveRows(int from,
int to)
Fetches multiple rows from the underlying data source.
The following condition must be true: from >= to.
The List returned must contain the row elements starting at from.
However, the List may contain less elements than those specified in the range. |
protected String |
retrieveRowsStatement(int from,
int to)
Retrieves the sql statement for the retrieveRows method. |
Methods inherited from class com.sciapp.table.db.DefaultPivotTableModel |
fireTableChanged, getColumnClass, getColumnCount, getColumnName, getPivotColumns, getRowCount, getValueAt, initColumns, isValueCached, orderByClause, prepareGroupTableHeader, readRowCount, retrievePivotColumns, retrievePivotColumnsStatement, setCursors, whereClause |
Methods inherited from class javax.swing.table.AbstractTableModel |
addTableModelListener, findColumn, fireTableCellUpdated, fireTableDataChanged, fireTableRowsDeleted, fireTableRowsInserted, fireTableRowsUpdated, fireTableStructureChanged, getListeners, getTableModelListeners, isCellEditable, removeTableModelListener, setValueAt |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
MSAccessPivotTableModel
public MSAccessPivotTableModel(Connection c,
DatabaseTableDefinition nonPivotDefinition,
DatabaseTableDefinition functionDefinition,
String pivotColumn,
String table)
- Constructs an MSAccessPivotTableModel.
MSAccessPivotTableModel
public MSAccessPivotTableModel(Connection c,
DatabaseTableDefinition nonPivotDefinition,
MeasureDefinition functionDefinition,
PivotDefinition pivotDefinition,
String joinStatement,
String pivotStatement)
- Constructs an MSAccessPivotTableModel.
readRowCountStatement
protected String readRowCountStatement()
- Retrieves the sql statement for the
readRowCount
method.
- Overrides:
readRowCountStatement
in class DefaultPivotTableModel
- Returns:
- the sql statement as a string
retrieveRows
public List retrieveRows(int from,
int to)
- Fetches multiple rows from the underlying data source.
The following condition must be true: from >= to.
The List returned must contain the row elements starting at from.
However, the List may contain less elements than those specified in the range.
- Specified by:
retrieveRows
in interface DatabaseTableModel
- Overrides:
retrieveRows
in class DefaultPivotTableModel
- Parameters:
from
- the starting rowto
- the ending row
- Returns:
- the retrieved rows
retrieveRowsStatement
protected String retrieveRowsStatement(int from,
int to)
- Retrieves the sql statement for the
retrieveRows
method.
- Overrides:
retrieveRowsStatement
in class DefaultPivotTableModel
- Parameters:
from
- the starting rowto
- the ending row
- Returns:
- the sql statement as a string