public class SQLResultSetTablePane
extends javax.swing.JComponent
implements java.io.Serializable
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 table 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.
SQLResultSetTablePane objects generate the following events:
This example creates an SQLResultSetTablePane 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 SQLResultSetTablePane object. SQLConnection connection = new SQLConnection("jdbc:as400://MySystem", "Userid", "Password"); String query = "SELECT * FROM MYLIB.MYTABLE"; SQLResultSetTablePane table = new SQLResultSetTablePane(connection, query);
// Put the table in a JFrame. JFrame frame = new JFrame("My Window"); frame.getContentPane().add(table);
// Set up the error dialog adapter. table.addErrorListener(new ErrorDialogAdapter(frame));
// Display the JFrame. frame.pack(); frame.show();
// Load the contents of the table. table.load();
This example creates an SQLResultSetTablePane 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("jdbc:as400://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 SQLResultSetTablePane object. SQLResultSetTablePane table = new SQLResultSetTablePane(rs);
// Put the table in a JFrame. JFrame frame = new JFrame("My Window"); frame.getContentPane().add(table);
// Set up the error dialog adapter. table.addErrorListener(new ErrorDialogAdapter(frame));
// Display the JFrame. frame.pack(); frame.show();
// Load the contents of the table. table.load();
javax.swing.JComponent.AccessibleJComponent
accessibleContext, listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOW
Constructor and Description |
---|
SQLResultSetTablePane()
Deprecated.
Constructs a SQLResultSetTablePane object.
|
SQLResultSetTablePane(java.sql.ResultSet resultSet,
boolean cacheAll)
Deprecated.
Constructs a SQLResultSetTablePane object.
|
SQLResultSetTablePane(SQLConnection connection,
java.lang.String query)
Deprecated.
Constructs a SQLResultSetTablePane object.
|
Modifier and Type | Method and Description |
---|---|
void |
addErrorListener(ErrorListener listener)
Deprecated.
Adds a listener to be notified when an error occurs.
|
void |
addListSelectionListener(javax.swing.event.ListSelectionListener listener)
Deprecated.
Adds a listener to be notified when the selection changes.
|
void |
addPropertyChangeListener(java.beans.PropertyChangeListener listener)
Deprecated.
Adds a listener to be notified when the value of any bound
property is changed.
|
void |
addVetoableChangeListener(java.beans.VetoableChangeListener listener)
Deprecated.
Adds a listener to be notified when the value of any constrained
property is changed.
|
void |
clearWarnings()
Deprecated.
Clears all SQL warnings.
|
void |
close()
Deprecated.
Closes the SQL result set this table represents.
|
javax.swing.table.TableColumnModel |
getColumnModel()
Deprecated.
Returns the column model for this table.
|
java.lang.String |
getColumnTitle(int columnIndex)
Deprecated.
Returns the title of a column.
|
int |
getColumnWidth(int columnIndex)
Deprecated.
Returns the width of a column.
|
SQLConnection |
getConnection()
Deprecated.
Returns the SQL connection with which to access data.
|
SQLResultSetTableModel |
getDataModel()
Deprecated.
Returns the data model for the table.
|
java.awt.Color |
getGridColor()
Deprecated.
Returns the color used to draw grid lines.
|
java.lang.String |
getQuery()
Deprecated.
Returns the SQL query used to generate the table data.
|
java.sql.ResultSet |
getResultSet()
Deprecated.
Returns the SQL result set.
|
javax.swing.ListSelectionModel |
getSelectionModel()
Deprecated.
Returns the ListSelectionModel that is used to maintain row selection state.
|
boolean |
getShowHorizontalLines()
Deprecated.
Returns whether horizontal lines are drawn between rows.
|
boolean |
getShowVerticalLines()
Deprecated.
Returns whether vertical lines are drawn between columns.
|
java.lang.String |
getStringValueAt(int rowIndex,
int columnIndex)
Deprecated.
Returns the string value at the specifed row and column.
|
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 warnings generated by the JDBC connection, statement, and
result set.
|
void |
load()
Deprecated.
Loads the table based on the state of the system.
|
static void |
main(java.lang.String[] args)
Deprecated.
|
void |
refreshHeadings()
Deprecated.
Updates the table header to match the result set data.
|
void |
removeErrorListener(ErrorListener listener)
Deprecated.
Removes a listener from being notified when an error occurs.
|
void |
removeListSelectionListener(javax.swing.event.ListSelectionListener listener)
Deprecated.
Removes a listener from being notified when the selection changes.
|
void |
removePropertyChangeListener(java.beans.PropertyChangeListener listener)
Deprecated.
Removes a listener from being notified when the value of any bound
property is changed.
|
void |
removeVetoableChangeListener(java.beans.VetoableChangeListener listener)
Deprecated.
Removes a listener from being notified when the value of any constrained
property is changed.
|
void |
setColumnTitle(int columnIndex,
java.lang.String title)
Deprecated.
Sets the title of a column.
|
void |
setColumnWidth(int columnIndex,
int width)
Deprecated.
Sets the width of a column.
|
void |
setConnection(SQLConnection connection)
Deprecated.
Sets the SQL connection with which to access data.
|
void |
setGridColor(java.awt.Color color)
Deprecated.
Sets the color used to draw grid lines.
|
void |
setQuery(java.lang.String query)
Deprecated.
Sets the SQL query used to build the table.
|
void |
setResultSet(java.sql.ResultSet resultSet)
Deprecated.
Sets the SQL result set used to build the table.
|
void |
setSelectionModel(javax.swing.ListSelectionModel model)
Deprecated.
Sets the ListSelectionModel that is used to maintain row selection state.
|
void |
setShowHorizontalLines(boolean show)
Deprecated.
Sets whether horizontal lines are drawn between rows.
|
void |
setShowVerticalLines(boolean show)
Deprecated.
Sets whether vertical lines are drawn between columns.
|
addAncestorListener, addNotify, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getAccessibleContext, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBaseline, getBaselineResizeBehavior, getBorder, getBounds, getClientProperty, getComponentGraphics, getComponentPopupMenu, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getFontMetrics, getGraphics, getHeight, getInheritsPopupMenu, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPopupLocation, getPreferredSize, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getUIClassID, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, paramString, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setComponentPopupMenu, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setFocusTraversalKeys, setFont, setForeground, setInheritsPopupMenu, setInputMap, setInputVerifier, setMaximumSize, setMinimumSize, setNextFocusableComponent, setOpaque, setPreferredSize, setRequestFocusEnabled, setToolTipText, setTransferHandler, setUI, setVerifyInputWhenFocusTarget, setVisible, unregisterKeyboardAction, update, updateUI
add, add, add, add, add, addContainerListener, addImpl, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, getMousePosition, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusCycleRoot, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setLayout, transferFocusBackward, transferFocusDownCycle, validate, validateTree
action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, coalesceEvents, contains, createImage, createImage, createVolatileImage, createVolatileImage, disableEvents, dispatchEvent, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isPreferredSizeSet, isShowing, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, postEvent, prepareImage, prepareImage, processComponentEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusUpCycle
public SQLResultSetTablePane()
public SQLResultSetTablePane(SQLConnection connection, java.lang.String query)
connection
- The SQL connection.query
- The SQL query.public SQLResultSetTablePane(java.sql.ResultSet resultSet, boolean cacheAll)
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.public void addErrorListener(ErrorListener listener)
listener
- The listener.public void addListSelectionListener(javax.swing.event.ListSelectionListener listener)
listener
- The listener.public void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
addPropertyChangeListener
in class java.awt.Container
listener
- The listener.public void addVetoableChangeListener(java.beans.VetoableChangeListener listener)
addVetoableChangeListener
in class javax.swing.JComponent
listener
- The listener.public void clearWarnings()
public void close()
public javax.swing.table.TableColumnModel getColumnModel()
public java.lang.String getColumnTitle(int columnIndex)
columnIndex
- The index of the column. Indices start at 0.public int getColumnWidth(int columnIndex)
columnIndex
- The index of the column. Indices start at 0.public SQLConnection getConnection()
public SQLResultSetTableModel getDataModel()
public java.awt.Color getGridColor()
public java.lang.String getQuery()
public java.sql.ResultSet getResultSet()
public javax.swing.ListSelectionModel getSelectionModel()
public boolean getShowHorizontalLines()
public boolean getShowVerticalLines()
public java.lang.String getStringValueAt(int rowIndex, int columnIndex)
rowIndex
- The row index.columnIndex
- The column index.public java.lang.Object getValueAt(int rowIndex, int columnIndex)
rowIndex
- The row index.columnIndex
- The column index.public java.sql.SQLWarning getWarnings()
public void load()
public void refreshHeadings()
public void removeErrorListener(ErrorListener listener)
listener
- The listener.public void removeListSelectionListener(javax.swing.event.ListSelectionListener listener)
listener
- The listener.public void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
removePropertyChangeListener
in class java.awt.Component
listener
- The listener.public void removeVetoableChangeListener(java.beans.VetoableChangeListener listener)
removeVetoableChangeListener
in class javax.swing.JComponent
listener
- The listener.public void setColumnTitle(int columnIndex, java.lang.String title)
columnIndex
- The index of column. Indices start at 0.title
- The title for the column.public void setColumnWidth(int columnIndex, int width)
columnIndex
- The index of column. Indices start at 0.width
- The column width.public void setConnection(SQLConnection connection) throws java.beans.PropertyVetoException
connection
- The SQL connection.java.beans.PropertyVetoException
- If the change is vetoed.public void setGridColor(java.awt.Color color)
color
- The color used to draw the grid lines.public void setQuery(java.lang.String query) throws java.beans.PropertyVetoException
query
- The SQL query.java.beans.PropertyVetoException
- If the change is vetoed.public void setResultSet(java.sql.ResultSet resultSet)
resultSet
- The SQL result set.public void setSelectionModel(javax.swing.ListSelectionModel model)
model
- The model that provides the row selection state.public void setShowHorizontalLines(boolean show)
show
- true if horizontal lines are to be drawn; false otherwise.public void setShowVerticalLines(boolean show)
show
- true if vertical lines are to be drawn; false otherwise.public static void main(java.lang.String[] args)