com.sptci.rwt.webui
Class BatchQueryExecutorView

java.lang.Object
  nextapp.echo2.app.Component
      consultas.echo2consultas.SpWindowPane
          com.sptci.echo2.WindowPane
              com.sptci.rwt.webui.ExecutorView
                  com.sptci.rwt.webui.BatchQueryExecutorView

All Implemented Interfaces:

com.sptci.echo2.View, Serializable, FloatingPane, ModalSupport, Pane, PaneContainer, RenderIdSupport

public class BatchQueryExecutorView
extends ExecutorView

Query executor view component used to send multiple SQL statements in one batch to the database server. Uses the BatchQueryExecutor class.

© Copyright 2007 Sans Pareil Technologies, Inc.

Version:

$Id: BatchQueryExecutorView.java 4123 2008-05-25 21:49:01Z rakesh $

Author:

Rakesh Vidyadharan 2007-10-10

See Also:

Serialized Form

Field Summary

private String	statement The SQL statement that is to be displayed in ExecutorView.query when it is initialised.
private TabbedPane	tabbedPane The tabbed pane used to display the results of query execution.

Fields inherited from class com.sptci.rwt.webui.ExecutorView

connectionManager, controller, history, maxColumnLength, maxResults, query, results

Fields inherited from class consultas.echo2consultas.SpWindowPane

DISPOSE_ON_CLOSE, DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE, INPUT_CLOSE, PROPERTY_BACKGROUND_IMAGE, PROPERTY_BORDER, PROPERTY_CLOSABLE, PROPERTY_CLOSE_ICON, PROPERTY_CLOSE_ICON_INSETS, PROPERTY_DEFAULT_CLOSE_OPERATION, PROPERTY_HEIGHT, PROPERTY_ICON, PROPERTY_ICON_INSETS, PROPERTY_INSETS, PROPERTY_MAXIMIZABLE, PROPERTY_MAXIMIZE_ICON, PROPERTY_MAXIMIZE_ICON_INSETS, PROPERTY_MAXIMIZED, PROPERTY_MAXIMUM_HEIGHT, PROPERTY_MAXIMUM_WIDTH, PROPERTY_MINIMIZABLE, PROPERTY_MINIMIZE_ICON, PROPERTY_MINIMIZE_ICON_INSETS, PROPERTY_MINIMIZED, PROPERTY_MINIMUM_HEIGHT, PROPERTY_MINIMUM_WIDTH, PROPERTY_MOVABLE, PROPERTY_POSITION_X, PROPERTY_POSITION_Y, PROPERTY_RESIZABLE, PROPERTY_TITLE, PROPERTY_TITLE_BACKGROUND, PROPERTY_TITLE_BACKGROUND_IMAGE, PROPERTY_TITLE_FONT, PROPERTY_TITLE_FOREGROUND, PROPERTY_TITLE_HEIGHT, PROPERTY_TITLE_INSETS, PROPERTY_WIDTH, Z_INDEX_CHANGED_PROPERTY

Fields inherited from class nextapp.echo2.app.Component

CHILDREN_CHANGED_PROPERTY, ENABLED_CHANGED_PROPERTY, FOCUS_TRAVERSAL_INDEX_CHANGED_PROPERTY, FOCUS_TRAVERSAL_PARTICIPANT_CHANGED_PROPERTY, LAYOUT_DIRECTION_CHANGED_PROPERTY, LOCALE_CHANGED_PROPERTY, PROPERTY_BACKGROUND, PROPERTY_FONT, PROPERTY_FOREGROUND, PROPERTY_LAYOUT_DATA, STYLE_CHANGED_PROPERTY, STYLE_NAME_CHANGED_PROPERTY, VISIBLE_CHANGED_PROPERTY

Fields inherited from interface nextapp.echo2.app.ModalSupport

MODAL_CHANGED_PROPERTY

Constructor Summary

BatchQueryExecutorView(MainController controller)
Create instance of the pane using the specified controller.

BatchQueryExecutorView(MainController controller, String statement)
Create instance of the pane using the specified controller.

Method Summary

void	addResults(String name, RowsTableModel model) Create a Table using the specified TableModel and display in a TabbedPane.
protected Component	createControls() Over-ridden to display controls relevant to this class.
(package private) void	createNavigation(RowsTableModel model, Component parent) Create a TableNavigation for the specified RowTable if necessary.
protected Component	createUpload() Create the component used to upload SQL script files.
void	init() Over-ridden to set the default value of ExecutorView.maxResults.
void	reset() Removes the results of a previous query execution.
void	setFile(File file) Set the contents of ExecutorView.query to the contents of the file specified.

Methods inherited from class com.sptci.rwt.webui.ExecutorView

addToHistory, createExecute, createExport, createHistory, createLiveTextField, createMaxColumnLength, createMaxResults, createQuery, createSave, getConnectionManager, getHistory, getListenerName, getMaxColumnLength, getMaxResults, getQuery, setQuery, setQueryFromHistory

Methods inherited from class consultas.echo2consultas.SpWindowPane

addWindowPaneListener, fireWindowClosing, getBackgroundImage, getBorder, getCloseIcon, getCloseIconInsets, getDefaultCloseOperation, getHeight, getIcon, getIconInsets, getInsets, getMaximizeIcon, getMaximizeIconInsets, getMaximumHeight, getMaximumWidth, getMinimizeIcon, getMinimizeIconInsets, getMinimumHeight, getMinimumWidth, getPositionX, getPositionY, getTitle, getTitleBackground, getTitleBackgroundImage, getTitleFont, getTitleForeground, getTitleHeight, getTitleInsets, getWidth, getZIndex, isClosable, isMaximizable, isMaximized, isMinimizable, isMinimized, isModal, isMovable, isResizable, isValidChild, isValidParent, processInput, removeWindowPaneListener, setBackgroundImage, setBorder, setClosable, setCloseIcon, setCloseIconInsets, setDefaultCloseOperation, setHeight, setIcon, setIconInsets, setInsets, setMaximizable, setMaximized, setMaximumHeight, setMaximumWidth, setMinimizable, setMinimized, setMinimumHeight, setMinimumWidth, setModal, setMovable, setPositionX, setPositionY, setResizable, setTitle, setTitleBackground, setTitleBackgroundImage, setTitleFont, setTitleForeground, setTitleHeight, setTitleInsets, setWidth, setZIndex, userClose

Methods inherited from class nextapp.echo2.app.Component

add, add, addPropertyChangeListener, addPropertyChangeListener, dispose, firePropertyChange, getApplicationInstance, getBackground, getComponent, getComponent, getComponentCount, getComponents, getEventListenerList, getFocusTraversalIndex, getFont, getForeground, getId, getIndexedProperty, getLayoutData, getLayoutDirection, getLocale, getParent, getProperty, getRenderId, getRenderIndexedProperty, getRenderIndexedProperty, getRenderLayoutDirection, getRenderLocale, getRenderProperty, getRenderProperty, getStyle, getStyleName, getVisibleComponent, getVisibleComponentCount, getVisibleComponents, hasEventListenerList, indexOf, isAncestorOf, isEnabled, isFocusTraversalParticipant, isRegistered, isRenderEnabled, isRenderVisible, isVisible, remove, remove, removeAll, removePropertyChangeListener, removePropertyChangeListener, setBackground, setEnabled, setFocusTraversalIndex, setFocusTraversalParticipant, setFont, setForeground, setId, setIndexedProperty, setLayoutData, setLayoutDirection, setLocale, setProperty, setRenderId, setStyle, setStyleName, setVisible, validate, verifyInput, visibleIndexOf

Methods inherited from class java.lang.Object

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

Field Detail

tabbedPane

private TabbedPane tabbedPane

The tabbed pane used to display the results of query execution.

statement

private String statement

The SQL statement that is to be displayed in ExecutorView.query when it is initialised.

Constructor Detail

BatchQueryExecutorView

public BatchQueryExecutorView(MainController controller)

Create instance of the pane using the specified controller.

Parameters:

controller - The controller to use to interact with the rest of the application.

BatchQueryExecutorView

public BatchQueryExecutorView(MainController controller,
                              String statement)

Create instance of the pane using the specified controller.

Parameters:

controller - The controller to use to interact with the rest of the application.

statement - The SQL statement that is to be displayed in the ExecutorView.query component.

Method Detail

init

public void init()

Over-ridden to set the default value of ExecutorView.maxResults.

Overrides:

init in class ExecutorView

See Also:

ExecutorView.createQuery(), ExecutorView.createControls()

createControls

protected Component createControls()

Over-ridden to display controls relevant to this class.

Specified by:

createControls in class ExecutorView

Returns:

The layout component.

See Also:

ExecutorView.createExecute(), ExecutorView.createMaxResults(nextapp.echo2.app.Component), ExecutorView.createMaxColumnLength(nextapp.echo2.app.Component), ExecutorView.createHistory(), ExecutorView.createSave(), createUpload()

reset

public void reset()

Removes the results of a previous query execution. Removes all the child components of ExecutorView.results and reinitialises tabbedPane.

Overrides:

reset in class ExecutorView

createUpload

protected Component createUpload()

Create the component used to upload SQL script files.

Returns:

The file upload component.

setFile

public void setFile(File file)

Set the contents of ExecutorView.query to the contents of the file specified.

Parameters:

file - The file whose contents are to be displayed in ExecutorView.query.

addResults

public void addResults(String name,
                       RowsTableModel model)

Create a Table using the specified TableModel and display in a TabbedPane.

Parameters:

name - The name to assign for the results tab.

model - The results table model to display.

See Also:

createNavigation(com.sptci.rwt.webui.RowsTableModel, nextapp.echo2.app.Component)

createNavigation

void createNavigation(RowsTableModel model,
                      Component parent)

Create a TableNavigation for the specified RowTable if necessary.

Parameters:

model - The table model based on whose size the navigation comonent is to be displayed.

parent - The parent component to which the navigation component is to be added.

Since:

Version 1.2