Copyright © 2011 Citra Technologies. All Rights Reserved.

com.citra.table.db
Class MSAccessPivotTableModel

java.lang.Object
  extended by javax.swing.table.AbstractTableModel
      extended by com.citra.table.db.AbstractDatabaseTableModel
          extended by com.citra.table.db.DefaultCrosstabTableModel
              extended by com.citra.table.db.MSAccessPivotTableModel
All Implemented Interfaces:
CacheableTableModel, CrosstabTableModel, DatabaseTableModel, Serializable, TableModel

public class MSAccessPivotTableModel
extends DefaultCrosstabTableModel

MSAccessPivotTableModel is a pivot table model that is customized for MS Access databases.

See Also:
Serialized Form

Nested Class Summary
 
Nested classes/interfaces inherited from class com.citra.table.db.DefaultCrosstabTableModel
DefaultCrosstabTableModel.SQLFilterPivotConverter
 
Field Summary
 
Fields inherited from class com.citra.table.db.DefaultCrosstabTableModel
aggregateDefinition, c, converter, cursors, functionDefinition, havingSQL, joinStatement, nonPivotDefinition, orderSQL, pivotColumns, pivotDefinition, pivotStatement, pivotValues, whereSQL
 
Fields inherited from class com.citra.table.db.AbstractDatabaseTableModel
cache, dbFilter, dbSorter, rangedModel, rowCount
 
Fields inherited from class javax.swing.table.AbstractTableModel
listenerList
 
Constructor Summary
MSAccessPivotTableModel(Connection c, DatabaseTableDefinition nonPivotDefinition, DatabaseTableDefinition functionDefinition, String pivotColumn, String table)
          Constructs an MSAccessPivotTableModel.
MSAccessPivotTableModel(Connection c, DatabaseTableDefinition nonPivotDefinition, MeasureDefinition functionDefinition, PivotDefinition pivotDefinition, String joinStatement, String pivotStatement)
          Constructs an MSAccessPivotTableModel.
 
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.citra.table.db.DefaultCrosstabTableModel
fireTableChanged, getColumnClass, getColumnCount, getColumnName, getPivotColumns, getRowCount, getValueAt, initColumns, isValueCached, orderByClause, prepareGroupTableHeader, readRowCount, retrievePivotColumns, retrievePivotColumnsStatement, setCursors, whereClause
 
Methods inherited from class com.citra.table.db.AbstractDatabaseTableModel
getCache, getFilterTableModel, getSortTableModel, getUncachedRows, isCountCached, isRangedModel, retrieveFromDB, retrieveFromDB, setCache, setRangedModel
 
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
 
Methods inherited from interface javax.swing.table.TableModel
addTableModelListener, isCellEditable, removeTableModelListener, setValueAt
 

Constructor Detail

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.

Method Detail

readRowCountStatement

protected String readRowCountStatement()
Retrieves the sql statement for the readRowCount method.

Overrides:
readRowCountStatement in class DefaultCrosstabTableModel
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 DefaultCrosstabTableModel
Parameters:
from - the starting row
to - 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 DefaultCrosstabTableModel
Parameters:
from - the starting row
to - the ending row
Returns:
the sql statement as a string

Copyright © 2011 Citra Technologies. All Rights Reserved.