com.sptci.echo2.table
Class StatementTableModel

java.lang.Object
  nextapp.echo2.app.table.AbstractTableModel
      com.sptci.echo2.table.AbstractTableModel<RowSet>
          com.sptci.echo2.table.RowSetTableModel
              com.sptci.echo2.table.DatabaseTableModel
                  com.sptci.echo2.table.StatementTableModel

All Implemented Interfaces:

PageableTableModel, SortableTableModel, Serializable, TableModel

public class StatementTableModel
extends DatabaseTableModel

A custom TableModel used to represent data contained in in a database table. This differs from the super class in that a user specified SQL statement is executed to fetch the data.

© Copyright 2007 Sans Pareil Technologies, Inc.

Version:

$Id: StatementTableModel.java 4553 2008-12-24 10:34:16Z rakesh $

Author:

Rakesh Vidyadharan 2007-09-20

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface com.sptci.echo2.table.SortableTableModel

SortableTableModel.Direction

Field Summary

protected String

query The SQL statement to be executed to fetch the data.

Fields inherited from class com.sptci.echo2.table.DatabaseTableModel

dataSource, dataSourceName, displayColumns, initialised, orderBy, page, pageSize, primaryKeys, schema, table, totalRows

Fields inherited from class com.sptci.echo2.table.RowSetTableModel

columns, prefix, rowCount, rowSet

Fields inherited from class com.sptci.echo2.table.AbstractTableModel

sortDirection, sortIndex

Constructor Summary

StatementTableModel()
Default constructor.

Method Summary

protected void	fetchData() Fetch the data from DatabaseTableModel.table.
String	getQuery() Returns query with any order by clause necessitated by a valid AbstractTableModel.sortIndex.
void	setQuery(String query) Set query.

Methods inherited from class com.sptci.echo2.table.DatabaseTableModel

getDataSourceName, getDisplayColumns, getOrderBy, getPage, getPageSize, getPrimaryKeys, getSchema, getTable, getTotalPages, init, introspect, processColumns, setDataSourceName, setDisplayColumns, setOrderBy, setPage, setPageSize, setSchema, setTable, sort, sort

Methods inherited from class com.sptci.echo2.table.RowSetTableModel

addRow, deleteRow, dispose, getColumnClass, getColumnCount, getColumnName, getObjectAt, getPrefix, getRowCount, getValueAt, setColumn, setPrefix, setRowCount, setRowCount, updateRow

Methods inherited from class com.sptci.echo2.table.AbstractTableModel

getSortDirection

Methods inherited from class nextapp.echo2.app.table.AbstractTableModel

addTableModelListener, fireTableCellUpdated, fireTableChanged, fireTableDataChanged, fireTableRowsDeleted, fireTableRowsInserted, fireTableRowsUpdated, fireTableStructureChanged, getEventListenerList, removeTableModelListener

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.sptci.echo2.table.SortableTableModel

getSortDirection

Field Detail

query

protected String query

The SQL statement to be executed to fetch the data.

Constructor Detail

StatementTableModel

public StatementTableModel()

Default constructor. You must invoke setQuery(java.lang.String) prior to DatabaseTableModel.init() method.

Method Detail

fetchData

protected void fetchData()
                  throws SQLException

Fetch the data from DatabaseTableModel.table. Executes query and fetches the data.

Overrides:

fetchData in class DatabaseTableModel

Throws:

SQLException - If errors are encountered while fetching data from the DatabaseTableModel.table.

See Also:

RowSetTableModel.setRowCount(), DatabaseHelper.getData(java.lang.String, javax.sql.DataSource, java.lang.String, java.util.List, int, int), AbstractTableModel.fireTableDataChanged()

getQuery

public String getQuery()

Returns query with any order by clause necessitated by a valid AbstractTableModel.sortIndex. This method is very rudimentary and does not account for complex queries that also have a group by clause.

Returns:

The value/reference of/to query.

setQuery

public void setQuery(String query)

Set query. You must ensure that all the primary key columns are included in the specified statement.

Parameters:

query - The value to set.