Class TableTabPanel_MySQL
java.lang.Object
java.awt.Component
java.awt.Container
javax.swing.JComponent
javax.swing.JPanel
com.dandymadeproductions.ajqvue.gui.panels.TableTabPanel
com.dandymadeproductions.ajqvue.gui.panels.TableTabPanel_MySQL
- All Implemented Interfaces:
TableTabInterface,ActionListener,KeyListener,ImageObserver,MenuContainer,Printable,Serializable,EventListener,Accessible,TableColumnModelListener
The TableTabPanel_MySQL class provides the table summary view of data
in a MySQL database that is listed according to a specified sort and search.
Entries from the database table may be viewed, added, edited, or deleted
by means of this panel. The panel also provides the mechanism to page
through the database table's data.
- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class javax.swing.JPanel
JPanel.AccessibleJPanelNested classes/interfaces inherited from class javax.swing.JComponent
JComponent.AccessibleJComponentNested classes/interfaces inherited from class java.awt.Container
Container.AccessibleAWTContainerNested classes/interfaces inherited from class java.awt.Component
Component.AccessibleAWTComponent, Component.BaselineResizeBehavior, Component.BltBufferStrategy, Component.FlipBufferStrategy -
Field Summary
Fields inherited from class com.dandymadeproductions.ajqvue.gui.panels.TableTabPanel
activateAdvancedSortSearchButton, activateUpdateButton, advancedSortSearch, advancedSortSearchFrame, allTableHeadings, ascDescString, autoIncrementHashMap, centerCardLayout, centerPanel, columnClassHashMap, columnEnumHashMap, columnNamesHashMap, columnSetHashMap, columnSizeHashMap, columnSizeScaling, columnSQLTypeHashMap, columnTypeNameHashMap, comboBoxFields, currentTableHeadings, exportedKeys, fields, foreignKeys, formFields, historyAction, identifierQuoteString, keyLengthHashMap, listTable, lob_sqlTableFieldsString, lobDataTypesHashMap, MAX_PREFERRED_COLUMN_SIZE, preferredColumnSizeHashMap, primaryKeys, refreshButton, schemaTableName, searchComboBox, searchTextField, sortComboBox, sqlTable, sqlTableFieldsString, sqlTableStatement, STATE_HISTORY_LIMIT, stateHistory, stateHistoryIndex, summaryTablePopupListener, tableData, tableModel, tableRowLimit, tableRowStart, tableScrollPane, tableViewForm, viewFormFieldsFields inherited from class javax.swing.JComponent
listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOWFields inherited from class java.awt.Component
accessibleContext, BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENTFields inherited from interface java.awt.image.ImageObserver
ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTHFields inherited from interface java.awt.print.Printable
NO_SUCH_PAGE, PAGE_EXISTS -
Constructor Summary
ConstructorsConstructorDescriptionTableTabPanel_MySQL(String table, Connection setup_dbConnection, boolean viewOnlyTable) -
Method Summary
Modifier and TypeMethodDescriptionvoidaddItem(Connection dbConnection) voideditSelectedItem(Connection dbConnection, int rowToEdit, Object columnName, Object id) booleangetColumnNames(Connection dbConnection) booleanloadTable(Connection dbConnection) voidviewSelectedItem(Connection dbConnection, int rowToView) Methods inherited from class com.dandymadeproductions.ajqvue.gui.panels.TableTabPanel
actionPerformed, clearHistory, columnAdded, columnMarginChanged, columnMoved, columnRemoved, columnSelectionChanged, createAdvancedSortSearchFrame, createUpdateFrame, deleteAllItems, deleteSelectedItems, displayMyDateString, getAllTableHeadings, getAutoIncrementHashMap, getColumnClassHashMap, getColumnEnumHashMap, getColumnNamesHashMap, getColumnSetHashMap, getColumnSizeHashMap, getColumnSQLTypeHashMap, getColumnTypeNameHashMap, getCurrentTableHeadings, getExportedKeys, getForeignKeys, getListTable, getPrimaryKeys, getSaveFileName, getState, getStateDelimiter, getStateSQLTABLE_STATEMENT_POS, getTableFields, getTableName, getTableRowLimit, getTableRowSize, getTableRowStart, getTableSQLStatement, getValidDataRowCount, keyPressed, keyReleased, keyTyped, parseColumnNameField, pasteClipboardContents, print, saveHistory, setSaveFileName, setSearchTextField, setSpecialFieldData, setState, setTableHeadings, setTableRowSize, setViewOnlyMethods inherited from class javax.swing.JPanel
getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUIMethods 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, updateMethods 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, validateTreeMethods 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, 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, requestFocus, requestFocus, requestFocusInWindow, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setMixingCutoutShape, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle
-
Constructor Details
-
TableTabPanel_MySQL
-
-
Method Details
-
getColumnNames
- Throws:
SQLException
-
loadTable
-
viewSelectedItem
- Throws:
SQLException
-
addItem
-
editSelectedItem
public void editSelectedItem(Connection dbConnection, int rowToEdit, Object columnName, Object id) throws SQLException - Throws:
SQLException
-