edu.udo.cs.yale.example
Class DatabaseExampleTable

java.lang.Object
  edu.udo.cs.yale.example.AbstractExampleTable
      edu.udo.cs.yale.example.DatabaseExampleTable

All Implemented Interfaces:

ExampleTable

public class DatabaseExampleTable
extends AbstractExampleTable

This class is another data supplier for example sets. For performance reasons one should use a MemoryExampleTable if the data is small enough for the main memory. Additionally, directly working on databases is highly experimental and therefore usually not recommended.

Version:

$Id: DatabaseExampleTable.java,v 2.14 2006/03/27 13:21:58 ingomierswa Exp $

Author:

Ingo Mierswa

Field Summary

private DatabaseHandler	databaseHandler
private java.sql.ResultSet	resultSet
private int	size
private java.lang.String	tableName

Constructor Summary

private

DatabaseExampleTable(java.sql.ResultSet resultSet, java.util.List<Attribute> attributes, DatabaseHandler databaseHandler, java.lang.String tableName)

Method Summary

int	addAttribute(Attribute attribute) Adds the attribute to the list of attributes assigning it a free column index.
private void	close()
static DatabaseExampleTable	createDatabaseExampleTable(DatabaseHandler databaseHandler, java.lang.String tableName)
void	finalize()
DataRowReader	getDataReader() Returns an Iterator for example data given as DataRow objects.
DataRow	getDataRow(int index) Returns the data row with the desired row index.
int	getSize() Returns the number of examples.
void	removeAttribute(Attribute attribute) Equivalent to calling removeAttribute(attribute.getTableIndex()).
private void	resetResultSet()

Methods inherited from class edu.udo.cs.yale.example.AbstractExampleTable

addAttributes, createCompleteExampleSet, createCompleteExampleSet, createCompleteExampleSet, createExampleSet, findAttribute, getAttribute, getAttribute, getAttributeCount, getAttributes, getBlockEndIndex, getHighestBlockNr, getNextFreeBlockNr, getNumberOfAttributes, removeAttribute, toDataString, toString

Methods inherited from class java.lang.Object

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

Field Detail

resultSet

private java.sql.ResultSet resultSet

databaseHandler

private DatabaseHandler databaseHandler

tableName

private java.lang.String tableName

size

private int size

Constructor Detail

DatabaseExampleTable

private DatabaseExampleTable(java.sql.ResultSet resultSet,
                             java.util.List<Attribute> attributes,
                             DatabaseHandler databaseHandler,
                             java.lang.String tableName)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

createDatabaseExampleTable

public static DatabaseExampleTable createDatabaseExampleTable(DatabaseHandler databaseHandler,
                                                              java.lang.String tableName)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

resetResultSet

private void resetResultSet()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getDataReader

public DataRowReader getDataReader()

Description copied from class: AbstractExampleTable

Returns an Iterator for example data given as DataRow objects. This should be used in all cases where iteration is desired. Since AbstractExampleTable.getDataRow(int) does not ensure to work in an efficient way the usage of this method is preferred (instead using for-loops).

Specified by:

getDataReader in interface ExampleTable

Specified by:

getDataReader in class AbstractExampleTable

getDataRow

public DataRow getDataRow(int index)

Returns the data row with the desired row index.

Specified by:

getDataRow in interface ExampleTable

Specified by:

getDataRow in class AbstractExampleTable

addAttribute

public int addAttribute(Attribute attribute)

Description copied from class: AbstractExampleTable

Adds the attribute to the list of attributes assigning it a free column index.

Specified by:

addAttribute in interface ExampleTable

Overrides:

addAttribute in class AbstractExampleTable

removeAttribute

public void removeAttribute(Attribute attribute)

Description copied from class: AbstractExampleTable

Equivalent to calling removeAttribute(attribute.getTableIndex()).

Specified by:

removeAttribute in interface ExampleTable

Overrides:

removeAttribute in class AbstractExampleTable

getSize

public int getSize()

Description copied from class: AbstractExampleTable

Returns the number of examples.

Specified by:

getSize in interface ExampleTable

Specified by:

getSize in class AbstractExampleTable

close

private void close()

finalize

public void finalize()

Overrides:

finalize in class java.lang.Object