SQLResultSetTableModel

java.lang.Object
- javax.swing.table.AbstractTableModel
- - com.ibm.as400.vaccess.SQLResultSetTableModel

All Implemented Interfaces:: java.io.Serializable, javax.swing.table.TableModel

Deprecated.

Use Java Swing instead, along with the classes in package com.ibm.as400.access

public class SQLResultSetTableModel
extends javax.swing.table.AbstractTableModel
implements java.io.Serializable

The SQLResultSetTableModel class represents the data in a JDBC result set generated by an SQL query. This class implements the underlying model for a table in a graphical user interface. Use this class if you want to customize the graphical user interface that presents a table. If you do not need to customize the graphical user interface, then use SQLResultSetTablePane instead.

You must specify an SQLConnection object and SQL query string to use for generating the data. Alternately, you can specify a ResultSet object directly. If you specify a ResultSet object, it will override any SQLConnection or SQL query previously set. In addition, if you specify a ResultSet, this class will use memory more efficiently if you create the ResultSet as scrollable.

You must explicitly call load() to load the information from the result set. The model will be empty until load() is called. If the query or result set includes updatable columns, then the respective columns will be editable.

This class assumes that the necessary JDBC driver(s) are already registered.

Call close() to ensure that the result set is closed when this table is no longer needed.

Most errors are reported as ErrorEvents rather than throwing exceptions. Listen for ErrorEvents in order to diagnose and recover from error conditions.

SQLResultSetTableModel objects generate the following events:

ErrorEvent
PropertyChangeEvent
TableModelEvent
WorkingEvent

This example creates an SQLResultSetTableModel using an SQLConnection and query and displays it using a JTable:

// Register the IBM Toolbox for Java JDBC driver.
DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());


// Create the SQLResultSetTableModel object.
SQLConnection connection = new SQLConnection("jdbc:as400://MySystem", "Userid", "Password");
String query = "SELECT * FROM MYLIB.MYTABLE";
SQLResultSetTableModel model = new SQLResultSetTableModel(connection, query);


// Create the enclosing JTable and put it in a JFrame.
JTable table = new JTable(model);
JFrame frame = new JFrame("My Window");
frame.getContentPane().add(new JScrollPane(table));


// Set up the error dialog adapter.
model.addErrorListener(new ErrorDialogAdapter(frame));


// Display the JFrame.
frame.pack();
frame.show();


// Load the contents of the model.
model.load();

This example creates an SQLResultSetTableModel using a ResultSet and displays it using a JTable:

// Register the IBM Toolbox for Java JDBC driver.
DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());


// Use JDBC to execute the SQL query directly.
Connection connection = DriverManager.getConnection("MySystem", "Userid", "Password");
Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = statement.executeQuery("SELECT * FROM MYLIB.MYTABLE");


// Create the SQLResultSetTableModel object.
SQLResultSetTableModel model = new SQLResultSetTableModel(rs);


// Create the enclosing JTable and put it in a JFrame.
JTable table = new JTable(model);
JFrame frame = new JFrame("My Window");
frame.getContentPane().add(new JScrollPane(table));


// Set up the error dialog adapter.
model.addErrorListener(new ErrorDialogAdapter(frame));


// Display the JFrame.
frame.pack();
frame.show();


// Load the contents of the model.
model.load();

See Also:: Serialized Form

Field Summary
- Fields inherited from class javax.swing.table.AbstractTableModel
  listenerList

Constructor Summary

Constructors
Constructor and Description
`SQLResultSetTableModel()` Deprecated. Constructs a SQLResultSetTableModel object.
`SQLResultSetTableModel(java.sql.ResultSet resultSet, boolean cacheAll)` Deprecated. Constructs a SQLResultSetTableModel object.
`SQLResultSetTableModel(SQLConnection connection, java.lang.String query)` Deprecated. Constructs a SQLResultSetTableModel object.

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`addErrorListener(ErrorListener listener)` Deprecated. Adds a listener to be notified when an error occurs.
`void`	`addPropertyChangeListener(java.beans.PropertyChangeListener listener)` Deprecated. Adds a listener to be notified when the value of any bound property changes.
`void`	`addVetoableChangeListener(java.beans.VetoableChangeListener listener)` Deprecated. Adds a listener to be notified when the value of any constrained property changes.
`void`	`addWorkingListener(WorkingListener listener)` Deprecated. Adds a listener to be notified when work starts and stops on potentially long-running operations.
`void`	`clearWarnings()` Deprecated. Clears all SQL warnings.
`void`	`close()` Deprecated. Closes the result set.
`java.lang.Class`	`getColumnClass(int columnIndex)` Deprecated. Returns the class of the values in the column.
`int`	`getColumnCount()` Deprecated. Returns the number of columns in the table.
`java.lang.String`	`getColumnID(int columnIndex)` Deprecated. Returns the column identifier.
`java.lang.String`	`getColumnName(int columnIndex)` Deprecated. Returns the column name.
`int`	`getColumnType(int columnIndex)` Deprecated. Returns the column type.
`int`	`getColumnWidth(int columnIndex)` Deprecated. Returns the column width.
`SQLConnection`	`getConnection()` Deprecated. Returns the SQL connection.
`java.lang.String`	`getQuery()` Deprecated. Returns the SQL query.
`java.sql.ResultSet`	`getResultSet()` Deprecated. Returns the SQL result set.
`int`	`getRowCount()` Deprecated. Returns the number of rows in the table.
`java.lang.Object`	`getValueAt(int rowIndex, int columnIndex)` Deprecated. Returns the value at the specifed row and column.
`java.sql.SQLWarning`	`getWarnings()` Deprecated. Returns the SQL warnings.
`boolean`	`isCellEditable(int rowIndex, int columnIndex)` Deprecated. Indicates if the cell is editable.
`void`	`load()` Deprecated. Loads the data in the table.
`void`	`removeErrorListener(ErrorListener listener)` Deprecated. Removes an error listener.
`void`	`removePropertyChangeListener(java.beans.PropertyChangeListener listener)` Deprecated. Removes a property change listener.
`void`	`removeVetoableChangeListener(java.beans.VetoableChangeListener listener)` Deprecated. Removes a vetoable change listener.
`void`	`removeWorkingListener(WorkingListener listener)` Deprecated. Removes a working listener.
`void`	`setConnection(SQLConnection connection)` Deprecated. Sets the SQL connection.
`void`	`setQuery(java.lang.String query)` Deprecated. Sets the SQL query.
`void`	`setResultSet(java.sql.ResultSet resultSet)` Deprecated. Sets the SQL result set used to build the table.
`void`	`setTable(javax.swing.JTable table)` Deprecated. Set a reference to the JTable so that the selected row can be updated after fireTableRowsInserted.
`void`	`setValueAt(java.lang.Object value, int rowIndex, int columnIndex)` Deprecated. Sets the value at the specifed row and column.

Methods inherited from class javax.swing.table.AbstractTableModel
addTableModelListener, findColumn, fireTableCellUpdated, fireTableChanged, fireTableDataChanged, fireTableRowsDeleted, fireTableRowsInserted, fireTableRowsUpdated, fireTableStructureChanged, getListeners, getTableModelListeners, removeTableModelListener

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - SQLResultSetTableModel
```
public SQLResultSetTableModel()
```
    Deprecated.
    
    Constructs a SQLResultSetTableModel object.
  - SQLResultSetTableModel
```
public SQLResultSetTableModel(SQLConnection connection,
                      java.lang.String query)
```
    Deprecated.
    
    Constructs a SQLResultSetTableModel object.
    
    Parameters:
    connection - The SQL connection.
    query - The SQL query.
  - SQLResultSetTableModel
```
public SQLResultSetTableModel(java.sql.ResultSet resultSet,
                      boolean cacheAll)
```
    Deprecated.
    
    Constructs a SQLResultSetTableModel object.
    
    Parameters:
    resultSet - The SQL result set.
    cacheAll - true to cache the entire result set when load() is called, false to cache parts of the result set as they are needed. Passing true may result in slow initial presentation of the data. However, it may be necessary to pass true if the result set is expected to close when the model is still needed.
- Method Detail
  - addErrorListener
```
public void addErrorListener(ErrorListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when an error occurs.
    
    Parameters:
    listener - The listener.
  - addPropertyChangeListener
```
public void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when the value of any bound property changes.
    
    Parameters:
    listener - The listener.
  - addVetoableChangeListener
```
public void addVetoableChangeListener(java.beans.VetoableChangeListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when the value of any constrained property changes.
    
    Parameters:
    listener - The listener.
  - addWorkingListener
```
public void addWorkingListener(WorkingListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when work starts and stops on potentially long-running operations.
    
    Parameters:
    listener - The listener.
  - clearWarnings
```
public void clearWarnings()
```
    Deprecated.
    
    Clears all SQL warnings.
  - close
```
public void close()
```
    Deprecated.
    
    Closes the result set.
  - getColumnClass
```
public java.lang.Class getColumnClass(int columnIndex)
```
    Deprecated.
    
    Returns the class of the values in the column.
    
    Specified by:
    
    getColumnClass in interface javax.swing.table.TableModel
    
    Overrides:
    
    getColumnClass in class javax.swing.table.AbstractTableModel
    
    Parameters:
    columnIndex - The column index (0-based).
    
    Returns:
    The class of the column values, or null if an error occurs.
  - getColumnCount
```
public int getColumnCount()
```
    Deprecated.
    
    Returns the number of columns in the table.
    
    Specified by:
    
    getColumnCount in interface javax.swing.table.TableModel
    
    Returns:
    The number of columns in the table, or 0 if an error occurs.
  - getColumnID
```
public java.lang.String getColumnID(int columnIndex)
```
    Deprecated.
    
    Returns the column identifier. This corresponds to the field name in the database.
    
    Parameters:
    columnIndex - The column index (0-based).
    
    Returns:
    The column identifier, or null if an error occurs.
  - getColumnName
```
public java.lang.String getColumnName(int columnIndex)
```
    Deprecated.
    
    Returns the column name. This corresponds to the column label in the database.
    
    Specified by:
    
    getColumnName in interface javax.swing.table.TableModel
    
    Overrides:
    
    getColumnName in class javax.swing.table.AbstractTableModel
    
    Parameters:
    columnIndex - The column index (0-based).
    
    Returns:
    The column name, or null if an error occurs.
  - getColumnType
```
public int getColumnType(int columnIndex)
```
    Deprecated.
    
    Returns the column type.
    
    Parameters:
    columnIndex - The column index (0-based).
    
    Returns:
    The column type, or 0 if an error occurs.
  - getColumnWidth
```
public int getColumnWidth(int columnIndex)
```
    Deprecated.
    
    Returns the column width.
    
    Parameters:
    columnIndex - The column index (0-based).
    
    Returns:
    The column width, in characters, or 0 if an error occurs.
  - getConnection
```
public SQLConnection getConnection()
```
    Deprecated.
    
    Returns the SQL connection.
    
    Returns:
    The SQL connection.
  - getQuery
```
public java.lang.String getQuery()
```
    Deprecated.
    
    Returns the SQL query.
    
    Returns:
    The SQL query.
  - getResultSet
```
public java.sql.ResultSet getResultSet()
```
    Deprecated.
    
    Returns the SQL result set.
    
    Returns:
    The SQL result set.
  - getRowCount
```
public int getRowCount()
```
    Deprecated.
    
    Returns the number of rows in the table. Because of incremental data retrieval, this value may not be accurate.
    
    Specified by:
    
    getRowCount in interface javax.swing.table.TableModel
    
    Returns:
    The number of rows in the table.
  - getValueAt
```
public java.lang.Object getValueAt(int rowIndex,
                          int columnIndex)
```
    Deprecated.
    
    Returns the value at the specifed row and column.
    
    Specified by:
    
    getValueAt in interface javax.swing.table.TableModel
    
    Parameters:
    rowIndex - The row index (0-based).
    columnIndex - The column index (0-based).
    
    Returns:
    The value at the specified row and column.
  - getWarnings
```
public java.sql.SQLWarning getWarnings()
```
    Deprecated.
    
    Returns the SQL warnings.
    
    Returns:
    The SQL warnings.
  - isCellEditable
```
public boolean isCellEditable(int rowIndex,
                     int columnIndex)
```
    Deprecated.
    
    Indicates if the cell is editable.
    
    Specified by:
    
    isCellEditable in interface javax.swing.table.TableModel
    
    Overrides:
    
    isCellEditable in class javax.swing.table.AbstractTableModel
    
    Parameters:
    rowIndex - The row index (0-based).
    columnIndex - The column index (0-based).
    
    Returns:
    true if the cell is editable, false otherwise or if an error occurs.
  - load
```
public void load()
```
    Deprecated.
    
    Loads the data in the table.
  - removeErrorListener
```
public void removeErrorListener(ErrorListener listener)
```
    Deprecated.
    
    Removes an error listener.
    
    Parameters:
    listener - The listener.
  - removePropertyChangeListener
```
public void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
```
    Deprecated.
    
    Removes a property change listener.
    
    Parameters:
    listener - The listener.
  - removeVetoableChangeListener
```
public void removeVetoableChangeListener(java.beans.VetoableChangeListener listener)
```
    Deprecated.
    
    Removes a vetoable change listener.
    
    Parameters:
    listener - The listener.
  - removeWorkingListener
```
public void removeWorkingListener(WorkingListener listener)
```
    Deprecated.
    
    Removes a working listener.
    
    Parameters:
    listener - The listener.
  - setConnection
```
public void setConnection(SQLConnection connection)
                   throws java.beans.PropertyVetoException
```
    Deprecated.
    
    Sets the SQL connection. The data will not change until load() is called.
    
    Parameters:
    connection - The SQL connection.
    
    Throws:
    
    java.beans.PropertyVetoException - If the change is vetoed.
  - setQuery
```
public void setQuery(java.lang.String query)
              throws java.beans.PropertyVetoException
```
    Deprecated.
    
    Sets the SQL query. The data will not change until load() is called.
    
    Parameters:
    query - The SQL query.
    
    Throws:
    
    java.beans.PropertyVetoException - If the change is vetoed.
  - setResultSet
```
public void setResultSet(java.sql.ResultSet resultSet)
```
    Deprecated.
    
    Sets the SQL result set used to build the table. If this is set, it is used instead of the SQL connection and SQL query. The data will not change until load() is called.
    
    Parameters:
    resultSet - The SQL result set.
  - setValueAt
```
public void setValueAt(java.lang.Object value,
              int rowIndex,
              int columnIndex)
```
    Deprecated.
    
    Sets the value at the specifed row and column.
    
    Specified by:
    
    setValueAt in interface javax.swing.table.TableModel
    
    Overrides:
    
    setValueAt in class javax.swing.table.AbstractTableModel
    
    Parameters:
    value - The value.
    rowIndex - The row index (0-based).
    columnIndex - The column index (0-based).
  - setTable
```
public void setTable(javax.swing.JTable table)
```
    Deprecated.
    
    Set a reference to the JTable so that the selected row can be updated after fireTableRowsInserted.
    
    Parameters:
    table -

Fields inherited from class javax.swing.table.AbstractTableModel

Methods inherited from class javax.swing.table.AbstractTableModel

Methods inherited from class java.lang.Object

SQLResultSetTableModel

SQLResultSetTableModel

SQLResultSetTableModel

addErrorListener

addPropertyChangeListener

addVetoableChangeListener

addWorkingListener

clearWarnings

close

getColumnClass

getColumnCount

getColumnID

getColumnName

getColumnType

getColumnWidth

getConnection

getQuery

getResultSet

getRowCount

getValueAt

getWarnings

isCellEditable

load

removeErrorListener

removePropertyChangeListener

removeVetoableChangeListener

removeWorkingListener

setConnection

setQuery

setResultSet

setValueAt

setTable