Package net.simplace.pipe.io

Class DatabaseAccessPanel

java.lang.Object

java.awt.Component

java.awt.Container

javax.swing.JComponent

javax.swing.JPanel

net.simplace.pipe.io.DatabaseAccessPanel

All Implemented Interfaces:

ActionListener, KeyListener, ImageObserver, MenuContainer, Serializable, EventListener, Accessible

public class DatabaseAccessPanel
extends JPanel
implements ActionListener, KeyListener

Swing Tool for managing a JDBC database.

             Usage: java DatabaseManagerSwing 
             where parameters include:
              --db_conn <classname>  name of the connectionpool
              --driver <classname>  jdbc driver class
              --url <name>          jdbc url
              --user <name>         username used for connection
              --password <password> password for this user
 

Note that the sys-table switch will not work for Oracle, because Oracle does not categorize their system tables correctly in the JDBC Metadata. New class based on Hypersonic SQL original

Author:

dmarshall@users, Andreas Enders@uni-bonn.de

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
protected class	DatabaseAccessPanel.StatementExecRunnable
class	DatabaseAccessPanel.TableNodeContent

Nested classes/interfaces inherited from class javax.swing.JPanel

JPanel.AccessibleJPanel

Nested classes/interfaces inherited from class javax.swing.JComponent

JComponent.AccessibleJComponent

Nested classes/interfaces inherited from class java.awt.Container

Container.AccessibleAWTContainer

Nested classes/interfaces inherited from class java.awt.Component

Component.AccessibleAWTComponent, Component.BaselineResizeBehavior, Component.BltBufferStrategy, Component.FlipBufferStrategy

Field Summary

Fields inherited from class javax.swing.JComponent

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

accessibleContext, BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT

Fields inherited from interface java.awt.image.ImageObserver

ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH

Constructor Summary

Constructors

Constructor	Description
DatabaseAccessPanel(FWObservable aObservable)
DatabaseAccessPanel(FWObservable aObservable, org.jdom2.Element aFormElement)

Method Summary

Modifier and Type	Method	Description
void	actionPerformed(ActionEvent ev)
void	connect(Connection aConnection)	This stuff is all quick, except for the refreshTree().
protected void	directRefreshTree()	Clear all existing nodes from the tree model and rebuild from scratch.
void	executeCurrentSQL()	Schedules to run in a Gui-safe thread
protected int[]	getRowCounts(Vector inTable, Vector inSchema)
String	getStatementText()	getting
void	init()
void	keyPressed(KeyEvent k)
void	keyReleased(KeyEvent k)
void	keyTyped(KeyEvent k)
protected void	refreshTree()	Schedules to run in a Gui-safe thread
void	setStatementChanged()	setting Statement to Changed: overwrite this method if other things have to be done.
void	setStatementText(String aString)
void	setWaiting(String description)

Methods inherited from class javax.swing.JPanel

getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUI

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, 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

Methods inherited from class java.awt.Container

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

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, 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, requestFocus, 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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

DatabaseAccessPanel

public DatabaseAccessPanel(FWObservable aObservable)

DatabaseAccessPanel

public DatabaseAccessPanel(FWObservable aObservable,
 org.jdom2.Element aFormElement)

Method Details

init

public void init()

connect

public void connect(Connection aConnection)

This stuff is all quick, except for the refreshTree(). This unit can be kicked off in main Gui thread. The refreshTree will be backgrounded and this method will return.

Parameters:

aConnection -

keyPressed

public void keyPressed(KeyEvent k)

Specified by:

keyPressed in interface KeyListener

keyReleased

public void keyReleased(KeyEvent k)

Specified by:

keyReleased in interface KeyListener

keyTyped

public void keyTyped(KeyEvent k)

Specified by:

keyTyped in interface KeyListener

actionPerformed

public void actionPerformed(ActionEvent ev)

Specified by:

actionPerformed in interface ActionListener

setWaiting

public void setWaiting(String description)

executeCurrentSQL

public void executeCurrentSQL()

Schedules to run in a Gui-safe thread

refreshTree

protected void refreshTree()

Schedules to run in a Gui-safe thread

directRefreshTree

protected void directRefreshTree()

Clear all existing nodes from the tree model and rebuild from scratch. This method executes in current thread

getRowCounts

protected int[] getRowCounts(Vector inTable,
 Vector inSchema)
                      throws Exception

Throws:

Exception

setStatementText

public void setStatementText(String aString)

Parameters:

aString -

getStatementText

public String getStatementText()

getting

Returns:

recent sql string

setStatementChanged

public void setStatementChanged()

setting Statement to Changed: overwrite this method if other things have to be done.