org.adempiere.webui.apps.form
Class WSQLProcess

java.lang.Object
  org.zkoss.zk.ui.AbstractComponent
      org.zkoss.zk.ui.HtmlBasedComponent
          org.zkoss.zul.impl.XulElement
              org.zkoss.zul.Window
                  org.adempiere.webui.component.Window
                      org.adempiere.webui.panel.ADForm
                          org.adempiere.webui.apps.form.WSQLProcess

All Implemented Interfaces:

Serializable, Cloneable, Component, EventListener, IdSpace, ComponentCtrl

public class WSQLProcess
extends ADForm
implements EventListener

A Custom Form to specify and process SQL statements. The range of statement types that can be performed can be restricted by allowing or disallowing DML statements.

Author:

Andrew Kimball

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class org.zkoss.zul.Window

Window.ExtraCtrl

Field Summary

Fields inherited from class org.adempiere.webui.panel.ADForm

logger, m_windowNo

Fields inherited from class org.adempiere.webui.component.Window

MODE_EMBEDDED, MODE_MODAL, MODE_OVERLAPPED, MODE_POPUP

Fields inherited from class org.zkoss.zk.ui.HtmlBasedComponent

RS_NO_DISPLAY, RS_NO_HEIGHT, RS_NO_WIDTH

Fields inherited from interface org.zkoss.zk.ui.Component

APPLICATION_SCOPE, COMPONENT_SCOPE, DESKTOP_SCOPE, PAGE_SCOPE, REQUEST_SCOPE, SESSION_SCOPE, SPACE_SCOPE

Constructor Summary

WSQLProcess()
Default constructor.

Method Summary

static Button	createProcessButton() Create Process Button.
void	init(int adFormId, String name) Initialise the form
void	onEvent(Event event)
static String	processStatement(String sqlStatement, boolean allowDML) Process SQL Statements.
static String	processStatements(String sqlStatements, boolean allowDML) Process a semicolon delimitted list of SQL Statements.

Methods inherited from class org.adempiere.webui.panel.ADForm

getAdFormId, getTitle, getWindowNo, isAsap, openForm

Methods inherited from class org.zkoss.zul.Window

clone, doEmbedded, doHighlighted, doModal, doOverlapped, doPopup, getBorder, getCaption, getContentSclass, getContentStyle, getDefaultActionOnShow, getMode, getOuterAttrs, getPosition, getRealStyle, getSclass, getTitleSclass, inEmbedded, inHighlighted, inModal, inOverlapped, inPopup, insertBefore, isClosable, isSizable, newExtraCtrl, onChildRemoved, onClose, onModal, setBorder, setClosable, setContentSclass, setContentStyle, setDefaultActionOnShow, setDraggable, setMode, setMode, setPage, setParent, setPosition, setSclass, setSizable, setTitle, setVisible

Methods inherited from class org.zkoss.zul.impl.XulElement

getAction, getActionAttrs, getAllOnClickAttrs, getContext, getCtrlKeys, getInnerAttrs, getPopup, getTooltip, setAction, setContext, setContext, setCtrlKeys, setPopup, setPopup, setTooltip, setTooltip

Methods inherited from class org.zkoss.zk.ui.HtmlBasedComponent

focus, getAllOnClickAttrs, getDraggable, getDroppable, getHeight, getLeft, getRealSclass, getRealStyleFlags, getStyle, getTooltiptext, getTop, getWidth, getZIndex, setClass, setDroppable, setFocus, setHeight, setLeft, setStyle, setTooltiptext, setTop, setWidth, setZIndex

Methods inherited from class org.zkoss.zk.ui.AbstractComponent

addAnnotation, addAnnotation, addEventHandler, addEventListener, addForward, addForward, addForward, addForward, addMoved, addSharedAnnotationMap, addSharedEventHandlerMap, appendAsapAttr, appendAsapAttr, appendChild, applyProperties, containsVariable, detach, equals, getAnnotatedProperties, getAnnotatedPropertiesBy, getAnnotation, getAnnotation, getAnnotations, getAnnotations, getAttribute, getAttribute, getAttributes, getAttributes, getChildren, getCommand, getDefinition, getDesktop, getEventHandler, getEventHandlerNames, getExtraCtrl, getFellow, getFellowIfAny, getFellows, getFirstChild, getId, getLastChild, getListenerIterator, getMold, getMoldURI, getNamespace, getNextSibling, getPage, getParent, getPreviousSibling, getPropagatee, getRoot, getSpaceOwner, getUuid, getVariable, invalidate, isAsapRequired, isChildable, isInvalidated, isListenerAvailable, isVisible, onChildAdded, onDrawNewChild, onPageAttached, onPageDetached, onWrongValue, redraw, removeAttribute, removeAttribute, removeChild, removeEventListener, removeForward, removeForward, response, sessionDidActivate, sessionWillPassivate, setAttribute, setAttribute, setComponentDefinition, setId, setMold, setPageBefore, setVariable, smartUpdate, smartUpdate, smartUpdate, smartUpdateDeferred, smartUpdateValues, toString, unsetVariable

Methods inherited from class java.lang.Object

finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.zkoss.zk.ui.IdSpace

getFellow, getFellowIfAny, getFellows

Constructor Detail

WSQLProcess

public WSQLProcess()

Default constructor.

Method Detail

init

public void init(int adFormId,
                 String name)

Description copied from class: ADForm

Initialise the form

Overrides:

init in class ADForm

Parameters:

adFormId - the Adempiere form identifier

name - the name of the Adempiere form

createProcessButton

public static final Button createProcessButton()

Create Process Button.

Returns:

button

processStatements

public static String processStatements(String sqlStatements,
                                       boolean allowDML)

Process a semicolon delimitted list of SQL Statements.

Parameters:

sqlStatements - one or more statements separated by a semicolon (';')

allowDML - whether to allow DML statements

Returns:

a string summarising the results

processStatement

public static String processStatement(String sqlStatement,
                                      boolean allowDML)

Process SQL Statements.

Parameters:

sqlStatement - a single SQL statement

allowDML - whether to allow DML statements

Returns:

a string summarising the results

onEvent

public void onEvent(Event event)
             throws Exception

Specified by:

onEvent in interface EventListener

Overrides:

onEvent in class ADForm

Throws:

Exception