com.ibm.as400.vaccess
Class SQLStatementButton
- java.lang.Object
-
- java.awt.Component
-
- java.awt.Container
-
- javax.swing.JComponent
-
- javax.swing.AbstractButton
-
- javax.swing.JButton
-
- com.ibm.as400.vaccess.SQLStatementButton
-
- All Implemented Interfaces:
- java.awt.image.ImageObserver, java.awt.ItemSelectable, java.awt.MenuContainer, java.io.Serializable, javax.accessibility.Accessible, javax.swing.SwingConstants
Deprecated.Use Java Swing instead, along with the classes in package com.ibm.as400.access
public class SQLStatementButton extends javax.swing.JButton implements java.io.Serializable
The SQLStatementButton class represents a button control that issues a SQL statement when pressed.It is up to the user to register a JDBC driver when using this class. For example, the following code registers the IBM Toolbox for Java JDBC driver.
DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ());
Most errors are reported by firing ErrorEvents, rather than throwing exceptions. Users should listen for ErrorEvents in order to diagnose and recover from error conditions.
SQLStatementButton objects generate the following events:
- ActionCompletedEvent
- ErrorEvent
- PropertyChangeEvent
- WorkingEvent
- See Also:
- Serialized Form
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class javax.swing.JButton
javax.swing.JButton.AccessibleJButton
-
Nested classes/interfaces inherited from class javax.swing.AbstractButton
javax.swing.AbstractButton.AccessibleAbstractButton, javax.swing.AbstractButton.ButtonChangeListener
-
Nested classes/interfaces inherited from class javax.swing.JComponent
javax.swing.JComponent.AccessibleJComponent
-
-
Field Summary
-
Fields inherited from class javax.swing.AbstractButton
actionListener, BORDER_PAINTED_CHANGED_PROPERTY, changeEvent, changeListener, CONTENT_AREA_FILLED_CHANGED_PROPERTY, DISABLED_ICON_CHANGED_PROPERTY, DISABLED_SELECTED_ICON_CHANGED_PROPERTY, FOCUS_PAINTED_CHANGED_PROPERTY, HORIZONTAL_ALIGNMENT_CHANGED_PROPERTY, HORIZONTAL_TEXT_POSITION_CHANGED_PROPERTY, ICON_CHANGED_PROPERTY, itemListener, MARGIN_CHANGED_PROPERTY, MNEMONIC_CHANGED_PROPERTY, model, MODEL_CHANGED_PROPERTY, PRESSED_ICON_CHANGED_PROPERTY, ROLLOVER_ENABLED_CHANGED_PROPERTY, ROLLOVER_ICON_CHANGED_PROPERTY, ROLLOVER_SELECTED_ICON_CHANGED_PROPERTY, SELECTED_ICON_CHANGED_PROPERTY, TEXT_CHANGED_PROPERTY, VERTICAL_ALIGNMENT_CHANGED_PROPERTY, VERTICAL_TEXT_POSITION_CHANGED_PROPERTY
-
Fields inherited from class javax.swing.JComponent
accessibleContext, listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOW
-
Fields inherited from class java.awt.Component
BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT
-
-
Constructor Summary
Constructors Constructor and Description SQLStatementButton()
Deprecated.Constructs a SQLStatementButton object.SQLStatementButton(javax.swing.Icon icon)
Deprecated.Constructs a SQLStatementButton object.SQLStatementButton(java.lang.String text)
Deprecated.Constructs a SQLStatementButton object.SQLStatementButton(java.lang.String text, javax.swing.Icon icon)
Deprecated.Constructs a SQLStatementButton object.SQLStatementButton(java.lang.String text, javax.swing.Icon icon, SQLConnection connection, java.lang.String SQLStatement)
Deprecated.Constructs a SQLStatementButton object.
-
Method Summary
Methods Modifier and Type Method and Description void
addActionCompletedListener(ActionCompletedListener listener)
Deprecated.Adds a listener to be notified when a SQL statement is executed.void
addErrorListener(ErrorListener listener)
Deprecated.Adds a listener to be notified when an error occurs.void
addWorkingListener(WorkingListener listener)
Deprecated.Adds a listener to be notified when work starts and stops on potentially long-running operations.SQLConnection
getConnection()
Deprecated.Returns the SQL connection used to execute statements.void
getMoreResults()
Deprecated.Makes the next result of the last statement run the current result.java.sql.ResultSet
getResultSet()
Deprecated.Returns the current results of the last SQL statement run.java.lang.String
getSQLStatement()
Deprecated.Returns the SQL statement that will be run when this button is pressed.int
getUpdateCount()
Deprecated.Returns the number of rows affected by the last SQL statement run.java.sql.SQLWarning
getWarnings()
Deprecated.Returns the warnings generated by the JDBC connection and statement.void
removeActionCompletedListener(ActionCompletedListener listener)
Deprecated.Removes a listener from being notified when a SQL statement is issued.void
removeErrorListener(ErrorListener listener)
Deprecated.Removes a listener from being notified when an error occurs.void
removeWorkingListener(WorkingListener listener)
Deprecated.Removes a listener from being notified when work starts and stops on potentially long-running operations.void
setConnection(SQLConnection connection)
Deprecated.Sets the SQL connection used to execute statements.void
setSQLStatement(java.lang.String SQLStatement)
Deprecated.Sets the SQL statement to run.-
Methods inherited from class javax.swing.JButton
getAccessibleContext, getUIClassID, isDefaultButton, isDefaultCapable, paramString, removeNotify, setDefaultCapable, updateUI
-
Methods inherited from class javax.swing.AbstractButton
actionPropertyChanged, addActionListener, addChangeListener, addImpl, addItemListener, checkHorizontalKey, checkVerticalKey, configurePropertiesFromAction, createActionListener, createActionPropertyChangeListener, createChangeListener, createItemListener, doClick, doClick, fireActionPerformed, fireItemStateChanged, fireStateChanged, getAction, getActionCommand, getActionListeners, getChangeListeners, getDisabledIcon, getDisabledSelectedIcon, getDisplayedMnemonicIndex, getHideActionText, getHorizontalAlignment, getHorizontalTextPosition, getIcon, getIconTextGap, getItemListeners, getLabel, getMargin, getMnemonic, getModel, getMultiClickThreshhold, getPressedIcon, getRolloverIcon, getRolloverSelectedIcon, getSelectedIcon, getSelectedObjects, getText, getUI, getVerticalAlignment, getVerticalTextPosition, imageUpdate, init, isBorderPainted, isContentAreaFilled, isFocusPainted, isRolloverEnabled, isSelected, paintBorder, removeActionListener, removeChangeListener, removeItemListener, setAction, setActionCommand, setBorderPainted, setContentAreaFilled, setDisabledIcon, setDisabledSelectedIcon, setDisplayedMnemonicIndex, setEnabled, setFocusPainted, setHideActionText, setHorizontalAlignment, setHorizontalTextPosition, setIcon, setIconTextGap, setLabel, setLayout, setMargin, setMnemonic, setMnemonic, setModel, setMultiClickThreshhold, setPressedIcon, setRolloverEnabled, setRolloverIcon, setRolloverSelectedIcon, setSelected, setSelectedIcon, setText, setUI, setVerticalAlignment, setVerticalTextPosition
-
Methods inherited from class javax.swing.JComponent
addAncestorListener, addNotify, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, 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, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintChildren, paintComponent, paintImmediately, paintImmediately, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setComponentPopupMenu, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setFocusTraversalKeys, setFont, setForeground, setInheritsPopupMenu, setInputMap, setInputVerifier, setMaximumSize, setMinimumSize, setNextFocusableComponent, setOpaque, setPreferredSize, setRequestFocusEnabled, setToolTipText, setTransferHandler, setUI, setVerifyInputWhenFocusTarget, setVisible, unregisterKeyboardAction, update
-
Methods inherited from class java.awt.Container
add, add, add, add, add, addContainerListener, addPropertyChangeListener, 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, transferFocusBackward, transferFocusDownCycle, validate, validateTree
-
Methods inherited from class java.awt.Component
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, 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, 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
-
-
-
-
Constructor Detail
-
SQLStatementButton
public SQLStatementButton()
Deprecated.Constructs a SQLStatementButton object.
-
SQLStatementButton
public SQLStatementButton(javax.swing.Icon icon)
Deprecated.Constructs a SQLStatementButton object.- Parameters:
icon
- The icon to be placed on the button.
-
SQLStatementButton
public SQLStatementButton(java.lang.String text)
Deprecated.Constructs a SQLStatementButton object.- Parameters:
text
- The text to be placed on the button.
-
SQLStatementButton
public SQLStatementButton(java.lang.String text, javax.swing.Icon icon)
Deprecated.Constructs a SQLStatementButton object.- Parameters:
text
- The text to be placed on the button.icon
- The icon to be placed on the button.
-
SQLStatementButton
public SQLStatementButton(java.lang.String text, javax.swing.Icon icon, SQLConnection connection, java.lang.String SQLStatement)
Deprecated.Constructs a SQLStatementButton object.- Parameters:
text
- The text to be placed on the button.icon
- The icon to be placed on the button.connection
- The SQL connection.SQLStatement
- The SQL statement.
-
-
Method Detail
-
addActionCompletedListener
public void addActionCompletedListener(ActionCompletedListener listener)
Deprecated.Adds a listener to be notified when a SQL statement is executed. The listener's actionCompleted() method will be called.- Parameters:
listener
- The listener.
-
addErrorListener
public void addErrorListener(ErrorListener listener)
Deprecated.Adds a listener to be notified when an error occurs. The listener's errorOccurred() method will be called.- 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.
-
getConnection
public SQLConnection getConnection()
Deprecated.Returns the SQL connection used to execute statements.- Returns:
- The SQL connection.
-
getMoreResults
public void getMoreResults()
Deprecated.Makes the next result of the last statement run the current result. Nothing is done if no statement has been executed.Refer to JDBC documentation for more information.
-
getResultSet
public java.sql.ResultSet getResultSet()
Deprecated.Returns the current results of the last SQL statement run. Multiple results can be obtained by calling getUpdateCount() and/or getResultSet() multiple times, with intervening getMoreResults() calls.Refer to JDBC documentation for more information.
- Returns:
- The result set or null if the result was not a result set, or if there are no results.
-
getSQLStatement
public java.lang.String getSQLStatement()
Deprecated.Returns the SQL statement that will be run when this button is pressed.- Returns:
- The SQL statement that will be run when this button is pressed.
-
getUpdateCount
public int getUpdateCount()
Deprecated.Returns the number of rows affected by the last SQL statement run. Multiple results can be obtained by calling getUpdateCount() and/or getResultSet() multiple times, with intervening getMoreResults() calls. If an error occurs, 0 is returned.Refer to JDBC documentation for more information.
- Returns:
- The number of rows that were affected. If no rows were affected or the SQL statement was a DDL command, 0 is returned. If there are no results or the results are a result set, -1 is returned.
-
getWarnings
public java.sql.SQLWarning getWarnings()
Deprecated.Returns the warnings generated by the JDBC connection and statement. Each time the button is pressed (the SQL statement is run), the warnings are cleared. Connection warnings are only available after the first time a statement is executed. The warnings from the statement will be linked to the end of any connection warnings.- Returns:
- The warnings generated by the connection and statement, or null if none.
-
removeActionCompletedListener
public void removeActionCompletedListener(ActionCompletedListener listener)
Deprecated.Removes a listener from being notified when a SQL statement is issued.- Parameters:
listener
- The listener.
-
removeErrorListener
public void removeErrorListener(ErrorListener listener)
Deprecated.Removes a listener from being notified when an error occurs.- Parameters:
listener
- The listener.
-
removeWorkingListener
public void removeWorkingListener(WorkingListener listener)
Deprecated.Removes a listener from being notified when work starts and stops on potentially long-running operations.- Parameters:
listener
- The listener.
-
setConnection
public void setConnection(SQLConnection connection) throws java.beans.PropertyVetoException
Deprecated.Sets the SQL connection used to execute statements. This property is bound and constrained.- Parameters:
connection
- The SQL connection.- Throws:
java.beans.PropertyVetoException
- If the change is vetoed.
-
setSQLStatement
public void setSQLStatement(java.lang.String SQLStatement) throws java.beans.PropertyVetoException
Deprecated.Sets the SQL statement to run. This property is bound and constrained.- Parameters:
SQLStatement
- The SQL statement.- Throws:
java.beans.PropertyVetoException
- If the change is vetoed.
-
-