org.tbee.swing.jdbc
Class JTableForEditRowset

java.lang.Object
  java.awt.Component
      java.awt.Container
          javax.swing.JComponent
              javax.swing.JTable
                  org.jdesktop.swingx.JXTable
                      org.tbee.swing.table.JTable
                          org.tbee.swing.table.JTableForEdit
                              org.tbee.swing.jdbc.JTableForEditRowset

All Implemented Interfaces:

java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, java.util.EventListener, javax.accessibility.Accessible, javax.swing.event.CellEditorListener, javax.swing.event.ListSelectionListener, javax.swing.event.RowSorterListener, javax.swing.event.TableColumnModelListener, javax.swing.event.TableModelListener, javax.swing.Scrollable, org.jdesktop.swingx.event.TableColumnModelExtListener

public class JTableForEditRowset
extends JTableForEdit

TOM 2007-09-11: Ziet er niet erg bruikbaar uit. Scrap? This class implements a quick JTableForEdit on a SQL statement using a CachedRowSet. Use the Column inner classes to hook in enhanced behaviour. Example: new JTableForEditRowset( lConnection , "select translationnr, id, countrycodenr, translation from translation" , new Column[] { new AutomaticValueColumn("Nr", "select translationnr.nextval from _number where n = 1") , new Column("Id") , new JComboBoxColumn("Taal", "select countrycodenr, countrycode from countrycodetable order by countrycode", true) , new Column("Vertaling") } );

Version:

$Revision: 1.10 $

See Also:

Serialized Form

Nested Class Summary

static class	JTableForEditRowset.AutomaticValueColumn Upon store this field will have a the result of an SQL statement put into it, if the current value is still the initial value
static class	JTableForEditRowset.Column Base column, just add some descriptive info
static class	JTableForEditRowset.JComboBoxColumn Use a combobox for this column, so we need an SQL statement.

Nested classes/interfaces inherited from class org.tbee.swing.table.JTableForEdit

JTableForEdit.RowCol

Nested classes/interfaces inherited from class org.tbee.swing.table.JTable

JTable.OnFocusStopEditHandler

Nested classes/interfaces inherited from class org.jdesktop.swingx.JXTable

org.jdesktop.swingx.JXTable.BooleanEditor, org.jdesktop.swingx.JXTable.GenericEditor, org.jdesktop.swingx.JXTable.NumberEditor, org.jdesktop.swingx.JXTable.TableAdapter

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

javax.swing.JTable.AccessibleJTable, javax.swing.JTable.DropLocation, javax.swing.JTable.PrintMode

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

static java.lang.String

SOURCECODE_VERSION Standard variable for determining version of a class file.

Fields inherited from class org.tbee.swing.table.JTableForEdit

iResourceBundle

Fields inherited from class org.tbee.swing.table.JTable

iFocusLostHandler, iJTableColumnResizer, iJTableRowResizer, SORTERCHANGED_PROPERTYID

Fields inherited from class org.jdesktop.swingx.JXTable

compoundHighlighter, dataAdapter, editorRemover, FOCUS_NEXT_COMPONENT, FOCUS_PREVIOUS_COMPONENT, HORIZONTALSCROLL_ACTION_COMMAND, isXTableRowHeightSet, MATCH_HIGHLIGHTER, PACKALL_ACTION_COMMAND, PACKSELECTED_ACTION_COMMAND, resetDefaultTableCellRendererHighlighter, searchable, UIPREFIX, USE_DTCR_COLORMEMORY_HACK

Fields inherited from class javax.swing.JTable

AUTO_RESIZE_ALL_COLUMNS, AUTO_RESIZE_LAST_COLUMN, AUTO_RESIZE_NEXT_COLUMN, AUTO_RESIZE_OFF, AUTO_RESIZE_SUBSEQUENT_COLUMNS, autoCreateColumnsFromModel, autoResizeMode, cellEditor, cellSelectionEnabled, columnModel, dataModel, defaultEditorsByColumnClass, defaultRenderersByColumnClass, editingColumn, editingRow, editorComp, gridColor, preferredViewportSize, rowHeight, rowMargin, rowSelectionAllowed, selectionBackground, selectionForeground, selectionModel, showHorizontalLines, showVerticalLines, tableHeader

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

Constructor Summary

JTableForEditRowset(java.sql.Connection connection, nl.knowledgeplaza.util.jdbc.SqlBuilder sqlBuilder, JTableForEditRowset.Column[] columns)

JTableForEditRowset(java.sql.Connection connection, java.lang.String sql, JTableForEditRowset.Column[] columns)

Method Summary

protected void	initialize() Initializes the table
protected void	initializeRowset() Initializes the table
void	reload() Discard any data and reload
void	store() Store the data and is no errors, refresh

Methods inherited from class org.tbee.swing.table.JTableForEdit

changeSelection, checkAllowDeleteRows, checkAllowInsertRows, checkAutoAddNewRow, deleteSelectedRows, determineNextCell, determineNextCellNext, determineNextCellPrevious, editCellAt, editingCanceled, editingStopped, getAllowDeleteRows, getAllowDeleteRowsConfirm, getAllowInsertRows, getAutoAddNewRow, getBlockOnError, getEditedRowZoom, getErrorMessageAt, getMessageOnError, getModelForEdit, getToolTipText, getWarnMessageAt, insertRow, makeSureRowIsValid, prepareRenderer, processKeyBinding, processMouseEvent, setAllowDeleteRows, setAllowDeleteRowsConfirm, setAllowInsertRows, setAutoAddNewRow, setBlockOnError, setCellSelectionEnabled, setColumnSelectionAllowed, setEditedRowZoom, setErrorInformation, setMessageOnError

Methods inherited from class org.tbee.swing.table.JTable

cancelEdit, changeSelectionForced, columnAdded, columnMarginChanged, columnMoved, columnRemoved, getAlternateRowColor, getAlternatingRowColor, getAutoSavePreferences, getCellEditor, getCellRenderer, getColumnEditor, getColumnRenderer, getColumnsAreResizable, getDisabledTableShowsCellsAsDisabled, getNameForPreferences, getResizableRowsAreAllSameHeight, getRowHeightAutomatical, getRowHeightIndividualAutomatical, getRowsAreResizable, getSecondAlternateRowColor, getShowValueExceptionsInDialog, getSwallowSetValueExceptions, getUneditableCellsShowAsDisabled, getUneditableTableShowsCellsAsDisabled, getValueAt, getValueAtAsString, isGetValueAtForEditor, isPrinting, prepareEditor, print, printBindings, repaintTableHeader, resetDefaultTableCellRendererColors, restoreAutoSavePreferences, restoreColumnOrderPreferences, restoreColumnVisiblePreferences, restoreColumnWidthPreferences, restorePreferences, saveAutoSavePreferences, saveColumnOrderPreferences, saveColumnVisiblePreferences, saveColumnWidthPreferences, savePreferences, setAlternateRowColor, setAlternatingRowColor, setAutoResizeMode, setAutoSavePreferences, setCellEditor, setCellRenderer, setColumnEditor, setColumnRenderer, setColumnsAreResizable, setDisabledTableShowsCellsAsDisabled, setEditable, setEnabled, setModel, setName, setNameForPreferences, setResizableRowsAreAllSameHeight, setRowHeight, setRowHeightAutomatical, setRowHeightIndividualAutomatical, setRowsAreResizable, setRowSorter, setSecondAlternateRowColor, setShowValueExceptionsInDialog, setSwallowSetValueExceptions, setUneditableCellsShowAsDisabled, setUneditableTableShowsCellsAsDisabled, setValueAt, setValueAtAsString, sorterChanged, stopEdit, tableChanged, withDisabledTableShowsCellsAsDisabled, withUneditableCellsShowAsDisabled, withUneditableTableShowsCellsAsDisabled

Methods inherited from class org.jdesktop.swingx.JXTable

addHighlighter, adjustComponentOrientation, adminSetRowHeight, columnPropertyChange, columnSelectionChanged, configureColumnControl, configureEnclosingScrollPane, configureSorterProperties, createDefaultColumnControl, createDefaultColumnModel, createDefaultColumnsFromModel, createDefaultEditors, createDefaultRenderers, createDefaultRowSorter, createDefaultStringValueRegistry, createDefaultTableHeader, createHighlighterChangeListener, createLinkController, createRolloverProducer, doFind, doLayout, getAutoCreateColumnsFromModel, getAutoCreateRowSorter, getColumn, getColumnControl, getColumnCount, getColumnExt, getColumnExt, getColumnFactory, getColumnMargin, getColumns, getColumns, getComponentAdapter, getComponentAdapter, getCompoundHighlighter, getControlsSorterProperties, getHighlighterChangeListener, getHighlighters, getLinkController, getNewDefaultRenderer, getPreferredScrollableViewportSize, getRowFilter, getScrollableTracksViewportWidth, getSearchable, getSelectionMode, getSortController, getSortedColumn, getSortOrder, getSortOrder, getSortOrderCycle, getSortsOnUpdates, getStringAt, getStringValueRegistry, getUIString, getUIString, getVisibleColumnCount, getVisibleRowCount, hasSortController, initializeColumnPreferredWidth, initializeColumnWidths, isAutoStartEditOnKeyStroke, isCellEditable, isColumnControlVisible, isDataChanged, isEditable, isFocusCycleRoot, isHorizontalScrollEnabled, isRolloverEnabled, isRowHeightEnabled, isSortable, isSortable, isSortable, isStructureChanged, isTerminateEditOnFocusLost, isUpdate, packAll, packColumn, packColumn, packSelected, packTable, removeEditor, removeHighlighter, removeNotify, resetSortOrder, rowAtPoint, scrollCellToVisible, scrollColumnToVisible, scrollRowToVisible, setAutoCreateRowSorter, setAutoStartEditOnKeyStroke, setColumnControl, setColumnControlVisible, setColumnFactory, setColumnMargin, setColumnModel, setColumnSequence, setComponentOrientation, setDefaultRenderer, setFillsViewportHeight, setGridColor, setHighlighters, setHorizontalScrollEnabled, setLocale, setPreferredScrollableViewportSize, setRolloverEnabled, setRowFilter, setRowHeight, setRowHeightEnabled, setSearchable, setSelectionBackground, setSelectionForeground, setShowGrid, setShowGrid, setSortable, setSortOrder, setSortOrder, setSortOrderCycle, setSortsOnUpdates, setTerminateEditOnFocusLost, setVisibleColumnCount, setVisibleRowCount, toggleSortOrder, toggleSortOrder, transferFocus, transferFocusBackward, unconfigureColumnControl, unconfigureEnclosingScrollPane, updateColumnControlUI, updateColumnUI, updateHighlighterUI, updateHorizontalAction, updateLocaleActionState, updateLocaleState, updateRowHeightUI, updateUI

Methods inherited from class javax.swing.JTable

addColumn, addColumnSelectionInterval, addNotify, addRowSelectionInterval, clearSelection, columnAtPoint, convertColumnIndexToModel, convertColumnIndexToView, convertRowIndexToModel, convertRowIndexToView, createDefaultDataModel, createDefaultSelectionModel, createScrollPaneForTable, editCellAt, getAccessibleContext, getAutoResizeMode, getCellEditor, getCellRect, getCellSelectionEnabled, getColumn, getColumnClass, getColumnCount, getColumnModel, getColumnName, getColumnSelectionAllowed, getDefaultEditor, getDefaultRenderer, getDragEnabled, getDropLocation, getDropMode, getEditingColumn, getEditingRow, getEditorComponent, getFillsViewportHeight, getGridColor, getIntercellSpacing, getModel, getPrintable, getRowCount, getRowHeight, getRowHeight, getRowMargin, getRowSelectionAllowed, getRowSorter, getScrollableBlockIncrement, getScrollableTracksViewportHeight, getScrollableUnitIncrement, getSelectedColumn, getSelectedColumnCount, getSelectedColumns, getSelectedRow, getSelectedRowCount, getSelectedRows, getSelectionBackground, getSelectionForeground, getSelectionModel, getShowHorizontalLines, getShowVerticalLines, getSurrendersFocusOnKeystroke, getTableHeader, getUI, getUIClassID, getUpdateSelectionOnSort, initializeLocalVars, isCellSelected, isColumnSelected, isEditing, isRowSelected, moveColumn, paramString, print, print, print, print, print, removeColumn, removeColumnSelectionInterval, removeRowSelectionInterval, resizeAndRepaint, selectAll, setAutoCreateColumnsFromModel, setCellEditor, setColumnSelectionInterval, setDefaultEditor, setDragEnabled, setDropMode, setEditingColumn, setEditingRow, setIntercellSpacing, setRowMargin, setRowSelectionAllowed, setRowSelectionInterval, setSelectionMode, setSelectionModel, setShowHorizontalLines, setShowVerticalLines, setSurrendersFocusOnKeystroke, setTableHeader, setUI, setUpdateSelectionOnSort, sizeColumnsToFit, sizeColumnsToFit, valueChanged

Methods inherited from class javax.swing.JComponent

addAncestorListener, 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, getTopLevelAncestor, getTransferHandler, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setComponentPopupMenu, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, 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, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, getMousePosition, insets, invalidate, isAncestorOf, 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, hide, 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, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocation, setLocation, setSize, setSize, show, show, size, toString, transferFocusUpCycle

Methods inherited from class java.lang.Object

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

Field Detail

SOURCECODE_VERSION

public static final java.lang.String SOURCECODE_VERSION

Standard variable for determining version of a class file.

See Also:

Constant Field Values

Constructor Detail

JTableForEditRowset

public JTableForEditRowset(java.sql.Connection connection,
                           java.lang.String sql,
                           JTableForEditRowset.Column[] columns)
                    throws java.sql.SQLException

Parameters:

connection -

sql -

columns -

Throws:

java.sql.SQLException

JTableForEditRowset

public JTableForEditRowset(java.sql.Connection connection,
                           nl.knowledgeplaza.util.jdbc.SqlBuilder sqlBuilder,
                           JTableForEditRowset.Column[] columns)
                    throws java.sql.SQLException

Parameters:

connection -

sql -

columns -

Throws:

java.sql.SQLException

Method Detail

initializeRowset

protected void initializeRowset()
                         throws java.sql.SQLException

Initializes the table

Throws:

java.sql.SQLException

initialize

protected void initialize()
                   throws java.sql.SQLException

Initializes the table

Throws:

java.sql.SQLException

reload

public void reload()
            throws java.sql.SQLException

Discard any data and reload

Throws:

java.sql.SQLException

store

public void store()
           throws java.sql.SQLException

Store the data and is no errors, refresh

Throws:

java.sql.SQLException