|
JMSLTM Numerical Library 4.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object com.imsl.io.AbstractFlatFile
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(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. |
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. |
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 |
Methods inherited from interface java.sql.ResultSet |
getBigDecimal, getBigDecimal, getUnicodeStream, getUnicodeStream |
Constructor Detail |
public AbstractFlatFile()
AbstractFlatFile
is abstract, it cannot be directly
instantiated.
Method Detail |
public boolean absolute(int row) throws SQLException
ResultSet
object.
absolute
in interface ResultSet
row
- an int
which specifies a row, of the
ResultSet
object, where the cursor is to be moved
boolean
whose value is true
if the
cursor is on the result set; false
otherwise
AbstractFlatFile.FlatFileSQLException
- is always thrown since only forward
operations are allowed
SQLException
public void afterLast() throws SQLException
ResultSet
object, just
after the last row. This method has no effect if the result set contains
no rows.
afterLast
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method has not
been implemented
SQLException
public void beforeFirst() throws SQLException
ResultSet
object,
just before the first row. This method has no effect if the result set
contains no rows.
beforeFirst
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since only forward
operations are allowed
SQLException
protected void beginGet()
get
Type
method. It closes any InputStreams
or Readers
created by get methods in this object. It also resets the
wasNull
flag to false
.
public void cancelRowUpdates() throws SQLException
ResultSet
object. Since updates are not allowed, this
method always throws an SQLException
.
cancelRowUpdates
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void clearWarnings() throws SQLException
ResultSet
object.
After this method is called, the method getWarnings
returns
null
until a new warning is reported for this
ResultSet
object.
clearWarnings
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public void close() throws SQLException
ResultSet
object's database and JDBC
resources immediately instead of waiting for this to happen when it is
automatically closed.
close
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public void deleteRow() throws SQLException
ResultSet
object and from
the underlying database. Since updates are not allowed, this method
always throws an SQLException
.
deleteRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
protected abstract byte[] doGetBytes(int columnIndex) throws SQLException
getBytes()
. The bytes represent the raw values
returned by the driver.
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
byte
array representation of the column value; if
the value is SQL null
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
protected abstract boolean doNext() throws SQLException
boolean
, true
if the new current row
is valid; false
if there are no more rows
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public int findColumn(String columnName) throws SQLException
ResultSet
column name to its
ResultSet
column index.
findColumn
in interface ResultSet
columnName
- a String
specifying the name of the
column
int
specifying the column index of the given
column name
AbstractFlatFile.FlatFileSQLException
- if the ResultSet
object does
not contain columnName
or a database access
error occurs
SQLException
protected String findColumnName(int columnIndex) throws SQLException
columnIndex
- an int
specifying the index of a column
for which the name is to be found
String
containing the name of the column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean first() throws SQLException
ResultSet
object.
first
in interface ResultSet
boolean
whose value is true
if the
cursor is on the result set; false
otherwise
AbstractFlatFile.FlatFileSQLException
- is always thrown since only forward
operations are allowed
SQLException
public Array getArray(int columnIndex) throws SQLException
ResultSet
object as an Array
object in the
Java programming language.
getArray
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
Array
object representing an SQL
Array
value in the specified column
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method is not
implemented
SQLException
public Array getArray(String columnName) throws SQLException
ResultSet
object as an Array
object in the
Java programming language.
getArray
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
Array
object representing the SQL
ARRAY
value in the specified column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public InputStream getAsciiStream(int columnIndex) throws SQLException
ResultSet
object as a stream of ASCII characters. The value
can then be read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values. The JDBC
driver will do any necessary conversion from the database format into
ASCII.
Note: All the data in the returned stream must be read prior
to getting the value of any other column. The next call to a
get
Type method implicitly closes the stream. Also, a stream
may return 0
when the method
InputStream.available
is called whether there is data
available or not.
getAsciiStream
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.io.InputStream
that delivers the database
column value as a stream of one-byte ASCII characters; if the
value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public InputStream getAsciiStream(String columnName) throws SQLException
ResultSet
object as a stream of ASCII characters. The value
can then be read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values. The JDBC
driver will do any necessary conversion from the database format into
ASCII.
Note: All the data in the returned stream must be read prior
to getting the value of any other column. The next call to a
get
Type method implicitly closes the stream. Also, a stream
may return 0
when the method available
is
called whether there is data available or not.
getAsciiStream
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.io.InputStream
that delivers the database
column value as a stream of one-byte ASCII characters. If the
value is SQL NULL
, the value returned is
null
.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
ResultSet
object as a java.math.BigDecimal
with full precision.
getBigDecimal
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.math.BigDecimal
object that contains the
column value; if the value is SQL NULL
, the value
returned is null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public BigDecimal getBigDecimal(String columnName) throws SQLException
ResultSet
object as a java.math.BigDecimal
with full precision.
getBigDecimal
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.math.BigDecimal
object that contains the
column value; if the value is SQL NULL
, the value
returned is null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public InputStream getBinaryStream(int columnIndex) throws SQLException
ResultSet
object as a binary stream of uninterpreted bytes.
The value can then be read in chunks from the stream. This method is
particularly suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior
to getting the value of any other column. The next call to a
get
Type method implicitly closes the stream. Also, a stream
may return 0
when the method
InputStream.available
is called whether there is data
available or not.
getBinaryStream
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.io.InputStream
that delivers the database
column value as a stream of uninterpreted bytes; if the value is
SQL NULL
, the value returned is null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public InputStream getBinaryStream(String columnName) throws SQLException
ResultSet
object as a stream of uninterpreted
byte
s. The value can then be read in chunks from the
stream. This method is particularly suitable for retrieving large
LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior
to getting the value of any other column. The next call to a
get
Type method implicitly closes the stream. Also, a stream
may return 0
when the method available
is
called whether there is data available or not.
getBinaryStream
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.io.InputStream
that delivers the database
column value as a stream of uninterpreted bytes; if the value is
SQL NULL
, the result is null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Blob getBlob(int columnIndex) throws SQLException
ResultSet
object as a Blob
object in the Java
programming language.
getBlob
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
Blob
object representing the SQL
BLOB
value in the specified column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Blob getBlob(String columnName) throws SQLException
ResultSet
object as a Blob
object in the Java
programming language.
getBlob
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
Blob
object representing the SQL
BLOB
value in the specified column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean getBoolean(int columnIndex) throws SQLException
ResultSet
object as a boolean
in the Java
programming language.
getBoolean
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
boolean
representation of the column value; if
the value is SQL NULL
, the value returned is
false
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public boolean getBoolean(String columnName) throws SQLException
ResultSet
object as a boolean
in the Java
programming language.
getBoolean
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
boolean
representation of the column value; if
the value is SQL NULL
, the value returned is
false
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public byte getByte(int columnIndex) throws SQLException
ResultSet
object as a byte
in the Java
programming language.
getByte
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
byte
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public byte getByte(String columnName) throws SQLException
ResultSet
object as a byte
in the Java
programming language.
getByte
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
byte
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public byte[] getBytes(int columnIndex) throws SQLException
ResultSet
object as a byte
array in the Java
programming language. The bytes represent the raw values returned by the
driver.
getBytes
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
byte
array representation of the column value; if
the value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public byte[] getBytes(String columnName) throws SQLException
ResultSet
object as a byte
array in the Java
programming language. The bytes represent the raw values returned by the
driver.
getBytes
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
byte
array representation of the column value; if
the value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Reader getCharacterStream(int columnIndex) throws SQLException
ResultSet
object as a java.io.Reader
object.
getCharacterStream
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned
is null
in the Java programming language.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Reader getCharacterStream(String columnName) throws SQLException
ResultSet
object as a java.io.Reader
object.
getCharacterStream
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned
is null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Clob getClob(int columnIndex) throws SQLException
ResultSet
object as a Clob
object in the Java
programming language.
getClob
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
Clob
object representing an SQL Clob
value in the specified column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Clob getClob(String columnName) throws SQLException
ResultSet
object as a Clob
object in the Java
programming language.
getClob
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
Clob
object representing the SQL
CLOB
value in the specified column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Class getColumnClass(int columnIndex) throws SQLException
getColumnClass
. If no class type is set the default
implementation returns Object.class
.
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
Class
object used to specify the class of the
data in the column
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
setColumnClass(int,Class)
public abstract int getColumnCount() throws SQLException
ResultSet
object.
int
which specifies the number of columns
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public int getConcurrency() throws SQLException
ResultSet
object.
getConcurrency
in interface ResultSet
int
which specifies whether concurrency is read
only or for update processes as well. Always returns
CONCUR_READ_ONLY
.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public String getCursorName() throws SQLException
ResultSet
object. The default implementation throws a SQLException.
getCursorName
in interface ResultSet
String
which specifies the SQL name for this
ResultSet
object's cursor.
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public Date getDate(int columnIndex) throws SQLException
ResultSet
object as a java.sql.Date
object in
the Java programming language.
getDate
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.sql.Date
representation of the column value;
if the value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public Date getDate(int columnIndex, Calendar cal) throws SQLException
ResultSet
object as a java.sql.Date
object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the date if the
underlying database does not store timezone information.
getDate
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...cal
- the java.util.Calendar
object to use in
constructing the date
java.sql.Date
object; if the
value is SQL NULL
, the value returned is
null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Date getDate(String columnName) throws SQLException
ResultSet
object as a java.sql.Date
object in
the Java programming language.
getDate
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.sql.Date
representation of the column value;
if the value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Date getDate(String columnName, Calendar cal) throws SQLException
ResultSet
object as a java.sql.Date
object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the date if the
underlying database does not store timezone information.
getDate
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columncal
- the java.util.Calendar
object to use in
constructing the date
java.sql.Date
object; if the
value is SQL NULL
, the value returned is
null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public double getDouble(int columnIndex) throws SQLException
ResultSet
object as a double
in the Java
programming language.
getDouble
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
double
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public double getDouble(String columnName) throws SQLException
ResultSet
object as a double
in the Java
programming language.
getDouble
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
double
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public int getFetchDirection() throws SQLException
ResultSet
object.
getFetchDirection
in interface ResultSet
int
which specifies the current fetch direction
for this ResultSet
object. Always returns
FETCH_FORWARD
.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public int getFetchSize() throws SQLException
ResultSet
object.
getFetchSize
in interface ResultSet
int
which specifies the current fetch size for
this ResultSet
object
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public float getFloat(int columnIndex) throws SQLException
ResultSet
object as a float
in the Java
programming language.
getFloat
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
float
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public float getFloat(String columnName) throws SQLException
ResultSet
object as a float
in the Java
programming language.
getFloat
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
float
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public int getInt(int columnIndex) throws SQLException
ResultSet
object as an int
in the Java
programming language.
getInt
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
int
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public int getInt(String columnName) throws SQLException
ResultSet
object as an int
in the Java
programming language.
getInt
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
int
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public long getLong(int columnIndex) throws SQLException
ResultSet
object as a long
in the Java
programming language.
getLong
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
long
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public long getLong(String columnName) throws SQLException
ResultSet
object as a long
in the Java
programming language.
getLong
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
long
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public ResultSetMetaData getMetaData() throws SQLException
ResultSet
object's columns.
getMetaData
in interface ResultSet
ResultSetMetaData
which provides a description of
this ResultSet
object's columns
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public abstract Object getObject(int columnIndex) throws SQLException
Gets the value of the designated column in the current row of this
ResultSet
object as an Object
in the Java
programming language.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
getObject
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.lang.Object
representation of the column
value
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Object getObject(int columnIndex, Map map) throws SQLException
ResultSet
object as an Object
in the Java
programming language. This method uses the given Map
object
for the custom mapping of the SQL structured or distinct type that is
being retrieved.
getObject
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...map
- a java.util.Map
object that contains the
mapping from SQL type names to classes in the Java
programming language
Object
in the Java programming language
representing the SQL value
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method has not
been implimented
SQLException
public Object getObject(String columnName) throws SQLException
Gets the value of the designated column in the current row of this
ResultSet
object as an Object
in the Java
programming language.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
This method may also be used to read datatabase-specific abstract
data types. In the JDBC 2.0 API, the behavior of the method
getObject
is extended to materialize data of SQL
user-defined types. When a column contains a structured or distinct
value, the behavior of this method is as if it were a call to:
getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.lang.Object
representation of the column
value
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Object getObject(String columnName, Map map) throws SQLException
ResultSet
object as an Object
in the Java
programming language. This method uses the specified Map
object for custom mapping if appropriate.
getObject
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnmap
- a java.util.Map
object that contains the
mapping from SQL type names to classes in the Java
programming language
Object
representing the SQL value in the
specified column
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method is not
implemented
SQLException
public Ref getRef(int columnIndex) throws SQLException
ResultSet
object as a Ref
object in the Java
programming language.
getRef
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
Ref
object representing the SQL REF
value in the specified column
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method has not
been implimented
SQLException
public Ref getRef(String columnName) throws SQLException
ResultSet
object as a Ref
object in the Java
programming language.
getRef
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
Ref
object representing the SQL REF
value in the specified column
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method is not
implemented
SQLException
public int getRow() throws SQLException
getRow
in interface ResultSet
int
which specifies the current row number;
0
if there is no current row
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public short getShort(int columnIndex) throws SQLException
ResultSet
object as a short
in the Java
programming language.
getShort
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
short
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public short getShort(String columnName) throws SQLException
ResultSet
object as a short
in the Java
programming language.
getShort
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
short
representation of the column value; if the
value is SQL NULL
, the value returned is
0
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Statement getStatement() throws SQLException
Statement
object that produced this
ResultSet
object. Since there is not statement, this method
always throws an SQLException
.
getStatement
in interface ResultSet
Statment
object that produced this
ResultSet
object or null
if the result
set was produced some other way
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public String getString(int columnIndex) throws SQLException
ResultSet
object as a String
in the Java
programming language.
getString
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
String
representation of the column value; if the
value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public String getString(String columnName) throws SQLException
ResultSet
object as a String
in the Java
programming language.
getString
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
String
representation of the column value; if the
value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Time getTime(int columnIndex) throws SQLException
ResultSet
object as a java.sql.Time
object in
the Java programming language.
getTime
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.sql.Time
representation of the column value;
if the value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public Time getTime(int columnIndex, Calendar cal) throws SQLException
ResultSet
object as a java.sql.Time
object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the time if the
underlying database does not store timezone information.
getTime
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...cal
- the java.util.Calendar
object to use in
constructing the time
java.sql.Time
object; if the
value is SQL NULL
, the value returned is
null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Time getTime(String columnName) throws SQLException
ResultSet
object as a java.sql.Time
object in
the Java programming language.
getTime
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.sql.Time
representation of the column value;
if the value is SQL NULL
, the value returned is
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Time getTime(String columnName, Calendar cal) throws SQLException
ResultSet
object as a java.sql.Time
object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the time if the
underlying database does not store timezone information.
getTime
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columncal
- the java.util.Calendar
object to use in
constructing the time
java.sql.Time
object; if the
value is SQL NULL
, the value returned is
null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Timestamp getTimestamp(int columnIndex) throws SQLException
ResultSet
object as a java.sql.Timestamp
object in the Java programming language.
getTimestamp
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.sql.Timestamp
representation of the column
value; if the value is SQL NULL
, the value returned
is null
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
ResultSet
object as a java.sql.Timestamp
object in the Java programming language. This method uses the given
calendar to construct an appropriate millisecond value for the timestamp
if the underlying database does not store timezone information.
getTimestamp
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...cal
- the java.util.Calendar
object to use in
constructing the timestamp
java.sql.Timestamp
object; if
the value is SQL NULL
, the value returned is
null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Timestamp getTimestamp(String columnName) throws SQLException
ResultSet
object as a java.sql.Timestamp
object.
getTimestamp
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.sql.Timestamp
representation of the column
value; if the value is SQL NULL
, the value returned
is null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
ResultSet
object as a java.sql.Timestamp
object in the Java programming language. This method uses the given
calendar to construct an appropriate millisecond value for the timestamp
if the underlying database does not store timezone information.
getTimestamp
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columncal
- the java.util.Calendar
object to use in
constructing the timestamp
java.sql.Timestamp
object; if
the value is SQL NULL
, the value returned is
null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public int getType() throws SQLException
ResultSet
object. The type is
determined by the Statement
object hat created the result
set.
getType
in interface ResultSet
int
which specifies the type of this
ResultSet
object. Always returns
TYPE_FORWARD_ONLY
.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public URL getURL(int columnIndex) throws SQLException
ResultSet
object as a java.net.URL
object.
getURL
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
java.net.URL
object that contains the
column value; if the value is SQL NULL
, the value
returned is null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a conversion or database access error
occurs
SQLException
public URL getURL(String columnName) throws SQLException
ResultSet
object as a java.net.URL
object.
getURL
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
java.net.URL
object that contains the
column value; if the value is SQL NULL
, the value
returned is null
in the Java programming language
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public SQLWarning getWarnings() throws SQLException
ResultSet
object. Subsequent warnings on this
ResultSet
object will be chained to the
SQLWarning
object that this method returns.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by
ResultSet
methods. Any warning caused by
Statement
methods (such as reading OUT parameters) will be
chained on the Statement
object.
getWarnings
in interface ResultSet
SQLWarning
object reported or
null
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public void insertRow() throws SQLException
ResultSet
object and into the database. Since updates are not allowed, this
method always throws an SQLException
.
insertRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public boolean isAfterLast() throws SQLException
ResultSet
object.
isAfterLast
in interface ResultSet
boolean
whose value is true
if the
cursor is after the last row; false
if the cursor
is at any other position or the ResultSet
contains
no rows
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean isBeforeFirst() throws SQLException
ResultSet
object.
isBeforeFirst
in interface ResultSet
boolean
whose value is true
if the
cursor is before the first row; false
if the cursor
is at any other position or the ResultSet
contains
no rows
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean isFirst() throws SQLException
ResultSet
object.
isFirst
in interface ResultSet
boolean
whose value is true
if the
cursor is on the first row; false
otherwise
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean isLast() throws SQLException
ResultSet
object. Note: Calling the method
isLast
may be expensive because the JDBC driver might need
to fetch ahead one row in order to determine whether the current row is
the last row in the result set.
isLast
in interface ResultSet
boolean
whose value is true
if the
cursor is on the last row; false
otherwise
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean last() throws SQLException
ResultSet
object.
last
in interface ResultSet
boolean
whose value is true
if the
cursor is on the result set; false
otherwise
AbstractFlatFile.FlatFileSQLException
- is always thrown since this method has not
been implemented
SQLException
public void moveToCurrentRow() throws SQLException
SQLException
.
moveToCurrentRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void moveToInsertRow() throws SQLException
SQLException
.
moveToInsertRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public boolean next() throws SQLException
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.
next
in interface ResultSet
boolean
, true
if the new current row
is valid; false
if there are no more rows
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean previous() throws SQLException
ResultSet
object.
previous
in interface ResultSet
boolean
whose value is true
if the
cursor is on the result set; false
otherwise
AbstractFlatFile.FlatFileSQLException
- is always thrown since only forward
operations are allowed
SQLException
public void refreshRow() throws SQLException
SQLException
.
refreshRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public boolean relative(int rows) throws SQLException
relative
in interface ResultSet
rows
- an int
which specifies the number of rows
in the ResultSet
object to advance or
regress
boolean
whose value is true
if the
cursor is on the result set; false
otherwise
AbstractFlatFile.FlatFileSQLException
- is always thrown since only forward
operations are allowed
SQLException
public boolean rowDeleted() throws SQLException
false
.
rowDeleted
in interface ResultSet
boolean
which indicates whether a row has been
deleted. Always returns false
since updates are not
allowed.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean rowInserted() throws SQLException
false
.
rowInserted
in interface ResultSet
boolean
which indicates whether the current row
had an insertion. Always returns false
since
updates are not allowed.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
public boolean rowUpdated() throws SQLException
false
.
rowUpdated
in interface ResultSet
boolean
which indicates whether a row has been
updated. Always returns false
since updates are not
allowed.
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
protected void setColumnClass(int columnIndex, Class columnClass)
columnIndex
- an int
specifying the index of a columncolumnClass
- a Class
object used to specify the
class of the data in the columnprotected void setColumnName(int columnIndex, String columnName)
findColumn
and findColumnName
.
columnIndex
- an int
specifying the column index of
the column to be namedcolumnName
- a String
specifying the name of the
columnfindColumn(String)
,
findColumnName(int)
public void setFetchDirection(int direction) throws SQLException
ResultSet
object will be processed.
setFetchDirection
in interface ResultSet
direction
- an int
which specifies the expected
direction this ResultSet
object is to
be processed
AbstractFlatFile.FlatFileSQLException
- if the fetch direction is not
FETCH_FORWARD
SQLException
Statement.setFetchDirection(int)
public void setFetchSize(int rows) throws SQLException
ResultSet
object. If the fetch size specified is zero, the
JDBC driver ignores the value and is free to make its own best guess as
to what the fetch size should be. The default value is set by the
Statement
object that created the result set. The fetch
size may be changed at any time.
setFetchSize
in interface ResultSet
rows
- an int
which specifies the number of rows
to fetch
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs or the
condition 0 <= rows <=
this.getMaxRows()
is not satisfied
SQLException
protected void setWarning(SQLWarning warning)
SQLWarning
.
warning
- a SQLWarning
that is to be added to this
object.public void updateArray(int column, Array x) throws SQLException
Array
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateArray
in interface ResultSet
column
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Array
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateArray(String columnName, Array x) throws SQLException
Array
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateArray
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Array
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException
SQLException
.
updateAsciiStream
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a InputStream
which specifies the new column
valuelength
- an int
which specifies the stream length
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
SQLException
.
updateAsciiStream
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a InputStream
which specifies the new column
valuelength
- an int
which specifies the stream length
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException
java.math.BigDecimal
value. Since updates are not allowed, this method always throws an
SQLException
.
updateBigDecimal
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.math.BigDecimal
which specifies the new
column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
java.sql.BigDecimal
value. Since updates are not allowed, this method always throws an
SQLException
.
updateBigDecimal
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.BigDecimal
which specifies the new
column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException
SQLException
.
updateBinaryStream
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a InputStream
which specifies the new column
valuelength
- an int
which specifies the stream length
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
SQLException
.
updateBinaryStream
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a InputStream
which specifies the new column
valuelength
- an int
which specifies the stream length
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBlob(int column, Blob x) throws SQLException
java.sql.Blob
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateBlob
in interface ResultSet
column
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Blob
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBlob(String columnName, Blob x) throws SQLException
java.sql.Blob
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateBlob
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Blob
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBoolean(int columnIndex, boolean x) throws SQLException
boolean
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateBoolean
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a boolean
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBoolean(String columnName, boolean x) throws SQLException
boolean
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateBoolean
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a boolean
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateByte(int columnIndex, byte x) throws SQLException
byte
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateByte
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a byte
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateByte(String columnName, byte x) throws SQLException
byte
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateByte
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a byte
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBytes(int columnIndex, byte[] x) throws SQLException
byte
array value.
Since updates are not allowed, this method always throws an
SQLException
.
updateBytes
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a byte
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateBytes(String columnName, byte[] x) throws SQLException
byte
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateBytes
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a byte
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException
SQLException
.
updateCharacterStream
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a Reader
which specifies the new column valuelength
- an int
which specifies the stream length
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
SQLException
.
updateCharacterStream
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnreader
- a Reader
which specifies the new column valuelength
- an int
which specifies the stream length
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateClob(int column, Clob x) throws SQLException
java.sql.Clob
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateClob
in interface ResultSet
column
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Clob
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateClob(String columnName, Clob x) throws SQLException
java.sql.Clob
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateClob
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Clob
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateDate(int columnIndex, Date x) throws SQLException
java.sql.Date
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateDate
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Date
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateDate(String columnName, Date x) throws SQLException
java.sql.Date
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateDate
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Date
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateDouble(int columnIndex, double x) throws SQLException
double
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateDouble
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a double
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateDouble(String columnName, double x) throws SQLException
double
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateDouble
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a double
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateFloat(int columnIndex, float x) throws SQLException
float
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateFloat
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a float
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateFloat(String columnName, float x) throws SQLException
float
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateFloat
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a float
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateInt(int columnIndex, int x) throws SQLException
int
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateInt
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- an int
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateInt(String columnName, int x) throws SQLException
int
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateInt
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- an int
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateLong(int columnIndex, long x) throws SQLException
long
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateLong
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a long
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateLong(String columnName, long x) throws SQLException
long
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateLong
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a long
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateNull(int columnIndex) throws SQLException
null
value. Since updates are not
allowed, this method always throws an SQLException
.
updateNull
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateNull(String columnName) throws SQLException
null
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateNull
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the column
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateObject(int columnIndex, Object x) throws SQLException
Object
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateObject
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- an Object
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateObject(int columnIndex, Object x, int scale) throws SQLException
Object
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateObject
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- an Object
which specifies the new column
valuescale
- for java.sql.Types.DECIMAL
or
java.sql.Types.NUMERIC
types, this is the
number of digits after the decimal point. For all other
types this value will be ignored.
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateObject(String columnName, Object x) throws SQLException
Object
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateObject
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Object
which specifies the new
column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateObject(String columnName, Object x, int scale) throws SQLException
Object
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateObject
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- an Object
which specifies the new column valuescale
- for java.sql.Types.DECIMAL
or
java.sql.Types.NUMERIC
types, this is the
number of digits after the decimal point. For all other
types this value will be ignored.
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateRef(int column, Ref x) throws SQLException
java.sql.Ref
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateRef
in interface ResultSet
column
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Ref
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateRef(String columnName, Ref x) throws SQLException
java.sql.Ref
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateRef
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Ref
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateRow() throws SQLException
ResultSet
object. Since updates are not allowed,
this method always throws an SQLException
.
updateRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateShort(int columnIndex, short x) throws SQLException
short
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateShort
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a short
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateShort(String columnName, short x) throws SQLException
short
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateShort
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a short
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateString(int columnIndex, String x) throws SQLException
String
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateString
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a String
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateString(String columnName, String x) throws SQLException
String
value. Since
updates are not allowed, this method always throws an
SQLException
.
updateString
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a String
which specifies the new column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateTime(int columnIndex, Time x) throws SQLException
java.sql.Time
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateTime
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Time
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateTime(String columnName, Time x) throws SQLException
java.sql.Time
value.
Since updates are not allowed, this method always throws an
SQLException
.
updateTime
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Time
which specifies the new column
value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
java.sql.Timestamp
value. Since updates are not allowed, this method always throws an
SQLException
.
updateTimestamp
in interface ResultSet
columnIndex
- an int
which specifies the column. The
first column is 1, the second is 2, ...x
- a java.sql.Timestamp
which specifies the new
column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public void updateTimestamp(String columnName, Timestamp x) throws SQLException
java.sql.Timestamp
value. Since updates are not allowed, this method always throws an
SQLException
.
updateTimestamp
in interface ResultSet
columnName
- a String
which specifies the SQL name
of the columnx
- a java.sql.Timestamp
which specifies the new
column value
AbstractFlatFile.FlatFileSQLException
- is always thrown since updates are not
allowed
SQLException
public boolean wasNull() throws SQLException
NULL
. Note that you must first call one of the
get
Type 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
.
wasNull
in interface ResultSet
boolean
, true
if the last column
value read was SQL NULL
and false
otherwise
AbstractFlatFile.FlatFileSQLException
- if a database access error occurs
SQLException
|
JMSLTM Numerical Library 4.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |