weka.gui.sql
Class SqlViewer

java.lang.Object
  extended by java.awt.Component
      extended by java.awt.Container
          extended by javax.swing.JComponent
              extended by javax.swing.JPanel
                  extended by weka.gui.sql.SqlViewer
All Implemented Interfaces:
java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, java.util.EventListener, javax.accessibility.Accessible, ConnectionListener, HistoryChangedListener, QueryExecuteListener, ResultChangedListener

public class SqlViewer
extends javax.swing.JPanel
implements ConnectionListener, HistoryChangedListener, QueryExecuteListener, ResultChangedListener

Represents a little tool for querying SQL databases.

Version:
$Revision: 1.6 $
Author:
FracPete (fracpete at waikato dot ac dot nz)
See Also:
Serialized Form

Nested Class Summary
 
Nested classes/interfaces inherited from class javax.swing.JComponent
javax.swing.JComponent.AccessibleJComponent
 
Nested classes/interfaces inherited from class java.awt.Component
java.awt.Component.BaselineResizeBehavior
 
Field Summary
static java.lang.String HEIGHT
          the height property in the history file
static java.lang.String WIDTH
          the width property in the history file
 
Fields inherited from class javax.swing.JComponent
TOOL_TIP_TEXT_KEY, 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
 
Fields inherited from interface java.awt.image.ImageObserver
ABORT, ALLBITS, ERROR, FRAMEBITS, PROPERTIES, SOMEBITS
 
Constructor Summary
SqlViewer(javax.swing.JFrame parent)
          initializes the SqlViewer
 
Method Summary
 void addConnectionListener(ConnectionListener l)
          adds the given listener to the list of listeners
 void addHistoryChangedListener(HistoryChangedListener l)
          adds the given listener to the list of listeners
 void addQueryExecuteListener(QueryExecuteListener l)
          adds the given listener to the list of listeners
 void addResultChangedListener(ResultChangedListener l)
          adds the given listener to the list of listeners
 void clear()
          calls the clear method of all sub-panels to set back to default values and free up memory
 void connectionChange(ConnectionEvent evt)
          This method gets called when the connection is either established or disconnected.
 java.lang.String getPassword()
          returns the password from the currently active tab in the ResultPanel, otherwise an empty string.
 java.lang.String getQuery()
          returns the query from the currently active tab in the ResultPanel, otherwise an empty string.
 java.lang.String getURL()
          returns the database URL from the currently active tab in the ResultPanel, otherwise an empty string.
 java.lang.String getUser()
          returns the user from the currently active tab in the ResultPanel, otherwise an empty string.
 void historyChanged(HistoryChangedEvent evt)
          This method gets called when a history is modified.
static void main(java.lang.String[] args)
          starts the SQL-Viewer interface.
 void queryExecuted(QueryExecuteEvent evt)
          This method gets called when a query has been executed.
 void removeConnectionListener(ConnectionListener l)
          removes the given listener from the list of listeners
 void removeHistoryChangedListener(HistoryChangedListener l)
          removes the given listener from the list of listeners
 void removeQueryExecuteListener(QueryExecuteListener l)
          removes the given listener from the list of listeners
 void removeResultChangedListener(ResultChangedListener l)
          removes the given listener from the list of listeners
 void resultChanged(ResultChangedEvent evt)
          This method gets called when a query has been executed.
 void saveSize()
          obtains the size of the panel and saves it in the history
 
Methods inherited from class javax.swing.JPanel
getAccessibleContext, getUI, getUIClassID, setUI, updateUI
 
Methods inherited from class javax.swing.JComponent
addAncestorListener, addNotify, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBaseline, getBaselineResizeBehavior, getBorder, getBounds, getClientProperty, 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, paintImmediately, paintImmediately, print, printAll, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, 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, 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, remove, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusCycleRoot, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setLayout, transferFocusBackward, transferFocusDownCycle, validate
 
Methods inherited from class java.awt.Component
action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, contains, createImage, createImage, createVolatileImage, createVolatileImage, dispatchEvent, enable, enableInputMethods, 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, 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
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

WIDTH

public static final java.lang.String WIDTH
the width property in the history file

See Also:
Constant Field Values

HEIGHT

public static final java.lang.String HEIGHT
the height property in the history file

See Also:
Constant Field Values
Constructor Detail

SqlViewer

public SqlViewer(javax.swing.JFrame parent)
initializes the SqlViewer

Parameters:
parent - the parent of this panel
Method Detail

connectionChange

public void connectionChange(ConnectionEvent evt)
This method gets called when the connection is either established or disconnected.

Specified by:
connectionChange in interface ConnectionListener

queryExecuted

public void queryExecuted(QueryExecuteEvent evt)
This method gets called when a query has been executed.

Specified by:
queryExecuted in interface QueryExecuteListener

resultChanged

public void resultChanged(ResultChangedEvent evt)
This method gets called when a query has been executed.

Specified by:
resultChanged in interface ResultChangedListener

historyChanged

public void historyChanged(HistoryChangedEvent evt)
This method gets called when a history is modified. It saves the history immediately to the users home directory.

Specified by:
historyChanged in interface HistoryChangedListener

saveSize

public void saveSize()
obtains the size of the panel and saves it in the history

See Also:
saveHistory()

clear

public void clear()
calls the clear method of all sub-panels to set back to default values and free up memory


getURL

public java.lang.String getURL()
returns the database URL from the currently active tab in the ResultPanel, otherwise an empty string.

Returns:
the currently selected tab's URL
See Also:
ResultPanel

getUser

public java.lang.String getUser()
returns the user from the currently active tab in the ResultPanel, otherwise an empty string.

Returns:
the currently selected tab's user
See Also:
ResultPanel

getPassword

public java.lang.String getPassword()
returns the password from the currently active tab in the ResultPanel, otherwise an empty string.

Returns:
the currently selected tab's password
See Also:
ResultPanel

getQuery

public java.lang.String getQuery()
returns the query from the currently active tab in the ResultPanel, otherwise an empty string.

Returns:
the currently selected tab's query
See Also:
ResultPanel

addConnectionListener

public void addConnectionListener(ConnectionListener l)
adds the given listener to the list of listeners

Parameters:
l - the listener to add to the list

removeConnectionListener

public void removeConnectionListener(ConnectionListener l)
removes the given listener from the list of listeners

Parameters:
l - the listener to remove

addQueryExecuteListener

public void addQueryExecuteListener(QueryExecuteListener l)
adds the given listener to the list of listeners

Parameters:
l - the listener to add to the list

removeQueryExecuteListener

public void removeQueryExecuteListener(QueryExecuteListener l)
removes the given listener from the list of listeners

Parameters:
l - the listener to remove

addResultChangedListener

public void addResultChangedListener(ResultChangedListener l)
adds the given listener to the list of listeners

Parameters:
l - the listener to add to the list

removeResultChangedListener

public void removeResultChangedListener(ResultChangedListener l)
removes the given listener from the list of listeners

Parameters:
l - the listener to remove

addHistoryChangedListener

public void addHistoryChangedListener(HistoryChangedListener l)
adds the given listener to the list of listeners

Parameters:
l - the listener to add to the list

removeHistoryChangedListener

public void removeHistoryChangedListener(HistoryChangedListener l)
removes the given listener from the list of listeners

Parameters:
l - the listener to remove

main

public static void main(java.lang.String[] args)
starts the SQL-Viewer interface.