org.postgresql.jdbc
public class PgResultSet extends Object implements ResultSet, PGRefCursorResultSet
| Modifier and Type | Class and Description |
|---|---|
class |
PgResultSet.CursorResultHandler |
| Modifier and Type | Field and Description |
|---|---|
protected BaseConnection |
connection |
protected int |
currentRow |
protected ResultCursor |
cursor |
protected int |
fetchSize |
protected Field[] |
fields |
protected int |
maxFieldSize |
protected int |
maxRows |
protected boolean |
onInsertRow |
protected Query |
originalQuery |
protected int |
rowOffset |
protected List<byte[][]> |
rows |
protected BaseStatement |
statement |
protected byte[][] |
thisRow |
protected SQLWarning |
warnings |
protected boolean |
wasNullFlag
True if the last obtained column value was SQL NULL as specified by
wasNull(). |
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| Modifier and Type | Method and Description |
|---|---|
boolean |
absolute(int index) |
protected void |
addWarning(SQLWarning warnings) |
void |
afterLast() |
void |
beforeFirst() |
void |
cancelRowUpdates() |
protected void |
checkClosed() |
protected void |
checkColumnIndex(int column) |
protected void |
checkResultSet(int column)
Checks that the result set is not closed, it's positioned on a valid row and that the given
column number is valid.
|
void |
clearWarnings() |
void |
close() |
protected void |
closeInternally() |
static Map<String,Integer> |
createColumnNameIndexMap(Field[] fields,
boolean isSanitiserDisabled) |
protected ResultSetMetaData |
createMetaData() |
void |
deleteRow() |
int |
findColumn(String columnName) |
boolean |
first() |
Array |
getArray(int i) |
Array |
getArray(String colName) |
InputStream |
getAsciiStream(int columnIndex) |
InputStream |
getAsciiStream(String columnName) |
BigDecimal |
getBigDecimal(int columnIndex) |
BigDecimal |
getBigDecimal(int columnIndex,
int scale) |
BigDecimal |
getBigDecimal(String columnName) |
BigDecimal |
getBigDecimal(String columnName,
int scale) |
InputStream |
getBinaryStream(int columnIndex) |
InputStream |
getBinaryStream(String columnName) |
Blob |
getBlob(int i) |
Blob |
getBlob(String columnName) |
boolean |
getBoolean(int columnIndex)
Retrieves 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) |
byte |
getByte(int columnIndex) |
byte |
getByte(String columnName) |
byte[] |
getBytes(int columnIndex) |
byte[] |
getBytes(String columnName) |
Reader |
getCharacterStream(int i) |
Reader |
getCharacterStream(String columnName) |
Clob |
getClob(int i) |
Clob |
getClob(String columnName) |
int |
getColumnOID(int field)
Returns the OID of a field.
|
int |
getConcurrency() |
String |
getCursorName() |
Date |
getDate(int columnIndex) |
Date |
getDate(int i,
Calendar cal) |
Date |
getDate(String columnName) |
Date |
getDate(String c,
Calendar cal) |
double |
getDouble(int columnIndex) |
double |
getDouble(String columnName) |
int |
getFetchDirection() |
int |
getFetchSize() |
String |
getFixedString(int col)
This is used to fix get*() methods on Money fields.
|
float |
getFloat(int columnIndex) |
float |
getFloat(String columnName) |
int |
getHoldability() |
int |
getInt(int columnIndex) |
int |
getInt(String columnName) |
long |
getLong(int columnIndex) |
long |
getLong(String columnName) |
ResultSetMetaData |
getMetaData() |
Reader |
getNCharacterStream(int columnIndex) |
Reader |
getNCharacterStream(String columnName) |
NClob |
getNClob(int columnIndex) |
NClob |
getNClob(String columnName) |
String |
getNString(int columnIndex) |
String |
getNString(String columnName) |
Object |
getObject(int columnIndex) |
<T> T |
getObject(int columnIndex,
Class<T> type) |
Object |
getObject(int i,
Map<String,Class<?>> map) |
Object |
getObject(String columnName) |
<T> T |
getObject(String columnLabel,
Class<T> type) |
Object |
getObject(String s,
Map<String,Class<?>> map) |
Object |
getObjectImpl(int i,
Map<String,Class<?>> map) |
Object |
getObjectImpl(String columnName,
Map<String,Class<?>> map) |
BaseStatement |
getPGStatement() |
protected String |
getPGType(int column) |
Ref |
getRef(int i) |
Ref |
getRef(String columnName) |
String |
getRefCursor() |
int |
getRow() |
RowId |
getRowId(int columnIndex) |
RowId |
getRowId(String columnName) |
short |
getShort(int columnIndex) |
short |
getShort(String columnName) |
protected int |
getSQLType(int column) |
SQLXML |
getSQLXML(int columnIndex) |
SQLXML |
getSQLXML(String columnName) |
Statement |
getStatement() |
String |
getString(int columnIndex) |
String |
getString(String columnName) |
Time |
getTime(int columnIndex) |
Time |
getTime(int i,
Calendar cal) |
Time |
getTime(String columnName) |
Time |
getTime(String c,
Calendar cal) |
Timestamp |
getTimestamp(int columnIndex) |
Timestamp |
getTimestamp(int i,
Calendar cal) |
Timestamp |
getTimestamp(String columnName) |
Timestamp |
getTimestamp(String c,
Calendar cal) |
int |
getType() |
InputStream |
getUnicodeStream(int columnIndex) |
InputStream |
getUnicodeStream(String columnName) |
URL |
getURL(int columnIndex) |
URL |
getURL(String columnName) |
protected Object |
getUUID(byte[] data) |
protected Object |
getUUID(String data) |
SQLWarning |
getWarnings() |
void |
insertRow() |
protected Object |
internalGetObject(int columnIndex,
Field field) |
boolean |
isAfterLast() |
boolean |
isBeforeFirst() |
protected boolean |
isBinary(int column)
Returns true if the value of the given column is in binary format.
|
boolean |
isClosed() |
boolean |
isFirst() |
boolean |
isLast() |
protected boolean |
isResultSetClosed() |
boolean |
isWrapperFor(Class<?> iface) |
boolean |
last() |
protected Array |
makeArray(int oid,
byte[] value) |
protected Array |
makeArray(int oid,
String value) |
protected Blob |
makeBlob(long oid) |
protected Clob |
makeClob(long oid) |
void |
moveToCurrentRow() |
void |
moveToInsertRow() |
boolean |
next() |
boolean |
previous() |
static String[] |
quotelessTableName(String fullname)
Cracks out the table name and schema (if it exists) from a fully qualified table name.
|
void |
refreshRow() |
boolean |
relative(int rows) |
boolean |
rowDeleted() |
boolean |
rowInserted() |
boolean |
rowUpdated() |
void |
setFetchDirection(int direction) |
void |
setFetchSize(int rows) |
static BigDecimal |
toBigDecimal(String s) |
BigDecimal |
toBigDecimal(String s,
int scale) |
static double |
toDouble(String s) |
static float |
toFloat(String s) |
static int |
toInt(String s) |
static long |
toLong(String s) |
static short |
toShort(String s) |
<T> T |
unwrap(Class<T> iface) |
void |
updateArray(int columnIndex,
Array x) |
void |
updateArray(String columnName,
Array x) |
void |
updateAsciiStream(int columnIndex,
InputStream inputStream) |
void |
updateAsciiStream(int columnIndex,
InputStream x,
int length) |
void |
updateAsciiStream(int columnIndex,
InputStream inputStream,
long length) |
void |
updateAsciiStream(String columnName,
InputStream inputStream) |
void |
updateAsciiStream(String columnName,
InputStream x,
int length) |
void |
updateAsciiStream(String columnName,
InputStream inputStream,
long length) |
void |
updateBigDecimal(int columnIndex,
BigDecimal x) |
void |
updateBigDecimal(String columnName,
BigDecimal x) |
void |
updateBinaryStream(int columnIndex,
InputStream inputStream) |
void |
updateBinaryStream(int columnIndex,
InputStream x,
int length) |
void |
updateBinaryStream(int columnIndex,
InputStream inputStream,
long length) |
void |
updateBinaryStream(String columnName,
InputStream inputStream) |
void |
updateBinaryStream(String columnName,
InputStream x,
int length) |
void |
updateBinaryStream(String columnName,
InputStream inputStream,
long length) |
void |
updateBlob(int columnIndex,
Blob x) |
void |
updateBlob(int columnIndex,
InputStream inputStream) |
void |
updateBlob(int columnIndex,
InputStream inputStream,
long length) |
void |
updateBlob(String columnName,
Blob x) |
void |
updateBlob(String columnName,
InputStream inputStream) |
void |
updateBlob(String columnName,
InputStream inputStream,
long length) |
void |
updateBoolean(int columnIndex,
boolean x) |
void |
updateBoolean(String columnName,
boolean x) |
void |
updateByte(int columnIndex,
byte x) |
void |
updateByte(String columnName,
byte x) |
void |
updateBytes(int columnIndex,
byte[] x) |
void |
updateBytes(String columnName,
byte[] x) |
void |
updateCharacterStream(int columnIndex,
Reader reader) |
void |
updateCharacterStream(int columnIndex,
Reader x,
int length) |
void |
updateCharacterStream(int columnIndex,
Reader reader,
long length) |
void |
updateCharacterStream(String columnName,
Reader reader) |
void |
updateCharacterStream(String columnName,
Reader reader,
int length) |
void |
updateCharacterStream(String columnName,
Reader reader,
long length) |
void |
updateClob(int columnIndex,
Clob x) |
void |
updateClob(int columnIndex,
Reader reader) |
void |
updateClob(int columnIndex,
Reader reader,
long length) |
void |
updateClob(String columnName,
Clob x) |
void |
updateClob(String columnName,
Reader reader) |
void |
updateClob(String columnName,
Reader reader,
long length) |
void |
updateDate(int columnIndex,
Date x) |
void |
updateDate(String columnName,
Date x) |
void |
updateDouble(int columnIndex,
double x) |
void |
updateDouble(String columnName,
double x) |
void |
updateFloat(int columnIndex,
float x) |
void |
updateFloat(String columnName,
float x) |
void |
updateInt(int columnIndex,
int x) |
void |
updateInt(String columnName,
int x) |
void |
updateLong(int columnIndex,
long x) |
void |
updateLong(String columnName,
long x) |
void |
updateNCharacterStream(int columnIndex,
Reader x) |
void |
updateNCharacterStream(int columnIndex,
Reader x,
int length) |
void |
updateNCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateNCharacterStream(String columnName,
Reader x) |
void |
updateNCharacterStream(String columnName,
Reader x,
int length) |
void |
updateNCharacterStream(String columnName,
Reader x,
long length) |
void |
updateNClob(int columnIndex,
NClob nClob) |
void |
updateNClob(int columnIndex,
Reader reader) |
void |
updateNClob(int columnIndex,
Reader reader,
long length) |
void |
updateNClob(String columnName,
NClob nClob) |
void |
updateNClob(String columnName,
Reader reader) |
void |
updateNClob(String columnName,
Reader reader,
long length) |
void |
updateNString(int columnIndex,
String nString) |
void |
updateNString(String columnName,
String nString) |
void |
updateNull(int columnIndex) |
void |
updateNull(String columnName) |
void |
updateObject(int columnIndex,
Object x) |
void |
updateObject(int columnIndex,
Object x,
int scale) |
void |
updateObject(String columnName,
Object x) |
void |
updateObject(String columnName,
Object x,
int scale) |
void |
updateRef(int columnIndex,
Ref x) |
void |
updateRef(String columnName,
Ref x) |
void |
updateRow() |
void |
updateRowId(int columnIndex,
RowId x) |
void |
updateRowId(String columnName,
RowId x) |
void |
updateShort(int columnIndex,
short x) |
void |
updateShort(String columnName,
short x) |
void |
updateSQLXML(int columnIndex,
SQLXML xmlObject) |
void |
updateSQLXML(String columnName,
SQLXML xmlObject) |
void |
updateString(int columnIndex,
String x) |
void |
updateString(String columnName,
String x) |
void |
updateTime(int columnIndex,
Time x) |
void |
updateTime(String columnName,
Time x) |
void |
updateTimestamp(int columnIndex,
Timestamp x) |
void |
updateTimestamp(String columnName,
Timestamp x) |
protected void |
updateValue(int columnIndex,
Object value) |
boolean |
wasNull() |
protected final BaseConnection connection
protected final BaseStatement statement
protected final Field[] fields
protected final Query originalQuery
protected final int maxRows
protected final int maxFieldSize
protected List<byte[][]> rows
protected int currentRow
protected int rowOffset
protected byte[][] thisRow
protected SQLWarning warnings
protected boolean wasNullFlag
wasNull(). The value
is always updated by the checkResultSet(int) method.protected boolean onInsertRow
protected int fetchSize
protected ResultCursor cursor
protected ResultSetMetaData createMetaData() throws SQLException
SQLExceptionpublic ResultSetMetaData getMetaData() throws SQLException
getMetaData in interface ResultSetSQLExceptionpublic URL getURL(int columnIndex) throws SQLException
getURL in interface ResultSetSQLExceptionpublic URL getURL(String columnName) throws SQLException
getURL in interface ResultSetSQLExceptionprotected Object internalGetObject(int columnIndex, Field field) throws SQLException
SQLExceptionpublic boolean absolute(int index)
throws SQLException
absolute in interface ResultSetSQLExceptionpublic void afterLast()
throws SQLException
afterLast in interface ResultSetSQLExceptionpublic void beforeFirst()
throws SQLException
beforeFirst in interface ResultSetSQLExceptionpublic boolean first()
throws SQLException
first in interface ResultSetSQLExceptionpublic Array getArray(String colName) throws SQLException
getArray in interface ResultSetSQLExceptionprotected Array makeArray(int oid, byte[] value) throws SQLException
SQLExceptionprotected Array makeArray(int oid, String value) throws SQLException
SQLExceptionpublic Array getArray(int i) throws SQLException
getArray in interface ResultSetSQLExceptionpublic BigDecimal getBigDecimal(int columnIndex) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic BigDecimal getBigDecimal(String columnName) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic Blob getBlob(String columnName) throws SQLException
getBlob in interface ResultSetSQLExceptionprotected Blob makeBlob(long oid) throws SQLException
SQLExceptionpublic Blob getBlob(int i) throws SQLException
getBlob in interface ResultSetSQLExceptionpublic Reader getCharacterStream(String columnName) throws SQLException
getCharacterStream in interface ResultSetSQLExceptionpublic Reader getCharacterStream(int i) throws SQLException
getCharacterStream in interface ResultSetSQLExceptionpublic Clob getClob(String columnName) throws SQLException
getClob in interface ResultSetSQLExceptionprotected Clob makeClob(long oid) throws SQLException
SQLExceptionpublic Clob getClob(int i) throws SQLException
getClob in interface ResultSetSQLExceptionpublic int getConcurrency()
throws SQLException
getConcurrency in interface ResultSetSQLExceptionpublic Date getDate(int i, Calendar cal) throws SQLException
getDate in interface ResultSetSQLExceptionpublic Time getTime(int i, Calendar cal) throws SQLException
getTime in interface ResultSetSQLExceptionpublic Timestamp getTimestamp(int i, Calendar cal) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic Date getDate(String c, Calendar cal) throws SQLException
getDate in interface ResultSetSQLExceptionpublic Time getTime(String c, Calendar cal) throws SQLException
getTime in interface ResultSetSQLExceptionpublic Timestamp getTimestamp(String c, Calendar cal) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic int getFetchDirection()
throws SQLException
getFetchDirection in interface ResultSetSQLExceptionpublic Object getObjectImpl(String columnName, Map<String,Class<?>> map) throws SQLException
SQLExceptionpublic Object getObjectImpl(int i, Map<String,Class<?>> map) throws SQLException
SQLExceptionpublic Ref getRef(String columnName) throws SQLException
getRef in interface ResultSetSQLExceptionpublic Ref getRef(int i) throws SQLException
getRef in interface ResultSetSQLExceptionpublic int getRow()
throws SQLException
getRow in interface ResultSetSQLExceptionpublic Statement getStatement() throws SQLException
getStatement in interface ResultSetSQLExceptionpublic int getType()
throws SQLException
getType in interface ResultSetSQLExceptionpublic boolean isAfterLast()
throws SQLException
isAfterLast in interface ResultSetSQLExceptionpublic boolean isBeforeFirst()
throws SQLException
isBeforeFirst in interface ResultSetSQLExceptionpublic boolean isFirst()
throws SQLException
isFirst in interface ResultSetSQLExceptionpublic boolean isLast()
throws SQLException
isLast in interface ResultSetSQLExceptionpublic boolean last()
throws SQLException
last in interface ResultSetSQLExceptionpublic boolean previous()
throws SQLException
previous in interface ResultSetSQLExceptionpublic boolean relative(int rows)
throws SQLException
relative in interface ResultSetSQLExceptionpublic void setFetchDirection(int direction)
throws SQLException
setFetchDirection in interface ResultSetSQLExceptionpublic void cancelRowUpdates()
throws SQLException
cancelRowUpdates in interface ResultSetSQLExceptionpublic void deleteRow()
throws SQLException
deleteRow in interface ResultSetSQLExceptionpublic void insertRow()
throws SQLException
insertRow in interface ResultSetSQLExceptionpublic void moveToCurrentRow()
throws SQLException
moveToCurrentRow in interface ResultSetSQLExceptionpublic void moveToInsertRow()
throws SQLException
moveToInsertRow in interface ResultSetSQLExceptionpublic boolean rowDeleted()
throws SQLException
rowDeleted in interface ResultSetSQLExceptionpublic boolean rowInserted()
throws SQLException
rowInserted in interface ResultSetSQLExceptionpublic boolean rowUpdated()
throws SQLException
rowUpdated in interface ResultSetSQLExceptionpublic void updateAsciiStream(int columnIndex,
InputStream x,
int length)
throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateBigDecimal(int columnIndex,
BigDecimal x)
throws SQLException
updateBigDecimal in interface ResultSetSQLExceptionpublic void updateBinaryStream(int columnIndex,
InputStream x,
int length)
throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateBoolean(int columnIndex,
boolean x)
throws SQLException
updateBoolean in interface ResultSetSQLExceptionpublic void updateByte(int columnIndex,
byte x)
throws SQLException
updateByte in interface ResultSetSQLExceptionpublic void updateBytes(int columnIndex,
byte[] x)
throws SQLException
updateBytes in interface ResultSetSQLExceptionpublic void updateCharacterStream(int columnIndex,
Reader x,
int length)
throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateDate(int columnIndex,
Date x)
throws SQLException
updateDate in interface ResultSetSQLExceptionpublic void updateDouble(int columnIndex,
double x)
throws SQLException
updateDouble in interface ResultSetSQLExceptionpublic void updateFloat(int columnIndex,
float x)
throws SQLException
updateFloat in interface ResultSetSQLExceptionpublic void updateInt(int columnIndex,
int x)
throws SQLException
updateInt in interface ResultSetSQLExceptionpublic void updateLong(int columnIndex,
long x)
throws SQLException
updateLong in interface ResultSetSQLExceptionpublic void updateNull(int columnIndex)
throws SQLException
updateNull in interface ResultSetSQLExceptionpublic void updateObject(int columnIndex,
Object x)
throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void updateObject(int columnIndex,
Object x,
int scale)
throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void refreshRow()
throws SQLException
refreshRow in interface ResultSetSQLExceptionpublic void updateRow()
throws SQLException
updateRow in interface ResultSetSQLExceptionpublic void updateShort(int columnIndex,
short x)
throws SQLException
updateShort in interface ResultSetSQLExceptionpublic void updateString(int columnIndex,
String x)
throws SQLException
updateString in interface ResultSetSQLExceptionpublic void updateTime(int columnIndex,
Time x)
throws SQLException
updateTime in interface ResultSetSQLExceptionpublic void updateTimestamp(int columnIndex,
Timestamp x)
throws SQLException
updateTimestamp in interface ResultSetSQLExceptionpublic void updateNull(String columnName) throws SQLException
updateNull in interface ResultSetSQLExceptionpublic void updateBoolean(String columnName, boolean x) throws SQLException
updateBoolean in interface ResultSetSQLExceptionpublic void updateByte(String columnName, byte x) throws SQLException
updateByte in interface ResultSetSQLExceptionpublic void updateShort(String columnName, short x) throws SQLException
updateShort in interface ResultSetSQLExceptionpublic void updateInt(String columnName, int x) throws SQLException
updateInt in interface ResultSetSQLExceptionpublic void updateLong(String columnName, long x) throws SQLException
updateLong in interface ResultSetSQLExceptionpublic void updateFloat(String columnName, float x) throws SQLException
updateFloat in interface ResultSetSQLExceptionpublic void updateDouble(String columnName, double x) throws SQLException
updateDouble in interface ResultSetSQLExceptionpublic void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
updateBigDecimal in interface ResultSetSQLExceptionpublic void updateString(String columnName, String x) throws SQLException
updateString in interface ResultSetSQLExceptionpublic void updateBytes(String columnName, byte[] x) throws SQLException
updateBytes in interface ResultSetSQLExceptionpublic void updateDate(String columnName, Date x) throws SQLException
updateDate in interface ResultSetSQLExceptionpublic void updateTime(String columnName, Time x) throws SQLException
updateTime in interface ResultSetSQLExceptionpublic void updateTimestamp(String columnName, Timestamp x) throws SQLException
updateTimestamp in interface ResultSetSQLExceptionpublic void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateObject(String columnName, Object x, int scale) throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void updateObject(String columnName, Object x) throws SQLException
updateObject in interface ResultSetSQLExceptionpublic static String[] quotelessTableName(String fullname)
fullname - string that we are trying to crack. Test cases:
Table: table
()
"Table": Table
()
Schema.Table:
table (schema)
"Schema"."Table": Table
(Schema)
"Schema"."Dot.Table": Dot.Table
(Schema)
Schema."Dot.Table": Dot.Table
(schema)
public BaseStatement getPGStatement()
public String getRefCursor()
getRefCursor in interface PGRefCursorResultSetpublic void setFetchSize(int rows)
throws SQLException
setFetchSize in interface ResultSetSQLExceptionpublic int getFetchSize()
throws SQLException
getFetchSize in interface ResultSetSQLExceptionpublic boolean next()
throws SQLException
next in interface ResultSetSQLExceptionpublic void close()
throws SQLException
close in interface ResultSetSQLExceptionprotected void closeInternally()
throws SQLException
SQLExceptionpublic boolean wasNull()
throws SQLException
wasNull in interface ResultSetSQLExceptionpublic String getString(int columnIndex) throws SQLException
getString in interface ResultSetSQLExceptionpublic boolean getBoolean(int columnIndex)
throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet
object as a boolean in the Java programming language.
If the designated column has a Character datatype and is one of the following values: "1",
"true", "t", "yes", "y" or "on", a value of true is returned. If the designated
column has a Character datatype and is one of the following values: "0", "false", "f", "no",
"n" or "off", a value of false is returned. Leading or trailing whitespace is
ignored, and case does not matter.
If the designated column has a Numeric datatype and is a 1, a value of true is
returned. If the designated column has a Numeric datatype and is a 0, a value of
false is returned.
getBoolean in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the value returned is
falseSQLException - if the columnIndex is not valid; if a database access error occurs; if
this method is called on a closed result set or is an invalid cast to boolean type.public byte getByte(int columnIndex)
throws SQLException
getByte in interface ResultSetSQLExceptionpublic short getShort(int columnIndex)
throws SQLException
getShort in interface ResultSetSQLExceptionpublic int getInt(int columnIndex)
throws SQLException
getInt in interface ResultSetSQLExceptionpublic long getLong(int columnIndex)
throws SQLException
getLong in interface ResultSetSQLExceptionpublic float getFloat(int columnIndex)
throws SQLException
getFloat in interface ResultSetSQLExceptionpublic double getDouble(int columnIndex)
throws SQLException
getDouble in interface ResultSetSQLExceptionpublic BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic byte[] getBytes(int columnIndex)
throws SQLException
In normal use, the bytes represent the raw values returned by the backend. However, if the column is an OID, then it is assumed to refer to a Large Object, and that object is returned as a byte array.
Be warned If the large object is huge, then you may run out of memory.
getBytes in interface ResultSetSQLExceptionpublic Date getDate(int columnIndex) throws SQLException
getDate in interface ResultSetSQLExceptionpublic Time getTime(int columnIndex) throws SQLException
getTime in interface ResultSetSQLExceptionpublic Timestamp getTimestamp(int columnIndex) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic InputStream getAsciiStream(int columnIndex) throws SQLException
getAsciiStream in interface ResultSetSQLExceptionpublic InputStream getUnicodeStream(int columnIndex) throws SQLException
getUnicodeStream in interface ResultSetSQLExceptionpublic InputStream getBinaryStream(int columnIndex) throws SQLException
getBinaryStream in interface ResultSetSQLExceptionpublic String getString(String columnName) throws SQLException
getString in interface ResultSetSQLExceptionpublic boolean getBoolean(String columnName) throws SQLException
getBoolean in interface ResultSetSQLExceptionpublic byte getByte(String columnName) throws SQLException
getByte in interface ResultSetSQLExceptionpublic short getShort(String columnName) throws SQLException
getShort in interface ResultSetSQLExceptionpublic int getInt(String columnName) throws SQLException
getInt in interface ResultSetSQLExceptionpublic long getLong(String columnName) throws SQLException
getLong in interface ResultSetSQLExceptionpublic float getFloat(String columnName) throws SQLException
getFloat in interface ResultSetSQLExceptionpublic double getDouble(String columnName) throws SQLException
getDouble in interface ResultSetSQLExceptionpublic BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic byte[] getBytes(String columnName) throws SQLException
getBytes in interface ResultSetSQLExceptionpublic Date getDate(String columnName) throws SQLException
getDate in interface ResultSetSQLExceptionpublic Time getTime(String columnName) throws SQLException
getTime in interface ResultSetSQLExceptionpublic Timestamp getTimestamp(String columnName) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic InputStream getAsciiStream(String columnName) throws SQLException
getAsciiStream in interface ResultSetSQLExceptionpublic InputStream getUnicodeStream(String columnName) throws SQLException
getUnicodeStream in interface ResultSetSQLExceptionpublic InputStream getBinaryStream(String columnName) throws SQLException
getBinaryStream in interface ResultSetSQLExceptionpublic SQLWarning getWarnings() throws SQLException
getWarnings in interface ResultSetSQLExceptionpublic void clearWarnings()
throws SQLException
clearWarnings in interface ResultSetSQLExceptionprotected void addWarning(SQLWarning warnings)
public String getCursorName() throws SQLException
getCursorName in interface ResultSetSQLExceptionpublic Object getObject(int columnIndex) throws SQLException
getObject in interface ResultSetSQLExceptionpublic Object getObject(String columnName) throws SQLException
getObject in interface ResultSetSQLExceptionpublic int findColumn(String columnName) throws SQLException
findColumn in interface ResultSetSQLExceptionpublic static Map<String,Integer> createColumnNameIndexMap(Field[] fields, boolean isSanitiserDisabled)
public int getColumnOID(int field)
field - field indexpublic String getFixedString(int col) throws SQLException
This is used to fix get*() methods on Money fields. It should only be used by those methods!
It converts ($##.##) to -##.## and $##.## to ##.##
col - column position (1-based)SQLException - if something wrong happensprotected String getPGType(int column) throws SQLException
SQLExceptionprotected int getSQLType(int column)
throws SQLException
SQLExceptionprotected void checkClosed()
throws SQLException
SQLExceptionprotected boolean isResultSetClosed()
protected void checkColumnIndex(int column)
throws SQLException
SQLExceptionprotected void checkResultSet(int column)
throws SQLException
wasNullFlag to correct value.column - The column number to check. Range starts from 1.SQLException - If state or column is invalid.protected boolean isBinary(int column)
column - The column to check. Range starts from 1.public static short toShort(String s) throws SQLException
SQLExceptionpublic static int toInt(String s) throws SQLException
SQLExceptionpublic static long toLong(String s) throws SQLException
SQLExceptionpublic static BigDecimal toBigDecimal(String s) throws SQLException
SQLExceptionpublic BigDecimal toBigDecimal(String s, int scale) throws SQLException
SQLExceptionpublic static float toFloat(String s) throws SQLException
SQLExceptionpublic static double toDouble(String s) throws SQLException
SQLExceptionprotected void updateValue(int columnIndex,
Object value)
throws SQLException
SQLExceptionprotected Object getUUID(String data) throws SQLException
SQLExceptionprotected Object getUUID(byte[] data) throws SQLException
SQLExceptionpublic void updateRef(int columnIndex,
Ref x)
throws SQLException
updateRef in interface ResultSetSQLExceptionpublic void updateRef(String columnName, Ref x) throws SQLException
updateRef in interface ResultSetSQLExceptionpublic void updateBlob(int columnIndex,
Blob x)
throws SQLException
updateBlob in interface ResultSetSQLExceptionpublic void updateBlob(String columnName, Blob x) throws SQLException
updateBlob in interface ResultSetSQLExceptionpublic void updateClob(int columnIndex,
Clob x)
throws SQLException
updateClob in interface ResultSetSQLExceptionpublic void updateClob(String columnName, Clob x) throws SQLException
updateClob in interface ResultSetSQLExceptionpublic void updateArray(int columnIndex,
Array x)
throws SQLException
updateArray in interface ResultSetSQLExceptionpublic void updateArray(String columnName, Array x) throws SQLException
updateArray in interface ResultSetSQLExceptionpublic <T> T getObject(int columnIndex,
Class<T> type)
throws SQLException
SQLExceptionpublic <T> T getObject(String columnLabel, Class<T> type) throws SQLException
SQLExceptionpublic Object getObject(String s, Map<String,Class<?>> map) throws SQLException
getObject in interface ResultSetSQLExceptionpublic Object getObject(int i, Map<String,Class<?>> map) throws SQLException
getObject in interface ResultSetSQLExceptionpublic RowId getRowId(int columnIndex) throws SQLException
getRowId in interface ResultSetSQLExceptionpublic RowId getRowId(String columnName) throws SQLException
getRowId in interface ResultSetSQLExceptionpublic void updateRowId(int columnIndex,
RowId x)
throws SQLException
updateRowId in interface ResultSetSQLExceptionpublic void updateRowId(String columnName, RowId x) throws SQLException
updateRowId in interface ResultSetSQLExceptionpublic int getHoldability()
throws SQLException
getHoldability in interface ResultSetSQLExceptionpublic boolean isClosed()
throws SQLException
isClosed in interface ResultSetSQLExceptionpublic void updateNString(int columnIndex,
String nString)
throws SQLException
updateNString in interface ResultSetSQLExceptionpublic void updateNString(String columnName, String nString) throws SQLException
updateNString in interface ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
NClob nClob)
throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void updateNClob(String columnName, NClob nClob) throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
Reader reader)
throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void updateNClob(String columnName, Reader reader) throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
Reader reader,
long length)
throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void updateNClob(String columnName, Reader reader, long length) throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic NClob getNClob(int columnIndex) throws SQLException
getNClob in interface ResultSetSQLExceptionpublic NClob getNClob(String columnName) throws SQLException
getNClob in interface ResultSetSQLExceptionpublic void updateBlob(int columnIndex,
InputStream inputStream,
long length)
throws SQLException
updateBlob in interface ResultSetSQLExceptionpublic void updateBlob(String columnName, InputStream inputStream, long length) throws SQLException
updateBlob in interface ResultSetSQLExceptionpublic void updateBlob(int columnIndex,
InputStream inputStream)
throws SQLException
updateBlob in interface ResultSetSQLExceptionpublic void updateBlob(String columnName, InputStream inputStream) throws SQLException
updateBlob in interface ResultSetSQLExceptionpublic void updateClob(int columnIndex,
Reader reader,
long length)
throws SQLException
updateClob in interface ResultSetSQLExceptionpublic void updateClob(String columnName, Reader reader, long length) throws SQLException
updateClob in interface ResultSetSQLExceptionpublic void updateClob(int columnIndex,
Reader reader)
throws SQLException
updateClob in interface ResultSetSQLExceptionpublic void updateClob(String columnName, Reader reader) throws SQLException
updateClob in interface ResultSetSQLExceptionpublic SQLXML getSQLXML(int columnIndex) throws SQLException
getSQLXML in interface ResultSetSQLExceptionpublic SQLXML getSQLXML(String columnName) throws SQLException
getSQLXML in interface ResultSetSQLExceptionpublic void updateSQLXML(int columnIndex,
SQLXML xmlObject)
throws SQLException
updateSQLXML in interface ResultSetSQLExceptionpublic void updateSQLXML(String columnName, SQLXML xmlObject) throws SQLException
updateSQLXML in interface ResultSetSQLExceptionpublic String getNString(int columnIndex) throws SQLException
getNString in interface ResultSetSQLExceptionpublic String getNString(String columnName) throws SQLException
getNString in interface ResultSetSQLExceptionpublic Reader getNCharacterStream(int columnIndex) throws SQLException
getNCharacterStream in interface ResultSetSQLExceptionpublic Reader getNCharacterStream(String columnName) throws SQLException
getNCharacterStream in interface ResultSetSQLExceptionpublic void updateNCharacterStream(int columnIndex,
Reader x,
int length)
throws SQLException
SQLExceptionpublic void updateNCharacterStream(String columnName, Reader x, int length) throws SQLException
SQLExceptionpublic void updateNCharacterStream(int columnIndex,
Reader x)
throws SQLException
updateNCharacterStream in interface ResultSetSQLExceptionpublic void updateNCharacterStream(String columnName, Reader x) throws SQLException
updateNCharacterStream in interface ResultSetSQLExceptionpublic void updateNCharacterStream(int columnIndex,
Reader x,
long length)
throws SQLException
updateNCharacterStream in interface ResultSetSQLExceptionpublic void updateNCharacterStream(String columnName, Reader x, long length) throws SQLException
updateNCharacterStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(int columnIndex,
Reader reader,
long length)
throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(String columnName, Reader reader, long length) throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(int columnIndex,
Reader reader)
throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(String columnName, Reader reader) throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateBinaryStream(int columnIndex,
InputStream inputStream,
long length)
throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateBinaryStream(String columnName, InputStream inputStream, long length) throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateBinaryStream(int columnIndex,
InputStream inputStream)
throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateBinaryStream(String columnName, InputStream inputStream) throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateAsciiStream(int columnIndex,
InputStream inputStream,
long length)
throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateAsciiStream(String columnName, InputStream inputStream, long length) throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateAsciiStream(int columnIndex,
InputStream inputStream)
throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateAsciiStream(String columnName, InputStream inputStream) throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor in interface WrapperSQLExceptionpublic <T> T unwrap(Class<T> iface) throws SQLException
unwrap in interface WrapperSQLExceptionCopyright © 2020 PostgreSQL Global Development Group. All rights reserved.