com.gsoft.titration.client
Class TitrationDataManager

java.lang.Object
  |
  +--java.awt.Component
        |
        +--java.awt.Container
              |
              +--java.awt.Window
                    |
                    +--java.awt.Frame
                          |
                          +--javax.swing.JFrame
                                |
                                +--com.gsoft.titration.client.TitrationDataManager

Direct Known Subclasses:

TitrationUI

public class TitrationDataManager

extends JFrame

Fields inherited from class java.awt.Frame

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

Fields inherited from class java.awt.Component

TOP_ALIGNMENT, CENTER_ALIGNMENT, BOTTOM_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT

Constructor Summary

TitrationDataManager()

Method Summary
boolean	addNewUser(String un, String pw, String dn)
void	addNotes(String date, String comment, int userid, int projectid)
void	createPreparedStatement(String name, String sql)
LoginItem	doLogin(String uname, String pword)
ArrayList	fetchNotes(int projectid)
Object[]	fetchProjectLists(int userid)
PreparedStatement	fetchStoredProcedure(String name)
ArrayList	fetchUserList()
private String	formatDate(String date)
int	getNextNum(String table)
ArrayList	getProjectList(int userid)
private void	initStatements()
boolean	projectNameOnfile(String pname)
private void	refreshStatements()
void	resetPassword(int userid, String pword)
void	saveNewProject(ProjectItem pi, int userID)
void	updateExistingProject(ProjectItem pi)
void	updatePriority(Object[] items)
void	updateUserProjects(int userid, Iterator list)
private void	validateConnection()
int	validateUpdateUserPassword(int userid, String old, String newpw)

Methods inherited from class javax.swing.JFrame

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

Methods inherited from class java.awt.Frame

finalize, addNotify, getTitle, setTitle, getIconImage, setIconImage, getMenuBar, setMenuBar, isResizable, setResizable, setState, getState, remove, removeNotify, setCursor, getCursorType, getFrames

Methods inherited from class java.awt.Window

pack, show, hide, dispose, toFront, toBack, getToolkit, getWarningString, getLocale, getInputContext, setCursor, getOwner, getOwnedWindows, addWindowListener, removeWindowListener, getListeners, processEvent, getFocusOwner, postEvent, isShowing, applyResourceBundle, applyResourceBundle, getGraphicsConfiguration

Methods inherited from class java.awt.Container

getComponentCount, countComponents, getComponent, getComponents, getInsets, insets, add, add, add, add, add, remove, removeAll, getLayout, doLayout, layout, invalidate, validate, validateTree, setFont, getPreferredSize, preferredSize, getMinimumSize, minimumSize, getMaximumSize, getAlignmentX, getAlignmentY, paint, print, paintComponents, printComponents, addContainerListener, removeContainerListener, processContainerEvent, deliverEvent, getComponentAt, locate, getComponentAt, findComponentAt, findComponentAt, isAncestorOf, list, list

Methods inherited from class java.awt.Component

getName, setName, getParent, getPeer, setDropTarget, getDropTarget, getTreeLock, isValid, isDisplayable, isVisible, isEnabled, setEnabled, enable, enable, disable, isDoubleBuffered, enableInputMethods, setVisible, show, getForeground, setForeground, getBackground, setBackground, getFont, setLocale, getColorModel, getLocation, getLocationOnScreen, location, setLocation, move, setLocation, getSize, size, setSize, resize, setSize, resize, getBounds, bounds, setBounds, reshape, setBounds, getX, getY, getWidth, getHeight, getBounds, getSize, getLocation, isOpaque, isLightweight, getGraphics, getFontMetrics, getCursor, paintAll, repaint, repaint, repaint, repaint, printAll, imageUpdate, createImage, createImage, prepareImage, prepareImage, checkImage, checkImage, contains, inside, contains, dispatchEvent, addComponentListener, removeComponentListener, addFocusListener, removeFocusListener, addHierarchyListener, removeHierarchyListener, addHierarchyBoundsListener, removeHierarchyBoundsListener, addKeyListener, removeKeyListener, addMouseListener, removeMouseListener, addMouseMotionListener, removeMouseMotionListener, addInputMethodListener, removeInputMethodListener, getInputMethodRequests, enableEvents, disableEvents, coalesceEvents, processComponentEvent, processFocusEvent, processMouseEvent, processMouseMotionEvent, processInputMethodEvent, processHierarchyEvent, processHierarchyBoundsEvent, handleEvent, mouseDown, mouseDrag, mouseUp, mouseMove, mouseEnter, mouseExit, keyDown, keyUp, action, gotFocus, lostFocus, isFocusTraversable, requestFocus, transferFocus, nextFocus, hasFocus, add, toString, list, list, list, addPropertyChangeListener, removePropertyChangeListener, addPropertyChangeListener, removePropertyChangeListener, firePropertyChange, setComponentOrientation, getComponentOrientation

Methods inherited from class java.lang.Object

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

Field Detail

conMgr

private ConnectionManager conMgr

private Connection conn

private Hashtable connList

private EncryptionUtility encUtil

private PreparedStatement pstate

private Hashtable stmtSQL

protected TagReader tReader

public TitrationDataManager()

public boolean addNewUser(String un, String pw, String dn)
                    throws java.lang.Exception

public void addNotes(String date, String comment, int userid, int projectid)
               throws java.lang.Exception

public void createPreparedStatement(String name, String sql)
                              throws java.lang.Exception

public LoginItem doLogin(String uname, String pword)
                   throws java.lang.Exception

public ArrayList fetchNotes(int projectid)
                      throws java.lang.Exception

public Object[] fetchProjectLists(int userid)
                            throws java.lang.Exception

public PreparedStatement fetchStoredProcedure(String name)
                                        throws java.lang.Exception

public ArrayList fetchUserList()
                         throws java.lang.Exception

private String formatDate(String date)

public int getNextNum(String table)
                throws java.lang.Exception

public ArrayList getProjectList(int userid)
                          throws java.lang.Exception

private void initStatements()
                      throws java.lang.Exception

public boolean projectNameOnfile(String pname)
                           throws java.lang.Exception

private void refreshStatements()
                         throws java.lang.Exception

public void resetPassword(int userid, String pword)
                    throws java.lang.Exception

public void saveNewProject(ProjectItem pi, int userID)
                     throws java.lang.Exception

public void updateExistingProject(ProjectItem pi)
                            throws java.lang.Exception

public void updatePriority(Object[] items)
                     throws java.lang.Exception

public void updateUserProjects(int userid, Iterator list)
                         throws java.lang.Exception

private void validateConnection()
                          throws java.lang.Exception

public int validateUpdateUserPassword(int userid, String old, String newpw)
                                throws java.lang.Exception