Methods' Summary |
wasNull |
reports whether the last column read had a value of SQL NULL.
Note that you must first call getXXX on a column to try to read
its value and then call
wasNull()
to see if the value read was SQL NULL.
|
getString |
gets the value of a column in the current row as a String.
|
getBoolean |
gets the value of a column in the current row as boolean.
|
getByte |
gets the value of a column in the current row as a byte.
|
getShort |
gets the value of a column in the current row as a short.
|
getInt |
gets the value of a column in the current row as a long.
|
getLong |
gets the value of a column in the current row as a hyper.
|
getFloat |
gets the value of a column in the current row as a float.
|
getDouble |
gets the value of a column in the current row as a double.
|
getBytes |
gets the value of a column in the current row as a byte array.
The bytes represent the raw values returned by the driver.
|
getDate |
gets the value of a column in the current row as a date object.
|
getTime |
gets the value of a column in the current row as a time object.
|
getTimestamp |
gets the value of a column in the current row as a datetime object.
|
getBinaryStream |
gets the value of a column in the current row as a stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly suitable for retrieving large
LONGVARBINARY or LONGVARCHAR values.
|
getCharacterStream |
gets the value of a column in the current row as a stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly suitable for retrieving large
LONGVARCHAR values.
|
getObject |
|
getRef |
gets a REF(<structured-type>) column value from the current row.
|
getBlob |
gets a BLOB (Binary Large OBject) value in the current row.
|
getClob |
gets a CLOB value in the current row of this ResultSet object.
|
getArray |
gets a SQL ARRAY value from the current row.
|
Methods' Details |
wasNull
- Description
- reports whether the last column read had a value of SQL NULL.
Note that you must first call getXXX on a column to try to read
its value and then call
wasNull()
to see if the value read was SQL NULL.
- Returns
- true if so
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getString
- Description
- gets the value of a column in the current row as a String.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getBoolean
- Description
- gets the value of a column in the current row as boolean.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getByte
- Description
- gets the value of a column in the current row as a byte.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getShort
- Description
- gets the value of a column in the current row as a short.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getInt
- Description
- gets the value of a column in the current row as a long.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getLong
- Description
- gets the value of a column in the current row as a hyper.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getFloat
- Description
- gets the value of a column in the current row as a float.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getDouble
- Description
- gets the value of a column in the current row as a double.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getBytes
- Description
- gets the value of a column in the current row as a byte array.
The bytes represent the raw values returned by the driver.
- Returns
- the column value;
if the value is SQL NULL, the result is empty.
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getDate
- Description
- gets the value of a column in the current row as a date object.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getTime
- Description
- gets the value of a column in the current row as a time object.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getTimestamp
- Description
- gets the value of a column in the current row as a datetime object.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getBinaryStream
- Description
- gets the value of a column in the current row as a stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly suitable for retrieving large
LONGVARBINARY or LONGVARCHAR 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 method implicitly closes the stream. Also, a
stream may return 0 when the method
::com::sun::star::io::XInputStream::available()
is called whether there is data available or not.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getCharacterStream
- Description
- gets the value of a column in the current row as a stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly suitable for retrieving large
LONGVARCHAR 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 method implicitly closes the stream. Also, a
stream may return 0 when the method
::com::sun::star::io::XInputStream::available()
is called whether there is data available or not.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getObject
- Returns
- the value of a column in the current row as an object.
This method uses the given
Map
object
for the custom mapping of the SQL structure or distinct type
that is being retrieved.
- Parameter typeMap
- the type map is used to fetch the correct type
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getRef
- Description
- gets a REF(<structured-type>) column value from the current row.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getBlob
- Description
- gets a BLOB (Binary Large OBject) value in the current row.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getClob
- Description
- gets a CLOB value in the current row of this
ResultSet object.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
getArray
- Description
- gets a SQL ARRAY value from the current row.
- Returns
- the column value
- Throws
- com::sun::star::sdbc::SQLException
if a database access error occurs.
|
|
Copyright © 2000, 2014 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.