edu.iastate.utils.sql
Class DBViewer

java.lang.Object
  java.awt.Component
      java.awt.Container
          java.awt.Window
              java.awt.Dialog
                  javax.swing.JDialog
                      edu.iastate.utils.sql.DBViewer

All Implemented Interfaces:

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

Direct Known Subclasses:

DataAVHViewer

public class DBViewer

extends javax.swing.JDialog

Title: LocalCacheViewer

Description: Interface to view database

Copyright: Copyright (c) 2003

Company: Iowa State University

Version:

1.0 2003-11-10 2.0 2005-03-18 Add table list selection

Author:

Jie Bao

See Also:

Serialized Form

To Do:

rewrite it with DBPanel, cut all redundant code.

Nested Class Summary

(package private) class

DBViewer.MySchemaListener

Nested classes inherited from class javax.swing.JDialog

javax.swing.JDialog.AccessibleJDialog

Nested classes inherited from class java.awt.Dialog

java.awt.Dialog.AccessibleAWTDialog

Nested classes inherited from class java.awt.Window

java.awt.Window.AccessibleAWTWindow

Nested classes inherited from class java.awt.Container

java.awt.Container.AccessibleAWTContainer

Nested classes inherited from class java.awt.Component

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

Field Summary

(package private) com.borland.dx.sql.dataset.Database	CacheDB
(package private) java.lang.String	connectionURL
protected javax.swing.JComboBox	datasourceList
protected com.borland.dbswing.JdbTable	dataTable
(package private) com.borland.dbswing.DBDisposeMonitor	dbDisposeMonitor
(package private) java.lang.String	driver
(package private) javax.swing.JButton	jButtonAdvanceSQL
(package private) javax.swing.JPanel	jPanel1
(package private) com.borland.dbswing.JdbStatusLabel	jStatusLabel
(package private) com.borland.dbswing.JdbNavToolBar	jToolBar
(package private) java.lang.String	password
(package private) boolean	promptPassword
(package private) com.borland.dx.sql.dataset.QueryDataSet	query
(package private) boolean	showSQLButton
(package private) java.lang.String	sql
(package private) com.borland.dbswing.TableScrollPane	tableScrollPane1
(package private) java.lang.String	userName

Fields inherited from class javax.swing.JDialog

accessibleContext, rootPane, rootPaneCheckingEnabled

Fields inherited from class java.awt.Dialog

Fields inherited from class java.awt.Window

Fields inherited from class java.awt.Container

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, EXIT_ON_CLOSE, HIDE_ON_CLOSE

Fields inherited from interface java.awt.image.ImageObserver

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

Constructor Summary

DBViewer(javax.swing.JFrame aFrame, boolean showSQLButton, java.lang.String title, java.lang.String connectionURL, java.lang.String userName, java.lang.String password, boolean promptPassword, java.lang.String driver)

Method Summary

private void	jbInit()
(package private) void	jButtonAdvancedQueryAction(java.awt.event.ActionEvent e)
static void	main(java.lang.String[] args)
(package private) void	readDatasource()
void	refresh() refresh
void	setSQL(java.lang.String newSQL) setSQL

Methods inherited from class javax.swing.JDialog

addImpl, createRootPane, dialogInit, getAccessibleContext, getContentPane, getDefaultCloseOperation, getGlassPane, getJMenuBar, getLayeredPane, getRootPane, isDefaultLookAndFeelDecorated, isRootPaneCheckingEnabled, paramString, processWindowEvent, remove, setContentPane, setDefaultCloseOperation, setDefaultLookAndFeelDecorated, setGlassPane, setJMenuBar, setLayeredPane, setLayout, setRootPane, setRootPaneCheckingEnabled, update

Methods inherited from class java.awt.Dialog

addNotify, dispose, getTitle, hide, isModal, isResizable, isUndecorated, setModal, setResizable, setTitle, setUndecorated, show

Methods inherited from class java.awt.Window

addPropertyChangeListener, addPropertyChangeListener, addWindowFocusListener, addWindowListener, addWindowStateListener, applyResourceBundle, applyResourceBundle, createBufferStrategy, createBufferStrategy, finalize, getBufferStrategy, getFocusableWindowState, getFocusCycleRootAncestor, getFocusOwner, getFocusTraversalKeys, getGraphicsConfiguration, getInputContext, getListeners, getLocale, getMostRecentFocusOwner, getOwnedWindows, getOwner, getToolkit, getWarningString, getWindowFocusListeners, getWindowListeners, getWindowStateListeners, isActive, isFocusableWindow, isFocusCycleRoot, isFocused, isShowing, pack, postEvent, processEvent, processWindowFocusEvent, processWindowStateEvent, removeWindowFocusListener, removeWindowListener, removeWindowStateListener, setCursor, setFocusableWindowState, setFocusCycleRoot, setLocationRelativeTo, 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, getContainerListeners, getFocusTraversalPolicy, getInsets, getLayout, getMaximumSize, getMinimumSize, getPreferredSize, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paint, paintComponents, preferredSize, print, printComponents, processContainerEvent, remove, removeAll, removeContainerListener, removeNotify, setFocusTraversalKeys, setFocusTraversalPolicy, setFont, transferFocusBackward, 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, getBackground, getBounds, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphics, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocation, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, 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, isOpaque, 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, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, repaint, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, reshape, resize, resize, setBackground, setBounds, setBounds, setComponentOrientation, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeysEnabled, setForeground, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, setVisible, show, size, toString, transferFocus, transferFocusUpCycle

Methods inherited from class java.lang.Object

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

Field Detail

tableScrollPane1

com.borland.dbswing.TableScrollPane tableScrollPane1

jStatusLabel

com.borland.dbswing.JdbStatusLabel jStatusLabel

dataTable

protected com.borland.dbswing.JdbTable dataTable

jToolBar

com.borland.dbswing.JdbNavToolBar jToolBar

CacheDB

com.borland.dx.sql.dataset.Database CacheDB

query

com.borland.dx.sql.dataset.QueryDataSet query

dbDisposeMonitor

com.borland.dbswing.DBDisposeMonitor dbDisposeMonitor

jPanel1

javax.swing.JPanel jPanel1

jButtonAdvanceSQL

javax.swing.JButton jButtonAdvanceSQL

showSQLButton

boolean showSQLButton

connectionURL

java.lang.String connectionURL

userName

java.lang.String userName

password

java.lang.String password

promptPassword

boolean promptPassword

driver

java.lang.String driver

sql

java.lang.String sql

datasourceList

protected javax.swing.JComboBox datasourceList

Constructor Detail

DBViewer

public DBViewer(javax.swing.JFrame aFrame,
                boolean showSQLButton,
                java.lang.String title,
                java.lang.String connectionURL,
                java.lang.String userName,
                java.lang.String password,
                boolean promptPassword,
                java.lang.String driver)
         throws java.awt.HeadlessException

Method Detail

jbInit

private void jbInit()
             throws java.lang.Exception

Throws:

java.lang.Exception

refresh

public void refresh()

refresh

setSQL

public void setSQL(java.lang.String newSQL)

setSQL

Parameters:

newSQL - String

readDatasource

void readDatasource()

jButtonAdvancedQueryAction

void jButtonAdvancedQueryAction(java.awt.event.ActionEvent e)

main

public static void main(java.lang.String[] args)
                 throws java.awt.HeadlessException

Throws:

java.awt.HeadlessException