Package weka.gui.sql
Class SqlViewer
- java.lang.Object
-
- java.awt.Component
-
- java.awt.Container
-
- javax.swing.JComponent
-
- javax.swing.JPanel
-
- 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: 10438 $
- Author:
- FracPete (fracpete at waikato dot ac dot nz)
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description 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
-
-
Constructor Summary
Constructors Constructor Description SqlViewer(javax.swing.JFrame parent)
initializes the SqlViewer.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description 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, hide, 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, 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, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, 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, requestFocus, requestFocusInWindow, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setMixingCutoutShape, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle
-
-
-
-
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
-
-
Method Detail
-
connectionChange
public void connectionChange(ConnectionEvent evt)
This method gets called when the connection is either established or disconnected.- Specified by:
connectionChange
in interfaceConnectionListener
- Parameters:
evt
- the event
-
queryExecuted
public void queryExecuted(QueryExecuteEvent evt)
This method gets called when a query has been executed.- Specified by:
queryExecuted
in interfaceQueryExecuteListener
- Parameters:
evt
- the event
-
resultChanged
public void resultChanged(ResultChangedEvent evt)
This method gets called when a query has been executed.- Specified by:
resultChanged
in interfaceResultChangedListener
- Parameters:
evt
- the event
-
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 interfaceHistoryChangedListener
- Parameters:
evt
- the event
-
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.- Parameters:
args
- the commandline arguments - ignored
-
-