public class QueryPanel extends JPanel implements ConnectionListener, CaretListener
JPanel.AccessibleJPanel
JComponent.AccessibleJComponent
Container.AccessibleAWTContainer
Component.AccessibleAWTComponent, Component.BaselineResizeBehavior, Component.BltBufferStrategy, Component.FlipBufferStrategy
Modifier and Type | Field and Description |
---|---|
static String |
HISTORY_NAME
the name of the history.
|
protected JButton |
m_ButtonClear
the clear button.
|
protected JButton |
m_ButtonExecute
the execute button.
|
protected JButton |
m_ButtonHistory
the history button.
|
protected boolean |
m_Connected
whether we have a connection to a database or not.
|
protected DbUtils |
m_DbUtils
for working on the database.
|
protected DefaultListModel |
m_History
the query history.
|
protected HashSet |
m_HistoryChangedListeners
the history listeners.
|
protected JFrame |
m_Parent
the parent of this panel.
|
protected HashSet |
m_QueryExecuteListeners
the connection listeners.
|
protected JSpinner |
m_SpinnerMaxRows
the spinner for the maximum number of rows.
|
protected JTextArea |
m_TextQuery
the textarea for the query.
|
static String |
MAX_ROWS
the name for the max rows in the history.
|
listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOW
accessibleContext, BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT
ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH
Constructor and Description |
---|
QueryPanel(JFrame parent)
initializes the panel.
|
Modifier and Type | Method and Description |
---|---|
protected void |
addHistory(String s)
adds the given string to the history (removes duplicates).
|
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 |
caretUpdate(CaretEvent event)
Called when the caret position is updated.
|
void |
clear()
clears the textarea.
|
void |
connectionChange(ConnectionEvent evt)
This method gets called when the connection is either established
or disconnected.
|
protected void |
createPanel()
creates the panel with all its components.
|
void |
execute()
executes the current query.
|
DefaultListModel |
getHistory()
returns the history.
|
int |
getMaxRows()
returns the current value for the maximum number of rows.
|
String |
getQuery()
returns the currently displayed query.
|
protected void |
notifyHistoryChangedListeners()
notifies the history listeners of the event.
|
protected void |
notifyQueryExecuteListeners(ResultSet rs,
Exception ex)
notifies the listeners of the event.
|
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.
|
protected void |
setButtons()
sets the buttons according to the connected-state.
|
void |
setFocus()
sets the focus in a designated control.
|
void |
setHistory(DefaultListModel history)
sets the local history to the given one.
|
void |
setMaxRows(int rows)
sets the maximum number of rows to display.
|
void |
setQuery(String query)
sets the query in the textarea.
|
void |
showHistory()
displays the query history.
|
getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUI
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, hide, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingOrigin, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removeVetoableChangeListener, 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
add, add, add, add, add, addContainerListener, addImpl, 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, setLayout, 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, 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, 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, transferFocusBackward, transferFocusUpCycle
public static final String HISTORY_NAME
public static final String MAX_ROWS
protected JFrame m_Parent
protected JTextArea m_TextQuery
protected JButton m_ButtonExecute
protected JButton m_ButtonClear
protected JButton m_ButtonHistory
protected JSpinner m_SpinnerMaxRows
protected HashSet m_QueryExecuteListeners
protected HashSet m_HistoryChangedListeners
protected DbUtils m_DbUtils
protected boolean m_Connected
protected DefaultListModel m_History
public QueryPanel(JFrame parent)
parent
- the parent of this panelprotected void createPanel()
public void setFocus()
protected void setButtons()
public void connectionChange(ConnectionEvent evt)
connectionChange
in interface ConnectionListener
evt
- the eventpublic void execute()
public void clear()
protected void addHistory(String s)
s
- the string to addpublic void setHistory(DefaultListModel history)
history
- the history to usepublic DefaultListModel getHistory()
public void showHistory()
public void setQuery(String query)
query
- the query to displaypublic String getQuery()
public void setMaxRows(int rows)
rows
- the maximum number of rowspublic int getMaxRows()
public void addQueryExecuteListener(QueryExecuteListener l)
l
- the listener to add to the listpublic void removeQueryExecuteListener(QueryExecuteListener l)
l
- the listener to removeprotected void notifyQueryExecuteListeners(ResultSet rs, Exception ex)
rs
- the resultsetex
- the exceptionpublic void addHistoryChangedListener(HistoryChangedListener l)
l
- the listener to add to the listpublic void removeHistoryChangedListener(HistoryChangedListener l)
l
- the listener to removeprotected void notifyHistoryChangedListeners()
public void caretUpdate(CaretEvent event)
caretUpdate
in interface CaretListener
event
- the eventCopyright © 2015 University of Waikato, Hamilton, NZ. All rights reserved.