appli.sqlplayer.gui
Class SqlPlayerResultPane

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

public class SqlPlayerResultPane
extends javax.swing.JPanel
implements Observer

Title:

Description: Affichage des resultats des commandes SQL contenues dans un fichier de commandes

Copyright: Copyright (c) 2003

Company:

Version:
1.0 July 2003
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.JFileChooser chooser
           
private  DisplayState dispCurASCIIState
           
private  DisplayState dispCurReportState
           
private  DisplayState dispCurTableState
           
private  DisplayState dispCurTSVState
           
private  DisplayState dispRealState
           
private  DisplayResultFormat drf
           
private  javax.swing.JLabel lblCmd
           
private  javax.swing.JLabel lblDescrCmd
           
private  javax.swing.JLabel lblDescrCmdValue
           
private  javax.swing.JLabel lblExecTime
           
private  javax.swing.JLabel lblExecTimeValue
           
private  javax.swing.JLabel lblNbRows
           
private  javax.swing.JLabel lblNbRowsValue
           
private  Mediator med
           
private  NavigPane navigPane
           
private  int nbTotalRows
           
private  javax.swing.JPanel pResult
           
private  javax.swing.JRadioButton rbASCII
           
private  javax.swing.JRadioButton rbReport
           
private  javax.swing.JRadioButton rbTable
           
private  javax.swing.JRadioButton rbTSV
           
private  javax.swing.JRadioButton rbXML
           
private  java.lang.Object resQuery
           
private  javax.swing.JTable resTable
           
private  javax.swing.JScrollPane scrollCmd
           
private  int state
           
private  javax.swing.JTextArea txtArea
           
private  javax.swing.JTextArea txtCmdValue
           
 
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
SqlPlayerResultPane()
          Construct the panel
 
Method Summary
 void displayMode()
          Affichage du resultat de la commande SQL sous plusieurs formes (table, texte...)
private  void displayText(DisplayState dispState)
          Affichage du resultat dans une zone de texte suivant l'etat d'affichage reel
 void initOptionPane()
          Initialisation des composants optionnels (invisibles).
private  void initPane()
          Initialisation de composants du panel.
private  void jbInit()
          Component initialization
private  void newQueryBtn_actionPerformed()
          Action effectuee quand pression sur le bouton New Query : nouvelle execution de la commande.
 void rbASCII_actionPerformed()
          Action effectuee quand clic sur le bouton radio ASCII Table
 void rbReport_actionPerformed()
          Action effectuee quand clic sur le bouton radio Report
 void rbTable_actionPerformed()
          Action effectuee quand clic sur le bouton radio Table
 void rbTSV_actionPerformed()
          Action effectuee quand clic sur le bouton radio TSV Table
 void rbXML_actionPerformed()
          Action effectuee quand clic sur le bouton radio XML. (+) Aucun effet pour le moment
 void refreshOptions()
          Affichage ou non des labels correspondant aux options cochees dans l'onglet des parametres
private  void saveBtn_actionPerformed()
          Action effectuee quand pression sur le bouton d'enregistrement : sauvegarde du resultat dans un fichier.
 void sendNotify(java.util.ArrayList value)
           
 void sendNotify(boolean value)
           
 void sendNotify(int value)
          Notification de changement du composant observe
 void sendNotify(java.lang.String value)
           
private  void setCurState(DisplayState dispState)
          Calcul de l'etat d'affichage courant (positionnement par rapport a l'etat reel) et mise a jour de l'etat reel.
 void setResQuery(java.lang.Object resQuery)
          Positionnement du resultat a afficher
 
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

nbTotalRows

private int nbTotalRows

med

private Mediator med

drf

private DisplayResultFormat drf

resQuery

private java.lang.Object resQuery

pResult

private javax.swing.JPanel pResult

resTable

private javax.swing.JTable resTable

txtArea

private javax.swing.JTextArea txtArea

rbTable

private javax.swing.JRadioButton rbTable

rbTSV

private javax.swing.JRadioButton rbTSV

rbASCII

private javax.swing.JRadioButton rbASCII

rbReport

private javax.swing.JRadioButton rbReport

rbXML

private javax.swing.JRadioButton rbXML

chooser

private javax.swing.JFileChooser chooser

lblDescrCmd

private javax.swing.JLabel lblDescrCmd

lblDescrCmdValue

private javax.swing.JLabel lblDescrCmdValue

lblCmd

private javax.swing.JLabel lblCmd

scrollCmd

private javax.swing.JScrollPane scrollCmd

txtCmdValue

private javax.swing.JTextArea txtCmdValue

lblExecTime

private javax.swing.JLabel lblExecTime

lblExecTimeValue

private javax.swing.JLabel lblExecTimeValue

lblNbRows

private javax.swing.JLabel lblNbRows

lblNbRowsValue

private javax.swing.JLabel lblNbRowsValue

navigPane

private NavigPane navigPane

dispRealState

private DisplayState dispRealState

dispCurTableState

private DisplayState dispCurTableState

dispCurTSVState

private DisplayState dispCurTSVState

dispCurASCIIState

private DisplayState dispCurASCIIState

dispCurReportState

private DisplayState dispCurReportState

state

private int state
Constructor Detail

SqlPlayerResultPane

public SqlPlayerResultPane()
Construct the panel

Method Detail

jbInit

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

Throws:
java.lang.Exception

saveBtn_actionPerformed

private void saveBtn_actionPerformed()
Action effectuee quand pression sur le bouton d'enregistrement : sauvegarde du resultat dans un fichier.


newQueryBtn_actionPerformed

private void newQueryBtn_actionPerformed()
Action effectuee quand pression sur le bouton New Query : nouvelle execution de la commande.


displayMode

public void displayMode()
Affichage du resultat de la commande SQL sous plusieurs formes (table, texte...)


displayText

private void displayText(DisplayState dispState)
Affichage du resultat dans une zone de texte suivant l'etat d'affichage reel

Parameters:
dispState - etat d'affichage courant

setCurState

private void setCurState(DisplayState dispState)
Calcul de l'etat d'affichage courant (positionnement par rapport a l'etat reel) et mise a jour de l'etat reel.

Parameters:
dispState - etat d'affichage courant

setResQuery

public void setResQuery(java.lang.Object resQuery)
Positionnement du resultat a afficher

Parameters:
resQuery - object contenant le resultat a afficher

rbTable_actionPerformed

public void rbTable_actionPerformed()
Action effectuee quand clic sur le bouton radio Table


rbTSV_actionPerformed

public void rbTSV_actionPerformed()
Action effectuee quand clic sur le bouton radio TSV Table


rbASCII_actionPerformed

public void rbASCII_actionPerformed()
Action effectuee quand clic sur le bouton radio ASCII Table


rbReport_actionPerformed

public void rbReport_actionPerformed()
Action effectuee quand clic sur le bouton radio Report


rbXML_actionPerformed

public void rbXML_actionPerformed()
Action effectuee quand clic sur le bouton radio XML. (+) Aucun effet pour le moment


refreshOptions

public void refreshOptions()
Affichage ou non des labels correspondant aux options cochees dans l'onglet des parametres


initPane

private void initPane()
Initialisation de composants du panel. Effectue lors d'un nouveau resultat a afficher


initOptionPane

public void initOptionPane()
Initialisation des composants optionnels (invisibles).
Certains deviendront visibles apres l'execution d'une commande si les cases associees sont cochees.


sendNotify

public void sendNotify(int value)
Notification de changement du composant observe

Specified by:
sendNotify in interface Observer
Parameters:
value - valeur recue suivant le changement effectue dans le composant observe

sendNotify

public void sendNotify(boolean value)
Specified by:
sendNotify in interface Observer

sendNotify

public void sendNotify(java.lang.String value)
Specified by:
sendNotify in interface Observer

sendNotify

public void sendNotify(java.util.ArrayList value)
Specified by:
sendNotify in interface Observer