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
SQLException
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface ResultSet
SQLException
public URL getURL(int columnIndex) throws SQLException
getURL
in interface ResultSet
SQLException
public URL getURL(String columnName) throws SQLException
getURL
in interface ResultSet
SQLException
protected Object internalGetObject(int columnIndex, Field field) throws SQLException
SQLException
public boolean absolute(int index) throws SQLException
absolute
in interface ResultSet
SQLException
public void afterLast() throws SQLException
afterLast
in interface ResultSet
SQLException
public void beforeFirst() throws SQLException
beforeFirst
in interface ResultSet
SQLException
public boolean first() throws SQLException
first
in interface ResultSet
SQLException
public Array getArray(String colName) throws SQLException
getArray
in interface ResultSet
SQLException
protected Array makeArray(int oid, byte[] value) throws SQLException
SQLException
protected Array makeArray(int oid, String value) throws SQLException
SQLException
public Array getArray(int i) throws SQLException
getArray
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(String columnName) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public Blob getBlob(String columnName) throws SQLException
getBlob
in interface ResultSet
SQLException
protected Blob makeBlob(long oid) throws SQLException
SQLException
public Blob getBlob(int i) throws SQLException
getBlob
in interface ResultSet
SQLException
public Reader getCharacterStream(String columnName) throws SQLException
getCharacterStream
in interface ResultSet
SQLException
public Reader getCharacterStream(int i) throws SQLException
getCharacterStream
in interface ResultSet
SQLException
public Clob getClob(String columnName) throws SQLException
getClob
in interface ResultSet
SQLException
protected Clob makeClob(long oid) throws SQLException
SQLException
public Clob getClob(int i) throws SQLException
getClob
in interface ResultSet
SQLException
public int getConcurrency() throws SQLException
getConcurrency
in interface ResultSet
SQLException
public Date getDate(int i, Calendar cal) throws SQLException
getDate
in interface ResultSet
SQLException
public Time getTime(int i, Calendar cal) throws SQLException
getTime
in interface ResultSet
SQLException
public Timestamp getTimestamp(int i, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public Date getDate(String c, Calendar cal) throws SQLException
getDate
in interface ResultSet
SQLException
public Time getTime(String c, Calendar cal) throws SQLException
getTime
in interface ResultSet
SQLException
public Timestamp getTimestamp(String c, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public int getFetchDirection() throws SQLException
getFetchDirection
in interface ResultSet
SQLException
public Object getObjectImpl(String columnName, Map<String,Class<?>> map) throws SQLException
SQLException
public Object getObjectImpl(int i, Map<String,Class<?>> map) throws SQLException
SQLException
public Ref getRef(String columnName) throws SQLException
getRef
in interface ResultSet
SQLException
public Ref getRef(int i) throws SQLException
getRef
in interface ResultSet
SQLException
public int getRow() throws SQLException
getRow
in interface ResultSet
SQLException
public Statement getStatement() throws SQLException
getStatement
in interface ResultSet
SQLException
public int getType() throws SQLException
getType
in interface ResultSet
SQLException
public boolean isAfterLast() throws SQLException
isAfterLast
in interface ResultSet
SQLException
public boolean isBeforeFirst() throws SQLException
isBeforeFirst
in interface ResultSet
SQLException
public boolean isFirst() throws SQLException
isFirst
in interface ResultSet
SQLException
public boolean isLast() throws SQLException
isLast
in interface ResultSet
SQLException
public boolean last() throws SQLException
last
in interface ResultSet
SQLException
public boolean previous() throws SQLException
previous
in interface ResultSet
SQLException
public boolean relative(int rows) throws SQLException
relative
in interface ResultSet
SQLException
public void setFetchDirection(int direction) throws SQLException
setFetchDirection
in interface ResultSet
SQLException
public void cancelRowUpdates() throws SQLException
cancelRowUpdates
in interface ResultSet
SQLException
public void deleteRow() throws SQLException
deleteRow
in interface ResultSet
SQLException
public void insertRow() throws SQLException
insertRow
in interface ResultSet
SQLException
public void moveToCurrentRow() throws SQLException
moveToCurrentRow
in interface ResultSet
SQLException
public void moveToInsertRow() throws SQLException
moveToInsertRow
in interface ResultSet
SQLException
public boolean rowDeleted() throws SQLException
rowDeleted
in interface ResultSet
SQLException
public boolean rowInserted() throws SQLException
rowInserted
in interface ResultSet
SQLException
public boolean rowUpdated() throws SQLException
rowUpdated
in interface ResultSet
SQLException
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBoolean(int columnIndex, boolean x) throws SQLException
updateBoolean
in interface ResultSet
SQLException
public void updateByte(int columnIndex, byte x) throws SQLException
updateByte
in interface ResultSet
SQLException
public void updateBytes(int columnIndex, byte[] x) throws SQLException
updateBytes
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateDate(int columnIndex, Date x) throws SQLException
updateDate
in interface ResultSet
SQLException
public void updateDouble(int columnIndex, double x) throws SQLException
updateDouble
in interface ResultSet
SQLException
public void updateFloat(int columnIndex, float x) throws SQLException
updateFloat
in interface ResultSet
SQLException
public void updateInt(int columnIndex, int x) throws SQLException
updateInt
in interface ResultSet
SQLException
public void updateLong(int columnIndex, long x) throws SQLException
updateLong
in interface ResultSet
SQLException
public void updateNull(int columnIndex) throws SQLException
updateNull
in interface ResultSet
SQLException
public void updateObject(int columnIndex, Object x) throws SQLException
updateObject
in interface ResultSet
SQLException
public void updateObject(int columnIndex, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
SQLException
public void refreshRow() throws SQLException
refreshRow
in interface ResultSet
SQLException
public void updateRow() throws SQLException
updateRow
in interface ResultSet
SQLException
public void updateShort(int columnIndex, short x) throws SQLException
updateShort
in interface ResultSet
SQLException
public void updateString(int columnIndex, String x) throws SQLException
updateString
in interface ResultSet
SQLException
public void updateTime(int columnIndex, Time x) throws SQLException
updateTime
in interface ResultSet
SQLException
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
SQLException
public void updateNull(String columnName) throws SQLException
updateNull
in interface ResultSet
SQLException
public void updateBoolean(String columnName, boolean x) throws SQLException
updateBoolean
in interface ResultSet
SQLException
public void updateByte(String columnName, byte x) throws SQLException
updateByte
in interface ResultSet
SQLException
public void updateShort(String columnName, short x) throws SQLException
updateShort
in interface ResultSet
SQLException
public void updateInt(String columnName, int x) throws SQLException
updateInt
in interface ResultSet
SQLException
public void updateLong(String columnName, long x) throws SQLException
updateLong
in interface ResultSet
SQLException
public void updateFloat(String columnName, float x) throws SQLException
updateFloat
in interface ResultSet
SQLException
public void updateDouble(String columnName, double x) throws SQLException
updateDouble
in interface ResultSet
SQLException
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
SQLException
public void updateString(String columnName, String x) throws SQLException
updateString
in interface ResultSet
SQLException
public void updateBytes(String columnName, byte[] x) throws SQLException
updateBytes
in interface ResultSet
SQLException
public void updateDate(String columnName, Date x) throws SQLException
updateDate
in interface ResultSet
SQLException
public void updateTime(String columnName, Time x) throws SQLException
updateTime
in interface ResultSet
SQLException
public void updateTimestamp(String columnName, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
SQLException
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateObject(String columnName, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
SQLException
public void updateObject(String columnName, Object x) throws SQLException
updateObject
in interface ResultSet
SQLException
public 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 PGRefCursorResultSet
public void setFetchSize(int rows) throws SQLException
setFetchSize
in interface ResultSet
SQLException
public int getFetchSize() throws SQLException
getFetchSize
in interface ResultSet
SQLException
public boolean next() throws SQLException
next
in interface ResultSet
SQLException
public void close() throws SQLException
close
in interface ResultSet
SQLException
protected void closeInternally() throws SQLException
SQLException
public boolean wasNull() throws SQLException
wasNull
in interface ResultSet
SQLException
public String getString(int columnIndex) throws SQLException
getString
in interface ResultSet
SQLException
public 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 ResultSet
columnIndex
- the first column is 1, the second is 2, ...NULL
, the value returned is
false
SQLException
- 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 ResultSet
SQLException
public short getShort(int columnIndex) throws SQLException
getShort
in interface ResultSet
SQLException
public int getInt(int columnIndex) throws SQLException
getInt
in interface ResultSet
SQLException
public long getLong(int columnIndex) throws SQLException
getLong
in interface ResultSet
SQLException
public float getFloat(int columnIndex) throws SQLException
getFloat
in interface ResultSet
SQLException
public double getDouble(int columnIndex) throws SQLException
getDouble
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public 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 ResultSet
SQLException
public Date getDate(int columnIndex) throws SQLException
getDate
in interface ResultSet
SQLException
public Time getTime(int columnIndex) throws SQLException
getTime
in interface ResultSet
SQLException
public Timestamp getTimestamp(int columnIndex) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public InputStream getAsciiStream(int columnIndex) throws SQLException
getAsciiStream
in interface ResultSet
SQLException
public InputStream getUnicodeStream(int columnIndex) throws SQLException
getUnicodeStream
in interface ResultSet
SQLException
public InputStream getBinaryStream(int columnIndex) throws SQLException
getBinaryStream
in interface ResultSet
SQLException
public String getString(String columnName) throws SQLException
getString
in interface ResultSet
SQLException
public boolean getBoolean(String columnName) throws SQLException
getBoolean
in interface ResultSet
SQLException
public byte getByte(String columnName) throws SQLException
getByte
in interface ResultSet
SQLException
public short getShort(String columnName) throws SQLException
getShort
in interface ResultSet
SQLException
public int getInt(String columnName) throws SQLException
getInt
in interface ResultSet
SQLException
public long getLong(String columnName) throws SQLException
getLong
in interface ResultSet
SQLException
public float getFloat(String columnName) throws SQLException
getFloat
in interface ResultSet
SQLException
public double getDouble(String columnName) throws SQLException
getDouble
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public byte[] getBytes(String columnName) throws SQLException
getBytes
in interface ResultSet
SQLException
public Date getDate(String columnName) throws SQLException
getDate
in interface ResultSet
SQLException
public Time getTime(String columnName) throws SQLException
getTime
in interface ResultSet
SQLException
public Timestamp getTimestamp(String columnName) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public InputStream getAsciiStream(String columnName) throws SQLException
getAsciiStream
in interface ResultSet
SQLException
public InputStream getUnicodeStream(String columnName) throws SQLException
getUnicodeStream
in interface ResultSet
SQLException
public InputStream getBinaryStream(String columnName) throws SQLException
getBinaryStream
in interface ResultSet
SQLException
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface ResultSet
SQLException
public void clearWarnings() throws SQLException
clearWarnings
in interface ResultSet
SQLException
protected void addWarning(SQLWarning warnings)
public String getCursorName() throws SQLException
getCursorName
in interface ResultSet
SQLException
public Object getObject(int columnIndex) throws SQLException
getObject
in interface ResultSet
SQLException
public Object getObject(String columnName) throws SQLException
getObject
in interface ResultSet
SQLException
public int findColumn(String columnName) throws SQLException
findColumn
in interface ResultSet
SQLException
public 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
SQLException
protected int getSQLType(int column) throws SQLException
SQLException
protected void checkClosed() throws SQLException
SQLException
protected boolean isResultSetClosed()
protected void checkColumnIndex(int column) throws SQLException
SQLException
protected 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
SQLException
public static int toInt(String s) throws SQLException
SQLException
public static long toLong(String s) throws SQLException
SQLException
public static BigDecimal toBigDecimal(String s) throws SQLException
SQLException
public BigDecimal toBigDecimal(String s, int scale) throws SQLException
SQLException
public static float toFloat(String s) throws SQLException
SQLException
public static double toDouble(String s) throws SQLException
SQLException
protected void updateValue(int columnIndex, Object value) throws SQLException
SQLException
protected Object getUUID(String data) throws SQLException
SQLException
protected Object getUUID(byte[] data) throws SQLException
SQLException
public void updateRef(int columnIndex, Ref x) throws SQLException
updateRef
in interface ResultSet
SQLException
public void updateRef(String columnName, Ref x) throws SQLException
updateRef
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, Blob x) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnName, Blob x) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Clob x) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnName, Clob x) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateArray(int columnIndex, Array x) throws SQLException
updateArray
in interface ResultSet
SQLException
public void updateArray(String columnName, Array x) throws SQLException
updateArray
in interface ResultSet
SQLException
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException
SQLException
public <T> T getObject(String columnLabel, Class<T> type) throws SQLException
SQLException
public Object getObject(String s, Map<String,Class<?>> map) throws SQLException
getObject
in interface ResultSet
SQLException
public Object getObject(int i, Map<String,Class<?>> map) throws SQLException
getObject
in interface ResultSet
SQLException
public RowId getRowId(int columnIndex) throws SQLException
getRowId
in interface ResultSet
SQLException
public RowId getRowId(String columnName) throws SQLException
getRowId
in interface ResultSet
SQLException
public void updateRowId(int columnIndex, RowId x) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void updateRowId(String columnName, RowId x) throws SQLException
updateRowId
in interface ResultSet
SQLException
public int getHoldability() throws SQLException
getHoldability
in interface ResultSet
SQLException
public boolean isClosed() throws SQLException
isClosed
in interface ResultSet
SQLException
public void updateNString(int columnIndex, String nString) throws SQLException
updateNString
in interface ResultSet
SQLException
public void updateNString(String columnName, String nString) throws SQLException
updateNString
in interface ResultSet
SQLException
public void updateNClob(int columnIndex, NClob nClob) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnName, NClob nClob) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(int columnIndex, Reader reader) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnName, Reader reader) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnName, Reader reader, long length) throws SQLException
updateNClob
in interface ResultSet
SQLException
public NClob getNClob(int columnIndex) throws SQLException
getNClob
in interface ResultSet
SQLException
public NClob getNClob(String columnName) throws SQLException
getNClob
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnName, InputStream inputStream, long length) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnName, InputStream inputStream) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Reader reader, long length) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnName, Reader reader, long length) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Reader reader) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnName, Reader reader) throws SQLException
updateClob
in interface ResultSet
SQLException
public SQLXML getSQLXML(int columnIndex) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public SQLXML getSQLXML(String columnName) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public void updateSQLXML(String columnName, SQLXML xmlObject) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public String getNString(int columnIndex) throws SQLException
getNString
in interface ResultSet
SQLException
public String getNString(String columnName) throws SQLException
getNString
in interface ResultSet
SQLException
public Reader getNCharacterStream(int columnIndex) throws SQLException
getNCharacterStream
in interface ResultSet
SQLException
public Reader getNCharacterStream(String columnName) throws SQLException
getNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(int columnIndex, Reader x, int length) throws SQLException
SQLException
public void updateNCharacterStream(String columnName, Reader x, int length) throws SQLException
SQLException
public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(String columnName, Reader x) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(String columnName, Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader reader, long length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnName, Reader reader, long length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader reader) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnName, Reader reader) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream inputStream, long length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnName, InputStream inputStream, long length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream inputStream) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnName, InputStream inputStream) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateAsciiStream(int columnIndex, InputStream inputStream, long length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnName, InputStream inputStream, long length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(int columnIndex, InputStream inputStream) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnName, InputStream inputStream) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor
in interface Wrapper
SQLException
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
SQLException
Copyright © 2020 PostgreSQL Global Development Group. All rights reserved.