TableDataSet (Village 3.3.1 API)

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.workingdogs.village
Class TableDataSet

java.lang.Object
  com.workingdogs.village.DataSet
      com.workingdogs.village.TableDataSet

public class TableDataSet
extends DataSet
extends DataSet

This class is used for doing select/insert/delete/update on the database. A TableDataSet cannot be used to join multiple tables for an update, if you need join functionality on a select, you should use a QueryDataSet.

Here is an example usage for this code that gets the first 10 records where column "a" = 1:

  KeyDef kd = new KeyDef().setAttrib("column");
  TableDataSet tds = new TableDataSet(connection, "table_name", kd );
  tds.where ("a=1" ); // WHERE a = 1
  tds.fetchRecords(10); // fetch first 10 records where column a=1
  for ( int i=0;i< tds.size(); i++ )
  {
  Record rec = tds.getRecord(i); // zero based
  String columnA = rec.getValue("a");
  if ( columnA.equals ("1") )
  System.out.print ("We got a column!");
  }
  tds.close();

It is important to remember to always close() the TableDataSet when you are finished with it.

As you can see, using a TableDataSet makes doing selects from the database trivial. You do not need to write any SQL and it makes it easy to cache a TableDataSet for future use within your application.

Version:: $Revision: 568 $
Author:: Jon S. Stevens

Field Summary

Fields inherited from class com.workingdogs.village.DataSet
`ALL_RECORDS, conn, records, resultSet, schema, selectString, stmt`

Constructor Summary
`TableDataSet()` Default constructor.
`TableDataSet(java.sql.Connection conn, Schema schema, KeyDef keydef)` Creates a new TableDataSet object.
`TableDataSet(java.sql.Connection conn, java.lang.String tableName)` Creates a new TableDataSet object.
`TableDataSet(java.sql.Connection conn, java.lang.String tableName, KeyDef keydef)` Creates a new TableDataSet object.
`TableDataSet(java.sql.Connection conn, java.lang.String tableName, java.lang.String columns)` Creates a new TableDataSet object.
`TableDataSet(java.sql.Connection conn, java.lang.String tableName, java.lang.String columns, KeyDef keydef)` Creates a new TableDataSet object.

Method Summary
`DataSet`	`fetchRecords(int start, int max)` Fetch start to max records.
`java.lang.String`	`getSelectString()` Builds the select string that was used to populate this TableDataSet.
`TableDataSet`	`order(java.lang.String order)` Sets the value for the SQL portion of the ORDER statement
`TableDataSet`	`other(java.lang.String other)` Sets the value for the SQL portion of the OTHER statement
`void`	`refresh(java.sql.Connection conn)` This method refreshes all of the Records stored in this TableDataSet.
`boolean`	`refreshOnSave()` Setting this causes each Record to refresh itself when a save() is performed on it.
`void`	`removeDeletedRecords()` Removes any records that are marked as a zombie.
`int`	`save()` Saves all the records in the DataSet.
`int`	`save(boolean intransaction)` Saves all the records in the DataSet with the intransaction boolean value.
`int`	`save(java.sql.Connection conn, boolean intransaction)` Saves all the records in the DataSet with the given connection and intransaction boolean value.
`void`	`setRefreshOnSave(boolean val)` Setting this causes each Record to refresh itself when a save() is performed on it.
`TableDataSet`	`tableQualifier(java.lang.String tq)` This sets additional SQL for the table name.
`TableDataSet`	`where(java.lang.String where)` Sets the value for the SQL portion of the WHERE statement

Methods inherited from class com.workingdogs.village.DataSet
`addRecord, addRecord, allRecordsRetrieved, clearRecords, close, connection, containsRecord, fetchRecords, fetchRecords, getRecord, keydef, lastFetchSize, releaseRecords, removeRecord, reset, resultSet, schema, size, tableName, toString`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait`

Constructor Detail

TableDataSet

public TableDataSet()
             throws java.sql.SQLException,
                    DataSetException

Default constructor.

Throws:: java.sql.SQLException; DataSetException