org.apache.tapestry.contrib.table.model.sql

Class SqlTableModel

java.lang.Object

org.apache.tapestry.contrib.table.model.common.AbstractTableModel

org.apache.tapestry.contrib.table.model.sql.SqlTableModel

All Implemented Interfaces:

java.io.Serializable, ITableModel

public class SqlTableModel
extends AbstractTableModel

An implementation of ITableModel that obtains its data through SQL queries. This is a very efficient model, since it uses SQL to perform the data sorting (through ORDER BY) and obtains only the data on the current page (through LIMIT/OFFSET).

This object is typically created in the following manner:

 
    ISqlConnectionSource objConnSrc = 
        new SimpleSqlConnectionSource("jdbc:postgresql://localhost/testdb", "testdb", "testdb");

    ISqlTableDataSource objDataSrc = 
        new SimpleSqlTableDataSource(objConnSrc, "test_table");

    SqlTableColumnModel objColumnModel = 
        new SqlTableColumnModel(new SqlTableColumn[] {
            new SqlTableColumn("language", "Language", true),
            new SqlTableColumn("country", "Country", true),
            new SqlTableColumn("variant", "Variant", true),
            new SqlTableColumn("intvalue", "Integer", true),
            new SqlTableColumn("floatvalue", "Float", true)
        });

    ITableModel objTableModel = new SqlTableModel(objDataSrc, objColumnModel);

    return objTableModel;
 

Author:

mindbridge

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
SqlTableModel(ISqlTableDataSource objDataSource, SqlTableColumnModel objColumnModel)
SqlTableModel(ISqlTableDataSource objDataSource, SqlTableColumnModel objColumnModel, SimpleTableState objState)

Method Summary

Methods

Modifier and Type	Method and Description
ITableColumnModel	getColumnModel() Method getColumnModel.
java.util.Iterator	getCurrentPageRows() Method getCurrentPageRows.
protected int	getRowCount()
SqlTableColumnModel	getSqlColumnModel()
ISqlTableDataSource	getSqlDataSource() Returns the dataSource.

Methods inherited from class org.apache.tapestry.contrib.table.model.common.AbstractTableModel

getPageCount, getPagingState, getSortingState, getState

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlTableModel

public SqlTableModel(ISqlTableDataSource objDataSource,
             SqlTableColumnModel objColumnModel)

SqlTableModel

public SqlTableModel(ISqlTableDataSource objDataSource,
             SqlTableColumnModel objColumnModel,
             SimpleTableState objState)

Method Detail

getColumnModel

public ITableColumnModel getColumnModel()

Description copied from interface: ITableModel

Method getColumnModel.

Returns:

ITableColumnModel the column model of the table

See Also:

ITableModel.getColumnModel()

getSqlColumnModel

public SqlTableColumnModel getSqlColumnModel()

getCurrentPageRows

public java.util.Iterator getCurrentPageRows()

Description copied from interface: ITableModel

Method getCurrentPageRows.

Returns:

Iterator the rows in the current table page given the current data, sorting, and paging state

See Also:

ITableModel.getCurrentPageRows()

getSqlDataSource

public ISqlTableDataSource getSqlDataSource()

Returns the dataSource.

Returns:

ISqlTableDataSource

getRowCount

protected int getRowCount()

Specified by:

getRowCount in class AbstractTableModel

See Also:

AbstractTableModel.getRowCount()