cug.ptree
Class PersonTable

java.lang.Object
  |
  +--jdbc.AbstractTable
        |
        +--cug.ptree.PersonTable

public class PersonTable

extends AbstractTable

Field Summary

protected static java.lang.String	FN_firstName
protected static java.lang.String	FN_formattedName
protected static java.lang.String	FN_gender
protected static java.lang.String	FN_initials
protected static java.lang.String	FN_key
protected static java.lang.String	FN_lastName
protected static java.lang.String	FN_nameInfix
protected static java.lang.String	FN_personID
protected static java.lang.String	FN_status
protected static java.lang.String	FN_userID
static int	ix_firstName
static int	ix_formattedName
static int	ix_gender
static int	ix_initials
static int	ix_key
static int	ix_lastName
static int	ix_nameInfix
static int	ix_personID
static int	ix_status
static int	ix_userID

Fields inherited from class jdbc.AbstractTable

colNamesR, contents, contentsMap, createID, dbname, defaultFieldLength, ix_primaryKey

Constructor Summary

PersonTable(DataSource dsn)

Method Summary

java.lang.String[]	getColumnNames() implement in subclass
java.lang.String	getFN_userID()
java.lang.String	getKeyString(java.lang.Object o) (override in subclass) used to perform equal match in contains(); determines behaviour of insertDifference, updateStringFor() etc.
java.lang.String	getName() implement in subclass
void	insertRec(java.sql.PreparedStatement insertStmt, java.lang.Object rec) insert 1 rec using PreparedStatement, call-back for insertInto( Vector ) has to be implemented if user of the table needs to call public insertInto( Vector ) does nothing by default
java.lang.Object	selectRec(java.sql.ResultSet result) assemble 1 Object based on 1 ResultSet item has to be implemented if client needs to use public Vector get( String sqlStatement ) returns null if not overridden in subclass

Methods inherited from class jdbc.AbstractTable

contains, get, getAll, getColNamesR, getColumnLengths, getContents, getContentsIt, getContentsMap, getDataSource, getDifference, getKeyField, hasColumnName, insertDifference, insertInto, insertStringRecord, prepareInsertInto, removeAll, selectAll, setColPrimaryKey, sqlCreateTable, sqlInsert, sqlPrepareInsertInto, sqlSelectAll, sqlUpdateStringVal, sqlUpdateVal, squote, toString, updateStringFor

Methods inherited from class java.lang.Object

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

Field Detail

FN_personID

protected static java.lang.String FN_personID

FN_userID

protected static java.lang.String FN_userID

FN_formattedName

protected static java.lang.String FN_formattedName

FN_lastName

protected static java.lang.String FN_lastName

FN_firstName

protected static java.lang.String FN_firstName

FN_nameInfix

protected static java.lang.String FN_nameInfix

FN_initials

protected static java.lang.String FN_initials

FN_gender

protected static java.lang.String FN_gender

FN_status

protected static java.lang.String FN_status

FN_key

protected static java.lang.String FN_key

ix_personID

public static final int ix_personID

See Also:

Constant Field Values

ix_userID

public static final int ix_userID

See Also:

Constant Field Values

ix_formattedName

public static final int ix_formattedName

See Also:

Constant Field Values

ix_lastName

public static final int ix_lastName

See Also:

Constant Field Values

ix_firstName

public static final int ix_firstName

See Also:

Constant Field Values

ix_nameInfix

public static final int ix_nameInfix

See Also:

Constant Field Values

ix_initials

public static final int ix_initials

See Also:

Constant Field Values

ix_gender

public static final int ix_gender

See Also:

Constant Field Values

ix_status

public static final int ix_status

See Also:

Constant Field Values

ix_key

public static final int ix_key

See Also:

Constant Field Values

Constructor Detail

PersonTable

public PersonTable(DataSource dsn)

Method Detail

getName

public java.lang.String getName()

Description copied from class: AbstractTable

implement in subclass

Specified by:

getName in class AbstractTable

Returns:

String name

getColumnNames

public java.lang.String[] getColumnNames()

Description copied from class: AbstractTable

implement in subclass

Specified by:

getColumnNames in class AbstractTable

Returns:

String[] column names

getKeyString

public java.lang.String getKeyString(java.lang.Object o)

Description copied from class: AbstractTable

(override in subclass) used to perform equal match in contains(); determines behaviour of insertDifference, updateStringFor() etc.

Overrides:

getKeyString in class AbstractTable

Returns:

String person-id

getFN_userID

public java.lang.String getFN_userID()

insertRec

public void insertRec(java.sql.PreparedStatement insertStmt,
                      java.lang.Object rec)
               throws java.sql.SQLException

Description copied from class: AbstractTable

insert 1 rec using PreparedStatement, call-back for insertInto( Vector ) has to be implemented if user of the table needs to call public insertInto( Vector ) does nothing by default

Overrides:

insertRec in class AbstractTable

java.sql.SQLException

See Also:

AbstractTable.insertInto(java.util.Vector)

selectRec

public java.lang.Object selectRec(java.sql.ResultSet result)
                           throws java.sql.SQLException

Description copied from class: AbstractTable

assemble 1 Object based on 1 ResultSet item has to be implemented if client needs to use public Vector get( String sqlStatement ) returns null if not overridden in subclass

Overrides:

selectRec in class AbstractTable

Returns:

Person

java.sql.SQLException

See Also:

AbstractTable.getAll()