repicea.io.javasql

Class SQLReader

java.lang.Object

repicea.io.FormatReader<SQLHeader>

repicea.io.javasql.SQLReader

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable

public class SQLReader
extends FormatReader<SQLHeader>

The SQLReader class makes it possible to read tables in Microsoft Access databases (*.mdb, *.accdb).

Constructor Summary

Constructors

Constructor and Description
SQLReader(java.lang.String dataBaseUrl, java.lang.String table) General constructor.

Method Summary

Modifier and Type	Method and Description
void	close()
int	getRowIndex() Returns the row index at which the reader is.
java.lang.Object[]	nextRecord(int skipThisNumberOfLines) This method skips some lines and then reads a record in the file;

Methods inherited from class repicea.io.FormatReader

createFormatReader, getField, getFieldCount, getFilename, getHeader, getRecordCount, isSystemResource, nextRecord, openStream, setFormatHeader

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLReader

public SQLReader(java.lang.String dataBaseUrl,
                 java.lang.String table)
          throws java.io.IOException

General constructor.

Parameters:

dataBaseUrl - the database URL

table - the table to be read

Throws:

java.io.IOException

Method Detail

close

public void close()
           throws java.io.IOException

Throws:

java.io.IOException

nextRecord

public java.lang.Object[] nextRecord(int skipThisNumberOfLines)
                              throws java.io.IOException

Description copied from class: FormatReader

This method skips some lines and then reads a record in the file;

Specified by:

nextRecord in class FormatReader<SQLHeader>

Parameters:

skipThisNumberOfLines - the number of lines to skip before reading the observation

Returns:

an Array of Object instances

Throws:

java.io.IOException

getRowIndex

public int getRowIndex()

Returns the row index at which the reader is. The indices starts from 1.

Returns:

an integer