com.jalios.jcms.widget
Class SQLQueryWidget

java.lang.Object
  extended by com.jalios.jcms.widget.AbstractWidget
      extended by com.jalios.jcms.widget.TextAreaWidget
          extended by 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: 42020 $
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, 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_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, 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, 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, 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 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)


Copyright © 2001-2010 Jalios SA. All Rights Reserved.