org.ecoinformatics.seek.querybuilder

Class DBWherePanel

java.lang.Object

java.awt.Component

java.awt.Container

javax.swing.JComponent

javax.swing.JPanel

org.ecoinformatics.seek.querybuilder.DBWherePanel

All Implemented Interfaces:

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

public class DBWherePanel
extends javax.swing.JPanel
implements javax.swing.event.ListSelectionListener, javax.swing.event.ListDataListener

This class is a JPanel that contains the list of Where OPerator and Condition objects. NOTE: The list display the operator and its children in reverse polish notation. It also contains
1) a sub-panel with some UI for adding and removing items.
2) A subpanel inspector for the editting of the COndition or Operator items
3) A text control for displaying the results of the where conidtion

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	mAddAndOperBtn
protected javax.swing.JButton	mAddCondBtn
protected javax.swing.JButton	mAddOROperBtn
protected javax.swing.JComboBox	mCondCombobox
protected javax.swing.JPanel	mCondInspPanel
protected javax.swing.JTextField	mCriteriaField
protected javax.swing.JPanel	mCurrInspPanel
protected javax.swing.JEditorPane	mEditorPane
protected javax.swing.JComboBox	mFieldsCombobox
protected javax.swing.JPanel	mInspContainer
protected DBWhereList	mList
protected DBWhereModel	mModel
protected javax.swing.event.TableModelListener	mModelListener
protected javax.swing.JTextField	mNameField
protected javax.swing.JComboBox	mOperCombobox
protected javax.swing.JPanel	mOperInspPanel
protected boolean	mRejectChanges
protected javax.swing.JButton	mRemoveBtn
protected DSSchemaIFace	mSchema
protected javax.swing.JComboBox	mTablesCombobox
protected javax.swing.JScrollPane	mTextScrollPane

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 and Description
DBWherePanel(DSSchemaIFace aSchema) Constructor

Method Summary

Modifier and Type	Method and Description
protected void	addNewItem(DBWhereIFace aParent, DBWhereIFace aItem) Helper class to add new item to main list
protected void	addOperator(java.lang.String aOperName) Create a new operator and two children
void	contentsChanged(javax.swing.event.ListDataEvent e)
protected javax.swing.JPanel	createCondInspector() Creates the inspector panel for a condition
protected javax.swing.JPanel	createControlPanel() Creates the control panel of button for adding and removing items in the "where clause"
protected javax.swing.JPanel	createOperInspector() Creates the inspector panel for the Operator
protected void	doUpdate(boolean aDoTextOnly) Updates the inspector UI depending on the type of object being editted
void	fillQueryDef(DBQueryDef aQueryDef) Fills QueryDef from Model
protected void	generateAndSetWhereText() Generates a textual representation of the "where" clause and displays it
java.lang.String	generateWhereSQL(boolean aUseSymbols) Generates a textual representation of the "where" clause
protected int	getIndexForName(javax.swing.JComboBox aCBX, java.lang.String aName) Returns the index of a String item in a combobox
DBWhereModel	getModel() Returns the model
protected DBWhereOperator	getParentForInsert() Return the appropriate DBWhereIFace object that the new item will be parented to
void	intervalAdded(javax.swing.event.ListDataEvent e)
void	intervalRemoved(javax.swing.event.ListDataEvent e)
boolean	isComplex() Generates a textual representation of the "where" clause
protected boolean	isComplexRecurse(DBWhereOperator aParent, java.lang.String aName) Recurses through the "tree" of operators and creates a textual rendering of the operators and conditions
protected javax.swing.JButton	makeButton(javax.swing.JPanel aPanel, java.lang.String name, java.awt.GridBagLayout gridbag, java.awt.GridBagConstraints c) Creates and adds a button to the control panel used for editting the list of operators and conditions
protected void	populateFieldComboboxFromMainList() Given a selection in the "main" list it populates the Field Combobox from the table
protected int	recurseList(DBWhereOperator aOper, java.lang.StringBuffer aStrBuf, int aLevel, boolean aUseSymbols) Recurses through the "tree" of operators and creates a textual rendering of the operators and conditions
void	setModelListener(javax.swing.event.TableModelListener aTblModelListener) Set a single model listener
void	valueChanged(javax.swing.event.ListSelectionEvent e) Upates the "inspector" ui when an item in the list is clicked on

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

mList

protected DBWhereList mList

mModel

protected DBWhereModel mModel

mSchema

protected DSSchemaIFace mSchema

mAddCondBtn

protected javax.swing.JButton mAddCondBtn

mAddAndOperBtn

protected javax.swing.JButton mAddAndOperBtn

mAddOROperBtn

protected javax.swing.JButton mAddOROperBtn

mRemoveBtn

protected javax.swing.JButton mRemoveBtn

mNameField

protected javax.swing.JTextField mNameField

mCriteriaField

protected javax.swing.JTextField mCriteriaField

mEditorPane

protected javax.swing.JEditorPane mEditorPane

mTextScrollPane

protected javax.swing.JScrollPane mTextScrollPane

mTablesCombobox

protected javax.swing.JComboBox mTablesCombobox

mFieldsCombobox

protected javax.swing.JComboBox mFieldsCombobox

mCondCombobox

protected javax.swing.JComboBox mCondCombobox

mOperCombobox

protected javax.swing.JComboBox mOperCombobox

mCondInspPanel

protected javax.swing.JPanel mCondInspPanel

mOperInspPanel

protected javax.swing.JPanel mOperInspPanel

mCurrInspPanel

protected javax.swing.JPanel mCurrInspPanel

mInspContainer

protected javax.swing.JPanel mInspContainer

mRejectChanges

protected boolean mRejectChanges

mModelListener

protected javax.swing.event.TableModelListener mModelListener

Constructor Detail

DBWherePanel

public DBWherePanel(DSSchemaIFace aSchema)

Constructor

Parameters:

aSchema - the schema

Method Detail

setModelListener

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

Set a single model listener

Parameters:

aTblModelListener - the listener

getModel

public DBWhereModel getModel()

Returns the model

Returns:

the model

createCondInspector

protected javax.swing.JPanel createCondInspector()

Creates the inspector panel for a condition

Returns:

the panel

createOperInspector

protected javax.swing.JPanel createOperInspector()

Creates the inspector panel for the Operator

Returns:

the panel

makeButton

protected javax.swing.JButton makeButton(javax.swing.JPanel aPanel,
                                         java.lang.String name,
                                         java.awt.GridBagLayout gridbag,
                                         java.awt.GridBagConstraints c)

Creates and adds a button to the control panel used for editting the list of operators and conditions

Parameters:

aPanel - the parent

name - the name/text on the button

gridbag - gridbag

c - constraint

Returns:

the new button

addNewItem

protected void addNewItem(DBWhereIFace aParent,
                          DBWhereIFace aItem)

Helper class to add new item to main list

Parameters:

aItem - item to be added

getParentForInsert

protected DBWhereOperator getParentForInsert()

Return the appropriate DBWhereIFace object that the new item will be parented to

Returns:

the parent

addOperator

protected void addOperator(java.lang.String aOperName)

Create a new operator and two children

Parameters:

aOperName -

createControlPanel

protected javax.swing.JPanel createControlPanel()

Creates the control panel of button for adding and removing items in the "where clause"

doUpdate

protected void doUpdate(boolean aDoTextOnly)

Updates the inspector UI depending on the type of object being editted

Parameters:

aDoTextOnly -

recurseList

protected int recurseList(DBWhereOperator aOper,
                          java.lang.StringBuffer aStrBuf,
                          int aLevel,
                          boolean aUseSymbols)

Recurses through the "tree" of operators and creates a textual rendering of the operators and conditions

Parameters:

aOper -

aStrBuf -

aLevel -

generateWhereSQL

public java.lang.String generateWhereSQL(boolean aUseSymbols)

Generates a textual representation of the "where" clause

isComplexRecurse

protected boolean isComplexRecurse(DBWhereOperator aParent,
                                   java.lang.String aName)

Recurses through the "tree" of operators and creates a textual rendering of the operators and conditions

Parameters:

aOper -

aStrBuf -

aLevel -

isComplex

public boolean isComplex()

Generates a textual representation of the "where" clause

generateAndSetWhereText

protected void generateAndSetWhereText()

Generates a textual representation of the "where" clause and displays it

populateFieldComboboxFromMainList

protected void populateFieldComboboxFromMainList()

Given a selection in the "main" list it populates the Field Combobox from the table

getIndexForName

protected int getIndexForName(javax.swing.JComboBox aCBX,
                              java.lang.String aName)

Returns the index of a String item in a combobox

Parameters:

aCBX - the combobox

aName - the string name of the item

Returns:

the index in the combobox

fillQueryDef

public void fillQueryDef(DBQueryDef aQueryDef)

Fills QueryDef from Model

valueChanged

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

Upates the "inspector" ui when an item in the list is clicked on

Specified by:

valueChanged in interface javax.swing.event.ListSelectionListener

contentsChanged

public void contentsChanged(javax.swing.event.ListDataEvent e)

Specified by:

contentsChanged in interface javax.swing.event.ListDataListener

intervalAdded

public void intervalAdded(javax.swing.event.ListDataEvent e)

Specified by:

intervalAdded in interface javax.swing.event.ListDataListener

intervalRemoved

public void intervalRemoved(javax.swing.event.ListDataEvent e)

Specified by:

intervalRemoved in interface javax.swing.event.ListDataListener