org.ecoinformatics.seek.querybuilder

Class QBSplitPaneIntermediate

java.lang.Object

java.awt.Component

java.awt.Container

javax.swing.JComponent

javax.swing.JPanel

org.ecoinformatics.seek.querybuilder.QBSplitPaneIntermediate

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 QBSplitPaneIntermediate
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 javax.swing.JRadioButton	mAllRadio
protected javax.swing.JRadioButton	mAnyRadio
protected DBTableDesktopPane	mDesktop
protected java.util.Hashtable	mModelHash
protected DSSchemaIFace	mSchema
protected javax.swing.JSplitPane	mSplitPane
protected DBTableJoin	mTableJoins
protected javax.swing.JList	mTableList
protected DBSelectTableModelStd	mTableModel
protected javax.swing.event.TableModelListener	mTableModelListener
protected java.util.Hashtable	mTablesViewHash
protected DBSelectTableUIStd	mTableView

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
QBSplitPaneIntermediate(DSSchemaIFace aSchema, javax.swing.event.TableModelListener aListener) QBSplitPaneIntermediate 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(DSSchemaIFace aSchema) Creates the lower panel that contains the tabs "Select" and "Where"
protected javax.swing.JPanel	createRadioButtons() Creates the radio buttons
java.lang.String	createSQL() Create SQL string
javax.swing.JComponent	createUpperPanel(DSSchemaIFace aSchema, 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

mAddBtn

protected javax.swing.JButton mAddBtn

mTableList

protected javax.swing.JList mTableList

mTableModelListener

protected javax.swing.event.TableModelListener mTableModelListener

mModelHash

protected java.util.Hashtable mModelHash

mTablesViewHash

protected java.util.Hashtable mTablesViewHash

mTableView

protected DBSelectTableUIStd mTableView

mTableModel

protected DBSelectTableModelStd mTableModel

mAllRadio

protected javax.swing.JRadioButton mAllRadio

mAnyRadio

protected javax.swing.JRadioButton mAnyRadio

Constructor Detail

QBSplitPaneIntermediate

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

QBSplitPaneIntermediate 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(DSSchemaIFace aSchema,
                                               javax.swing.event.TableModelListener aListener)

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

Parameters:

aSchema - the schema

aListener - the listener for the overall model changes

Returns:

the component representing the upper pane

createRadioButtons

protected javax.swing.JPanel createRadioButtons()

Creates the radio buttons

Returns:

the container (panel)

createLowerPanel

public javax.swing.JComponent createLowerPanel(DSSchemaIFace aSchema)

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

Parameters:

aSchema - the schema

Returns:

the component representing the lower pane

refresh

protected void refresh()

Makes the entire Desktop object repaint itself

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

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

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

createSQL

public java.lang.String createSQL()

Create SQL string

Specified by:

createSQL in interface QBBuilderInterface

Returns:

Returns a string representing the interal SQL Query

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