A B C D E F G I K L M N O P Q R S T U V W Z

A

addAttrib(String) - Method in class com.workingdogs.village.KeyDef

Adds the named attribute to the KeyDef.

addRecord() - Method in class com.workingdogs.village.DataSet

Calls addRecord(DataSet)

addRecord(DataSet) - Method in class com.workingdogs.village.DataSet

Creates a new Record within this DataSet

AFTERDELETE - Static variable in class com.workingdogs.village.Enums

trigger state after a delete is run

AFTERINSERT - Static variable in class com.workingdogs.village.Enums

trigger state after a insert is run

AFTERUPDATE - Static variable in class com.workingdogs.village.Enums

trigger state after a update is run

ALL_RECORDS - Static variable in class com.workingdogs.village.DataSet

indicates that all records should be retrieved during a fetch

allRecordsRetrieved() - Method in class com.workingdogs.village.DataSet

Check if all the records have been retrieve

asBigDecimal() - Method in class com.workingdogs.village.Value

Get the value as a BigDecimal

asBigDecimal(int) - Method in class com.workingdogs.village.Value

Get the value as a BigDecimal

asBoolean() - Method in class com.workingdogs.village.Value

Get the value as a asBoolean

asBooleanObj() - Method in class com.workingdogs.village.Value

Get the value as a Boolean object

asByte() - Method in class com.workingdogs.village.Value

Get the value as a asByte

asByteObj() - Method in class com.workingdogs.village.Value

Get the value as a Byte Object

asBytes() - Method in class com.workingdogs.village.Value

Get the value as a asBytes

asDate() - Method in class com.workingdogs.village.Value

Get the value as a asDate

asDouble() - Method in class com.workingdogs.village.Value

Get the value as a asDouble

asDoubleObj() - Method in class com.workingdogs.village.Value

Get the value as a Double Object

asFloat() - Method in class com.workingdogs.village.Value

Get the value as a asFloat

asFloatObj() - Method in class com.workingdogs.village.Value

Get the value as a Float Obj

asFormattedString(String, int[]) - Method in class com.workingdogs.village.Record

return the value of each column as a string.

asInt() - Method in class com.workingdogs.village.Value

Get the value as a asInt

asIntegerObj() - Method in class com.workingdogs.village.Value

Get the value as a Integer Ojbect

asLong() - Method in class com.workingdogs.village.Value

Get the value as a asLong

asLongObj() - Method in class com.workingdogs.village.Value

Get the value as a Long Object

asShort() - Method in class com.workingdogs.village.Value

Get the value as a asShort

asShortObj() - Method in class com.workingdogs.village.Value

Get the value as a Short Object

asString() - Method in class com.workingdogs.village.Value

Returns the string representation of this object

asTime() - Method in class com.workingdogs.village.Value

Get the value as a asTime

asTimestamp() - Method in class com.workingdogs.village.Value

Get the value as a asTimestamp

asUtilDate() - Method in class com.workingdogs.village.Value

Get the value as a asUtilDate

attributes() - Method in class com.workingdogs.village.Schema

List of columns to select from the table

B

BEFOREDELETE - Static variable in class com.workingdogs.village.Enums

trigger state before a delete is run

BEFOREINSERT - Static variable in class com.workingdogs.village.Enums

trigger state before a insert is run

BEFOREUPDATE - Static variable in class com.workingdogs.village.Enums

trigger state before a update is run

C

clearRecords() - Method in class com.workingdogs.village.DataSet

Remove all records from the DataSet and nulls those records out and close() the DataSet.

close() - Method in class com.workingdogs.village.DataSet

Releases the records, closes the ResultSet and the Statement, and nulls the Schema and Connection references.

Column - Class in com.workingdogs.village

This class represents a Column in the database and its associated meta information.

Column() - Constructor for class com.workingdogs.village.Column

constructor

column(int) - Method in class com.workingdogs.village.Schema

Returns the requested Column object at index i

column(String) - Method in class com.workingdogs.village.Schema

Returns the requested Column object by name

com.workingdogs.village - package com.workingdogs.village

Village is a JDBC abstraction layer.

conn - Variable in class com.workingdogs.village.DataSet

this DataSet's connection object

connection() - Method in class com.workingdogs.village.DataSet

Gets the current database connection

containsAttrib(String) - Method in class com.workingdogs.village.KeyDef

Determines if the KeyDef contains the requested Attribute.

containsRecord(int) - Method in class com.workingdogs.village.DataSet

Check to see if the DataSet contains a Record at 0 based position

D

DataSet - Class in com.workingdogs.village

The DataSet represents a table in the database.

DataSet() - Constructor for class com.workingdogs.village.DataSet

Private, not used

dataset() - Method in class com.workingdogs.village.Record

Gets the DataSet for this Record

DataSetException - Exception in com.workingdogs.village

A DataSetException is thrown if there is an error.

DataSetException() - Constructor for exception com.workingdogs.village.DataSetException

Creates a new DataSetException object.

DataSetException(String) - Constructor for exception com.workingdogs.village.DataSetException

Creates a new DataSetException object.

DELETE - Static variable in class com.workingdogs.village.Enums

A record marked for delete

E

Enums - Class in com.workingdogs.village

A class for constants.

F

fetchRecords() - Method in class com.workingdogs.village.DataSet

Causes the DataSet to hit the database and fetch all the records.

fetchRecords(int) - Method in class com.workingdogs.village.DataSet

Causes the DataSet to hit the database and fetch max records.

fetchRecords(int, int) - Method in class com.workingdogs.village.DataSet

Causes the DataSet to hit the database and fetch max records, starting at start.

fetchRecords(int, int) - Method in class com.workingdogs.village.TableDataSet

Fetch start to max records.

G

getAllTableNames() - Method in class com.workingdogs.village.Schema

returns all table names that this Schema represents

getAttrib(int) - Method in class com.workingdogs.village.KeyDef

getAttrib is 1 based.

getColumn(String) - Method in class com.workingdogs.village.Schema

Returns the requested Column object by name

getColumn(String, String) - Method in class com.workingdogs.village.Schema

Returns the requested Column object belonging to the specified table by name

getRecord(int) - Method in class com.workingdogs.village.DataSet

Get Record at 0 based index position

getRefreshQueryString() - Method in class com.workingdogs.village.Record

This builds the SELECT statement in order to refresh the contents of this Record.

getSaveString() - Method in class com.workingdogs.village.Record

Gets the appropriate SQL string for this record.

getSelectString() - Method in class com.workingdogs.village.DataSet

Classes extending this class must implement this method.

getSelectString() - Method in class com.workingdogs.village.QueryDataSet

get the Select String that was used to create this QueryDataSet

getSelectString() - Method in class com.workingdogs.village.TableDataSet

Builds the select string that was used to populate this TableDataSet.

getTableName() - Method in class com.workingdogs.village.Column

TODO: DOCUMENT ME!

getTableName() - Method in class com.workingdogs.village.Schema

returns the table name that this Schema represents

getValue(int) - Method in class com.workingdogs.village.Record

gets the value at index i

getValue(String) - Method in class com.workingdogs.village.Record

TODO: DOCUMENT ME!

I

index(String) - Method in class com.workingdogs.village.Schema

Gets the index position of a named column.

index(String, String) - Method in class com.workingdogs.village.Schema

Gets the index position of a named column.

initSchemas(Connection) - Static method in class com.workingdogs.village.Schema

Initialize all table schemas reachable from this connection

INSERT - Static variable in class com.workingdogs.village.Enums

A record marked for insert

isAZombie() - Method in class com.workingdogs.village.Record

Determines if this record is a Zombie.

isBigDecimal() - Method in class com.workingdogs.village.Column

column isBigDecimal: 2 || 3

isBigDecimal() - Method in class com.workingdogs.village.Value

Is the value a isBigDecimal

isBinary() - Method in class com.workingdogs.village.Column

column isBinary: -2

isBoolean() - Method in class com.workingdogs.village.Column

column isBoolean: -7

isBoolean() - Method in class com.workingdogs.village.Value

Is the value a isBoolean

isByte() - Method in class com.workingdogs.village.Column

column isByte: -6

isByte() - Method in class com.workingdogs.village.Value

Is the value a isByte

isBytes() - Method in class com.workingdogs.village.Column

column isBytes: -4 || -3 || -2

isBytes() - Method in class com.workingdogs.village.Value

Is the value a isBytes

isDate() - Method in class com.workingdogs.village.Column

column isBytes: 91

isDate() - Method in class com.workingdogs.village.Value

Is the value a isDate

isDouble() - Method in class com.workingdogs.village.Column

column isDouble: 6 || 8

isDouble() - Method in class com.workingdogs.village.Value

Is the value a isDouble

isFloat() - Method in class com.workingdogs.village.Column

column isFloat: 7

isFloat() - Method in class com.workingdogs.village.Value

Is the value a isFloat

isInt() - Method in class com.workingdogs.village.Column

column isInt: 4

isInt() - Method in class com.workingdogs.village.Value

Is the value a isInt

isLong() - Method in class com.workingdogs.village.Column

column isLong: -5

isLong() - Method in class com.workingdogs.village.Value

Is the value a isLong

isLongVarBinary() - Method in class com.workingdogs.village.Column

column isLongVarBinary: -4

isNull() - Method in class com.workingdogs.village.Value

Is the value a isNull

isShort() - Method in class com.workingdogs.village.Column

column isShort: 5

isShort() - Method in class com.workingdogs.village.Value

Is the value a isShort

isSingleTable() - Method in class com.workingdogs.village.Schema

Checks to see if this DataSet represents one table in the database.

isString() - Method in class com.workingdogs.village.Column

column isString: -1 || -11 || 12

isString() - Method in class com.workingdogs.village.Value

Is the value a isString

isTime() - Method in class com.workingdogs.village.Column

column isTime: 92

isTime() - Method in class com.workingdogs.village.Value

Is the value a isTime

isTimestamp() - Method in class com.workingdogs.village.Column

column isTimestamp: 93

isTimestamp() - Method in class com.workingdogs.village.Value

Is the value a isTimestamp

isUtilDate() - Method in class com.workingdogs.village.Value

Is the value a isUtilDate

isVarBinary() - Method in class com.workingdogs.village.Column

column isVarBinary: -3

K

keydef() - Method in class com.workingdogs.village.DataSet

gets the KeyDef object for this DataSet

KeyDef - Class in com.workingdogs.village

A KeyDef is a way to define the key columns in a table.

KeyDef() - Constructor for class com.workingdogs.village.KeyDef

Constructor for KeyDef.

L

lastFetchSize() - Method in class com.workingdogs.village.DataSet

The number of records that were fetched with the last fetchRecords.

M

markForInsert() - Method in class com.workingdogs.village.Record

Marks this record to be inserted when a save is executed.

markForUpdate() - Method in class com.workingdogs.village.Record

Marks this record to be updated when a save is executed.

markRecordClean() - Method in class com.workingdogs.village.Record

Marks all the values in this record as clean.

markToBeDeleted() - Method in class com.workingdogs.village.Record

Marks this record to be deleted when a save is executed.

markValueClean(int) - Method in class com.workingdogs.village.Record

marks a value at a given position as clean.

markValueClean(String) - Method in class com.workingdogs.village.Record

marks a value with a given column name as clean.

markValueDirty(int) - Method in class com.workingdogs.village.Record

marks a value at a given position as dirty.

markValueDirty(String) - Method in class com.workingdogs.village.Record

marks a value with a given column name as dirty.

N

name() - Method in class com.workingdogs.village.Column

the name of the column

needsToBeSaved() - Method in class com.workingdogs.village.Record

If the record is not clean, needs to be saved with an Update, Delete or Insert, it returns true.

nullAllowed() - Method in class com.workingdogs.village.Column

does this column allow null?

numberOfColumns() - Method in class com.workingdogs.village.Schema

Gets the number of columns in this Schema

O

ORACLE - Static variable in class com.workingdogs.village.Enums

an oracle type

order(String) - Method in class com.workingdogs.village.TableDataSet

Sets the value for the SQL portion of the ORDER statement

other(String) - Method in class com.workingdogs.village.TableDataSet

Sets the value for the SQL portion of the OTHER statement

P

populate(ResultSetMetaData, int, String, String) - Method in class com.workingdogs.village.Column

internal package method for populating a Column instance

populate(String, String, String, int, boolean) - Method in class com.workingdogs.village.Column

internal package method for populating a Column instance

Q

QueryDataSet - Class in com.workingdogs.village

This class is used for doing SQL select statements on the database.

QueryDataSet() - Constructor for class com.workingdogs.village.QueryDataSet

Private...does nothing.

QueryDataSet(Connection, String) - Constructor for class com.workingdogs.village.QueryDataSet

Creates a new QueryDataSet based on a connection and a select string

QueryDataSet(ResultSet) - Constructor for class com.workingdogs.village.QueryDataSet

Create a new QueryDataSet based on an existing resultSet

R

readOnly() - Method in class com.workingdogs.village.Column

is this column read only?

Record - Class in com.workingdogs.village

A Record represents a row in the database.

Record() - Constructor for class com.workingdogs.village.Record

This isn't used and doesn't do anything.

Record(DataSet) - Constructor for class com.workingdogs.village.Record

Creates a new Record and sets the parent dataset to the passed in value.

recordIsClean() - Method in class com.workingdogs.village.Record

Goes through all the values in the record to determine if it is clean or not.

records - Variable in class com.workingdogs.village.DataSet

this DataSet's collection of Record objects

refresh(Connection) - Method in class com.workingdogs.village.Record

This method refreshes this Record's Value's.

refresh(Connection) - Method in class com.workingdogs.village.TableDataSet

This method refreshes all of the Records stored in this TableDataSet.

refreshOnSave() - Method in class com.workingdogs.village.TableDataSet

Setting this causes each Record to refresh itself when a save() is performed on it.

releaseRecords() - Method in class com.workingdogs.village.DataSet

Removes the records from the DataSet, but does not null the records out

removeDeletedRecords() - Method in class com.workingdogs.village.TableDataSet

Removes any records that are marked as a zombie.

removeRecord(Record) - Method in class com.workingdogs.village.DataSet

Remove a record from the DataSet's internal storage

reset() - Method in class com.workingdogs.village.DataSet

Essentially the same as releaseRecords, but it won't work on a QueryDataSet that has been created with a ResultSet

resultSet - Variable in class com.workingdogs.village.DataSet

the result set for this DataSet

resultSet() - Method in class com.workingdogs.village.DataSet

Gets the ResultSet for this DataSet

S

save() - Method in class com.workingdogs.village.Record

Saves the data in this Record to the database.

save(Connection) - Method in class com.workingdogs.village.Record

Saves the data in this Record to the database.

save() - Method in class com.workingdogs.village.TableDataSet

Saves all the records in the DataSet.

save(boolean) - Method in class com.workingdogs.village.TableDataSet

Saves all the records in the DataSet with the intransaction boolean value.

save(Connection, boolean) - Method in class com.workingdogs.village.TableDataSet

Saves all the records in the DataSet with the given connection and intransaction boolean value.

saveWithoutStatusUpdate() - Method in class com.workingdogs.village.Record

TODO: DOCUMENT ME!

schema - Variable in class com.workingdogs.village.DataSet

this DataSet's schema object

schema() - Method in class com.workingdogs.village.DataSet

Gets the Schema for this DataSet

schema() - Method in class com.workingdogs.village.Record

Gets the schema for the parent DataSet

Schema - Class in com.workingdogs.village

The Schema object represents the Columns in a database table.

Schema() - Constructor for class com.workingdogs.village.Schema

A blank Schema object

schema(Connection, String) - Method in class com.workingdogs.village.Schema

Creates a Schema with all columns

schema(Connection, String, String) - Method in class com.workingdogs.village.Schema

Creates a Schema with the named columns in the columnsAttribute

selectString - Variable in class com.workingdogs.village.DataSet

the select string that was used to build this DataSet

setRefreshOnSave(boolean) - Method in class com.workingdogs.village.TableDataSet

Setting this causes each Record to refresh itself when a save() is performed on it.

setValue(int, BigDecimal) - Method in class com.workingdogs.village.Record

sets the value at pos with a BigDecimal

setValue(int, boolean) - Method in class com.workingdogs.village.Record

sets the value at pos with a boolean

setValue(int, byte[]) - Method in class com.workingdogs.village.Record

sets the value at pos with a byte[]

setValue(int, Date) - Method in class com.workingdogs.village.Record

sets the value at pos with a java.util.Date

setValue(int, Date) - Method in class com.workingdogs.village.Record

sets the value at pos with a java.sql.Date

setValue(int, double) - Method in class com.workingdogs.village.Record

sets the value at pos with a double

setValue(int, float) - Method in class com.workingdogs.village.Record

sets the value at pos with a float

setValue(int, int) - Method in class com.workingdogs.village.Record

sets the value at pos with a int

setValue(int, long) - Method in class com.workingdogs.village.Record

sets the value at pos with a long

setValue(int, String) - Method in class com.workingdogs.village.Record

sets the value at pos with a String

setValue(int, Time) - Method in class com.workingdogs.village.Record

sets the value at pos with a java.sql.Time

setValue(int, Timestamp) - Method in class com.workingdogs.village.Record

sets the value at pos with a java.sql.Timestamp

setValue(int, Value) - Method in class com.workingdogs.village.Record

sets the value at pos with a Value

setValue(String, BigDecimal) - Method in class com.workingdogs.village.Record

sets the value at column name with a BigDecimal

setValue(String, boolean) - Method in class com.workingdogs.village.Record

sets the value at column name with a boolean

setValue(String, byte[]) - Method in class com.workingdogs.village.Record

sets the value at column name with a byte[]

setValue(String, Date) - Method in class com.workingdogs.village.Record

sets the value at column name with a java.util.Date

setValue(String, Date) - Method in class com.workingdogs.village.Record

sets the value at column name with a java.sql.Date

setValue(String, double) - Method in class com.workingdogs.village.Record

sets the value at column name with a double

setValue(String, float) - Method in class com.workingdogs.village.Record

sets the value at column name with a float

setValue(String, int) - Method in class com.workingdogs.village.Record

sets the value at column name with a int

setValue(String, long) - Method in class com.workingdogs.village.Record

sets the value at column name with a long

setValue(String, String) - Method in class com.workingdogs.village.Record

sets the value at column name with a String

setValue(String, Time) - Method in class com.workingdogs.village.Record

sets the value at column name with a java.sql.Time

setValue(String, Timestamp) - Method in class com.workingdogs.village.Record

sets the value at column name with a java.sql.Timestamp

setValue(String, Value) - Method in class com.workingdogs.village.Record

sets the value at column name with a Value

setValueNull(int) - Method in class com.workingdogs.village.Record

sets the value at pos with a NULL

setValueNull(String) - Method in class com.workingdogs.village.Record

sets the value at column name with a NULL

size() - Method in class com.workingdogs.village.DataSet

Gets the number of Records in this DataSet.

size() - Method in class com.workingdogs.village.KeyDef

KeyDef's are 1 based, returns size - 1

size() - Method in class com.workingdogs.village.Record

the number of columns in this object

SQLSERVER - Static variable in class com.workingdogs.village.Enums

an sqlserver type

stmt - Variable in class com.workingdogs.village.DataSet

the Statement for this DataSet

SYBASE - Static variable in class com.workingdogs.village.Enums

an sybase type

T

TableDataSet - Class in com.workingdogs.village

This class is used for doing select/insert/delete/update on the database.

TableDataSet() - Constructor for class com.workingdogs.village.TableDataSet

Default constructor.

TableDataSet(Connection, String) - Constructor for class com.workingdogs.village.TableDataSet

Creates a new TableDataSet object.

TableDataSet(Connection, Schema, KeyDef) - Constructor for class com.workingdogs.village.TableDataSet

Creates a new TableDataSet object.

TableDataSet(Connection, String, KeyDef) - Constructor for class com.workingdogs.village.TableDataSet

Creates a new TableDataSet object.

TableDataSet(Connection, String, String) - Constructor for class com.workingdogs.village.TableDataSet

Creates a new TableDataSet object.

TableDataSet(Connection, String, String, KeyDef) - Constructor for class com.workingdogs.village.TableDataSet

Creates a new TableDataSet object.

tableName() - Method in class com.workingdogs.village.DataSet

Gets the tableName defined in the schema

tableName() - Method in class com.workingdogs.village.Schema

returns the table name that this Schema represents

tableQualifier(String) - Method in class com.workingdogs.village.TableDataSet

This sets additional SQL for the table name.

toBeSavedWithDelete() - Method in class com.workingdogs.village.Record

whether or not this Record is to be saved with an SQL delete statement

toBeSavedWithInsert() - Method in class com.workingdogs.village.Record

whether or not this Record is to be saved with an SQL insert statement

toBeSavedWithUpdate() - Method in class com.workingdogs.village.Record

whether or not this Record is to be saved with an SQL update statement

toString() - Method in class com.workingdogs.village.DataSet

This returns a represention of this DataSet

toString() - Method in class com.workingdogs.village.Record

This returns a representation of this Record

toString() - Method in class com.workingdogs.village.Schema

This returns a representation of this Schema

toString() - Method in class com.workingdogs.village.Value

Returns the string representation of this object

type() - Method in class com.workingdogs.village.Column

the type of the column as a string

type() - Method in class com.workingdogs.village.Value

Return the type of this value

typeEnum() - Method in class com.workingdogs.village.Column

the data type of a column

U

UNKNOWN - Static variable in class com.workingdogs.village.Enums

an unknown type

unmarkToBeDeleted() - Method in class com.workingdogs.village.Record

Unmarks a record that has been marked for deletion.

UPDATE - Static variable in class com.workingdogs.village.Enums

A record marked for update

V

Value - Class in com.workingdogs.village

A Value represents a single cell in a database table.

Value(ResultSet, int, int) - Constructor for class com.workingdogs.village.Value

Creates a new Value object based on the ResultSet, columnNumber and type

valueIsClean(int) - Method in class com.workingdogs.village.Record

Determines whether or not a value stored in the record is clean.

W

where(String) - Method in class com.workingdogs.village.TableDataSet

Sets the value for the SQL portion of the WHERE statement

Z

ZOMBIE - Static variable in class com.workingdogs.village.Enums

DataSet record that has been deleted but not removed from the DataSet

A B C D E F G I K L M N O P Q R S T U V W Z