com.ontimize.db.query
Class QueryBuilder
java.lang.Object
java.awt.Component
java.awt.Container
javax.swing.JComponent
javax.swing.JPanel
com.ontimize.db.query.QueryBuilder
- All Implemented Interfaces:
- javax.accessibility.Accessible, java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable
- public class QueryBuilder
- extends javax.swing.JPanel
- See Also:
- Serialized Form
| Nested classes inherited from class javax.swing.JPanel |
javax.swing.JPanel.AccessibleJPanel |
| Nested classes inherited from class javax.swing.JComponent |
javax.swing.JComponent.AccessibleJComponent |
| Nested classes inherited from class java.awt.Container |
java.awt.Container.AccessibleAWTContainer |
| Nested classes inherited from class java.awt.Component |
java.awt.Component.AccessibleAWTComponent, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy |
| Fields inherited from class javax.swing.JComponent |
accessibleContext, listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOW |
| Fields inherited from class java.awt.Component |
BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT |
| Fields inherited from interface java.awt.image.ImageObserver |
ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH |
|
Method Summary |
static java.lang.String[] |
convertColumns(java.lang.Object[] cols)
|
static int[] |
convertType(java.util.List type)
|
static int[] |
getAllColsType(java.lang.String[] col)
|
static int |
getAny()
|
boolean |
getBasicSave()
|
java.lang.String[] |
getCols()
|
protected SQLStatementBuilder.Operator[] |
getColumnTypeOperators(int type)
|
protected static java.util.Hashtable |
getColumnTypes(java.lang.String e,
java.util.ResourceBundle bu)
|
static int |
getDate()
|
java.lang.String |
getEntity()
|
SQLStatementBuilder.Expression |
getExpression()
|
static int |
getNumber()
|
boolean[] |
getQueryColumns()
|
protected static java.lang.String |
getStringType(int i)
|
static int |
getTypeCol(java.lang.String type)
|
protected int[] |
getTypes()
|
static int |
getVarchar()
|
static boolean |
hasExpressionParameters(SQLStatementBuilder.Expression e)
|
protected void |
installButtonListeners()
|
protected void |
installTableListener()
|
protected boolean |
isCancelPressed()
|
static boolean |
isTextType(int i)
|
protected void |
loadQuery()
|
static boolean |
needsExpressionParameters(SQLStatementBuilder.Expression e)
|
protected void |
removeExpression()
|
protected void |
saveQuery()
|
boolean |
setBasicSave(boolean basicSave)
|
void |
setColumns(java.lang.String[] cols,
int[] types)
|
void |
setExpression(SQLStatementBuilder.Expression ex)
|
static boolean |
showParameterValues(java.awt.Component c,
java.util.ResourceBundle b,
SQLStatementBuilder.Expression e,
java.lang.String[] co,
int[] ty)
|
protected static boolean |
showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
javax.swing.JTable t,
java.lang.String[] cols,
int[] types)
|
static boolean |
showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
QueryExpression qe)
|
static boolean |
showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
SQLStatementBuilder.Expression e,
java.lang.String entity)
|
protected static boolean |
showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
SQLStatementBuilder.Expression e,
java.lang.String[] cols,
int[] types)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.util.ResourceBundle bundle,
java.lang.String[] columns,
java.lang.String[] types,
SQLStatementBuilder.Expression initExpression,
java.util.Vector lastName)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
boolean okCancel)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols,
java.lang.String[] tCols)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean mostrarCols,
java.lang.String[] tCols,
java.util.Vector lastName)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
SQLStatementBuilder.Expression initQuery,
boolean okCancel,
boolean openList)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.util.Vector entities,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.util.Vector v,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openCols,
boolean showCols)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.util.Vector v,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols,
java.lang.String[] tCols)
|
static QueryExpression |
showQueryBuilder(java.awt.Component c,
java.util.Vector v,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols,
java.lang.String[] tCols,
java.util.Vector lastName)
|
protected void |
simpleAll()
|
| Methods inherited from class javax.swing.JPanel |
getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUI |
| Methods inherited from class javax.swing.JComponent |
addAncestorListener, addNotify, addPropertyChangeListener, addPropertyChangeListener, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBorder, getBounds, getClientProperty, getComponentGraphics, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getGraphics, getHeight, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPreferredSize, getPropertyChangeListeners, getPropertyChangeListeners, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isMaximumSizeSet, isMinimumSizeSet, isOpaque, isOptimizedDrawingEnabled, isPaintingTile, isPreferredSizeSet, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removePropertyChangeListener, removePropertyChangeListener, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setFont, setForeground, setInputMap, setInputVerifier, setMaximumSize, setMinimumSize, setNextFocusableComponent, setOpaque, setPreferredSize, setRequestFocusEnabled, setToolTipText, setTransferHandler, setUI, setVerifyInputWhenFocusTarget, setVisible, unregisterKeyboardAction, update |
| Methods inherited from class java.awt.Container |
add, add, add, add, add, addContainerListener, addImpl, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setFocusCycleRoot, setFocusTraversalKeys, setFocusTraversalPolicy, setLayout, transferFocusBackward, transferFocusDownCycle, validate, validateTree |
| Methods inherited from class java.awt.Component |
action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, coalesceEvents, contains, createImage, createImage, createVolatileImage, createVolatileImage, disableEvents, dispatchEvent, enable, enableEvents, enableInputMethods, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMouseWheelListeners, getName, getParent, getPeer, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isShowing, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, postEvent, prepareImage, prepareImage, processComponentEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processMouseEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusUpCycle |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
ANY_COLUMN
public static final java.lang.String ANY_COLUMN
- See Also:
- Constant Field Values
DEBUG
public static boolean DEBUG
bOKCons
protected javax.swing.JButton bOKCons
bCancelCons
protected javax.swing.JButton bCancelCons
bStore
protected javax.swing.JButton bStore
bPreview
protected javax.swing.JButton bPreview
bSave
protected javax.swing.JButton bSave
bLoad
protected javax.swing.JButton bLoad
bCols
protected javax.swing.JButton bCols
bClear
protected javax.swing.JButton bClear
bNew
protected javax.swing.JButton bNew
bDelete
protected javax.swing.JButton bDelete
bOR
protected javax.swing.JButton bOR
bAnd
protected javax.swing.JButton bAnd
bModif
protected javax.swing.JButton bModif
bValues
protected javax.swing.JButton bValues
bClearValues
protected javax.swing.JButton bClearValues
bSplit
protected javax.swing.JButton bSplit
bAndN
protected javax.swing.JButton bAndN
bORN
protected javax.swing.JButton bORN
bHelp
protected javax.swing.JButton bHelp
bHelp2
protected javax.swing.JButton bHelp2
text
protected javax.swing.JTextArea text
pButtons
protected javax.swing.JPanel pButtons
pOKCancel
protected javax.swing.JPanel pOKCancel
cancelPressed
protected boolean cancelPressed
panelQuery
protected javax.swing.JPanel panelQuery
table
protected QueryBuilder.EJTable table
js
protected javax.swing.JScrollPane js
comboEntities
protected javax.swing.JComboBox comboEntities
cols
protected java.lang.String[] cols
queryColumns
protected boolean[] queryColumns
types
protected int[] types
bundle
protected java.util.ResourceBundle bundle
expressionDialog
protected QueryBuilder.SimpleExpressionsDialog expressionDialog
locator
protected EntityReferenceLocator locator
entity
protected java.lang.String entity
entityList
protected java.util.Vector entityList
okCancel
protected boolean okCancel
showColumns
protected boolean showColumns
pvt
protected static QueryBuilder.ParameterValuesTable pvt
queryBuilderDialog
protected static javax.swing.JDialog queryBuilderDialog
qb
protected static QueryBuilder qb
QueryBuilder
public QueryBuilder(java.util.Vector entityList,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
boolean okCancel,
QueryExpression initQuery,
boolean mostrarCols,
java.lang.String[] tCols)
QueryBuilder
public QueryBuilder(java.util.ResourceBundle bundle,
java.lang.String[] lCols,
java.lang.String[] tCols,
SQLStatementBuilder.Expression initExpression)
QueryBuilder
public QueryBuilder()
getBasicSave
public boolean getBasicSave()
setBasicSave
public boolean setBasicSave(boolean basicSave)
getVarchar
public static int getVarchar()
getDate
public static int getDate()
getNumber
public static int getNumber()
getAny
public static int getAny()
needsExpressionParameters
public static boolean needsExpressionParameters(SQLStatementBuilder.Expression e)
hasExpressionParameters
public static boolean hasExpressionParameters(SQLStatementBuilder.Expression e)
getColumnTypes
protected static java.util.Hashtable getColumnTypes(java.lang.String e,
java.util.ResourceBundle bu)
getEntity
public java.lang.String getEntity()
getCols
public java.lang.String[] getCols()
getQueryColumns
public boolean[] getQueryColumns()
getTypes
protected int[] getTypes()
showParameterValuesTable
protected static boolean showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
javax.swing.JTable t,
java.lang.String[] cols,
int[] types)
showParameterValuesTable
protected static boolean showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
SQLStatementBuilder.Expression e,
java.lang.String[] cols,
int[] types)
showParameterValues
public static boolean showParameterValues(java.awt.Component c,
java.util.ResourceBundle b,
SQLStatementBuilder.Expression e,
java.lang.String[] co,
int[] ty)
showParameterValuesTable
public static boolean showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
SQLStatementBuilder.Expression e,
java.lang.String entity)
showParameterValuesTable
public static boolean showParameterValuesTable(java.awt.Component c,
java.util.ResourceBundle b,
QueryExpression qe)
simpleAll
protected void simpleAll()
installButtonListeners
protected void installButtonListeners()
isCancelPressed
protected boolean isCancelPressed()
setColumns
public void setColumns(java.lang.String[] cols,
int[] types)
getColumnTypeOperators
protected SQLStatementBuilder.Operator[] getColumnTypeOperators(int type)
installTableListener
protected void installTableListener()
saveQuery
protected void saveQuery()
loadQuery
protected void loadQuery()
getExpression
public SQLStatementBuilder.Expression getExpression()
setExpression
public void setExpression(SQLStatementBuilder.Expression ex)
removeExpression
protected void removeExpression()
convertType
public static int[] convertType(java.util.List type)
getStringType
protected static java.lang.String getStringType(int i)
getTypeCol
public static int getTypeCol(java.lang.String type)
isTextType
public static boolean isTextType(int i)
getAllColsType
public static int[] getAllColsType(java.lang.String[] col)
convertColumns
public static java.lang.String[] convertColumns(java.lang.Object[] cols)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
boolean okCancel)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols,
java.lang.String[] tCols)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean mostrarCols,
java.lang.String[] tCols,
java.util.Vector lastName)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.lang.String entity,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
SQLStatementBuilder.Expression initQuery,
boolean okCancel,
boolean openList)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.util.Vector entities,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.util.Vector v,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openCols,
boolean showCols)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.util.Vector v,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols,
java.lang.String[] tCols)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.util.Vector v,
java.util.ResourceBundle bundle,
EntityReferenceLocator locator,
QueryExpression initQuery,
boolean okCancel,
boolean openList,
boolean showCols,
java.lang.String[] tCols,
java.util.Vector lastName)
showQueryBuilder
public static QueryExpression showQueryBuilder(java.awt.Component c,
java.util.ResourceBundle bundle,
java.lang.String[] columns,
java.lang.String[] types,
SQLStatementBuilder.Expression initExpression,
java.util.Vector lastName)