charger.db

Class DatabaseFrame

Object

Component

Container

Window

Frame

JFrame

charger.db.DatabaseFrame

All Implemented Interfaces:

ImageObserver, MenuContainer, Serializable, EventListener, Accessible, ChangeListener, ListSelectionListener, RootPaneContainer, WindowConstants

public class DatabaseFrame
extends JFrame
implements ListSelectionListener, ChangeListener

Provides a way for the CharGer user to examine the contents of a text "database" file. Allows setting up of simple graph as a starting point for database semantic modeling.

Author:

Harry S. Delugach ( delugach@uah.edu ) Copyright 1998-2020 by Harry S. Delugach

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private class	DatabaseFrame.MyTableModel

Nested classes/interfaces inherited from class JFrame

JFrame.AccessibleJFrame

Nested classes/interfaces inherited from class Frame

Frame.AccessibleAWTFrame

Nested classes/interfaces inherited from class Window

Window.AccessibleAWTWindow, Window.Type

Nested classes/interfaces inherited from class Container

Container.AccessibleAWTContainer

Nested classes/interfaces inherited from class Component

Component.AccessibleAWTComponent, Component.BaselineResizeBehavior, Component.BltBufferStrategy, Component.FlipBufferStrategy

Field Summary

Fields

Modifier and Type	Field and Description
private int	currentRecordNumber The last record number that was read from the db file
private JLabel	databaseFieldsLabel
private JTextField	DatabaseTypeReferent
private JLabel	databaseValuesLabel
private TextDatabase	db
private String[]	DBFieldArray The list of field (column) identifiers, in order
private chargerlib.CGButton	ExamineButton
private JList	FieldList
private JTextField	filePath
private JLabel	inputConceptLabel
private JTextField	messageWindow
private chargerlib.CGButton	nextRecord
private JTextField	primaryKeyIndex
private JLabel	primaryKeyLabel
private chargerlib.CGButton	selectDBbutton
private JTextField	selectedIndex
private JLabel	sequenceNumberLabel
private chargerlib.CGButton	setPrimaryKey
private chargerlib.CGButton	setupGraph
private JScrollPane	SPFieldList
private JScrollPane	SPFieldValuePane
private JScrollPane	SPValueList
private JLabel	titleTextLabel
private JList	ValueList

Fields inherited from class JFrame

accessibleContext, EXIT_ON_CLOSE, rootPane, rootPaneCheckingEnabled

Fields inherited from class 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 Component

BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT

Fields inherited from interface WindowConstants

DISPOSE_ON_CLOSE, DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE

Fields inherited from interface ImageObserver

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

Constructor Summary

Constructors

Constructor and Description
DatabaseFrame(String Folder)

Method Summary

Modifier and Type	Method and Description
(package private) void	clearWindow()
void	ExamineButtonActionPerformed(ActionEvent e)
void	ExamineDatabase()
void	FieldListMouseClicked(MouseEvent e)
void	initComponents()
void	LoadFieldsAndPositions() Scans the given input file (generally a path relative to the current Folder) and determines whether it is a valid database file.
void	LoadNextValues() Gets the next line of data from the database file and displays it in the window.
void	nextRecordActionPerformed(ActionEvent e)
private boolean	selectDB()
void	selectDBbuttonActionPerformed(ActionEvent e)
void	setPrimaryKeyActionPerformed(ActionEvent e)
void	setupGraphActionPerformed(ActionEvent e) Sets up a graph based on the user's choice of a database and primary key.
void	stateChanged(ChangeEvent ce) Handle scrolling list events.
(package private) void	thisWindowClosing(WindowEvent e)
void	valueChanged(ListSelectionEvent e)

Methods inherited from class 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 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 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 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 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 Object

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

Methods inherited from interface MenuContainer

getFont, postEvent

Field Detail

db

private TextDatabase db

DBFieldArray

private String[] DBFieldArray

The list of field (column) identifiers, in order

currentRecordNumber

private int currentRecordNumber

The last record number that was read from the db file

ExamineButton

private chargerlib.CGButton ExamineButton

setPrimaryKey

private chargerlib.CGButton setPrimaryKey

setupGraph

private chargerlib.CGButton setupGraph

selectDBbutton

private chargerlib.CGButton selectDBbutton

nextRecord

private chargerlib.CGButton nextRecord

selectedIndex

private JTextField selectedIndex

primaryKeyIndex

private JTextField primaryKeyIndex

filePath

private JTextField filePath

DatabaseTypeReferent

private JTextField DatabaseTypeReferent

messageWindow

private JTextField messageWindow

inputConceptLabel

private JLabel inputConceptLabel

databaseFieldsLabel

private JLabel databaseFieldsLabel

databaseValuesLabel

private JLabel databaseValuesLabel

sequenceNumberLabel

private JLabel sequenceNumberLabel

primaryKeyLabel

private JLabel primaryKeyLabel

titleTextLabel

private JLabel titleTextLabel

SPFieldList

private JScrollPane SPFieldList

FieldList

private JList FieldList

SPValueList

private JScrollPane SPValueList

ValueList

private JList ValueList

SPFieldValuePane

private JScrollPane SPFieldValuePane

Constructor Detail

DatabaseFrame

public DatabaseFrame(String Folder)

Method Detail

initComponents

public void initComponents()
                    throws Exception

Throws:

Exception

valueChanged

public void valueChanged(ListSelectionEvent e)

Specified by:

valueChanged in interface ListSelectionListener

stateChanged

public void stateChanged(ChangeEvent ce)

Handle scrolling list events. If the viewport of either scrollpane reports a change (e.g., we've scrolled either), then set the other viewport's position. Allows user to scroll either side.

Specified by:

stateChanged in interface ChangeListener

thisWindowClosing

void thisWindowClosing(WindowEvent e)

ExamineButtonActionPerformed

public void ExamineButtonActionPerformed(ActionEvent e)

clearWindow

void clearWindow()

ExamineDatabase

public void ExamineDatabase()

LoadFieldsAndPositions

public void LoadFieldsAndPositions()

Scans the given input file (generally a path relative to the current Folder) and determines whether it is a valid database file. For CharGer purposes, "valid" means it is a tabular list of tab-separated values, where the first line contains the headers to the table. A number of conditions can be noted for the user.

LoadNextValues

public void LoadNextValues()

Gets the next line of data from the database file and displays it in the window.

nextRecordActionPerformed

public void nextRecordActionPerformed(ActionEvent e)

selectDB

private boolean selectDB()

setupGraphActionPerformed

public void setupGraphActionPerformed(ActionEvent e)

Sets up a graph based on the user's choice of a database and primary key.

selectDBbuttonActionPerformed

public void selectDBbuttonActionPerformed(ActionEvent e)

setPrimaryKeyActionPerformed

public void setPrimaryKeyActionPerformed(ActionEvent e)

FieldListMouseClicked

public void FieldListMouseClicked(MouseEvent e)