public class SQLServerResultSet extends Object implements ISQLServerResultSet
Modifier and Type | Field and Description |
---|---|
protected static Logger |
loggerExternal |
CONCUR_SS_OPTIMISTIC_CC, CONCUR_SS_OPTIMISTIC_CCVAL, CONCUR_SS_SCROLL_LOCKS, TYPE_SS_DIRECT_FORWARD_ONLY, TYPE_SS_SCROLL_DYNAMIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_STATIC, TYPE_SS_SERVER_CURSOR_FORWARD_ONLY
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 row)
Moves the cursor to the specified row in this ResultSet object.
|
void |
afterLast() |
void |
beforeFirst() |
void |
cancelRowUpdates() |
void |
clearWarnings()
Clear result set warnings
|
void |
close() |
void |
deleteRow() |
int |
findColumn(String columnName)
Find a column index given a column name
|
boolean |
first()
Moves the cursor to the first row in this ResultSet object.
|
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)
Deprecated.
|
BigDecimal |
getBigDecimal(String columnName) |
BigDecimal |
getBigDecimal(String columnName,
int scale)
Deprecated.
|
InputStream |
getBinaryStream(int columnIndex) |
InputStream |
getBinaryStream(String columnName) |
Blob |
getBlob(int i) |
Blob |
getBlob(String colName) |
boolean |
getBoolean(int columnIndex) |
boolean |
getBoolean(String columnName) |
byte |
getByte(int columnIndex) |
byte |
getByte(String columnName) |
byte[] |
getBytes(int columnIndex) |
byte[] |
getBytes(String columnName) |
Reader |
getCharacterStream(int columnIndex) |
Reader |
getCharacterStream(String columnName) |
Clob |
getClob(int columnIndex) |
Clob |
getClob(String colName) |
int |
getConcurrency() |
String |
getCursorName() |
Date |
getDate(int columnIndex) |
Date |
getDate(int columnIndex,
Calendar cal) |
Date |
getDate(String columnName) |
Date |
getDate(String colName,
Calendar cal) |
Timestamp |
getDateTime(int columnIndex) |
Timestamp |
getDateTime(int columnIndex,
Calendar cal) |
Timestamp |
getDateTime(String columnName) |
Timestamp |
getDateTime(String colName,
Calendar cal) |
DateTimeOffset |
getDateTimeOffset(int columnIndex) |
DateTimeOffset |
getDateTimeOffset(String columnName) |
double |
getDouble(int columnIndex) |
double |
getDouble(String columnName) |
int |
getFetchDirection() |
int |
getFetchSize() |
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() |
BigDecimal |
getMoney(int columnIndex) |
BigDecimal |
getMoney(String columnName) |
Reader |
getNCharacterStream(int columnIndex) |
Reader |
getNCharacterStream(String columnLabel) |
NClob |
getNClob(int columnIndex) |
NClob |
getNClob(String columnLabel) |
String |
getNString(int columnIndex) |
String |
getNString(String columnLabel) |
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 columnName,
Class<T> type) |
Object |
getObject(String colName,
Map<String,Class<?>> map) |
Ref |
getRef(int i) |
Ref |
getRef(String colName) |
int |
getRow()
Retrieves the number of the current row in this ResultSet object.
|
RowId |
getRowId(int columnIndex) |
RowId |
getRowId(String columnLabel) |
short |
getShort(int columnIndex) |
short |
getShort(String columnName) |
Timestamp |
getSmallDateTime(int columnIndex) |
Timestamp |
getSmallDateTime(int columnIndex,
Calendar cal) |
Timestamp |
getSmallDateTime(String columnName) |
Timestamp |
getSmallDateTime(String colName,
Calendar cal) |
BigDecimal |
getSmallMoney(int columnIndex) |
BigDecimal |
getSmallMoney(String columnName) |
SQLXML |
getSQLXML(int columnIndex) |
SQLXML |
getSQLXML(String columnLabel) |
Statement |
getStatement() |
String |
getString(int columnIndex) |
String |
getString(String columnName) |
Time |
getTime(int columnIndex) |
Time |
getTime(int columnIndex,
Calendar cal) |
Time |
getTime(String columnName) |
Time |
getTime(String colName,
Calendar cal) |
Timestamp |
getTimestamp(int columnIndex) |
Timestamp |
getTimestamp(int columnIndex,
Calendar cal) |
Timestamp |
getTimestamp(String columnName) |
Timestamp |
getTimestamp(String colName,
Calendar cal) |
int |
getType() |
InputStream |
getUnicodeStream(int columnIndex)
Deprecated.
|
InputStream |
getUnicodeStream(String columnName)
Deprecated.
|
String |
getUniqueIdentifier(int columnIndex) |
String |
getUniqueIdentifier(String columnLabel) |
URL |
getURL(int columnIndex) |
URL |
getURL(String sColumn) |
SQLWarning |
getWarnings() |
void |
insertRow() |
boolean |
isAfterLast() |
boolean |
isBeforeFirst() |
boolean |
isClosed() |
boolean |
isFirst()
Determines whether the cursor is on the first row in this ResultSet object.
|
boolean |
isLast()
Determines whether the cursor is on the last row in this ResultSet object.
|
boolean |
isWrapperFor(Class<?> iface) |
boolean |
last()
Moves the cursor to the last row in this ResultSet object.
|
void |
moveToCurrentRow() |
void |
moveToInsertRow() |
boolean |
next()
Initially moves the cursor to the first row of this ResultSet object, with
subsequent calls moving the cursor to the second row, the third row, and so on.
|
boolean |
previous()
Moves the cursor to the previous row in this ResultSet object.
|
void |
refreshRow() |
boolean |
relative(int rows) |
boolean |
rowDeleted() |
boolean |
rowInserted() |
boolean |
rowUpdated() |
void |
setFetchDirection(int direction) |
void |
setFetchSize(int rows) |
String |
toString() |
<T> T |
unwrap(Class<T> iface) |
void |
updateArray(int columnIndex,
Array x) |
void |
updateArray(String columnName,
Array x) |
void |
updateAsciiStream(int columnIndex,
InputStream x) |
void |
updateAsciiStream(int index,
InputStream x,
int length) |
void |
updateAsciiStream(int columnIndex,
InputStream x,
long length) |
void |
updateAsciiStream(String columnLabel,
InputStream x) |
void |
updateAsciiStream(String columnName,
InputStream x,
int length) |
void |
updateAsciiStream(String columnName,
InputStream streamValue,
long length) |
void |
updateBigDecimal(int index,
BigDecimal x) |
void |
updateBigDecimal(int index,
BigDecimal x,
Integer precision,
Integer scale) |
void |
updateBigDecimal(int index,
BigDecimal x,
Integer precision,
Integer scale,
boolean forceEncrypt) |
void |
updateBigDecimal(String columnName,
BigDecimal x) |
void |
updateBigDecimal(String columnName,
BigDecimal x,
boolean forceEncrypt) |
void |
updateBigDecimal(String columnName,
BigDecimal x,
Integer precision,
Integer scale) |
void |
updateBigDecimal(String columnName,
BigDecimal x,
Integer precision,
Integer scale,
boolean forceEncrypt) |
void |
updateBinaryStream(int columnIndex,
InputStream x) |
void |
updateBinaryStream(int columnIndex,
InputStream streamValue,
int length) |
void |
updateBinaryStream(int columnIndex,
InputStream x,
long length) |
void |
updateBinaryStream(String columnLabel,
InputStream x) |
void |
updateBinaryStream(String columnName,
InputStream streamValue,
int length) |
void |
updateBinaryStream(String columnLabel,
InputStream x,
long length) |
void |
updateBlob(int columnIndex,
Blob blobValue) |
void |
updateBlob(int columnIndex,
InputStream inputStream) |
void |
updateBlob(int columnIndex,
InputStream inputStream,
long length) |
void |
updateBlob(String columnName,
Blob blobValue) |
void |
updateBlob(String columnLabel,
InputStream inputStream) |
void |
updateBlob(String columnLabel,
InputStream inputStream,
long length) |
void |
updateBoolean(int index,
boolean x) |
void |
updateBoolean(int index,
boolean x,
boolean forceEncrypt) |
void |
updateBoolean(String columnName,
boolean x) |
void |
updateBoolean(String columnName,
boolean x,
boolean forceEncrypt) |
void |
updateByte(int index,
byte x) |
void |
updateByte(int index,
byte x,
boolean forceEncrypt) |
void |
updateByte(String columnName,
byte x) |
void |
updateByte(String columnName,
byte x,
boolean forceEncrypt) |
void |
updateBytes(int index,
byte[] x) |
void |
updateBytes(int index,
byte[] x,
boolean forceEncrypt) |
void |
updateBytes(String columnName,
byte[] x) |
void |
updateBytes(String columnName,
byte[] x,
boolean forceEncrypt) |
void |
updateCharacterStream(int columnIndex,
Reader x) |
void |
updateCharacterStream(int columnIndex,
Reader readerValue,
int length) |
void |
updateCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateCharacterStream(String columnLabel,
Reader reader) |
void |
updateCharacterStream(String columnName,
Reader readerValue,
int length) |
void |
updateCharacterStream(String columnLabel,
Reader reader,
long length) |
void |
updateClob(int columnIndex,
Clob clobValue) |
void |
updateClob(int columnIndex,
Reader reader) |
void |
updateClob(int columnIndex,
Reader reader,
long length) |
void |
updateClob(String columnName,
Clob clobValue) |
void |
updateClob(String columnLabel,
Reader reader) |
void |
updateClob(String columnLabel,
Reader reader,
long length) |
void |
updateDate(int index,
Date x) |
void |
updateDate(int index,
Date x,
boolean forceEncrypt) |
void |
updateDate(String columnName,
Date x) |
void |
updateDate(String columnName,
Date x,
boolean forceEncrypt) |
void |
updateDateTime(int index,
Timestamp x) |
void |
updateDateTime(int index,
Timestamp x,
Integer scale) |
void |
updateDateTime(int index,
Timestamp x,
Integer scale,
boolean forceEncrypt) |
void |
updateDateTime(String columnName,
Timestamp x) |
void |
updateDateTime(String columnName,
Timestamp x,
int scale) |
void |
updateDateTime(String columnName,
Timestamp x,
int scale,
boolean forceEncrypt) |
void |
updateDateTimeOffset(int index,
DateTimeOffset x) |
void |
updateDateTimeOffset(int index,
DateTimeOffset x,
Integer scale) |
void |
updateDateTimeOffset(int index,
DateTimeOffset x,
Integer scale,
boolean forceEncrypt) |
void |
updateDateTimeOffset(String columnName,
DateTimeOffset x) |
void |
updateDateTimeOffset(String columnName,
DateTimeOffset x,
int scale) |
void |
updateDateTimeOffset(String columnName,
DateTimeOffset x,
int scale,
boolean forceEncrypt) |
void |
updateDouble(int index,
double x) |
void |
updateDouble(int index,
double x,
boolean forceEncrypt) |
void |
updateDouble(String columnName,
double x) |
void |
updateDouble(String columnName,
double x,
boolean forceEncrypt) |
void |
updateFloat(int index,
float x) |
void |
updateFloat(int index,
float x,
boolean forceEncrypt) |
void |
updateFloat(String columnName,
float x) |
void |
updateFloat(String columnName,
float x,
boolean forceEncrypt) |
void |
updateInt(int index,
int x) |
void |
updateInt(int index,
int x,
boolean forceEncrypt) |
void |
updateInt(String columnName,
int x) |
void |
updateInt(String columnName,
int x,
boolean forceEncrypt) |
void |
updateLong(int index,
long x) |
void |
updateLong(int index,
long x,
boolean forceEncrypt) |
void |
updateLong(String columnName,
long x) |
void |
updateLong(String columnName,
long x,
boolean forceEncrypt) |
void |
updateMoney(int index,
BigDecimal x) |
void |
updateMoney(int index,
BigDecimal x,
boolean forceEncrypt) |
void |
updateMoney(String columnName,
BigDecimal x) |
void |
updateMoney(String columnName,
BigDecimal x,
boolean forceEncrypt) |
void |
updateNCharacterStream(int columnIndex,
Reader x) |
void |
updateNCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateNCharacterStream(String columnLabel,
Reader reader) |
void |
updateNCharacterStream(String columnLabel,
Reader reader,
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 columnLabel,
NClob nClob) |
void |
updateNClob(String columnLabel,
Reader reader) |
void |
updateNClob(String columnLabel,
Reader reader,
long length) |
void |
updateNString(int columnIndex,
String nString) |
void |
updateNString(int columnIndex,
String nString,
boolean forceEncrypt) |
void |
updateNString(String columnLabel,
String nString) |
void |
updateNString(String columnLabel,
String nString,
boolean forceEncrypt) |
void |
updateNull(int index) |
void |
updateNull(String columnName) |
void |
updateObject(int index,
Object obj) |
void |
updateObject(int index,
Object x,
int scale) |
protected void |
updateObject(int index,
Object x,
Integer scale,
com.microsoft.sqlserver.jdbc.JDBCType jdbcType,
Integer precision,
boolean forceEncrypt) |
void |
updateObject(int index,
Object x,
int precision,
int scale) |
void |
updateObject(int index,
Object x,
int precision,
int scale,
boolean forceEncrypt) |
void |
updateObject(String columnName,
Object x) |
void |
updateObject(String columnName,
Object x,
int scale) |
void |
updateObject(String columnName,
Object x,
int precision,
int scale) |
void |
updateObject(String columnName,
Object x,
int precision,
int scale,
boolean forceEncrypt) |
void |
updateRef(int columnIndex,
Ref x) |
void |
updateRef(String columnName,
Ref x) |
void |
updateRow() |
void |
updateRowId(int columnIndex,
RowId x) |
void |
updateRowId(String columnLabel,
RowId x) |
void |
updateShort(int index,
short x) |
void |
updateShort(int index,
short x,
boolean forceEncrypt) |
void |
updateShort(String columnName,
short x) |
void |
updateShort(String columnName,
short x,
boolean forceEncrypt) |
void |
updateSmallDateTime(int index,
Timestamp x) |
void |
updateSmallDateTime(int index,
Timestamp x,
Integer scale) |
void |
updateSmallDateTime(int index,
Timestamp x,
Integer scale,
boolean forceEncrypt) |
void |
updateSmallDateTime(String columnName,
Timestamp x) |
void |
updateSmallDateTime(String columnName,
Timestamp x,
int scale) |
void |
updateSmallDateTime(String columnName,
Timestamp x,
int scale,
boolean forceEncrypt) |
void |
updateSmallMoney(int index,
BigDecimal x) |
void |
updateSmallMoney(int index,
BigDecimal x,
boolean forceEncrypt) |
void |
updateSmallMoney(String columnName,
BigDecimal x) |
void |
updateSmallMoney(String columnName,
BigDecimal x,
boolean forceEncrypt) |
void |
updateSQLXML(int columnIndex,
SQLXML xmlObject) |
void |
updateSQLXML(String columnLabel,
SQLXML x) |
void |
updateString(int columnIndex,
String stringValue) |
void |
updateString(int columnIndex,
String stringValue,
boolean forceEncrypt) |
void |
updateString(String columnName,
String x) |
void |
updateString(String columnName,
String x,
boolean forceEncrypt) |
void |
updateTime(int index,
Time x) |
void |
updateTime(int index,
Time x,
Integer scale) |
void |
updateTime(int index,
Time x,
Integer scale,
boolean forceEncrypt) |
void |
updateTime(String columnName,
Time x) |
void |
updateTime(String columnName,
Time x,
int scale) |
void |
updateTime(String columnName,
Time x,
int scale,
boolean forceEncrypt) |
void |
updateTimestamp(int index,
Timestamp x) |
void |
updateTimestamp(int index,
Timestamp x,
int scale) |
void |
updateTimestamp(int index,
Timestamp x,
int scale,
boolean forceEncrypt) |
void |
updateTimestamp(String columnName,
Timestamp x) |
void |
updateTimestamp(String columnName,
Timestamp x,
int scale) |
void |
updateTimestamp(String columnName,
Timestamp x,
int scale,
boolean forceEncrypt) |
void |
updateUniqueIdentifier(int index,
String x) |
void |
updateUniqueIdentifier(int index,
String x,
boolean forceEncrypt) |
void |
updateUniqueIdentifier(String columnName,
String x) |
void |
updateUniqueIdentifier(String columnName,
String x,
boolean forceEncrypt) |
boolean |
wasNull() |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
updateObject, updateObject, updateObject, updateObject
protected static final Logger loggerExternal
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
public boolean isClosed() throws SQLException
isClosed
in interface ResultSet
SQLException
public void close() throws SQLServerException
close
in interface AutoCloseable
close
in interface ResultSet
SQLServerException
public int findColumn(String columnName) throws SQLServerException
findColumn
in interface ResultSet
columnName
- the nameSQLServerException
public void clearWarnings() throws SQLServerException
clearWarnings
in interface ResultSet
SQLServerException
public boolean relative(int rows) throws SQLServerException
relative
in interface ResultSet
SQLServerException
public boolean next() throws SQLServerException
next
in interface ResultSet
SQLServerException
public boolean wasNull() throws SQLServerException
wasNull
in interface ResultSet
SQLServerException
public boolean isBeforeFirst() throws SQLServerException
isBeforeFirst
in interface ResultSet
SQLServerException
public boolean isAfterLast() throws SQLServerException
isAfterLast
in interface ResultSet
SQLServerException
public boolean isFirst() throws SQLServerException
isFirst
in interface ResultSet
SQLServerException
public boolean isLast() throws SQLServerException
isLast
in interface ResultSet
SQLServerException
public void beforeFirst() throws SQLServerException
beforeFirst
in interface ResultSet
SQLServerException
public void afterLast() throws SQLServerException
afterLast
in interface ResultSet
SQLServerException
public boolean first() throws SQLServerException
first
in interface ResultSet
SQLServerException
public boolean last() throws SQLServerException
last
in interface ResultSet
SQLServerException
public int getRow() throws SQLServerException
getRow
in interface ResultSet
SQLServerException
public boolean absolute(int row) throws SQLServerException
absolute
in interface ResultSet
SQLServerException
public boolean previous() throws SQLServerException
previous
in interface ResultSet
SQLServerException
public SQLWarning getWarnings() throws SQLServerException
getWarnings
in interface ResultSet
SQLServerException
public void setFetchDirection(int direction) throws SQLServerException
setFetchDirection
in interface ResultSet
SQLServerException
public int getFetchDirection() throws SQLServerException
getFetchDirection
in interface ResultSet
SQLServerException
public void setFetchSize(int rows) throws SQLServerException
setFetchSize
in interface ResultSet
SQLServerException
public int getFetchSize() throws SQLServerException
getFetchSize
in interface ResultSet
SQLServerException
public int getType() throws SQLServerException
getType
in interface ResultSet
SQLServerException
public int getConcurrency() throws SQLServerException
getConcurrency
in interface ResultSet
SQLServerException
public InputStream getAsciiStream(int columnIndex) throws SQLServerException
getAsciiStream
in interface ResultSet
SQLServerException
public InputStream getAsciiStream(String columnName) throws SQLServerException
getAsciiStream
in interface ResultSet
SQLServerException
@Deprecated public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLServerException
getBigDecimal
in interface ResultSet
SQLServerException
@Deprecated public BigDecimal getBigDecimal(String columnName, int scale) throws SQLServerException
getBigDecimal
in interface ResultSet
SQLServerException
public InputStream getBinaryStream(int columnIndex) throws SQLServerException
getBinaryStream
in interface ResultSet
SQLServerException
public InputStream getBinaryStream(String columnName) throws SQLServerException
getBinaryStream
in interface ResultSet
SQLServerException
public boolean getBoolean(int columnIndex) throws SQLServerException
getBoolean
in interface ResultSet
SQLServerException
public boolean getBoolean(String columnName) throws SQLServerException
getBoolean
in interface ResultSet
SQLServerException
public byte getByte(int columnIndex) throws SQLServerException
getByte
in interface ResultSet
SQLServerException
public byte getByte(String columnName) throws SQLServerException
getByte
in interface ResultSet
SQLServerException
public byte[] getBytes(int columnIndex) throws SQLServerException
getBytes
in interface ResultSet
SQLServerException
public byte[] getBytes(String columnName) throws SQLServerException
getBytes
in interface ResultSet
SQLServerException
public Date getDate(int columnIndex) throws SQLServerException
getDate
in interface ResultSet
SQLServerException
public Date getDate(String columnName) throws SQLServerException
getDate
in interface ResultSet
SQLServerException
public Date getDate(int columnIndex, Calendar cal) throws SQLServerException
getDate
in interface ResultSet
SQLServerException
public Date getDate(String colName, Calendar cal) throws SQLServerException
getDate
in interface ResultSet
SQLServerException
public double getDouble(int columnIndex) throws SQLServerException
getDouble
in interface ResultSet
SQLServerException
public double getDouble(String columnName) throws SQLServerException
getDouble
in interface ResultSet
SQLServerException
public float getFloat(int columnIndex) throws SQLServerException
getFloat
in interface ResultSet
SQLServerException
public float getFloat(String columnName) throws SQLServerException
getFloat
in interface ResultSet
SQLServerException
public int getInt(int columnIndex) throws SQLServerException
getInt
in interface ResultSet
SQLServerException
public int getInt(String columnName) throws SQLServerException
getInt
in interface ResultSet
SQLServerException
public long getLong(int columnIndex) throws SQLServerException
getLong
in interface ResultSet
SQLServerException
public long getLong(String columnName) throws SQLServerException
getLong
in interface ResultSet
SQLServerException
public ResultSetMetaData getMetaData() throws SQLServerException
getMetaData
in interface ResultSet
SQLServerException
public Object getObject(int columnIndex) throws SQLServerException
getObject
in interface ResultSet
SQLServerException
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException
getObject
in interface ResultSet
SQLException
public Object getObject(String columnName) throws SQLServerException
getObject
in interface ResultSet
SQLServerException
public <T> T getObject(String columnName, Class<T> type) throws SQLException
getObject
in interface ResultSet
SQLException
public short getShort(int columnIndex) throws SQLServerException
getShort
in interface ResultSet
SQLServerException
public short getShort(String columnName) throws SQLServerException
getShort
in interface ResultSet
SQLServerException
public String getString(int columnIndex) throws SQLServerException
getString
in interface ResultSet
SQLServerException
public String getString(String columnName) throws SQLServerException
getString
in interface ResultSet
SQLServerException
public String getNString(int columnIndex) throws SQLException
getNString
in interface ResultSet
SQLException
public String getNString(String columnLabel) throws SQLException
getNString
in interface ResultSet
SQLException
public String getUniqueIdentifier(int columnIndex) throws SQLException
SQLException
public String getUniqueIdentifier(String columnLabel) throws SQLException
SQLException
public Time getTime(int columnIndex) throws SQLServerException
getTime
in interface ResultSet
SQLServerException
public Time getTime(String columnName) throws SQLServerException
getTime
in interface ResultSet
SQLServerException
public Time getTime(int columnIndex, Calendar cal) throws SQLServerException
getTime
in interface ResultSet
SQLServerException
public Time getTime(String colName, Calendar cal) throws SQLServerException
getTime
in interface ResultSet
SQLServerException
public Timestamp getTimestamp(int columnIndex) throws SQLServerException
getTimestamp
in interface ResultSet
SQLServerException
public Timestamp getTimestamp(String columnName) throws SQLServerException
getTimestamp
in interface ResultSet
SQLServerException
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLServerException
getTimestamp
in interface ResultSet
SQLServerException
public Timestamp getTimestamp(String colName, Calendar cal) throws SQLServerException
getTimestamp
in interface ResultSet
SQLServerException
public Timestamp getDateTime(int columnIndex) throws SQLServerException
SQLServerException
public Timestamp getDateTime(String columnName) throws SQLServerException
SQLServerException
public Timestamp getDateTime(int columnIndex, Calendar cal) throws SQLServerException
SQLServerException
public Timestamp getDateTime(String colName, Calendar cal) throws SQLServerException
SQLServerException
public Timestamp getSmallDateTime(int columnIndex) throws SQLServerException
SQLServerException
public Timestamp getSmallDateTime(String columnName) throws SQLServerException
SQLServerException
public Timestamp getSmallDateTime(int columnIndex, Calendar cal) throws SQLServerException
SQLServerException
public Timestamp getSmallDateTime(String colName, Calendar cal) throws SQLServerException
SQLServerException
public DateTimeOffset getDateTimeOffset(int columnIndex) throws SQLException
getDateTimeOffset
in interface ISQLServerResultSet
SQLException
public DateTimeOffset getDateTimeOffset(String columnName) throws SQLException
getDateTimeOffset
in interface ISQLServerResultSet
SQLException
@Deprecated public InputStream getUnicodeStream(int columnIndex) throws SQLServerException
getUnicodeStream
in interface ResultSet
SQLServerException
@Deprecated public InputStream getUnicodeStream(String columnName) throws SQLServerException
getUnicodeStream
in interface ResultSet
SQLServerException
public Object getObject(int i, Map<String,Class<?>> map) throws SQLServerException
getObject
in interface ResultSet
SQLServerException
public Ref getRef(int i) throws SQLServerException
getRef
in interface ResultSet
SQLServerException
public Blob getBlob(int i) throws SQLServerException
getBlob
in interface ResultSet
SQLServerException
public Blob getBlob(String colName) throws SQLServerException
getBlob
in interface ResultSet
SQLServerException
public Clob getClob(int columnIndex) throws SQLServerException
getClob
in interface ResultSet
SQLServerException
public Clob getClob(String colName) throws SQLServerException
getClob
in interface ResultSet
SQLServerException
public NClob getNClob(int columnIndex) throws SQLException
getNClob
in interface ResultSet
SQLException
public NClob getNClob(String columnLabel) throws SQLException
getNClob
in interface ResultSet
SQLException
public Array getArray(int i) throws SQLServerException
getArray
in interface ResultSet
SQLServerException
public Object getObject(String colName, Map<String,Class<?>> map) throws SQLServerException
getObject
in interface ResultSet
SQLServerException
public Ref getRef(String colName) throws SQLServerException
getRef
in interface ResultSet
SQLServerException
public Array getArray(String colName) throws SQLServerException
getArray
in interface ResultSet
SQLServerException
public String getCursorName() throws SQLServerException
getCursorName
in interface ResultSet
SQLServerException
public Reader getCharacterStream(int columnIndex) throws SQLServerException
getCharacterStream
in interface ResultSet
SQLServerException
public Reader getCharacterStream(String columnName) throws SQLServerException
getCharacterStream
in interface ResultSet
SQLServerException
public Reader getNCharacterStream(int columnIndex) throws SQLException
getNCharacterStream
in interface ResultSet
SQLException
public Reader getNCharacterStream(String columnLabel) throws SQLException
getNCharacterStream
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(int columnIndex) throws SQLServerException
getBigDecimal
in interface ResultSet
SQLServerException
public BigDecimal getBigDecimal(String columnName) throws SQLServerException
getBigDecimal
in interface ResultSet
SQLServerException
public BigDecimal getMoney(int columnIndex) throws SQLServerException
SQLServerException
public BigDecimal getMoney(String columnName) throws SQLServerException
SQLServerException
public BigDecimal getSmallMoney(int columnIndex) throws SQLServerException
SQLServerException
public BigDecimal getSmallMoney(String columnName) throws SQLServerException
SQLServerException
public RowId getRowId(int columnIndex) throws SQLException
getRowId
in interface ResultSet
SQLException
public RowId getRowId(String columnLabel) throws SQLException
getRowId
in interface ResultSet
SQLException
public SQLXML getSQLXML(int columnIndex) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public SQLXML getSQLXML(String columnLabel) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public boolean rowUpdated() throws SQLServerException
rowUpdated
in interface ResultSet
SQLServerException
public boolean rowInserted() throws SQLServerException
rowInserted
in interface ResultSet
SQLServerException
public boolean rowDeleted() throws SQLServerException
rowDeleted
in interface ResultSet
SQLServerException
public void updateNull(int index) throws SQLServerException
updateNull
in interface ResultSet
SQLServerException
public void updateBoolean(int index, boolean x) throws SQLServerException
updateBoolean
in interface ResultSet
SQLServerException
public void updateBoolean(int index, boolean x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateByte(int index, byte x) throws SQLServerException
updateByte
in interface ResultSet
SQLServerException
public void updateByte(int index, byte x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateShort(int index, short x) throws SQLServerException
updateShort
in interface ResultSet
SQLServerException
public void updateShort(int index, short x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateInt(int index, int x) throws SQLServerException
updateInt
in interface ResultSet
SQLServerException
public void updateInt(int index, int x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateLong(int index, long x) throws SQLServerException
updateLong
in interface ResultSet
SQLServerException
public void updateLong(int index, long x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateFloat(int index, float x) throws SQLServerException
updateFloat
in interface ResultSet
SQLServerException
public void updateFloat(int index, float x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDouble(int index, double x) throws SQLServerException
updateDouble
in interface ResultSet
SQLServerException
public void updateDouble(int index, double x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateMoney(int index, BigDecimal x) throws SQLServerException
SQLServerException
public void updateMoney(int index, BigDecimal x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateMoney(String columnName, BigDecimal x) throws SQLServerException
SQLServerException
public void updateMoney(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateSmallMoney(int index, BigDecimal x) throws SQLServerException
SQLServerException
public void updateSmallMoney(int index, BigDecimal x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateSmallMoney(String columnName, BigDecimal x) throws SQLServerException
SQLServerException
public void updateSmallMoney(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateBigDecimal(int index, BigDecimal x) throws SQLServerException
updateBigDecimal
in interface ResultSet
SQLServerException
public void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale) throws SQLServerException
SQLServerException
public void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateString(int columnIndex, String stringValue) throws SQLServerException
updateString
in interface ResultSet
SQLServerException
public void updateString(int columnIndex, String stringValue, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateNString(int columnIndex, String nString) throws SQLException
updateNString
in interface ResultSet
SQLException
public void updateNString(int columnIndex, String nString, boolean forceEncrypt) throws SQLException
SQLException
public void updateNString(String columnLabel, String nString) throws SQLException
updateNString
in interface ResultSet
SQLException
public void updateNString(String columnLabel, String nString, boolean forceEncrypt) throws SQLException
SQLException
public void updateBytes(int index, byte[] x) throws SQLServerException
updateBytes
in interface ResultSet
SQLServerException
public void updateBytes(int index, byte[] x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDate(int index, Date x) throws SQLServerException
updateDate
in interface ResultSet
SQLServerException
public void updateDate(int index, Date x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateTime(int index, Time x) throws SQLServerException
updateTime
in interface ResultSet
SQLServerException
public void updateTime(int index, Time x, Integer scale) throws SQLServerException
SQLServerException
public void updateTime(int index, Time x, Integer scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateTimestamp(int index, Timestamp x) throws SQLServerException
updateTimestamp
in interface ResultSet
SQLServerException
public void updateTimestamp(int index, Timestamp x, int scale) throws SQLServerException
SQLServerException
public void updateTimestamp(int index, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDateTime(int index, Timestamp x) throws SQLServerException
SQLServerException
public void updateDateTime(int index, Timestamp x, Integer scale) throws SQLServerException
SQLServerException
public void updateDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateSmallDateTime(int index, Timestamp x) throws SQLServerException
SQLServerException
public void updateSmallDateTime(int index, Timestamp x, Integer scale) throws SQLServerException
SQLServerException
public void updateSmallDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDateTimeOffset(int index, DateTimeOffset x) throws SQLException
updateDateTimeOffset
in interface ISQLServerResultSet
SQLException
public void updateDateTimeOffset(int index, DateTimeOffset x, Integer scale) throws SQLException
SQLException
public void updateDateTimeOffset(int index, DateTimeOffset x, Integer scale, boolean forceEncrypt) throws SQLException
SQLException
public void updateUniqueIdentifier(int index, String x) throws SQLException
SQLException
public void updateUniqueIdentifier(int index, String x, boolean forceEncrypt) throws SQLException
SQLException
public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(int index, InputStream x, int length) throws SQLServerException
updateAsciiStream
in interface ResultSet
SQLServerException
public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLServerException
updateAsciiStream
in interface ResultSet
SQLServerException
public void updateAsciiStream(String columnName, InputStream streamValue, long length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream streamValue, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnName, InputStream streamValue, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader x) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader readerValue, int length) throws SQLServerException
updateCharacterStream
in interface ResultSet
SQLServerException
public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnName, Reader readerValue, int length) throws SQLServerException
updateCharacterStream
in interface ResultSet
SQLServerException
public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(int columnIndex, 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 columnLabel, Reader reader) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateObject(int index, Object obj) throws SQLServerException
updateObject
in interface ResultSet
SQLServerException
public void updateObject(int index, Object x, int scale) throws SQLServerException
updateObject
in interface ResultSet
SQLServerException
public void updateObject(int index, Object x, int precision, int scale) throws SQLServerException
SQLServerException
public void updateObject(int index, Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
protected final void updateObject(int index, Object x, Integer scale, com.microsoft.sqlserver.jdbc.JDBCType jdbcType, Integer precision, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateNull(String columnName) throws SQLServerException
updateNull
in interface ResultSet
SQLServerException
public void updateBoolean(String columnName, boolean x) throws SQLServerException
updateBoolean
in interface ResultSet
SQLServerException
public void updateBoolean(String columnName, boolean x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateByte(String columnName, byte x) throws SQLServerException
updateByte
in interface ResultSet
SQLServerException
public void updateByte(String columnName, byte x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateShort(String columnName, short x) throws SQLServerException
updateShort
in interface ResultSet
SQLServerException
public void updateShort(String columnName, short x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateInt(String columnName, int x) throws SQLServerException
updateInt
in interface ResultSet
SQLServerException
public void updateInt(String columnName, int x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateLong(String columnName, long x) throws SQLServerException
updateLong
in interface ResultSet
SQLServerException
public void updateLong(String columnName, long x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateFloat(String columnName, float x) throws SQLServerException
updateFloat
in interface ResultSet
SQLServerException
public void updateFloat(String columnName, float x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDouble(String columnName, double x) throws SQLServerException
updateDouble
in interface ResultSet
SQLServerException
public void updateDouble(String columnName, double x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLServerException
updateBigDecimal
in interface ResultSet
SQLServerException
public void updateBigDecimal(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale) throws SQLServerException
SQLServerException
public void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateString(String columnName, String x) throws SQLServerException
updateString
in interface ResultSet
SQLServerException
public void updateString(String columnName, String x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateBytes(String columnName, byte[] x) throws SQLServerException
updateBytes
in interface ResultSet
SQLServerException
public void updateBytes(String columnName, byte[] x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDate(String columnName, Date x) throws SQLServerException
updateDate
in interface ResultSet
SQLServerException
public void updateDate(String columnName, Date x, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateTime(String columnName, Time x) throws SQLServerException
updateTime
in interface ResultSet
SQLServerException
public void updateTime(String columnName, Time x, int scale) throws SQLServerException
SQLServerException
public void updateTime(String columnName, Time x, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateTimestamp(String columnName, Timestamp x) throws SQLServerException
updateTimestamp
in interface ResultSet
SQLServerException
public void updateTimestamp(String columnName, Timestamp x, int scale) throws SQLServerException
SQLServerException
public void updateTimestamp(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDateTime(String columnName, Timestamp x) throws SQLServerException
SQLServerException
public void updateDateTime(String columnName, Timestamp x, int scale) throws SQLServerException
SQLServerException
public void updateDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateSmallDateTime(String columnName, Timestamp x) throws SQLServerException
SQLServerException
public void updateSmallDateTime(String columnName, Timestamp x, int scale) throws SQLServerException
SQLServerException
public void updateSmallDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateDateTimeOffset(String columnName, DateTimeOffset x) throws SQLException
updateDateTimeOffset
in interface ISQLServerResultSet
SQLException
public void updateDateTimeOffset(String columnName, DateTimeOffset x, int scale) throws SQLException
SQLException
public void updateDateTimeOffset(String columnName, DateTimeOffset x, int scale, boolean forceEncrypt) throws SQLException
SQLException
public void updateUniqueIdentifier(String columnName, String x) throws SQLException
SQLException
public void updateUniqueIdentifier(String columnName, String x, boolean forceEncrypt) throws SQLException
SQLException
public void updateObject(String columnName, Object x, int scale) throws SQLServerException
updateObject
in interface ResultSet
SQLServerException
public void updateObject(String columnName, Object x, int precision, int scale) throws SQLServerException
SQLServerException
public void updateObject(String columnName, Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateObject(String columnName, Object x) throws SQLServerException
updateObject
in interface ResultSet
SQLServerException
public void updateRowId(int columnIndex, RowId x) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void updateRowId(String columnLabel, RowId x) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public void updateSQLXML(String columnLabel, SQLXML x) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public int getHoldability() throws SQLException
getHoldability
in interface ResultSet
SQLException
public void insertRow() throws SQLServerException
insertRow
in interface ResultSet
SQLServerException
public void updateRow() throws SQLServerException
updateRow
in interface ResultSet
SQLServerException
public void deleteRow() throws SQLServerException
deleteRow
in interface ResultSet
SQLServerException
public void refreshRow() throws SQLServerException
refreshRow
in interface ResultSet
SQLServerException
public void cancelRowUpdates() throws SQLServerException
cancelRowUpdates
in interface ResultSet
SQLServerException
public void moveToInsertRow() throws SQLServerException
moveToInsertRow
in interface ResultSet
SQLServerException
public void moveToCurrentRow() throws SQLServerException
moveToCurrentRow
in interface ResultSet
SQLServerException
public Statement getStatement() throws SQLServerException
getStatement
in interface ResultSet
SQLServerException
public void updateClob(int columnIndex, Clob clobValue) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Reader reader) throws SQLException
updateClob
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, Clob clobValue) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnLabel, Reader reader) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnLabel, Reader reader, long length) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateNClob(int columnIndex, 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(int columnIndex, Reader reader, long length) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnLabel, NClob nClob) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnLabel, Reader reader) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, Blob blobValue) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException
updateBlob
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, Blob blobValue) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateArray(int columnIndex, Array x) throws SQLServerException
updateArray
in interface ResultSet
SQLServerException
public void updateArray(String columnName, Array x) throws SQLServerException
updateArray
in interface ResultSet
SQLServerException
public void updateRef(int columnIndex, Ref x) throws SQLServerException
updateRef
in interface ResultSet
SQLServerException
public void updateRef(String columnName, Ref x) throws SQLServerException
updateRef
in interface ResultSet
SQLServerException
public URL getURL(int columnIndex) throws SQLServerException
getURL
in interface ResultSet
SQLServerException
public URL getURL(String sColumn) throws SQLServerException
getURL
in interface ResultSet
SQLServerException
Copyright © 2016. All rights reserved.