Class DatabaseEditor.Table

java.lang.Object

java.awt.Component

java.awt.Container

java.awt.Window

java.awt.Frame

javax.swing.JFrame

DatabaseEditor.Table

All Implemented Interfaces:

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

Enclosing class:

DatabaseEditor

class DatabaseEditor.Table
extends javax.swing.JFrame

This class implements a window displaying the contents of a database table, view, or result set. The first constructor displays tables and views and the second constructor displays result sets.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) class	DatabaseEditor.Table.DBTable This is the JPanel displaying the database table, view, or result set.

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

javax.swing.JFrame.AccessibleJFrame

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

java.awt.Frame.AccessibleAWTFrame

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

java.awt.Window.AccessibleAWTWindow, java.awt.Window.Type

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
(package private) java.util.ArrayList<java.util.ArrayList<java.lang.String>>	data
(package private) java.util.ArrayList<javax.swing.JFrame>	dependents
(package private) java.util.ArrayList<java.lang.String>	heading
(package private) java.util.ArrayList<java.util.ArrayList<java.lang.String>>	oldData
(package private) java.util.ArrayList<java.lang.String>	rowid
(package private) static long	serialVersionUID
(package private) javax.swing.JTable	table
(package private) javax.swing.table.AbstractTableModel	tableModel This TableModel gets data from and stores data into the containing Table class.
(package private) java.lang.String	tableName

Fields inherited from class javax.swing.JFrame

accessibleContext, EXIT_ON_CLOSE, rootPane, rootPaneCheckingEnabled

Fields inherited from class java.awt.Frame

CROSSHAIR_CURSOR, DEFAULT_CURSOR, E_RESIZE_CURSOR, HAND_CURSOR, ICONIFIED, MAXIMIZED_BOTH, MAXIMIZED_HORIZ, MAXIMIZED_VERT, MOVE_CURSOR, N_RESIZE_CURSOR, NE_RESIZE_CURSOR, NORMAL, NW_RESIZE_CURSOR, S_RESIZE_CURSOR, SE_RESIZE_CURSOR, SW_RESIZE_CURSOR, TEXT_CURSOR, W_RESIZE_CURSOR, WAIT_CURSOR

Fields inherited from class java.awt.Component

BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT

Fields inherited from interface javax.swing.WindowConstants

DISPOSE_ON_CLOSE, DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE

Fields inherited from interface java.awt.image.ImageObserver

ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH

Constructor Summary

Constructors

Constructor and Description
Table(java.sql.ResultSet rs, java.lang.String tableName) For displaying result sets
Table(java.lang.String tableName) For displaying tables or views

Method Summary

Modifier and Type	Method and Description
(package private) void	addRow() This method adds a new row to the table.
(package private) void	deleteRows() Delete all of the rows that are selected.
(package private) boolean	eql(java.lang.String x, java.lang.String y) Compare two Strings for equality.
(package private) void	fillColumn(int i, int j) This method fills in all cells from cell[i, j] to the end of the table stopping at the first nonnull entry
(package private) void	fillColumn(int i, int j, java.lang.String s1, java.lang.String s2) This method fills in all cells from cell[i, j] to the end of the table stopping at the first nonnull entry.
(package private) void	initTables(java.sql.ResultSet rs) Initialize tables for a table or view with null argument.
(package private) DatabaseEditor.EditWindow	makeCellEditWindow(DatabaseEditor.Table jtable, int i, int jj, java.awt.Rectangle location) Create an edit window on a Table cell and update table focus to edited cell.
(package private) void	makeNull() This method sets the selected cell to null
(package private) void	outputTable(java.lang.String fileName, java.lang.String column, java.lang.String row, java.lang.String nil, boolean escape) Output a result set to a text file separating rows by a new line and cells in a row by the separator String.
(package private) void	revertSelected() This method undoes all of the uncommitted edits in the selected row.
(package private) void	revertTable() This method undoes all of the uncommitted edits in the entire table.
(package private) void	updateRow(int i) New strategy is to use ? instead of putting new values in the statement itself.
(package private) void	updateSelected() This method updates all cells in the selected row.
(package private) void	updateTable() This method updates all cells in the entire table.

Methods inherited from class javax.swing.JFrame

addImpl, createRootPane, frameInit, getAccessibleContext, getContentPane, getDefaultCloseOperation, getGlassPane, getGraphics, getJMenuBar, getLayeredPane, getRootPane, getTransferHandler, isDefaultLookAndFeelDecorated, isRootPaneCheckingEnabled, paramString, processWindowEvent, remove, repaint, setContentPane, setDefaultCloseOperation, setDefaultLookAndFeelDecorated, setGlassPane, setIconImage, setJMenuBar, setLayeredPane, setLayout, setRootPane, setRootPaneCheckingEnabled, setTransferHandler, update

Methods inherited from class java.awt.Frame

addNotify, getCursorType, getExtendedState, getFrames, getIconImage, getMaximizedBounds, getMenuBar, getState, getTitle, isResizable, isUndecorated, remove, removeNotify, setBackground, setCursor, setExtendedState, setMaximizedBounds, setMenuBar, setOpacity, setResizable, setShape, setState, setTitle, setUndecorated

Methods inherited from class java.awt.Window

addPropertyChangeListener, addPropertyChangeListener, addWindowFocusListener, addWindowListener, addWindowStateListener, applyResourceBundle, applyResourceBundle, createBufferStrategy, createBufferStrategy, dispose, getBackground, getBufferStrategy, getFocusableWindowState, getFocusCycleRootAncestor, getFocusOwner, getFocusTraversalKeys, getIconImages, getInputContext, getListeners, getLocale, getModalExclusionType, getMostRecentFocusOwner, getOpacity, getOwnedWindows, getOwner, getOwnerlessWindows, getShape, getToolkit, getType, getWarningString, getWindowFocusListeners, getWindowListeners, getWindows, getWindowStateListeners, hide, isActive, isAlwaysOnTop, isAlwaysOnTopSupported, isAutoRequestFocus, isFocusableWindow, isFocusCycleRoot, isFocused, isLocationByPlatform, isOpaque, isShowing, isValidateRoot, pack, paint, postEvent, processEvent, processWindowFocusEvent, processWindowStateEvent, removeWindowFocusListener, removeWindowListener, removeWindowStateListener, reshape, setAlwaysOnTop, setAutoRequestFocus, setBounds, setBounds, setCursor, setFocusableWindowState, setFocusCycleRoot, setIconImages, setLocation, setLocation, setLocationByPlatform, setLocationRelativeTo, setMinimumSize, setModalExclusionType, setSize, setSize, setType, setVisible, show, toBack, toFront

Methods inherited from class java.awt.Container

add, add, add, add, add, addContainerListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getAlignmentX, getAlignmentY, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalPolicy, getInsets, getLayout, getMaximumSize, getMinimumSize, getMousePosition, getPreferredSize, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, print, printComponents, processContainerEvent, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusTraversalKeys, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setFont, 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, contains, createImage, createImage, createVolatileImage, createVolatileImage, disable, disableEvents, dispatchEvent, enable, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBaseline, getBaselineResizeBehavior, getBounds, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphicsConfiguration, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocation, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getSize, getTreeLock, getWidth, getX, getY, gotFocus, handleEvent, hasFocus, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isDoubleBuffered, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isPreferredSizeSet, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, prepareImage, prepareImage, printAll, processComponentEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processKeyEvent, processMouseEvent, processMouseMotionEvent, processMouseWheelEvent, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resize, resize, revalidate, setComponentOrientation, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeysEnabled, setForeground, setIgnoreRepaint, setLocale, setMaximumSize, setName, setPreferredSize, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.awt.MenuContainer

getFont, postEvent

Field Detail

serialVersionUID

static final long serialVersionUID

See Also:

Constant Field Values

tableName

java.lang.String tableName

dependents

java.util.ArrayList<javax.swing.JFrame> dependents

table

javax.swing.JTable table

heading

java.util.ArrayList<java.lang.String> heading

data

java.util.ArrayList<java.util.ArrayList<java.lang.String>> data

oldData

java.util.ArrayList<java.util.ArrayList<java.lang.String>> oldData

rowid

java.util.ArrayList<java.lang.String> rowid

tableModel

javax.swing.table.AbstractTableModel tableModel

This TableModel gets data from and stores data into the containing Table class. The model allows drag & drop and cell editing. The default editor is disabled if there is a new-line in the string.

Constructor Detail

Table

Table(java.lang.String tableName)

For displaying tables or views

Parameters:

tableName - the title of the window and table or view to display

Table

Table(java.sql.ResultSet rs,
      java.lang.String tableName)

For displaying result sets

Parameters:

rs - the ResultSet to display

tableName - the title of the window

Method Detail

initTables

void initTables(java.sql.ResultSet rs)

Initialize tables for a table or view with null argument. Initialize tables for a result set with result set argument. If called with a null argument then the variable tableName is used as the table to view. Assume that names of databases and tables do not contain "."

Parameters:

rs - the result set to view or null if a table or view

eql

boolean eql(java.lang.String x,
            java.lang.String y)

Compare two Strings for equality. Also handles nulls.

Parameters:

x - first string

y - second string

Returns:

true if strings are equal or both are null

makeCellEditWindow

DatabaseEditor.EditWindow makeCellEditWindow(DatabaseEditor.Table jtable,
                                             int i,
                                             int jj,
                                             java.awt.Rectangle location)

Create an edit window on a Table cell and update table focus to edited cell. Caller is responsible for setting location and showing the window. Don't search for an existing cellEditWindow if rowid is null.

Parameters:

jtable - the table containing the cell to be edited

i - the row of the Table being edited

jj - the column of the Table being edited

location - the location to put the CellEditWindow

Returns:

returns the new EditWindow

outputTable

void outputTable(java.lang.String fileName,
                 java.lang.String column,
                 java.lang.String row,
                 java.lang.String nil,
                 boolean escape)

Output a result set to a text file separating rows by a new line and cells in a row by the separator String.

Parameters:

fileName - the name of the file to write

column - the cell separator

row - the row cell separator

nil - the String used for a null entry

escape - true if replace ' with ''

deleteRows

void deleteRows()

Delete all of the rows that are selected. Then reloads the table from the database. Currently only a single cell can be selected so this method deletes a single row. Note that this method throws away all pending edits that have not been committed.

makeNull

void makeNull()

This method sets the selected cell to null

revertSelected

void revertSelected()

This method undoes all of the uncommitted edits in the selected row. Currently only one cell/row can be selected.

revertTable

void revertTable()

This method undoes all of the uncommitted edits in the entire table.

addRow

void addRow()

This method adds a new row to the table. All cells in this new row are set to null. If at least one entry is not set non-null then this row will not be added to the table. To add an all null row first add a row with a cell not null and then edit this cell to null (by dragging a null cell value to it).

fillColumn

void fillColumn(int i,
                int j)

This method fills in all cells from cell[i, j] to the end of the table stopping at the first nonnull entry

Parameters:

i - the row number of the first cell to be filled

j - the column number of the first cell to be filled

fillColumn

void fillColumn(int i,
                int j,
                java.lang.String s1,
                java.lang.String s2)

This method fills in all cells from cell[i, j] to the end of the table stopping at the first nonnull entry. It requires that s1 and s2 are Strings of equal length and differ in only one character. The differing character is continually incremented by the difference between the two differing characters and the resulting patched String isinserted in successive cells. This makes the successive cells in arithmetic progression. No checks are made for generating illegal characters.

Parameters:

i - the row number of the first cell to be filled

j - the column number of the first cell to be filled

s1 - the first string in sequence

s2 - the second string in sequence

updateSelected

void updateSelected()

This method updates all cells in the selected row.

updateTable

void updateTable()

This method updates all cells in the entire table.

updateRow

void updateRow(int i)

New strategy is to use ? instead of putting new values in the statement itself. There are row.size() ? marks and the same number of putWithCharset(PreparedStatement stat, int i, String data) calls. The advantage of the new way is that the character encoding can be changed easily (and from the command line) although this is currently disables because of the difficulty of using blobs. Also avoids sql injection attacks. This method updates the specified row

Parameters:

i - the row number to update