com.jalios.jcms.widget
Class SQLQueryWidget

java.lang.Object
  com.jalios.jcms.widget.AbstractWidget
      com.jalios.jcms.widget.TextAreaWidget
          com.jalios.jcms.widget.SQLQueryWidget

All Implemented Interfaces:

JcmsConstants, JaliosConstants

public class SQLQueryWidget
extends TextAreaWidget

This widget provides an input to enter a SQL query

Since:

jcms-5.5.0

Version:

$Revision: 27753 $

Author:

Olivier Dedieu

Field Summary

protected String	dataSource
protected String[]	dataSourceArray
protected boolean	dataSourceMenu
protected static org.apache.log4j.Logger	logger
protected int	maxRows
protected int[]	maxRowsArray
static String	REVISION
protected int	rows

Fields inherited from class com.jalios.jcms.widget.TextAreaWidget

cols, imageMap, wysiwygParams

Fields inherited from class com.jalios.jcms.widget.AbstractWidget

channel, context, css, customAttributes, defaultValue, description, descriptionUI, disabled, editorUI, firstInputID, forceUpDown, formName, hidden, hiddenActions, inline, isTabbed, itemCount, keyword, label, languageList, multilingual, printLabel, printSeparator, printWidget, required, showAddButton, showAddIcons, showCalendarIcons, showCategoryButton, showColorChooser, showCreateIcons, showDBRecChooser, showDocChooser, showDownIcons, showEditIcons, showFileChooser, showGrpChooser, showImageChooser, showLeftIcons, showLinkID, showMediaChooser, showMrbChooser, showQueryChooser, showRemoveIcons, showRightIcons, showSelectIcons, showTrashIcons, showUpIcons, showWebdavChooser, tabGroup, tabIndex, UI_DESCRIPTION_NONE, UI_DESCRIPTION_TEXT, UI_DESCRIPTION_TOOLTIP, UI_EDITOR_ACLCHOOSER, UI_EDITOR_CATEGORIESCHOOSER, UI_EDITOR_CATEGORYCHOOSER, UI_EDITOR_CATEGORYTREE, UI_EDITOR_COLORCHOOSER, UI_EDITOR_DATECHOOSER, UI_EDITOR_DBRECORDCHOOSER, UI_EDITOR_DURATIONCHOOSER, UI_EDITOR_EMAIL, UI_EDITOR_ENUMERATE_BOOLEAN, UI_EDITOR_ENUMERATE_CATEGORIES, UI_EDITOR_ENUMERATE_CHECK, UI_EDITOR_ENUMERATE_COMBO, UI_EDITOR_ENUMERATE_GROUP, UI_EDITOR_ENUMERATE_LIST, UI_EDITOR_ENUMERATE_MEMBER, UI_EDITOR_ENUMERATE_RADIO, UI_EDITOR_FILEPATH, UI_EDITOR_GROUPCHOOSER, UI_EDITOR_GROUPSCHOOSER, UI_EDITOR_IMAGEMAPAREA, UI_EDITOR_IMAGEPATH, UI_EDITOR_MEDIAPATH, UI_EDITOR_MEMBERCHOOSER, UI_EDITOR_MEMBERSCHOOSER, UI_EDITOR_PASSWORD, UI_EDITOR_PUBLICATIONCHOOSER, UI_EDITOR_PUBLICATIONSCHOOSER, UI_EDITOR_QUERYCHOOSER, UI_EDITOR_RICHTEXT, UI_EDITOR_SIMPLEIMAGEPATH, UI_EDITOR_SIMPLEMEDIAPATH, UI_EDITOR_SQLQUERY, UI_EDITOR_TEXTAREA, UI_EDITOR_TEXTFIELD, UI_EDITOR_TEXTFIELD_DOUBLE, UI_EDITOR_TEXTFIELD_INTEGER, UI_EDITOR_URL, UI_EDITOR_WARNAREA, UI_EDITOR_WIKIAREA, UI_EDITOR_WORKSPACECHOOSER, userLang, valueMap, values, widgetAddCount, widgetId, widgetName, wrapper

Fields inherited from interface com.jalios.jcms.JcmsConstants

ADATE_SEARCH, ADMIN_NOTES_PROP, ADVANCED_TAB, ARCHIVES_DIR, ASCII_WIDTH, CATEGORY_TAB, CDATE_SEARCH, COMMON_ALARM, CONTENT_TAB, COOKIE_MAX_AGE, CRYPT_MD5, CRYPT_UNDEFINED, CRYPT_UNIX, CTRL_TOPIC_INTERNAL, CTRL_TOPIC_REF, CTRL_TOPIC_VALUE, CTRL_TOPIC_WRITE, CUSTOM_PROP, DOCCHOOSER_HEIGHT, DOCCHOOSER_WIDTH, DOCS_DIR, EDATE_SEARCH, EMAIL_REGEXP, ERROR_MSG, FORBIDDEN_FILE_ACCESS, FORBIDDEN_REDIRECT, FORCE_REDIRECT, ICON_ARCHIVE, ICON_LOCK, ICON_LOCK_STRONG, ICON_WARN, ICON_WH_BOOK_CLOSED, ICON_WH_BOOK_OPEN, INFORMATION_MSG, JALIOS_JUNIT_PROP, JCMS_CADDY, JCMS_MSG_LIST, JSYNC_DOWNLOAD_DIR, JSYNC_SYNC_ALARM, LOG_FILE, LOG_TOPIC_SECURITY, LOGGER_PROP, LOGGER_XMLPROP, MBR_PHOTO_DIR, MDATE_SEARCH, MONITOR_XML, OP_CREATE, OP_DEEP_COPY, OP_DEEP_DELETE, OP_DELETE, OP_MERGE, OP_UPDATE, PDATE_SEARCH, PHOTO_DIR, PHOTO_ICON, PHOTO_ICON_HEIGHT, PHOTO_ICON_WIDTH, PHOTO_LARGE, PHOTO_LARGE_HEIGHT, PHOTO_LARGE_WIDTH, PHOTO_NORMAL, PHOTO_NORMAL_HEIGHT, PHOTO_NORMAL_WIDTH, PHOTO_SMALL, PHOTO_SMALL_HEIGHT, PHOTO_SMALL_WIDTH, PHOTO_TINY, PHOTO_TINY_HEIGHT, PHOTO_TINY_WIDTH, PREVIOUS_TAB, PRINT_VIEW, PRIVATE_FILE_ACCESS, PUBLIC_FILE_ACCESS, READ_RIGHT_TAB, SDATE_SEARCH, SEARCHENGINE_ALARM, SESSION_AUTHORIZED_FILENAMES_SET, STATS_REPORT_DIR, STATUS_PROP, STORE_XML, TEMPLATE_TAB, THUMBNAIL_LARGE_HEIGHT, THUMBNAIL_LARGE_WIDTH, THUMBNAIL_SMALL_HEIGHT, THUMBNAIL_SMALL_WIDTH, UDATE_SEARCH, UPDATE_RIGHT_TAB, UPLOAD_DIR, URL_REGEXP, WARNING_MSG, WEBAPP_PROP, WFEXPRESS_ALARM, WFREMINDER_ALARM, WORKFLOW_TAB, WORKFLOW_XML

Fields inherited from interface com.jalios.util.JaliosConstants

CRLF, MILLIS_IN_ONE_DAY, MILLIS_IN_ONE_HOUR, MILLIS_IN_ONE_MINUTE, MILLIS_IN_ONE_MONTH, MILLIS_IN_ONE_SECOND, MILLIS_IN_ONE_WEEK, MILLIS_IN_ONE_YEAR

Constructor Summary

SQLQueryWidget()

Method Summary

int	getComponentCount() Returns the number of form elements (input, textarea, button,...).
String	getWidgetEditor(int count, String lang, String inputId)
void	setDataSource(String dataSource)
void	setDataSource(String[] dataSourceArray)
void	setDataSourceMenu(boolean dataSourceMenu)
void	setMaxRows(int maxRows)
void	setMaxRows(int[] maxRowsArray)

Methods inherited from class com.jalios.jcms.widget.TextAreaWidget

getCols, getRows, getWysiwygParams, initWidget, isInline, printTabbedFieldAndItemIcons, setCols, setImageMap, setRows, setWysiwygParams

Methods inherited from class com.jalios.jcms.widget.AbstractWidget

convertObject, getAddComponentCount, getAllValues, getContext, getCss, getCustomAttributes, getDefaultValue, getDescription, getDescriptionName, getDescriptionUI, getEditor, getEditorName, getEditorUI, getFormName, getHiddenActions, getInputId, getInputTitle, getKeyword, getLabel, getListWidgetEditor, getListWidgetEditor, getListWidgetEditorByLI, getMessage, getShowAddButton, getTabGroup, getTabIndex, getTotalComponentCount, getValue, getValue, getValues, getWidget, getWidgetAddCount, getWidgetDescription, getWidgetEditor, getWidgetEditor, getWidgetHidden, getWidgetLang, getWidgetName, getWidgetTab, getWidgetTabAdd, getWidgetTitle, getWrapper, isDisabled, isEditorCtxMenu, isHidden, isKeywordDisplay, isMultilingual, isMultivalued, isPrintSeparator, isPrintWidget, isRequired, isShowAddButton, isTabbedEditor, setContext, setCss, setCustomAttributes, setDefaultValue, setDescription, setDescriptionUI, setDisabled, setEditorUI, setFormName, setHidden, setHiddenActions, setInline, setIsTabbed, setKeyword, setLabel, setLanguageList, setMultilingual, setPrintLabel, setPrintSeparator, setPrintWidget, setRequired, setShowAddButton, setTabGroup, setTabIndex, setValue, setValues, setWidgetAddCount, setWidgetInitCount, setWidgetName, setWrapper

Methods inherited from class java.lang.Object

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

Field Detail

REVISION

public static final String REVISION

See Also:

Constant Field Values

logger

protected static final org.apache.log4j.Logger logger

rows

protected int rows

dataSource

protected String dataSource

dataSourceMenu

protected boolean dataSourceMenu

dataSourceArray

protected String[] dataSourceArray

maxRows

protected int maxRows

maxRowsArray

protected int[] maxRowsArray

Constructor Detail

SQLQueryWidget

public SQLQueryWidget()

Method Detail

getWidgetEditor

public String getWidgetEditor(int count,
                              String lang,
                              String inputId)

Overrides:

getWidgetEditor in class TextAreaWidget

getComponentCount

public int getComponentCount()

Description copied from class: AbstractWidget

Returns the number of form elements (input, textarea, button,...).

Overrides:

getComponentCount in class AbstractWidget

Returns:

the number of form elements (input, textarea, button,...).

setDataSource

public void setDataSource(String dataSource)

setDataSourceMenu

public void setDataSourceMenu(boolean dataSourceMenu)

setDataSource

public void setDataSource(String[] dataSourceArray)

setMaxRows

public void setMaxRows(int maxRows)

setMaxRows

public void setMaxRows(int[] maxRowsArray)