AbstractFlatFile (JMSL Numerical Library)

Overview

Package

Class

Tree

Deprecated

Index

Help

JMSL^TM Numerical Library 3.0

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.imsl.io
Class AbstractFlatFile

java.lang.Object
  com.imsl.io.AbstractFlatFile

All Implemented Interfaces:: ResultSet

Direct Known Subclasses:: FlatFile

public abstract class AbstractFlatFile
extends Object
implements ResultSet

Reads a text or binary file as a ResultSet.

In Java, the result of a database query is normally returned as a ResultSet object. This class is intended to support reading of text or binary flat files and returning them as a ResultSet.

A flat file is a rectangular data set where each row is an observation and each column is a variable. The data type in any one column is the same for all of the rows.

Nested Class Summary
`protected static class`	`AbstractFlatFile.FlatFileSQLException` A SQLException thrown by the AbstractFlatFile class.

Field Summary

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary
`AbstractFlatFile()` Initializes an AbstractFlatFile.

Method Summary
`boolean`	`absolute(int row)` Moves the cursor to the given row number in this `ResultSet` object.
`void`	`afterLast()` Moves the cursor to the end of this `ResultSet` object, just after the last row.
`void`	`beforeFirst()` Moves the cursor to the front of this `ResultSet` object, just before the first row.
`protected void`	`beginGet()` This method should be called at the start of every `get`Type method.
`void`	`cancelRowUpdates()` Cancels the updates made to the current row in this `ResultSet` object.
`void`	`clearWarnings()` Clears all warnings reported on this `ResultSet` object.
`void`	`close()` Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
`void`	`deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`protected abstract byte[]`	`doGetBytes(int columnIndex)` Implements the actual `getBytes()`.
`protected abstract boolean`	`doNext()` Implements the operations on the file required by the method next().
`int`	`findColumn(String columnName)` Maps the given `ResultSet` column name to its `ResultSet` column index.
`protected String`	`findColumnName(int columnIndex)` Maps the given columnIndex into its column name.
`boolean`	`first()` Moves the cursor to the first row in this `ResultSet` object.
`Array`	`getArray(int columnIndex)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`Array`	`getArray(String columnName)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`InputStream`	`getAsciiStream(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`InputStream`	`getAsciiStream(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`BigDecimal`	`getBigDecimal(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`BigDecimal`	`getBigDecimal(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`BigDecimal`	`getBigDecimal(String columnName, int scale)` Deprecated.
`InputStream`	`getBinaryStream(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a binary stream of uninterpreted bytes.
`InputStream`	`getBinaryStream(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
`Blob`	`getBlob(int columnIndex)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`Blob`	`getBlob(String columnName)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`boolean`	`getBoolean(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`boolean`	`getBoolean(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`byte`	`getByte(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`byte`	`getByte(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`byte[]`	`getBytes(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`byte[]`	`getBytes(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`Reader`	`getCharacterStream(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Reader`	`getCharacterStream(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Clob`	`getClob(int columnIndex)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`Clob`	`getClob(String columnName)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`Class`	`getColumnClass(int columnIndex)` Returns the class of the items in the specified column.
`abstract int`	`getColumnCount()` Returns the number of columns in this `ResultSet` object.
`int`	`getConcurrency()` Returns the concurrency mode of this `ResultSet` object.
`String`	`getCursorName()` Gets the name of the SQL cursor used by this `ResultSet` object.
`Date`	`getDate(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date`	`getDate(int columnIndex, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date`	`getDate(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`Date`	`getDate(String columnName, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`double`	`getDouble(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`double`	`getDouble(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`int`	`getFetchDirection()` Returns the fetch direction for this `ResultSet` object.
`int`	`getFetchSize()` Returns the fetch size for this `ResultSet` object.
`float`	`getFloat(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`float`	`getFloat(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`int`	`getInt(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`int`	`getInt(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`long`	`getLong(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`long`	`getLong(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`ResultSetMetaData`	`getMetaData()` Retrieves the number, types and properties of this `ResultSet` object's columns.
`abstract Object`	`getObject(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object`	`getObject(int columnIndex, Map map)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object`	`getObject(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Object`	`getObject(String columnName, Map map)` Returns the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`Ref`	`getRef(int columnIndex)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`Ref`	`getRef(String columnName)` Returns the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`int`	`getRow()` Retrieves the current row number.
`short`	`getShort(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`short`	`getShort(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`Statement`	`getStatement()` Returns the `Statement` object that produced this `ResultSet` object.
`String`	`getString(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getString(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`Time`	`getTime(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time`	`getTime(int columnIndex, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time`	`getTime(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Time`	`getTime(String columnName, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`Timestamp`	`getTimestamp(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`Timestamp`	`getTimestamp(String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object.
`Timestamp`	`getTimestamp(String columnName, Calendar cal)` Returns the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`int`	`getType()` Returns the type of this `ResultSet` object.
`InputStream`	`getUnicodeStream(int columnIndex)` Deprecated. use `getCharacterStream` in place of `getUnicodeStream`
`InputStream`	`getUnicodeStream(String columnName)` Deprecated.
`URL`	`getURL(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object.
`URL`	`getURL(String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object.
`SQLWarning`	`getWarnings()` Returns the first warning reported by calls on this `ResultSet` object.
`void`	`insertRow()` Inserts the contents of the insert row into this `ResultSet` object and into the database.
`boolean`	`isAfterLast()` Indicates whether the cursor is after the last row in this `ResultSet` object.
`boolean`	`isBeforeFirst()` Indicates whether the cursor is before the first row in this `ResultSet` object.
`boolean`	`isFirst()` Indicates whether the cursor is on the first row of this `ResultSet` object.
`boolean`	`isLast()` Indicates whether the cursor is on the last row of this `ResultSet` object.
`boolean`	`last()` Moves the cursor to the last row in this `ResultSet` object.
`void`	`moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()` Moves the cursor to the insert row.
`boolean`	`next()` Moves the cursor down one row from its current position.
`boolean`	`previous()` Moves the cursor to the previous row in this `ResultSet` object.
`void`	`refreshRow()` Refreshes the current row with its most recent value in the database.
`boolean`	`relative(int rows)` Moves the cursor a relative number of rows, either positive or negative.
`boolean`	`rowDeleted()` Indicates whether a row has been deleted.
`boolean`	`rowInserted()` Indicates whether the current row has had an insertion.
`boolean`	`rowUpdated()` Indicates whether the current row has been updated.
`protected void`	`setColumnClass(int columnIndex, Class columnClass)` Sets a column class.
`protected void`	`setColumnName(int columnIndex, String columnName)` Sets a column name.
`void`	`setFetchDirection(int direction)` Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
`void`	`setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this `ResultSet` object.
`protected void`	`setWarning(SQLWarning warning)` Sets a `SQLWarning`.
`void`	`updateArray(int column, Array x)` Updates the designated column with an `Array` value.
`void`	`updateArray(String columnName, Array x)` Updates the designated column with an `Array` value.
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(String columnName, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void`	`updateBigDecimal(String columnName, BigDecimal x)` Updates the designated column with a `java.sql.BigDecimal` value.
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(String columnName, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBlob(int column, Blob x)` Updates the designated column with an `java.sql.Blob` value.
`void`	`updateBlob(String columnName, Blob x)` Updates the designated column with an `java.sql.Blob` value.
`void`	`updateBoolean(int columnIndex, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(String columnName, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateByte(int columnIndex, byte x)` Updates the designated column with a `byte` value.
`void`	`updateByte(String columnName, byte x)` Updates the designated column with a `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)` Updates the designated column with a `byte` array value.
`void`	`updateBytes(String columnName, byte[] x)` Updates the designated column with a `byte` value.
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(String columnName, Reader reader, int length)` Updates the designated column with a character stream value.
`void`	`updateClob(int column, Clob x)` Updates the designated column with an `java.sql.Clob` value.
`void`	`updateClob(String columnName, Clob x)` Updates the designated column with an `java.sql.Clob` value.
`void`	`updateDate(int columnIndex, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(String columnName, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDouble(int columnIndex, double x)` Updates the designated column with a `double` value.
`void`	`updateDouble(String columnName, double x)` Updates the designated column with a `double` value.
`void`	`updateFloat(int columnIndex, float x)` Updates the designated column with a `float` value.
`void`	`updateFloat(String columnName, float x)` Updates the designated column with a `float` value.
`void`	`updateInt(int columnIndex, int x)` Updates the designated column with an `int` value.
`void`	`updateInt(String columnName, int x)` Updates the designated column with an `int` value.
`void`	`updateLong(int columnIndex, long x)` Updates the designated column with a `long` value.
`void`	`updateLong(String columnName, long x)` Updates the designated column with a `long` value.
`void`	`updateNull(int columnIndex)` Gives a nullable column a `null` value.
`void`	`updateNull(String columnName)` Updates the designated column with a `null` value.
`void`	`updateObject(int columnIndex, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(int columnIndex, Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnName, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnName, Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateRef(int column, Ref x)` Updates the designated column with an `java.sql.Ref` value.
`void`	`updateRef(String columnName, Ref x)` Updates the designated column with an `java.sql.Ref` value.
`void`	`updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`	`updateShort(int columnIndex, short x)` Updates the designated column with a `short` value.
`void`	`updateShort(String columnName, short x)` Updates the designated column with a `short` value.
`void`	`updateString(int columnIndex, String x)` Updates the designated column with a `String` value.
`void`	`updateString(String columnName, String x)` Updates the designated column with a `String` value.
`void`	`updateTime(int columnIndex, Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTime(String columnName, Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTimestamp(int columnIndex, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(String columnName, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`boolean`	`wasNull()` Reports whether the last column read had a value of SQL `NULL`.

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractFlatFile

public AbstractFlatFile()

Initializes an AbstractFlatFile. Since AbstractFlatFile is abstract, it cannot be directly instantiated.

Method Detail

setColumnName

protected void setColumnName(int columnIndex,
                             String columnName)

Sets a column name. A subclass can define its own mechanism for naming columns. An alternate mechanism would require overriding the methods findColumn and findColumnName.

Parameters:: columnIndex - an int specifying the column index of the column to be named; columnName - a String specifying the name of the column
See Also:: findColumn(String), findColumnName(int)

setColumnClass

protected void setColumnClass(int columnIndex,
                              Class columnClass)

Sets a column class.

Parameters:: columnIndex - an int specifying the index of a column; columnClass - a Class object used to specify the class of the data in the column

findColumn

public int findColumn(String columnName)
               throws SQLException

Maps the given ResultSet column name to its ResultSet column index.

Specified by:: findColumn in interface ResultSet

Parameters:: columnName - a String specifying the name of the column
Returns:: an int specifying the column index of the given column name
Throws:: AbstractFlatFile.FlatFileSQLException - if the ResultSet object does not contain columnName or a database access error occurs; SQLException

findColumnName

protected String findColumnName(int columnIndex)
                         throws SQLException

Maps the given columnIndex into its column name.

Parameters:: columnIndex - an int specifying the index of a column for which the name is to be found
Returns:: a String containing the name of the column
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

beginGet

protected void beginGet()

This method should be called at the start of every getType method. It closes any InputStreams or Readers created by get methods in this object. It also resets the wasNull flag to false.

public boolean next()
             throws SQLException

Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Specified by:: next in interface ResultSet

Returns:: a boolean, true if the new current row is valid; false if there are no more rows
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

doNext

protected abstract boolean doNext()
                           throws SQLException

Implements the operations on the file required by the method next().

Returns:: a boolean, true if the new current row is valid; false if there are no more rows
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

getColumnCount

public abstract int getColumnCount()
                            throws SQLException

Returns the number of columns in this ResultSet object.

Returns:: an int which specifies the number of columns
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

close

public void close()
           throws SQLException

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

Specified by:: close in interface ResultSet

Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

getColumnClass

public Class getColumnClass(int columnIndex)
                     throws SQLException

Returns the class of the items in the specified column. The default implementation returns the Class set using getColumnClass. If no class type is set the default implementation returns Object.class.

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a Class object used to specify the class of the data in the column
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException
See Also:: setColumnClass(int,Class)

wasNull

public boolean wasNull()
                throws SQLException

Reports whether the last column read had a value of SQL NULL. Note that you must first call one of the getType methods on a column to try to read its value and then call the method wasNull to see if the value read was SQL NULL.

Specified by:: wasNull in interface ResultSet

Returns:: a boolean, true if the last column value read was SQL NULL and false otherwise
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

getString

public String getString(int columnIndex)
                 throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Specified by:: getString in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a String representation of the column value; if the value is SQL NULL, the value returned is null
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

getBoolean

public boolean getBoolean(int columnIndex)
                   throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

Specified by:: getBoolean in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a boolean representation of the column value; if the value is SQL NULL, the value returned is false
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getByte

public byte getByte(int columnIndex)
             throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

Specified by:: getByte in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a byte representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getShort

public short getShort(int columnIndex)
               throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

Specified by:: getShort in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a short representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getInt

public int getInt(int columnIndex)
           throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Specified by:: getInt in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: an int representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getLong

public long getLong(int columnIndex)
             throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Specified by:: getLong in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a long representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getFloat

public float getFloat(int columnIndex)
               throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

Specified by:: getFloat in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a float representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getDouble

public double getDouble(int columnIndex)
                 throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Specified by:: getDouble in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a double representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
                         throws SQLException

Deprecated.

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.

Specified by:: getBigDecimal in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...; scale - an int which specifies the number of digits to the right of the decimal point
Returns:: a java.sql.BigDecimal representation of the column value; if the value is SQL NULL, the value returned is null
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

getBytes

public byte[] getBytes(int columnIndex)
                throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.

Specified by:: getBytes in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a byte array representation of the column value; if the value is SQL NULL, the value returned is null
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

doGetBytes

protected abstract byte[] doGetBytes(int columnIndex)
                              throws SQLException

Implements the actual getBytes(). The bytes represent the raw values returned by the driver.

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a byte array representation of the column value; if the value is SQL null, the value returned is null
Throws:: AbstractFlatFile.FlatFileSQLException - if a database access error occurs; SQLException

getDate

public Date getDate(int columnIndex)
             throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Specified by:: getDate in interface ResultSet

Parameters:: columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:: a java.sql.Date representation of the column value; if the value is SQL NULL, the value returned is null
Throws:: AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs; SQLException

getTime

public Time getTime(int columnIndex)
             throws SQLException

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Specified by:: getTime

com.imsl.io Class AbstractFlatFile