com.highqsoft.resulttablemodel

Class SortedResultSet

java.lang.Object

javax.swing.table.AbstractTableModel

com.highqsoft.resulttablemodel.SortedResultSet

All Implemented Interfaces:

java.io.Serializable, javax.swing.table.TableModel

public class SortedResultSet
extends javax.swing.table.AbstractTableModel

This Class creates a model for the Presentor Table. It requires one ElemResultSet where it can draw its data from. It is a subclass of AbstractTableModel

The model required that the ResultSet returns the Instance ID in the first column. If this is not the case, the Model will abort the work and thrown an Exception

Author:

Alexander Ziller, HighQSoft GmbH

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected class	SortedResultSet.Comparator_DT_BOOLEAN
protected class	SortedResultSet.Comparator_DT_BYTE
protected class	SortedResultSet.Comparator_DT_DATE
protected class	SortedResultSet.Comparator_DT_DOUBLE
protected class	SortedResultSet.Comparator_DT_ENUM
protected class	SortedResultSet.Comparator_DT_FLOAT
protected class	SortedResultSet.Comparator_DT_LONG
protected class	SortedResultSet.Comparator_DT_LONGLONG
protected class	SortedResultSet.Comparator_DT_SHORT
protected class	SortedResultSet.Comparator_DT_STRING
protected class	SortedResultSet.TableHeaderRenderer A Custom Tablehead Renderer to set the sorting indicator icon and the color if the column is a relation

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	ascending
protected int	attrsnumber
protected java.lang.String[]	colNames
protected NameValueSeqUnitId[]	colValues An array where the data is stored from the ResultSet
protected ResultSetExt	elemRes The Resultset on which this Object's data is based.
protected EnumerationDefinition[]	enumDefs An array of enumeration definitions
protected java.util.HashMap<java.lang.Integer,java.lang.String>[]	enumMaps
protected int	filtercolumn
protected java.lang.Integer[]	idx An index array to keep the index when sorting
protected int	sortedColumn

Fields inherited from class javax.swing.table.AbstractTableModel

listenerList

Constructor Summary

Constructors

Constructor and Description
SortedResultSet(ApplicationStructure asObj, ResultSetExt rs) The standard constructor for this class.

Method Summary

Methods

Modifier and Type	Method and Description
protected static java.lang.String	dateToString(java.lang.String date) method to convert an ODS-conform date String into a more understandable format
int	getColumnCount()
java.lang.String	getColumnName(int column)
DataType	getDataType(int column) Returns the datatype of a column in the model.
int	getRowCount()
ElemId	getRowElemId(int row) Returns the ElemId of the instance element in the given row.
java.lang.Object	getValueAt(int row, int column)
void	modifyTable(javax.swing.JTable tabl) Modifies the Table.
void	setValueAt(java.lang.Object aValue, int rowIndex, int columnIndex)
void	sort(int column, boolean ascending) The sorting function for the resultset sorter.
protected static java.lang.String	stringtoDate(java.lang.String date) Helper method to convert a human readable date into an ODS Date String

Methods inherited from class javax.swing.table.AbstractTableModel

addTableModelListener, findColumn, fireTableCellUpdated, fireTableChanged, fireTableDataChanged, fireTableRowsDeleted, fireTableRowsInserted, fireTableRowsUpdated, fireTableStructureChanged, getColumnClass, getListeners, getTableModelListeners, isCellEditable, removeTableModelListener

Methods inherited from class java.lang.Object

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

Field Detail

elemRes

protected ResultSetExt elemRes

The Resultset on which this Object's data is based.

idx

protected java.lang.Integer[] idx

An index array to keep the index when sorting

colValues

protected NameValueSeqUnitId[] colValues

An array where the data is stored from the ResultSet

enumDefs

protected EnumerationDefinition[] enumDefs

An array of enumeration definitions

enumMaps

protected java.util.HashMap<java.lang.Integer,java.lang.String>[] enumMaps

colNames

protected java.lang.String[] colNames

sortedColumn

protected int sortedColumn

attrsnumber

protected int attrsnumber

filtercolumn

protected int filtercolumn

ascending

protected boolean ascending

Constructor Detail

SortedResultSet

public SortedResultSet(ApplicationStructure asObj,
               ResultSetExt rs)

The standard constructor for this class. Creates a model for any JTable to use.

Parameters:

rs - The ResulstSet that holds the data for the Table

numberofattrs - Number of attributes in the resultset

Method Detail

modifyTable

public void modifyTable(javax.swing.JTable tabl)

Modifies the Table. -Adds a mouse listener to the Header to be able to sort after a column -Makes Relations visible by coloring the background differently.

Parameters:

tabl - The Table this listener should be bound to.

getValueAt

public java.lang.Object getValueAt(int row,
                          int column)

getColumnCount

public int getColumnCount()

getColumnName

public java.lang.String getColumnName(int column)

Specified by:

getColumnName in interface javax.swing.table.TableModel

Overrides:

getColumnName in class javax.swing.table.AbstractTableModel

getRowCount

public int getRowCount()

getRowElemId

public ElemId getRowElemId(int row)

Returns the ElemId of the instance element in the given row.

This method REQUIRES that the model has been given a ResultSet which contains the ID Attribute of the Instances in the first column!

Parameters:

row - the row index

Returns:

an ElemId of the selected instance element

dateToString

protected static java.lang.String dateToString(java.lang.String date)

method to convert an ODS-conform date String into a more understandable format

Parameters:

date - the date string

Returns:

another date string, but more user friendly

stringtoDate

protected static java.lang.String stringtoDate(java.lang.String date)

Helper method to convert a human readable date into an ODS Date String

Parameters:

date - the date string

Returns:

The ODS date String

getDataType

public DataType getDataType(int column)

Returns the datatype of a column in the model.

Parameters:

column - The column for the datatype

Returns:

The DataType

setValueAt

public void setValueAt(java.lang.Object aValue,
              int rowIndex,
              int columnIndex)

Specified by:

setValueAt in interface javax.swing.table.TableModel

Overrides:

setValueAt in class javax.swing.table.AbstractTableModel

sort

public void sort(int column,
        boolean ascending)

The sorting function for the resultset sorter. Does not actually change the values but rather resorts the indexed index so when the Table is redrawn, the new index will be used.

Parameters:

column - The column that has to be sorted

ascending - The sorting order