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 4950 2010-02-24 02:12:59Z 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

Fields

Modifier and Type	Field and Description
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

Constructors

Constructor and Description
StatementTableModel() Default constructor.

Method Summary

Modifier and Type	Method and Description
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<java.lang.String>, 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.