appli.sqlplayer.gui
Class SqlPlayerSQLCommandsPane

java.lang.Object
  extended byjava.awt.Component
      extended byjava.awt.Container
          extended byjavax.swing.JComponent
              extended byjavax.swing.JPanel
                  extended byappli.sqlplayer.gui.SqlPlayerSQLCommandsPane
All Implemented Interfaces:
javax.accessibility.Accessible, java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable

public class SqlPlayerSQLCommandsPane
extends javax.swing.JPanel

Tab containing the SQL command list.
They can be visualized as a list or as a tree based on the 'category' tag definitions A selected command can be executed.
A command file can be dynamically loaded, and the current one can be reloaded.

Version:
1.0 July 2003 (SJ)
Author:
Sylvaine Jaehn
See Also:
Serialized Form

Nested Class Summary
 
Nested classes inherited from class javax.swing.JPanel
javax.swing.JPanel.AccessibleJPanel
 
Nested classes inherited from class javax.swing.JComponent
javax.swing.JComponent.AccessibleJComponent
 
Nested classes inherited from class java.awt.Container
java.awt.Container.AccessibleAWTContainer
 
Nested classes inherited from class java.awt.Component
java.awt.Component.AccessibleAWTComponent, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy
 
Field Summary
private  javax.swing.JTree catTree
           
private  javax.swing.JFileChooser chooser
           
private  java.io.File currentDir
           
private  javax.swing.JButton displayModeBtn
           
private  Mediator med
           
private  SqlCommands partSqlCommands
           
private  javax.swing.JPanel pCmdsList
           
private  SqlCommands sqlcommands
           
private  javax.swing.JTable sqlTable
           
private static int SQLTABLE_HEIGHT
           
private  javax.swing.JTable sqlTable2
           
 
Fields inherited from class javax.swing.JPanel
 
Fields inherited from class javax.swing.JComponent
accessibleContext, 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.Container
 
Fields inherited from class java.awt.Component
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
SqlPlayerSQLCommandsPane()
          Tab panel constructor
 
Method Summary
private  void catTree_valueChanged()
          Actions effectuees lors de la selection d'un noeud de l'arbre des categories (=> affichage des commandes de la categorie selectionnee)
 void displayMode()
          Affichage de la liste des commandes SQL sous plusieurs formes (table, arbre)
private  void displayModeBtn_actionPerformed()
          Changement du mode d'affichage des commandes SQL
private  void execBtn_actionPerformed()
          Execution de la commande SQL selectionnee
private  void execSQLCmd()
          Execution de la commande SQL selectionnee, soit directement, soit par l'intermediaire d'une fenetre pour la saisie des parametres
private  void jbInit()
          Component initialization
private  void loadSqlBtn_actionPerformed()
          Load Button was pressed and a new SQLParser object is created and the SQL batch file is parsed
private  void reloadSqlBtn_actionPerformed()
          Action effectuee quand pression sur le bouton reload : rechargement du fichier des commandes courant.
private  void sqlTable_mouseClicked(java.awt.event.MouseEvent e)
          Action quand double clic sur une ligne de la table contenant les commandes SQL (affichage table) : execution de la commande selectionnee
private  void sqlTable2_mouseClicked(java.awt.event.MouseEvent e)
          Action quand double clic sur une ligne de la table contenant les commandes SQL (affichage arbre) : execution de la commande selectionnee
 
Methods inherited from class javax.swing.JPanel
getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUI
 
Methods inherited from class javax.swing.JComponent
addAncestorListener, addNotify, addPropertyChangeListener, addPropertyChangeListener, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBorder, getBounds, getClientProperty, getComponentGraphics, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getGraphics, getHeight, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPreferredSize, getPropertyChangeListeners, getPropertyChangeListeners, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isMaximumSizeSet, isMinimumSizeSet, isOpaque, isOptimizedDrawingEnabled, isPaintingTile, isPreferredSizeSet, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removePropertyChangeListener, removePropertyChangeListener, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setFont, setForeground, 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, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setFocusCycleRoot, setFocusTraversalKeys, setFocusTraversalPolicy, setLayout, transferFocusBackward, 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, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMouseWheelListeners, getName, getParent, getPeer, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, 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, processMouseEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusUpCycle
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

SQLTABLE_HEIGHT

private static final int SQLTABLE_HEIGHT
See Also:
Constant Field Values

med

private Mediator med

sqlcommands

private SqlCommands sqlcommands

sqlTable

private javax.swing.JTable sqlTable

catTree

private javax.swing.JTree catTree

sqlTable2

private javax.swing.JTable sqlTable2

partSqlCommands

private SqlCommands partSqlCommands

currentDir

private java.io.File currentDir

pCmdsList

private javax.swing.JPanel pCmdsList

displayModeBtn

private javax.swing.JButton displayModeBtn

chooser

private javax.swing.JFileChooser chooser
Constructor Detail

SqlPlayerSQLCommandsPane

public SqlPlayerSQLCommandsPane()
Tab panel constructor

Method Detail

jbInit

private void jbInit()
             throws java.lang.Exception
Component initialization

Throws:
java.lang.Exception

loadSqlBtn_actionPerformed

private void loadSqlBtn_actionPerformed()
Load Button was pressed and a new SQLParser object is created and the SQL batch file is parsed


reloadSqlBtn_actionPerformed

private void reloadSqlBtn_actionPerformed()
Action effectuee quand pression sur le bouton reload : rechargement du fichier des commandes courant.


displayModeBtn_actionPerformed

private void displayModeBtn_actionPerformed()
Changement du mode d'affichage des commandes SQL


execBtn_actionPerformed

private void execBtn_actionPerformed()
Execution de la commande SQL selectionnee


catTree_valueChanged

private void catTree_valueChanged()
Actions effectuees lors de la selection d'un noeud de l'arbre des categories (=> affichage des commandes de la categorie selectionnee)


displayMode

public void displayMode()
Affichage de la liste des commandes SQL sous plusieurs formes (table, arbre)


sqlTable_mouseClicked

private void sqlTable_mouseClicked(java.awt.event.MouseEvent e)
Action quand double clic sur une ligne de la table contenant les commandes SQL (affichage table) : execution de la commande selectionnee

Parameters:
e - objet MouseEvent

sqlTable2_mouseClicked

private void sqlTable2_mouseClicked(java.awt.event.MouseEvent e)
Action quand double clic sur une ligne de la table contenant les commandes SQL (affichage arbre) : execution de la commande selectionnee

Parameters:
e - objet MouseEvent

execSQLCmd

private void execSQLCmd()
Execution de la commande SQL selectionnee, soit directement, soit par l'intermediaire d'une fenetre pour la saisie des parametres