org.wandora.application.tools.sqlconsole

Class SQLConsolePanel

java.lang.Object

java.awt.Component

java.awt.Container

javax.swing.JComponent

javax.swing.JPanel

org.wandora.application.tools.sqlconsole.SQLConsolePanel

All Implemented Interfaces:

java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, javax.accessibility.Accessible

public class SQLConsolePanel
extends javax.swing.JPanel

Author:

olli

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class javax.swing.JPanel

javax.swing.JPanel.AccessibleJPanel

Nested classes/interfaces inherited from class javax.swing.JComponent

javax.swing.JComponent.AccessibleJComponent

Nested classes/interfaces inherited from class java.awt.Container

java.awt.Container.AccessibleAWTContainer

Nested classes/interfaces inherited from class java.awt.Component

java.awt.Component.AccessibleAWTComponent, java.awt.Component.BaselineResizeBehavior, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	connection
private boolean	isSimpleView
private Options	options
private javax.swing.JPanel	queryPanel
private javax.swing.JPanel	queryPanelContainer
private javax.swing.JPanel	resultContainer
private int	resultMaxRows
private javax.swing.JPanel	resultPanel
private javax.swing.JScrollPane	resultScrollPane
private javax.swing.JSplitPane	splitPane
private java.util.Map<java.lang.String,StoredQuery>	storedQueries

Fields inherited from class javax.swing.JComponent

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

accessibleContext, 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

Constructor Summary

Constructors

Constructor and Description
SQLConsolePanel(Options options) Creates new form SQLConsolePanel

Method Summary

Modifier and Type	Method and Description
void	clearStoredQueries()
void	connect(java.lang.String driver, java.lang.String connectString, java.lang.String user, java.lang.String password)
void	executeQuery(java.lang.String query)
SQLQueryResult	executeQueryLowLevel(java.lang.String query)
static SQLQueryResult	executeQueryLowLevel(java.lang.String query, java.sql.Connection connection, int resultMaxRows)
static SQLQueryResult	executeQueryLowLevel(java.lang.String query, java.sql.Connection connection, int resultMaxRows, Delegate<java.lang.Integer,java.lang.Integer> onOverflow)
static java.sql.Connection	getConnection(java.lang.String driver, java.lang.String connectString, java.lang.String user, java.lang.String password)
int	getResultMaxRows()
java.util.Map<java.lang.String,StoredQuery>	getStoredQueries()
void	importQueries(java.util.Map<java.lang.String,StoredQuery> queries)
private void	initComponents() This method is called from within the constructor to initialize the form.
void	loadStoredQueries()
void	saveQuery(StoredQuery query)
void	saveStoredQueries()
void	setResultMaxRows(int count)
void	setSimpleSize()
void	switchToEdit(StoredQuery query)
void	switchToSimple(java.lang.String name)
void	updateSimpleView()

Methods inherited from class javax.swing.JPanel

getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUI

Methods inherited from class javax.swing.JComponent

addAncestorListener, addNotify, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBaseline, getBaselineResizeBehavior, getBorder, getBounds, getClientProperty, getComponentGraphics, getComponentPopupMenu, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getFontMetrics, getGraphics, getHeight, getInheritsPopupMenu, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPopupLocation, getPreferredSize, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, hide, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingOrigin, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setComponentPopupMenu, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setFocusTraversalKeys, setFont, setForeground, setInheritsPopupMenu, 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, addPropertyChangeListener, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, getMousePosition, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusCycleRoot, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setLayout, 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, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isPreferredSizeSet, 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, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle

Methods inherited from class java.lang.Object

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

Field Detail

storedQueries

private java.util.Map<java.lang.String,StoredQuery> storedQueries

connection

private java.sql.Connection connection

resultMaxRows

private int resultMaxRows

options

private Options options

isSimpleView

private boolean isSimpleView

queryPanel

private javax.swing.JPanel queryPanel

queryPanelContainer

private javax.swing.JPanel queryPanelContainer

resultContainer

private javax.swing.JPanel resultContainer

resultPanel

private javax.swing.JPanel resultPanel

resultScrollPane

private javax.swing.JScrollPane resultScrollPane

splitPane

private javax.swing.JSplitPane splitPane

Constructor Detail

SQLConsolePanel

public SQLConsolePanel(Options options)

Creates new form SQLConsolePanel

Method Detail

initComponents

private void initComponents()

This method is called from within the constructor to initialize the form. WARNING: Do NOT modify this code. The content of this method is always regenerated by the Form Editor.

getConnection

public static java.sql.Connection getConnection(java.lang.String driver,
                                                java.lang.String connectString,
                                                java.lang.String user,
                                                java.lang.String password)
                                         throws java.lang.ClassNotFoundException,
                                                java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

connect

public void connect(java.lang.String driver,
                    java.lang.String connectString,
                    java.lang.String user,
                    java.lang.String password)

setResultMaxRows

public void setResultMaxRows(int count)

getResultMaxRows

public int getResultMaxRows()

executeQuery

public void executeQuery(java.lang.String query)

executeQueryLowLevel

public static SQLQueryResult executeQueryLowLevel(java.lang.String query,
                                                  java.sql.Connection connection,
                                                  int resultMaxRows)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryLowLevel

public static SQLQueryResult executeQueryLowLevel(java.lang.String query,
                                                  java.sql.Connection connection,
                                                  int resultMaxRows,
                                                  Delegate<java.lang.Integer,java.lang.Integer> onOverflow)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQueryLowLevel

public SQLQueryResult executeQueryLowLevel(java.lang.String query)

saveQuery

public void saveQuery(StoredQuery query)

switchToSimple

public void switchToSimple(java.lang.String name)

setSimpleSize

public void setSimpleSize()

switchToEdit

public void switchToEdit(StoredQuery query)

updateSimpleView

public void updateSimpleView()

clearStoredQueries

public void clearStoredQueries()

loadStoredQueries

public void loadStoredQueries()
                       throws java.lang.Exception

Throws:

java.lang.Exception

saveStoredQueries

public void saveStoredQueries()
                       throws java.io.IOException

Throws:

java.io.IOException

importQueries

public void importQueries(java.util.Map<java.lang.String,StoredQuery> queries)

getStoredQueries

public java.util.Map<java.lang.String,StoredQuery> getStoredQueries()