org.ecoinformatics.seek.querybuilder

Class QBSplitPaneAdvanced

java.lang.Object

java.awt.Component

java.awt.Container

javax.swing.JComponent

javax.swing.JPanel

org.ecoinformatics.seek.querybuilder.QBSplitPaneAdvanced

All Implemented Interfaces:

java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, java.util.EventListener, javax.accessibility.Accessible, javax.swing.event.ListSelectionListener, QBBuilderInterface

public class QBSplitPaneAdvanced
extends javax.swing.JPanel
implements javax.swing.event.ListSelectionListener, QBBuilderInterface

This class shows a split view with a set of table schemas as draggable tables in the upper pane. The the "from" clause of the select can be created by dragging fields from one table to the next to form the "join" relationships. And a two tab control in the lower pane. The Select pane enables the user to indicate which fields will be displayed and what the conditions will be for each of the fields. The Where pane enables the user to specify a complex conditional.

See Also:

Serialized Form

Nested Class Summary

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

javax.swing.JPanel.AccessibleJPanel

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

javax.swing.JComponent.AccessibleJComponent

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

java.awt.Container.AccessibleAWTContainer

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

java.awt.Component.AccessibleAWTComponent, java.awt.Component.BaselineResizeBehavior, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy

Field Summary

Fields

Modifier and Type	Field and Description
protected javax.swing.JButton	mAddBtn
protected DBTableDesktopPane	mDesktop
protected DSSchemaIFace	mSchema
protected javax.swing.JPanel	mSelectPanel
protected javax.swing.JSplitPane	mSplitPane
protected DBTableJoin	mTableJoins
protected javax.swing.JList	mTableList
protected DBSelectTableModelAdv	mTableModel
protected javax.swing.event.TableModelListener	mTableModelListener
protected DBSelectTableUIAdv	mTableView
protected DBWherePanel	mWherePanel

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 org.ecoinformatics.seek.querybuilder.QBBuilderInterface

ADVANCED, INTERMEDIATE, STANDARD

Fields inherited from interface java.awt.image.ImageObserver

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

Constructor Summary

Constructors

Constructor and Description
QBSplitPaneAdvanced(DSSchemaIFace aSchema, javax.swing.event.TableModelListener aListener) QBSplitPaneAdvanced Constructor

Method Summary

Modifier and Type	Method and Description
int	buildFromQueryDef(DBQueryDef aQueryDef) Build UI from the Query Definition Object
boolean	canConvertTo(QBBuilderInterface aBldr) This checks to see if this type of builder can convert the internal SQL to a more complex or less complex form.
javax.swing.JComponent	createLowerPanel() Creates the lower panel that contains the tabs "Select" and "Where"
javax.swing.JPanel	createSelectForDisplayPanel(DSSchemaIFace aSchema) Creates the "Select" panel for discribing what fields will have their values displayed
java.lang.String	createSQL() Create SQL string
javax.swing.JComponent	createUpperPanel(javax.swing.event.TableModelListener aListener) Creates the DesktopPane that contains all the tables with "links" or joins.
protected void	fillHashWithTableNamesForWhere(DBWhereIFace aWhereObj, java.util.Hashtable aHashTable) Fill the hastable with the table names
void	fillQueryDef(DBQueryDef aQueryDef) Fill the QueryDef from the Model
java.lang.String	getName() A textual name for this builder
DSSchemaIFace	getSchema() Return Schema
int	getType()
boolean	possibleDataLoss() Returns whether their will be data loss if this query is converted to a "standard" query meaning we have defined some "where" items, but have not created any "display" items
protected void	refresh() Makes the entire Desktop object repaint itself
void	setTableModelListener(javax.swing.event.TableModelListener aTblModelListener) Sets the Model Listener appropriately
void	shutdown() Do Clean up
void	valueChanged(javax.swing.event.ListSelectionEvent e)

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

Methods inherited from class java.lang.Object

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

Field Detail

mSplitPane

protected javax.swing.JSplitPane mSplitPane

mSchema

protected DSSchemaIFace mSchema

mDesktop

protected DBTableDesktopPane mDesktop

mTableJoins

protected DBTableJoin mTableJoins

mWherePanel

protected DBWherePanel mWherePanel

mSelectPanel

protected javax.swing.JPanel mSelectPanel

mTableView

protected DBSelectTableUIAdv mTableView

mTableModel

protected DBSelectTableModelAdv mTableModel

mAddBtn

protected javax.swing.JButton mAddBtn

mTableList

protected javax.swing.JList mTableList

mTableModelListener

protected javax.swing.event.TableModelListener mTableModelListener

Constructor Detail

QBSplitPaneAdvanced

public QBSplitPaneAdvanced(DSSchemaIFace aSchema,
                           javax.swing.event.TableModelListener aListener)

QBSplitPaneAdvanced Constructor

Parameters:

aSchema - the schema

aListener - a listener of changes to the overall model

Method Detail

setTableModelListener

public void setTableModelListener(javax.swing.event.TableModelListener aTblModelListener)

Sets the Model Listener appropriately

Parameters:

aTblModelListener - a listener

shutdown

public void shutdown()

Do Clean up

getSchema

public DSSchemaIFace getSchema()

Return Schema

Returns:

the schema

createUpperPanel

public javax.swing.JComponent createUpperPanel(javax.swing.event.TableModelListener aListener)

Creates the DesktopPane that contains all the tables with "links" or joins.

Parameters:

aListener - the listener for the overall model changes

Returns:

the component representing the upper pane

createSelectForDisplayPanel

public javax.swing.JPanel createSelectForDisplayPanel(DSSchemaIFace aSchema)

Creates the "Select" panel for discribing what fields will have their values displayed

Parameters:

aSchema - the schema

Returns:

the component representing the select pane

createLowerPanel

public javax.swing.JComponent createLowerPanel()

Creates the lower panel that contains the tabs "Select" and "Where"

Parameters:

aSchema - the schema

Returns:

the component representing the lower pane

createSQL

public java.lang.String createSQL()

Create SQL string

Specified by:

createSQL in interface QBBuilderInterface

Returns:

Returns a string representing the interal SQL Query

refresh

protected void refresh()

Makes the entire Desktop object repaint itself

fillHashWithTableNamesForWhere

protected void fillHashWithTableNamesForWhere(DBWhereIFace aWhereObj,
                                              java.util.Hashtable aHashTable)

Fill the hastable with the table names

Parameters:

aWhereObj - the where object

aHashTable - the hastable

valueChanged

public void valueChanged(javax.swing.event.ListSelectionEvent e)

Specified by:

valueChanged in interface javax.swing.event.ListSelectionListener

getType

public int getType()

Specified by:

getType in interface QBBuilderInterface

Returns:

returns the "type" of builder it is as defined by the constants in this interface

getName

public java.lang.String getName()

A textual name for this builder

Specified by:

getName in interface QBBuilderInterface

Overrides:

getName in class java.awt.Component

Returns:

string of the name

possibleDataLoss

public boolean possibleDataLoss()

Returns whether their will be data loss if this query is converted to a "standard" query meaning we have defined some "where" items, but have not created any "display" items

Returns:

true if possible data loss

canConvertTo

public boolean canConvertTo(QBBuilderInterface aBldr)

This checks to see if this type of builder can convert the internal SQL to a more complex or less complex form. This is typically called when switching from a more complex builder to a less complex builder

Specified by:

canConvertTo in interface QBBuilderInterface

Parameters:

aBldr - The "receiving" builder, in other words can this builder convert the SQL to the new builder

Returns:

true if it can convert it, false if it can not

buildFromQueryDef

public int buildFromQueryDef(DBQueryDef aQueryDef)

Build UI from the Query Definition Object

Specified by:

buildFromQueryDef in interface QBBuilderInterface

Parameters:

aQueryDef - the query

fillQueryDef

public void fillQueryDef(DBQueryDef aQueryDef)

Fill the QueryDef from the Model

Specified by:

fillQueryDef in interface QBBuilderInterface

Parameters:

aQueryDef - the query