ISQLServerResultSet
, java.io.Serializable
, java.lang.AutoCloseable
, java.sql.ResultSet
, java.sql.Wrapper
public class SQLServerResultSet extends java.lang.Object implements ISQLServerResultSet, java.io.Serializable
Modifier and Type | Field | Description |
---|---|---|
protected static java.util.logging.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
Modifier and Type | Method | Description |
---|---|---|
boolean |
absolute(int row) |
Moves the cursor to the given row number in this
ResultSet object. |
void |
afterLast() |
|
void |
beforeFirst() |
|
void |
cancelRowUpdates() |
|
void |
clearWarnings() |
Clears result set warnings.
|
void |
close() |
|
void |
deleteRow() |
|
int |
findColumn(java.lang.String columnName) |
Finds a column index given a column name.
|
boolean |
first() |
Moves the cursor to the first row in this
ResultSet object. |
java.sql.Array |
getArray(int i) |
|
java.sql.Array |
getArray(java.lang.String colName) |
|
java.io.InputStream |
getAsciiStream(int columnIndex) |
|
java.io.InputStream |
getAsciiStream(java.lang.String columnName) |
|
java.math.BigDecimal |
getBigDecimal(int columnIndex) |
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName) |
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale) |
Deprecated.
|
java.io.InputStream |
getBinaryStream(int columnIndex) |
|
java.io.InputStream |
getBinaryStream(java.lang.String columnName) |
|
java.sql.Blob |
getBlob(int i) |
|
java.sql.Blob |
getBlob(java.lang.String colName) |
|
boolean |
getBoolean(int columnIndex) |
|
boolean |
getBoolean(java.lang.String columnName) |
|
byte |
getByte(int columnIndex) |
|
byte |
getByte(java.lang.String columnName) |
|
byte[] |
getBytes(int columnIndex) |
|
byte[] |
getBytes(java.lang.String columnName) |
|
java.io.Reader |
getCharacterStream(int columnIndex) |
|
java.io.Reader |
getCharacterStream(java.lang.String columnName) |
|
java.sql.Clob |
getClob(int columnIndex) |
|
java.sql.Clob |
getClob(java.lang.String colName) |
|
int |
getConcurrency() |
|
java.lang.String |
getCursorName() |
|
java.sql.Date |
getDate(int columnIndex) |
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal) |
|
java.sql.Date |
getDate(java.lang.String columnName) |
|
java.sql.Date |
getDate(java.lang.String colName,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getDateTime(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getDateTime(int columnIndex,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getDateTime(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getDateTime(java.lang.String colName,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
DateTimeOffset |
getDateTimeOffset(int columnIndex) |
Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column
ordinal.
|
DateTimeOffset |
getDateTimeOffset(java.lang.String columnName) |
Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.
|
double |
getDouble(int columnIndex) |
|
double |
getDouble(java.lang.String columnName) |
|
int |
getFetchDirection() |
|
int |
getFetchSize() |
|
float |
getFloat(int columnIndex) |
|
float |
getFloat(java.lang.String columnName) |
|
Geography |
getGeography(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.
|
Geography |
getGeography(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.
|
Geometry |
getGeometry(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.
|
Geometry |
getGeometry(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.
|
int |
getHoldability() |
|
int |
getInt(int columnIndex) |
|
int |
getInt(java.lang.String columnName) |
|
long |
getLong(int columnIndex) |
|
long |
getLong(java.lang.String columnName) |
|
java.sql.ResultSetMetaData |
getMetaData() |
|
java.math.BigDecimal |
getMoney(int columnIndex) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getMoney(java.lang.String columnName) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.io.Reader |
getNCharacterStream(int columnIndex) |
|
java.io.Reader |
getNCharacterStream(java.lang.String columnLabel) |
|
java.sql.NClob |
getNClob(int columnIndex) |
|
java.sql.NClob |
getNClob(java.lang.String columnLabel) |
|
java.lang.String |
getNString(int columnIndex) |
|
java.lang.String |
getNString(java.lang.String columnLabel) |
|
java.lang.Object |
getObject(int columnIndex) |
|
<T> T |
getObject(int columnIndex,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
|
java.lang.Object |
getObject(java.lang.String columnName) |
|
<T> T |
getObject(java.lang.String columnName,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
|
java.sql.Ref |
getRef(int i) |
|
java.sql.Ref |
getRef(java.lang.String colName) |
|
int |
getRow() |
|
java.sql.RowId |
getRowId(int columnIndex) |
|
java.sql.RowId |
getRowId(java.lang.String columnLabel) |
|
SensitivityClassification |
getSensitivityClassification() |
Returns the Data Classification information for the current ResultSet For SQL Servers that do not support Data
Classification or results that do not fetch any classified columns, this data can be null.
|
protected int |
getServerCursorId() |
|
short |
getShort(int columnIndex) |
|
short |
getShort(java.lang.String columnName) |
|
java.sql.Timestamp |
getSmallDateTime(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getSmallDateTime(int columnIndex,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getSmallDateTime(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getSmallDateTime(java.lang.String colName,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.math.BigDecimal |
getSmallMoney(int columnIndex) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getSmallMoney(java.lang.String columnName) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.sql.SQLXML |
getSQLXML(int columnIndex) |
|
java.sql.SQLXML |
getSQLXML(java.lang.String columnLabel) |
|
java.sql.Statement |
getStatement() |
|
java.lang.String |
getString(int columnIndex) |
|
java.lang.String |
getString(java.lang.String columnName) |
|
protected com.microsoft.sqlserver.jdbc.TDSReader |
getTDSReader() |
|
java.sql.Time |
getTime(int columnIndex) |
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal) |
|
java.sql.Time |
getTime(java.lang.String columnName) |
|
java.sql.Time |
getTime(java.lang.String colName,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(int columnIndex) |
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String colName,
java.util.Calendar cal) |
|
int |
getType() |
|
java.io.InputStream |
getUnicodeStream(int columnIndex) |
Deprecated.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName) |
Deprecated.
|
java.lang.String |
getUniqueIdentifier(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a String object in the
Java programming language.
|
java.lang.String |
getUniqueIdentifier(java.lang.String columnLabel) |
Returns the value of the designated column in the current row of this ResultSet object as a String object in the
Java programming language.
|
java.net.URL |
getURL(int columnIndex) |
|
java.net.URL |
getURL(java.lang.String sColumn) |
|
java.sql.SQLWarning |
getWarnings() |
|
void |
insertRow() |
|
boolean |
isAfterLast() |
|
boolean |
isBeforeFirst() |
Returns if the cursor is before the first row in this result set.
|
boolean |
isClosed() |
|
boolean |
isFirst() |
Returns whether the cursor is on the first row of this
ResultSet object. |
protected boolean |
isForwardOnly() |
|
boolean |
isLast() |
Returns whether the cursor is on the last row of this
ResultSet object. |
boolean |
isWrapperFor(java.lang.Class<?> iface) |
|
boolean |
last() |
Moves the cursor to the last row in this
ResultSet object. |
void |
moveToCurrentRow() |
|
void |
moveToInsertRow() |
|
boolean |
next() |
Moves the cursor to the first row of this ResultSet object initially, then subsequent calls move 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) |
|
java.lang.String |
toString() |
|
<T> T |
unwrap(java.lang.Class<T> iface) |
|
void |
updateArray(int columnIndex,
java.sql.Array x) |
|
void |
updateArray(java.lang.String columnName,
java.sql.Array x) |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x) |
|
void |
updateAsciiStream(int index,
java.io.InputStream x,
int length) |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length) |
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x) |
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length) |
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream streamValue,
long length) |
|
void |
updateBigDecimal(int index,
java.math.BigDecimal x) |
|
void |
updateBigDecimal(int index,
java.math.BigDecimal x,
java.lang.Integer precision,
java.lang.Integer scale) |
Updates the designated column with a
java.math.BigDecimal value. |
void |
updateBigDecimal(int index,
java.math.BigDecimal x,
java.lang.Integer precision,
java.lang.Integer scale,
boolean forceEncrypt) |
Updates the designated column with a
java.math.BigDecimal value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x) |
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.BigDecimal value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x,
java.lang.Integer precision,
java.lang.Integer scale) |
Updates the designated column with a
java.sql.BigDecimal value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x,
java.lang.Integer precision,
java.lang.Integer scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.BigDecimal value. |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x) |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream streamValue,
int length) |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length) |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x) |
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream streamValue,
int length) |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length) |
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream) |
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length) |
|
void |
updateBlob(int columnIndex,
java.sql.Blob blobValue) |
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream) |
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length) |
|
void |
updateBlob(java.lang.String columnName,
java.sql.Blob blobValue) |
|
void |
updateBoolean(int index,
boolean x) |
|
void |
updateBoolean(int index,
boolean x,
boolean forceEncrypt) |
Updates the designated column with a
boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean x) |
|
void |
updateBoolean(java.lang.String columnName,
boolean x,
boolean forceEncrypt) |
Updates the designated column with a
boolean value. |
void |
updateByte(int index,
byte x) |
|
void |
updateByte(int index,
byte x,
boolean forceEncrypt) |
Updates the designated column with a
byte value. |
void |
updateByte(java.lang.String columnName,
byte x) |
|
void |
updateByte(java.lang.String columnName,
byte x,
boolean forceEncrypt) |
Updates the designated column with a
byte value. |
void |
updateBytes(int index,
byte[] x) |
|
void |
updateBytes(int index,
byte[] x,
boolean forceEncrypt) |
Updates the designated column with a
byte array value. |
void |
updateBytes(java.lang.String columnName,
byte[] x) |
|
void |
updateBytes(java.lang.String columnName,
byte[] x,
boolean forceEncrypt) |
Updates the designated column with a byte array value.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x) |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader readerValue,
int length) |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length) |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader) |
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader readerValue,
int length) |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
|
void |
updateClob(int columnIndex,
java.io.Reader reader) |
|
void |
updateClob(int columnIndex,
java.io.Reader reader,
long length) |
|
void |
updateClob(int columnIndex,
java.sql.Clob clobValue) |
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader) |
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
|
void |
updateClob(java.lang.String columnName,
java.sql.Clob clobValue) |
|
void |
updateDate(int index,
java.sql.Date x) |
|
void |
updateDate(int index,
java.sql.Date x,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Date value. |
void |
updateDate(java.lang.String columnName,
java.sql.Date x) |
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Date value. |
void |
updateDateTime(int index,
java.sql.Timestamp x) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateDateTime(int index,
java.sql.Timestamp x,
java.lang.Integer scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateDateTime(int index,
java.sql.Timestamp x,
java.lang.Integer scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateDateTime(java.lang.String columnName,
java.sql.Timestamp x) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateDateTime(java.lang.String columnName,
java.sql.Timestamp x,
int scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateDateTime(java.lang.String columnName,
java.sql.Timestamp x,
int scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateDateTimeOffset(int index,
DateTimeOffset x) |
Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
|
void |
updateDateTimeOffset(int index,
DateTimeOffset x,
java.lang.Integer scale) |
Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
|
void |
updateDateTimeOffset(int index,
DateTimeOffset x,
java.lang.Integer scale,
boolean forceEncrypt) |
Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
|
void |
updateDateTimeOffset(java.lang.String columnName,
DateTimeOffset x) |
Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
|
void |
updateDateTimeOffset(java.lang.String columnName,
DateTimeOffset x,
int scale) |
Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
|
void |
updateDateTimeOffset(java.lang.String columnName,
DateTimeOffset x,
int scale,
boolean forceEncrypt) |
Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
|
void |
updateDouble(int index,
double x) |
|
void |
updateDouble(int index,
double x,
boolean forceEncrypt) |
Updates the designated column with a
double value. |
void |
updateDouble(java.lang.String columnName,
double x) |
|
void |
updateDouble(java.lang.String columnName,
double x,
boolean forceEncrypt) |
Updates the designated column with a
double value. |
void |
updateFloat(int index,
float x) |
|
void |
updateFloat(int index,
float x,
boolean forceEncrypt) |
Updates the designated column with a
float value. |
void |
updateFloat(java.lang.String columnName,
float x) |
|
void |
updateFloat(java.lang.String columnName,
float x,
boolean forceEncrypt) |
Updates the designated column with a
float value. |
void |
updateInt(int index,
int x) |
|
void |
updateInt(int index,
int x,
boolean forceEncrypt) |
Updates the designated column with an
int value. |
void |
updateInt(java.lang.String columnName,
int x) |
|
void |
updateInt(java.lang.String columnName,
int x,
boolean forceEncrypt) |
Updates the designated column with an
int value. |
void |
updateLong(int index,
long x) |
|
void |
updateLong(int index,
long x,
boolean forceEncrypt) |
Updates the designated column with a
long value. |
void |
updateLong(java.lang.String columnName,
long x) |
|
void |
updateLong(java.lang.String columnName,
long x,
boolean forceEncrypt) |
Updates the designated column with a
long value. |
void |
updateMoney(int index,
java.math.BigDecimal x) |
Updates the designated column with a
money value. |
void |
updateMoney(int index,
java.math.BigDecimal x,
boolean forceEncrypt) |
Updates the designated column with a
money value. |
void |
updateMoney(java.lang.String columnName,
java.math.BigDecimal x) |
Updates the designated column with a
money value. |
void |
updateMoney(java.lang.String columnName,
java.math.BigDecimal x,
boolean forceEncrypt) |
Updates the designated column with a
money value. |
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x) |
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length) |
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader) |
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
|
void |
updateNClob(int columnIndex,
java.io.Reader reader) |
|
void |
updateNClob(int columnIndex,
java.io.Reader reader,
long length) |
|
void |
updateNClob(int columnIndex,
java.sql.NClob nClob) |
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader) |
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
|
void |
updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob) |
|
void |
updateNString(int columnIndex,
java.lang.String nString) |
|
void |
updateNString(int columnIndex,
java.lang.String nString,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
void |
updateNString(java.lang.String columnLabel,
java.lang.String nString) |
|
void |
updateNString(java.lang.String columnLabel,
java.lang.String nString,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
void |
updateNull(int index) |
|
void |
updateNull(java.lang.String columnName) |
|
void |
updateObject(int index,
java.lang.Object obj) |
|
void |
updateObject(int index,
java.lang.Object x,
int scale) |
|
void |
updateObject(int index,
java.lang.Object x,
int precision,
int scale) |
Updates the designated column with an
Object value. |
void |
updateObject(int index,
java.lang.Object x,
int precision,
int scale,
boolean forceEncrypt) |
Updates the designated column with an
Object value. |
protected void |
updateObject(int index,
java.lang.Object x,
java.lang.Integer scale,
com.microsoft.sqlserver.jdbc.JDBCType jdbcType,
java.lang.Integer precision,
boolean forceEncrypt) |
|
void |
updateObject(int index,
java.lang.Object obj,
java.sql.SQLType targetSqlType) |
|
void |
updateObject(int index,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scale) |
|
void |
updateObject(int index,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scale,
boolean forceEncrypt) |
Updates the designated column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x) |
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale) |
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int precision,
int scale) |
Updates the designated column with an
Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int precision,
int scale,
boolean forceEncrypt) |
Updates the designated column with an
Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object obj,
java.sql.SQLType targetSqlType) |
|
void |
updateObject(java.lang.String columnName,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scale) |
|
void |
updateObject(java.lang.String columnName,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scale,
boolean forceEncrypt) |
Updates the designated column with an Object value.
|
void |
updateRef(int columnIndex,
java.sql.Ref x) |
|
void |
updateRef(java.lang.String columnName,
java.sql.Ref x) |
|
void |
updateRow() |
|
void |
updateRowId(int columnIndex,
java.sql.RowId x) |
|
void |
updateRowId(java.lang.String columnLabel,
java.sql.RowId x) |
|
void |
updateShort(int index,
short x) |
|
void |
updateShort(int index,
short x,
boolean forceEncrypt) |
Updates the designated column with a
short value. |
void |
updateShort(java.lang.String columnName,
short x) |
|
void |
updateShort(java.lang.String columnName,
short x,
boolean forceEncrypt) |
Updates the designated column with a
short value. |
void |
updateSmallDateTime(int index,
java.sql.Timestamp x) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateSmallDateTime(int index,
java.sql.Timestamp x,
java.lang.Integer scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateSmallDateTime(int index,
java.sql.Timestamp x,
java.lang.Integer scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateSmallDateTime(java.lang.String columnName,
java.sql.Timestamp x) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateSmallDateTime(java.lang.String columnName,
java.sql.Timestamp x,
int scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateSmallDateTime(java.lang.String columnName,
java.sql.Timestamp x,
int scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateSmallMoney(int index,
java.math.BigDecimal x) |
Updates the designated column with a
smallmoney value. |
void |
updateSmallMoney(int index,
java.math.BigDecimal x,
boolean forceEncrypt) |
Updates the designated column with a
smallmoney value. |
void |
updateSmallMoney(java.lang.String columnName,
java.math.BigDecimal x) |
Updates the designated column with a
smallmoney value. |
void |
updateSmallMoney(java.lang.String columnName,
java.math.BigDecimal x,
boolean forceEncrypt) |
Updates the designated column with a
smallmoney value. |
void |
updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject) |
|
void |
updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML x) |
|
void |
updateString(int columnIndex,
java.lang.String stringValue) |
|
void |
updateString(int columnIndex,
java.lang.String stringValue,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
void |
updateString(java.lang.String columnName,
java.lang.String x) |
|
void |
updateString(java.lang.String columnName,
java.lang.String x,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
void |
updateTime(int index,
java.sql.Time x) |
|
void |
updateTime(int index,
java.sql.Time x,
java.lang.Integer scale) |
Updates the designated column with a
java.sql.Time value. |
void |
updateTime(int index,
java.sql.Time x,
java.lang.Integer scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Time value. |
void |
updateTime(java.lang.String columnName,
java.sql.Time x) |
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x,
int scale) |
Updates the designated column with a
java.sql.Time value. |
void |
updateTime(java.lang.String columnName,
java.sql.Time x,
int scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Time value. |
void |
updateTimestamp(int index,
java.sql.Timestamp x) |
|
void |
updateTimestamp(int index,
java.sql.Timestamp x,
int scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateTimestamp(int index,
java.sql.Timestamp x,
int scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x) |
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x,
int scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x,
int scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateUniqueIdentifier(int index,
java.lang.String x) |
Updates the designated column with a
String value. |
void |
updateUniqueIdentifier(int index,
java.lang.String x,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
void |
updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x) |
Updates the designated column with a
String value. |
void |
updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
boolean |
wasNull() |
public java.lang.String toString()
toString
in class java.lang.Object
protected int getServerCursorId()
protected com.microsoft.sqlserver.jdbc.TDSReader getTDSReader()
public SensitivityClassification getSensitivityClassification()
ISQLServerResultSet
getSensitivityClassification
in interface ISQLServerResultSet
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
java.sql.SQLException
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
java.sql.SQLException
public boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.ResultSet
java.sql.SQLException
protected boolean isForwardOnly()
public void close() throws SQLServerException
close
in interface java.lang.AutoCloseable
close
in interface java.sql.ResultSet
SQLServerException
public int findColumn(java.lang.String columnName) throws SQLServerException
findColumn
in interface java.sql.ResultSet
columnName
- the name of the columnSQLServerException
- If any errors occur.public void clearWarnings() throws SQLServerException
clearWarnings
in interface java.sql.ResultSet
SQLServerException
- when an error occurspublic boolean relative(int rows) throws java.sql.SQLException
relative
in interface java.sql.ResultSet
java.sql.SQLException
public boolean next() throws SQLServerException
next
in interface java.sql.ResultSet
SQLServerException
public boolean wasNull() throws SQLServerException
wasNull
in interface java.sql.ResultSet
SQLServerException
public boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isFirst() throws java.sql.SQLException
ResultSet
object.
This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE,
TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
Note:Support for the isFirst
method is optional for ResultSet
s with a
result set type of TYPE_FORWARD_ONLY
isFirst
in interface java.sql.ResultSet
true
if the cursor is on the first row; false
otherwisejava.sql.SQLException
- if a database access error occurs or this method is called on a closed result setpublic boolean isLast() throws java.sql.SQLException
ResultSet
object. Note:
Calling the method isLast
may be expensive because the JDBC driver might need to fetch ahead one row
in order to determine whether the current row is the last row in the result set.
This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
Note: Support for theisLast
method is optional for ResultSet
s with a
result set type of TYPE_FORWARD_ONLY
isLast
in interface java.sql.ResultSet
true
if the cursor is on the last row; false
otherwisejava.sql.SQLException
- if a database access error occurs or this method is called on a closed result setpublic void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean first() throws java.sql.SQLException
ResultSet
object.
This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
first
in interface java.sql.ResultSet
true
if the cursor is on a valid row; false
if there are no rows in the result
setjava.sql.SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type
is TYPE_FORWARD_ONLY
public boolean last() throws java.sql.SQLException
ResultSet
object.
This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE,
TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.last
in interface java.sql.ResultSet
true
if the cursor is on a valid row; false
if there are no rows in the result
setjava.sql.SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type
is TYPE_FORWARD_ONLY
public int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
public boolean absolute(int row) throws java.sql.SQLException
ResultSet
object.
This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the
result set. For example, calling the method absolute(-1)
positions the cursor on the last row;
calling the method absolute(-2)
moves the cursor to the next-to-last row, and so on.
If the row number specified is zero, the cursor is moved to before the first row.
An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.
Note: Calling absolute(1)
is the same as calling first()
. Calling
absolute(-1)
is the same as calling last()
.
absolute
in interface java.sql.ResultSet
row
- the number of the row to which the cursor should move. A value of zero indicates that the cursor will be
positioned before the first row; a positive number indicates the row number counting from the beginning of
the result set; a negative number indicates the row number counting from the end of the result settrue
if the cursor is moved to a position in this ResultSet
object;
false
if the cursor is before the first row or after the last rowjava.sql.SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type
is TYPE_FORWARD_ONLY
public boolean previous() throws java.sql.SQLException
ResultSet
object.
This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE,
TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.previous
in interface java.sql.ResultSet
true
if the cursor is now positioned on a valid row; false
if the cursor is
positioned before the first rowjava.sql.SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type
is TYPE_FORWARD_ONLY
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchSize(int rows) throws SQLServerException
setFetchSize
in interface java.sql.ResultSet
SQLServerException
public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public int getType() throws SQLServerException
getType
in interface java.sql.ResultSet
SQLServerException
public int getConcurrency() throws SQLServerException
getConcurrency
in interface java.sql.ResultSet
SQLServerException
public java.io.InputStream getAsciiStream(int columnIndex) throws SQLServerException
getAsciiStream
in interface java.sql.ResultSet
SQLServerException
public java.io.InputStream getAsciiStream(java.lang.String columnName) throws SQLServerException
getAsciiStream
in interface java.sql.ResultSet
SQLServerException
@Deprecated public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLServerException
getBigDecimal
in interface java.sql.ResultSet
SQLServerException
@Deprecated public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws SQLServerException
getBigDecimal
in interface java.sql.ResultSet
SQLServerException
public java.io.InputStream getBinaryStream(int columnIndex) throws SQLServerException
getBinaryStream
in interface java.sql.ResultSet
SQLServerException
public java.io.InputStream getBinaryStream(java.lang.String columnName) throws SQLServerException
getBinaryStream
in interface java.sql.ResultSet
SQLServerException
public boolean getBoolean(int columnIndex) throws SQLServerException
getBoolean
in interface java.sql.ResultSet
SQLServerException
public boolean getBoolean(java.lang.String columnName) throws SQLServerException
getBoolean
in interface java.sql.ResultSet
SQLServerException
public byte getByte(int columnIndex) throws SQLServerException
getByte
in interface java.sql.ResultSet
SQLServerException
public byte getByte(java.lang.String columnName) throws SQLServerException
getByte
in interface java.sql.ResultSet
SQLServerException
public byte[] getBytes(int columnIndex) throws SQLServerException
getBytes
in interface java.sql.ResultSet
SQLServerException
public byte[] getBytes(java.lang.String columnName) throws SQLServerException
getBytes
in interface java.sql.ResultSet
SQLServerException
public java.sql.Date getDate(int columnIndex) throws SQLServerException
getDate
in interface java.sql.ResultSet
SQLServerException
public java.sql.Date getDate(java.lang.String columnName) throws SQLServerException
getDate
in interface java.sql.ResultSet
SQLServerException
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws SQLServerException
getDate
in interface java.sql.ResultSet
SQLServerException
public java.sql.Date getDate(java.lang.String colName, java.util.Calendar cal) throws SQLServerException
getDate
in interface java.sql.ResultSet
SQLServerException
public double getDouble(int columnIndex) throws SQLServerException
getDouble
in interface java.sql.ResultSet
SQLServerException
public double getDouble(java.lang.String columnName) throws SQLServerException
getDouble
in interface java.sql.ResultSet
SQLServerException
public float getFloat(int columnIndex) throws SQLServerException
getFloat
in interface java.sql.ResultSet
SQLServerException
public float getFloat(java.lang.String columnName) throws SQLServerException
getFloat
in interface java.sql.ResultSet
SQLServerException
public Geometry getGeometry(int columnIndex) throws SQLServerException
ISQLServerResultSet
getGeometry
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic Geometry getGeometry(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getGeometry
in interface ISQLServerResultSet
columnName
- the name of the columnSQLServerException
- when an error occurspublic Geography getGeography(int columnIndex) throws SQLServerException
ISQLServerResultSet
getGeography
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic Geography getGeography(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getGeography
in interface ISQLServerResultSet
columnName
- the name of the columnSQLServerException
- when an error occurspublic int getInt(int columnIndex) throws SQLServerException
getInt
in interface java.sql.ResultSet
SQLServerException
public int getInt(java.lang.String columnName) throws SQLServerException
getInt
in interface java.sql.ResultSet
SQLServerException
public long getLong(int columnIndex) throws SQLServerException
getLong
in interface java.sql.ResultSet
SQLServerException
public long getLong(java.lang.String columnName) throws SQLServerException
getLong
in interface java.sql.ResultSet
SQLServerException
public java.sql.ResultSetMetaData getMetaData() throws SQLServerException
getMetaData
in interface java.sql.ResultSet
SQLServerException
public java.lang.Object getObject(int columnIndex) throws SQLServerException
getObject
in interface java.sql.ResultSet
SQLServerException
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(java.lang.String columnName) throws SQLServerException
getObject
in interface java.sql.ResultSet
SQLServerException
public <T> T getObject(java.lang.String columnName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public short getShort(int columnIndex) throws SQLServerException
getShort
in interface java.sql.ResultSet
SQLServerException
public short getShort(java.lang.String columnName) throws SQLServerException
getShort
in interface java.sql.ResultSet
SQLServerException
public java.lang.String getString(int columnIndex) throws SQLServerException
getString
in interface java.sql.ResultSet
SQLServerException
public java.lang.String getString(java.lang.String columnName) throws SQLServerException
getString
in interface java.sql.ResultSet
SQLServerException
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException
getNString
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
getNString
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getUniqueIdentifier(int columnIndex) throws SQLServerException
ISQLServerResultSet
getUniqueIdentifier
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic java.lang.String getUniqueIdentifier(java.lang.String columnLabel) throws SQLServerException
ISQLServerResultSet
getUniqueIdentifier
in interface ISQLServerResultSet
columnLabel
- the name of the columnSQLServerException
- when an error occurspublic java.sql.Time getTime(int columnIndex) throws SQLServerException
getTime
in interface java.sql.ResultSet
SQLServerException
public java.sql.Time getTime(java.lang.String columnName) throws SQLServerException
getTime
in interface java.sql.ResultSet
SQLServerException
public java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws SQLServerException
getTime
in interface java.sql.ResultSet
SQLServerException
public java.sql.Time getTime(java.lang.String colName, java.util.Calendar cal) throws SQLServerException
getTime
in interface java.sql.ResultSet
SQLServerException
public java.sql.Timestamp getTimestamp(int columnIndex) throws SQLServerException
getTimestamp
in interface java.sql.ResultSet
SQLServerException
public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws SQLServerException
getTimestamp
in interface java.sql.ResultSet
SQLServerException
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws SQLServerException
getTimestamp
in interface java.sql.ResultSet
SQLServerException
public java.sql.Timestamp getTimestamp(java.lang.String colName, java.util.Calendar cal) throws SQLServerException
getTimestamp
in interface java.sql.ResultSet
SQLServerException
public java.sql.Timestamp getDateTime(int columnIndex) throws SQLServerException
ISQLServerResultSet
getDateTime
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic java.sql.Timestamp getDateTime(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnSQLServerException
- If any errors occur.public java.sql.Timestamp getDateTime(int columnIndex, java.util.Calendar cal) throws SQLServerException
ISQLServerResultSet
getDateTime
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar object to use in constructing the dateTimeSQLServerException
- If any errors occur.public java.sql.Timestamp getDateTime(java.lang.String colName, java.util.Calendar cal) throws SQLServerException
ISQLServerResultSet
getDateTime
in interface ISQLServerResultSet
colName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then
the label is the name of the columncal
- the java.util.Calendar object to use in constructing the dateTimeSQLServerException
- If any errors occur.public java.sql.Timestamp getSmallDateTime(int columnIndex) throws SQLServerException
ISQLServerResultSet
getSmallDateTime
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic java.sql.Timestamp getSmallDateTime(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getSmallDateTime
in interface ISQLServerResultSet
columnName
- is the name of a column.SQLServerException
- If any errors occur.public java.sql.Timestamp getSmallDateTime(int columnIndex, java.util.Calendar cal) throws SQLServerException
ISQLServerResultSet
getSmallDateTime
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar object to use in constructing the smalldateTimeSQLServerException
- If any errors occur.public java.sql.Timestamp getSmallDateTime(java.lang.String colName, java.util.Calendar cal) throws SQLServerException
ISQLServerResultSet
getSmallDateTime
in interface ISQLServerResultSet
colName
- The name of a columncal
- the java.util.Calendar object to use in constructing the smalldateTimeSQLServerException
- If any errors occur.public DateTimeOffset getDateTimeOffset(int columnIndex) throws SQLServerException
ISQLServerResultSet
getDateTimeOffset
in interface ISQLServerResultSet
columnIndex
- The zero-based ordinal of a column.SQLServerException
- when an error occurspublic DateTimeOffset getDateTimeOffset(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getDateTimeOffset
in interface ISQLServerResultSet
columnName
- The name of a column.SQLServerException
- when an error occurs@Deprecated public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
@Deprecated public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Blob getBlob(int i) throws SQLServerException
getBlob
in interface java.sql.ResultSet
SQLServerException
public java.sql.Blob getBlob(java.lang.String colName) throws SQLServerException
getBlob
in interface java.sql.ResultSet
SQLServerException
public java.sql.Clob getClob(int columnIndex) throws SQLServerException
getClob
in interface java.sql.ResultSet
SQLServerException
public java.sql.Clob getClob(java.lang.String colName) throws SQLServerException
getClob
in interface java.sql.ResultSet
SQLServerException
public java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
getNClob
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
getNClob
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getMoney(int columnIndex) throws SQLServerException
ISQLServerResultSet
getMoney
in interface ISQLServerResultSet
columnIndex
- The zero-based ordinal of a column.SQLServerException
- when an error occurspublic java.math.BigDecimal getMoney(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getMoney
in interface ISQLServerResultSet
columnName
- is the name of a column.SQLServerException
- If any errors occur.public java.math.BigDecimal getSmallMoney(int columnIndex) throws SQLServerException
ISQLServerResultSet
getSmallMoney
in interface ISQLServerResultSet
columnIndex
- The zero-based ordinal of a column.SQLServerException
- If any errors occur.public java.math.BigDecimal getSmallMoney(java.lang.String columnName) throws SQLServerException
ISQLServerResultSet
getSmallMoney
in interface ISQLServerResultSet
columnName
- is the name of a column.SQLServerException
- If any errors occur.public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
getRowId
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
getRowId
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
getSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowUpdated() throws SQLServerException
rowUpdated
in interface java.sql.ResultSet
SQLServerException
public boolean rowInserted() throws SQLServerException
rowInserted
in interface java.sql.ResultSet
SQLServerException
public boolean rowDeleted() throws SQLServerException
rowDeleted
in interface java.sql.ResultSet
SQLServerException
public void updateNull(int index) throws SQLServerException
updateNull
in interface java.sql.ResultSet
SQLServerException
public void updateBoolean(int index, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBoolean(int index, boolean x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
boolean
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateBoolean
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateByte(int index, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
java.sql.SQLException
public void updateByte(int index, byte x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
byte
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateByte
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateShort(int index, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
java.sql.SQLException
public void updateShort(int index, short x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
short
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateShort
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateInt(int index, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
java.sql.SQLException
public void updateInt(int index, int x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
int
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateInt
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateLong(int index, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
java.sql.SQLException
public void updateLong(int index, long x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
long
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateLong
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateFloat(int index, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
java.sql.SQLException
public void updateFloat(int index, float x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
float
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateFloat
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateDouble(int index, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
java.sql.SQLException
public void updateDouble(int index, double x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
double
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateDouble
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateMoney(int index, java.math.BigDecimal x) throws SQLServerException
ISQLServerResultSet
money
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateMoney
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueSQLServerException
- when an error occurspublic void updateMoney(int index, java.math.BigDecimal x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
money
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateMoney
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateMoney(java.lang.String columnName, java.math.BigDecimal x) throws SQLServerException
ISQLServerResultSet
money
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateMoney
in interface ISQLServerResultSet
columnName
- the column namex
- the new column valueSQLServerException
- If any errors occur.public void updateMoney(java.lang.String columnName, java.math.BigDecimal x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
money
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateMoney
in interface ISQLServerResultSet
columnName
- the column namex
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateSmallMoney(int index, java.math.BigDecimal x) throws SQLServerException
ISQLServerResultSet
smallmoney
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateSmallMoney
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueSQLServerException
- when an error occurspublic void updateSmallMoney(int index, java.math.BigDecimal x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
smallmoney
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateSmallMoney
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateSmallMoney(java.lang.String columnName, java.math.BigDecimal x) throws SQLServerException
ISQLServerResultSet
smallmoney
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateSmallMoney
in interface ISQLServerResultSet
columnName
- the column namex
- the new column valueSQLServerException
- If any errors occur.public void updateSmallMoney(java.lang.String columnName, java.math.BigDecimal x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
smallmoney
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateSmallMoney
in interface ISQLServerResultSet
columnName
- the column namex
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateBigDecimal(int index, java.math.BigDecimal x) throws SQLServerException
updateBigDecimal
in interface java.sql.ResultSet
SQLServerException
public void updateBigDecimal(int index, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale) throws SQLServerException
ISQLServerResultSet
java.math.BigDecimal
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateBigDecimal
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnSQLServerException
- when an error occurspublic void updateBigDecimal(int index, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.math.BigDecimal
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateBigDecimal
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateString(int columnIndex, java.lang.String stringValue) throws SQLServerException
updateString
in interface java.sql.ResultSet
SQLServerException
public void updateString(int columnIndex, java.lang.String stringValue, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
String
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateString
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second is 2, ...stringValue
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException
updateNString
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNString(int columnIndex, java.lang.String nString, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
String
value. It is intended for use when updating
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateNString
in interface ISQLServerResultSet
columnIndex
- the first column is 1, the second 2, ...nString
- the value for the column to be updatedforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateNString(java.lang.String columnLabel, java.lang.String nString) throws java.sql.SQLException
updateNString
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNString(java.lang.String columnLabel, java.lang.String nString, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
String
value. It is intended for use when updating
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateNString
in interface ISQLServerResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then
the label is the name of the columnnString
- the value for the column to be updatedforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateBytes(int index, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBytes(int index, byte[] x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
byte
array value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateBytes
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateDate(int index, java.sql.Date x) throws SQLServerException
updateDate
in interface java.sql.ResultSet
SQLServerException
public void updateDate(int index, java.sql.Date x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Date
value. The updater methods are used to update
column values in the current row or the insert row. The updater methods do not update the underlying database;
instead the updateRow
or insertRow
methods are called to update the database.updateDate
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateTime(int index, java.sql.Time x) throws SQLServerException
updateTime
in interface java.sql.ResultSet
SQLServerException
public void updateTime(int index, java.sql.Time x, java.lang.Integer scale) throws SQLServerException
ISQLServerResultSet
java.sql.Time
value. The updater methods are used to update
column values in the current row or the insert row. The updater methods do not update the underlying database;
instead the updateRow
or insertRow
methods are called to update the database.updateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnSQLServerException
- when an error occurspublic void updateTime(int index, java.sql.Time x, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Time
value. The updater methods are used to update
column values in the current row or the insert row. The updater methods do not update the underlying database;
instead the updateRow
or insertRow
methods are called to update the database.updateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateTimestamp(int index, java.sql.Timestamp x) throws SQLServerException
updateTimestamp
in interface java.sql.ResultSet
SQLServerException
public void updateTimestamp(int index, java.sql.Timestamp x, int scale) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateTimestamp
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnSQLServerException
- when an error occurspublic void updateTimestamp(int index, java.sql.Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateTimestamp
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateDateTime(int index, java.sql.Timestamp x) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateDateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueSQLServerException
- when an error occurspublic void updateDateTime(int index, java.sql.Timestamp x, java.lang.Integer scale) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateDateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnSQLServerException
- when an error occurspublic void updateDateTime(int index, java.sql.Timestamp x, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateDateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateSmallDateTime(int index, java.sql.Timestamp x) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateSmallDateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueSQLServerException
- when an error occurspublic void updateSmallDateTime(int index, java.sql.Timestamp x, java.lang.Integer scale) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateSmallDateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnSQLServerException
- when an error occurspublic void updateSmallDateTime(int index, java.sql.Timestamp x, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateSmallDateTime
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateDateTimeOffset(int index, DateTimeOffset x) throws SQLServerException
ISQLServerResultSet
updateDateTimeOffset
in interface ISQLServerResultSet
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.SQLServerException
- when an error occurspublic void updateDateTimeOffset(int index, DateTimeOffset x, java.lang.Integer scale) throws SQLServerException
ISQLServerResultSet
updateDateTimeOffset
in interface ISQLServerResultSet
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.scale
- scale of the columnSQLServerException
- when an error occurspublic void updateDateTimeOffset(int index, DateTimeOffset x, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
updateDateTimeOffset
in interface ISQLServerResultSet
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.scale
- scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateUniqueIdentifier(int index, java.lang.String x) throws SQLServerException
ISQLServerResultSet
String
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateUniqueIdentifier
in interface ISQLServerResultSet
index
- The zero-based ordinal of a column.x
- the new column valueSQLServerException
- when an error occurspublic void updateUniqueIdentifier(int index, java.lang.String x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
String
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateUniqueIdentifier
in interface ISQLServerResultSet
index
- The zero-based ordinal of a column.x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateAsciiStream(int index, java.io.InputStream x, int length) throws SQLServerException
updateAsciiStream
in interface java.sql.ResultSet
SQLServerException
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLServerException
updateAsciiStream
in interface java.sql.ResultSet
SQLServerException
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream streamValue, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(int columnIndex, java.io.InputStream streamValue, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream streamValue, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateCharacterStream(int columnIndex, java.io.Reader readerValue, int length) throws SQLServerException
updateCharacterStream
in interface java.sql.ResultSet
SQLServerException
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateCharacterStream(java.lang.String columnName, java.io.Reader readerValue, int length) throws SQLServerException
updateCharacterStream
in interface java.sql.ResultSet
SQLServerException
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateObject(int index, java.lang.Object obj) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateObject(int index, java.lang.Object x, int scale) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateObject(int index, java.lang.Object x, int precision, int scale) throws SQLServerException
ISQLServerResultSet
Object
value.
The updater methods are used to update column values in the current row or the insert row. The updater methods do
not update the underlying database; instead the updateRow
or insertRow
methods are called to
update the database.updateObject
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnSQLServerException
- when an error occurspublic void updateObject(int index, java.lang.Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
Object
value.
The updater methods are used to update column values in the current row or the insert row. The updater methods do
not update the underlying database; instead the updateRow
or insertRow
methods are called to
update the database.updateObject
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occursprotected final void updateObject(int index, java.lang.Object x, java.lang.Integer scale, com.microsoft.sqlserver.jdbc.JDBCType jdbcType, java.lang.Integer precision, boolean forceEncrypt) throws SQLServerException
SQLServerException
public void updateNull(java.lang.String columnName) throws SQLServerException
updateNull
in interface java.sql.ResultSet
SQLServerException
public void updateBoolean(java.lang.String columnName, boolean x) throws SQLServerException
updateBoolean
in interface java.sql.ResultSet
SQLServerException
public void updateBoolean(java.lang.String columnName, boolean x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
boolean
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateBoolean
in interface ISQLServerResultSet
columnName
- the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occurspublic void updateByte(java.lang.String columnName, byte x) throws SQLServerException
updateByte
in interface java.sql.ResultSet
SQLServerException
public void updateByte(java.lang.String columnName, byte x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
byte
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateByte
in interface ISQLServerResultSet
columnName
- the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateShort(java.lang.String columnName, short x) throws SQLServerException
updateShort
in interface java.sql.ResultSet
SQLServerException
public void updateShort(java.lang.String columnName, short x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
short
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateShort
in interface ISQLServerResultSet
columnName
- the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateInt(java.lang.String columnName, int x) throws SQLServerException
updateInt
in interface java.sql.ResultSet
SQLServerException
public void updateInt(java.lang.String columnName, int x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
int
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateInt
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateLong(java.lang.String columnName, long x) throws SQLServerException
updateLong
in interface java.sql.ResultSet
SQLServerException
public void updateLong(java.lang.String columnName, long x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
long
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateLong
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateFloat(java.lang.String columnName, float x) throws SQLServerException
updateFloat
in interface java.sql.ResultSet
SQLServerException
public void updateFloat(java.lang.String columnName, float x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
float
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateFloat
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateDouble(java.lang.String columnName, double x) throws SQLServerException
updateDouble
in interface java.sql.ResultSet
SQLServerException
public void updateDouble(java.lang.String columnName, double x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
double
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateDouble
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws SQLServerException
updateBigDecimal
in interface java.sql.ResultSet
SQLServerException
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.BigDecimal
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateBigDecimal
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale) throws SQLServerException
ISQLServerResultSet
java.sql.BigDecimal
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateBigDecimal
in interface ISQLServerResultSet
columnName
- is the name of the column and Always Encrypted is enabled on the connection or on the statement. If the
boolean forceEncrypt is set to false, the driver will not force encryption on parameters.x
- BigDecimal valueprecision
- the precision of the columnscale
- the scale of the columnSQLServerException
- If any errors occur.public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.BigDecimal
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateBigDecimal
in interface ISQLServerResultSet
columnName
- is the name of the column and Always Encrypted is enabled on the connection or on the statement. If the
boolean forceEncrypt is set to false, the driver will not force encryption on parameters.x
- BigDecimal valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateString(java.lang.String columnName, java.lang.String x) throws SQLServerException
updateString
in interface java.sql.ResultSet
SQLServerException
public void updateString(java.lang.String columnName, java.lang.String x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
String
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateString
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateBytes(java.lang.String columnName, byte[] x) throws SQLServerException
updateBytes
in interface java.sql.ResultSet
SQLServerException
public void updateBytes(java.lang.String columnName, byte[] x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
updateRow
or insertRow
methods are
called to update the database.updateBytes
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateDate(java.lang.String columnName, java.sql.Date x) throws SQLServerException
updateDate
in interface java.sql.ResultSet
SQLServerException
public void updateDate(java.lang.String columnName, java.sql.Date x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Date
value. The updater methods are used to update
column values in the current row or the insert row. The updater methods do not update the underlying database;
instead the updateRow
or insertRow
methods are called to update the database.updateDate
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateTime(java.lang.String columnName, java.sql.Time x) throws SQLServerException
updateTime
in interface java.sql.ResultSet
SQLServerException
public void updateTime(java.lang.String columnName, java.sql.Time x, int scale) throws SQLServerException
ISQLServerResultSet
java.sql.Time
value. The updater methods are used to update
column values in the current row or the insert row. The updater methods do not update the underlying database;
instead the updateRow
or insertRow
methods are called to update the database.updateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnSQLServerException
- If any errors occur.public void updateTime(java.lang.String columnName, java.sql.Time x, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Time
value. The updater methods are used to update
column values in the current row or the insert row. The updater methods do not update the underlying database;
instead the updateRow
or insertRow
methods are called to update the database.updateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws SQLServerException
updateTimestamp
in interface java.sql.ResultSet
SQLServerException
public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x, int scale) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateTimestamp
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnSQLServerException
- If any errors occur.public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateTimestamp
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateDateTime(java.lang.String columnName, java.sql.Timestamp x) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueSQLServerException
- If any errors occur.public void updateDateTime(java.lang.String columnName, java.sql.Timestamp x, int scale) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnSQLServerException
- If any errors occur.public void updateDateTime(java.lang.String columnName, java.sql.Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateSmallDateTime(java.lang.String columnName, java.sql.Timestamp x) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateSmallDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valueSQLServerException
- If any errors occur.public void updateSmallDateTime(java.lang.String columnName, java.sql.Timestamp x, int scale) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateSmallDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnSQLServerException
- If any errors occur.public void updateSmallDateTime(java.lang.String columnName, java.sql.Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
java.sql.Timestamp
value. The updater methods are used to
update column values in the current row or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.updateSmallDateTime
in interface ISQLServerResultSet
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateDateTimeOffset(java.lang.String columnName, DateTimeOffset x) throws SQLServerException
ISQLServerResultSet
updateDateTimeOffset
in interface ISQLServerResultSet
columnName
- The name of a column.x
- A DateTimeOffset Class object.SQLServerException
- when an error occurspublic void updateDateTimeOffset(java.lang.String columnName, DateTimeOffset x, int scale) throws SQLServerException
ISQLServerResultSet
updateDateTimeOffset
in interface ISQLServerResultSet
columnName
- The name of a column.x
- A DateTimeOffset Class object.scale
- the scale of the columnSQLServerException
- If any errors occur.public void updateDateTimeOffset(java.lang.String columnName, DateTimeOffset x, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
updateDateTimeOffset
in interface ISQLServerResultSet
columnName
- The name of a column.x
- A DateTimeOffset Class object.scale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateUniqueIdentifier(java.lang.String columnName, java.lang.String x) throws SQLServerException
ISQLServerResultSet
String
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateUniqueIdentifier
in interface ISQLServerResultSet
columnName
- The name of a column.x
- the new column valueSQLServerException
- If any errors occur.public void updateUniqueIdentifier(java.lang.String columnName, java.lang.String x, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
String
value. The updater methods are used to update column
values in the current row or the insert row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called to update the database.updateUniqueIdentifier
in interface ISQLServerResultSet
columnName
- The name of a column.x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateObject(java.lang.String columnName, java.lang.Object x, int precision, int scale) throws SQLServerException
ISQLServerResultSet
Object
value.
The updater methods are used to update column values in the current row or the insert row. The updater methods do
not update the underlying database; instead the updateRow
or insertRow
methods are called to
update the database.updateObject
in interface ISQLServerResultSet
columnName
- The name of a column.x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnSQLServerException
- If any errors occur.public void updateObject(java.lang.String columnName, java.lang.Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
Object
value.
The updater methods are used to update column values in the current row or the insert row. The updater methods do
not update the underlying database; instead the updateRow
or insertRow
methods are called to
update the database.updateObject
in interface ISQLServerResultSet
columnName
- The name of a column.x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateObject(java.lang.String columnName, java.lang.Object x) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
updateRowId
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
updateRowId
in interface java.sql.ResultSet
java.sql.SQLException
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
updateSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML x) throws java.sql.SQLException
updateSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public int getHoldability() throws java.sql.SQLException
getHoldability
in interface java.sql.ResultSet
java.sql.SQLException
public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
public void cancelRowUpdates() throws SQLServerException
cancelRowUpdates
in interface java.sql.ResultSet
SQLServerException
public void moveToInsertRow() throws SQLServerException
moveToInsertRow
in interface java.sql.ResultSet
SQLServerException
public void moveToCurrentRow() throws SQLServerException
moveToCurrentRow
in interface java.sql.ResultSet
SQLServerException
public java.sql.Statement getStatement() throws SQLServerException
getStatement
in interface java.sql.ResultSet
SQLServerException
public void updateClob(int columnIndex, java.sql.Clob clobValue) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(java.lang.String columnName, java.sql.Clob clobValue) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(int columnIndex, java.sql.Blob blobValue) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(java.lang.String columnName, java.sql.Blob blobValue) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(java.lang.String sColumn) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public void updateObject(int index, java.lang.Object obj, java.sql.SQLType targetSqlType) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateObject(int index, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateObject(int index, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
updateObject
in interface ISQLServerResultSet
index
- the first column is 1, the second is 2, ...obj
- the new column valuetargetSqlType
- the SQL type to be sent to the databasescale
- for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java
Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other
types, this value will be ignored.forceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateObject(java.lang.String columnName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
public void updateObject(java.lang.String columnName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerResultSet
updateObject
in interface ISQLServerResultSet
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then
the label is the name of the columnobj
- the new column valuetargetSqlType
- the SQL type to be sent to the databasescale
- for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java
Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other
types, this value will be ignored.forceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.public void updateObject(java.lang.String columnName, java.lang.Object obj, java.sql.SQLType targetSqlType) throws SQLServerException
updateObject
in interface java.sql.ResultSet
SQLServerException
Copyright © 2018 Microsoft Corporation. All rights reserved.