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: 42021 $

Author:

Olivier Dedieu

Field Summary

Fields

Modifier and Type	Field and Description
protected java.lang.String	dataSource
protected java.lang.String[]	dataSourceArray
protected boolean	dataSourceMenu
protected static org.apache.log4j.Logger	logger
protected int	maxRows
protected int[]	maxRowsArray
static java.lang.String	REVISION
protected int	rows

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

cols, imageMap, wikiwyg, wysiwygCss, 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, placeholder, printLabel, printSeparator, printWidget, required, showAddButton, showAddIcons, showCalendarIcons, showCategoryButton, showColorChooser, showCreateIcons, showDBRecChooser, showDocChooser, showDownIcons, showEditIcons, 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, 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_CREATE_STR, OP_DEEP_COPY, OP_DEEP_COPY_STR, OP_DEEP_DELETE, OP_DEEP_DELETE_STR, OP_DELETE, OP_DELETE_STR, OP_MERGE, OP_MERGE_STR, OP_UPDATE, OP_UPDATE_STR, 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, TYPES_ICON_ALT_PROP, TYPES_ICON_SUFFIX_PROP, TYPES_ICON_TITLE_PROP, TYPES_PREFIX_PROP, TYPES_THUMB_SUFFIX_PROP, 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

Constructors

Constructor and Description
SQLQueryWidget()

Method Summary

Methods

Modifier and Type	Method and Description
int	getComponentCount() Returns the number of form elements (input, textarea, button,...).
java.lang.String	getWidgetEditor(int count, java.lang.String lang, java.lang.String inputId)
void	setDataSource(java.lang.String dataSource)
void	setDataSource(java.lang.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, setWikiwyg, setWysiwygCss, 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, getPlaceholder, getShowAddButton, getTabGroup, getTabIndex, getTotalComponentCount, getValue, getValue, getValues, getWidget, getWidgetAddCount, getWidgetDescriptionText, getWidgetDescriptionTooltip, 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, setPlaceholder, 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 java.lang.String REVISION

See Also:

Constant Field Values

logger

protected static final org.apache.log4j.Logger logger

rows

protected int rows

dataSource

protected java.lang.String dataSource

dataSourceMenu

protected boolean dataSourceMenu

dataSourceArray

protected java.lang.String[] dataSourceArray

maxRows

protected int maxRows

maxRowsArray

protected int[] maxRowsArray

Constructor Detail

SQLQueryWidget

public SQLQueryWidget()

Method Detail

getWidgetEditor

public java.lang.String getWidgetEditor(int count,
                               java.lang.String lang,
                               java.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(java.lang.String dataSource)

setDataSourceMenu

public void setDataSourceMenu(boolean dataSourceMenu)

setDataSource

public void setDataSource(java.lang.String[] dataSourceArray)

setMaxRows

public void setMaxRows(int maxRows)

setMaxRows

public void setMaxRows(int[] maxRowsArray)