ISQLServerResultSet, java.lang.AutoCloseable, java.sql.ResultSet, java.sql.WrapperSQLServerResultSet42public class SQLServerResultSet extends java.lang.Object implements ISQLServerResultSet
| 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 specified row in this ResultSet object.
|
void |
afterLast() |
|
void |
beforeFirst() |
|
void |
cancelRowUpdates() |
|
void |
clearWarnings() |
Clear result set warnings
|
void |
close() |
|
void |
deleteRow() |
|
int |
findColumn(java.lang.String columnName) |
Find 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) |
Retrieves 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) |
Retrieves 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) |
Retrieves 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) |
Retrieves 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) |
Retrieves the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.
|
DateTimeOffset |
getDateTimeOffset(java.lang.String columnName) |
Retrieves 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) |
|
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) |
Retrieves the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getMoney(java.lang.String columnName) |
Retrieves 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() |
Retrieves the number of the current row in this ResultSet object.
|
java.sql.RowId |
getRowId(int columnIndex) |
|
java.sql.RowId |
getRowId(java.lang.String columnLabel) |
|
protected int |
getServerCursorId() |
|
short |
getShort(int columnIndex) |
|
short |
getShort(java.lang.String columnName) |
|
java.sql.Timestamp |
getSmallDateTime(int columnIndex) |
Retrieves 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) |
Retrieves 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) |
Retrieves 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) |
|
java.math.BigDecimal |
getSmallMoney(int columnIndex) |
Retrieves the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getSmallMoney(java.lang.String columnName) |
Retrieves 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) |
Retrieves the value of the designated column in the current row of this ResultSet object as a microsoft.sql.datetimeoffset object in the Java
programming language.
|
java.lang.String |
getUniqueIdentifier(java.lang.String columnLabel) |
Retrieves the value of the designated column in the current row of this ResultSet object as a microsoft.sql.datetimeoffset 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() |
|
boolean |
isClosed() |
|
boolean |
isFirst() |
Determines whether the cursor is on the first row in this ResultSet object.
|
protected boolean |
isForwardOnly() |
|
boolean |
isLast() |
Determines whether the cursor is on the last row in 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() |
Initially moves the cursor to the first row of this ResultSet object, with subsequent calls moving the cursor to the second row, the third row,
and so on.
|
boolean |
previous() |
Moves the cursor to the previous row in this ResultSet object.
|
void |
refreshRow() |
|
boolean |
relative(int rows) |
|
boolean |
rowDeleted() |
|
boolean |
rowInserted() |
|
boolean |
rowUpdated() |
|
void |
setFetchDirection(int direction) |
|
void |
setFetchSize(int rows) |
|
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(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 |
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
Stringvalue. |
void |
updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x,
boolean forceEncrypt) |
Updates the designated column with a
Stringvalue. |
boolean |
wasNull() |
public java.lang.String toString()
toString in class java.lang.Objectprotected int getServerCursorId()
protected com.microsoft.sqlserver.jdbc.TDSReader getTDSReader()
public boolean isWrapperFor(java.lang.Class<?> iface)
throws java.sql.SQLException
isWrapperFor in interface java.sql.Wrapperjava.sql.SQLExceptionpublic <T> T unwrap(java.lang.Class<T> iface)
throws java.sql.SQLException
unwrap in interface java.sql.Wrapperjava.sql.SQLExceptionpublic boolean isClosed()
throws java.sql.SQLException
isClosed in interface java.sql.ResultSetjava.sql.SQLExceptionprotected boolean isForwardOnly()
public void close()
throws SQLServerException
close in interface java.lang.AutoCloseableclose in interface java.sql.ResultSetSQLServerExceptionpublic int findColumn(java.lang.String columnName)
throws SQLServerException
findColumn in interface java.sql.ResultSetcolumnName - the name of the columnSQLServerException - If any errors occur.public void clearWarnings()
throws SQLServerException
clearWarnings in interface java.sql.ResultSetSQLServerException - when an error occurspublic boolean relative(int rows)
throws SQLServerException
relative in interface java.sql.ResultSetSQLServerExceptionpublic boolean next()
throws SQLServerException
next in interface java.sql.ResultSetSQLServerExceptionpublic boolean wasNull()
throws SQLServerException
wasNull in interface java.sql.ResultSetSQLServerExceptionpublic boolean isBeforeFirst()
throws SQLServerException
isBeforeFirst in interface java.sql.ResultSetSQLServerExceptionpublic boolean isAfterLast()
throws SQLServerException
isAfterLast in interface java.sql.ResultSetSQLServerExceptionpublic boolean isFirst()
throws SQLServerException
isFirst in interface java.sql.ResultSetSQLServerExceptionpublic boolean isLast()
throws SQLServerException
isLast in interface java.sql.ResultSetSQLServerExceptionpublic void beforeFirst()
throws SQLServerException
beforeFirst in interface java.sql.ResultSetSQLServerExceptionpublic void afterLast()
throws SQLServerException
afterLast in interface java.sql.ResultSetSQLServerExceptionpublic boolean first()
throws SQLServerException
first in interface java.sql.ResultSetSQLServerExceptionpublic boolean last()
throws SQLServerException
last in interface java.sql.ResultSetSQLServerExceptionpublic int getRow()
throws SQLServerException
getRow in interface java.sql.ResultSetSQLServerExceptionpublic boolean absolute(int row)
throws SQLServerException
absolute in interface java.sql.ResultSetSQLServerExceptionpublic boolean previous()
throws SQLServerException
previous in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.SQLWarning getWarnings()
throws SQLServerException
getWarnings in interface java.sql.ResultSetSQLServerExceptionpublic void setFetchDirection(int direction)
throws SQLServerException
setFetchDirection in interface java.sql.ResultSetSQLServerExceptionpublic int getFetchDirection()
throws SQLServerException
getFetchDirection in interface java.sql.ResultSetSQLServerExceptionpublic void setFetchSize(int rows)
throws SQLServerException
setFetchSize in interface java.sql.ResultSetSQLServerExceptionpublic int getFetchSize()
throws SQLServerException
getFetchSize in interface java.sql.ResultSetSQLServerExceptionpublic int getType()
throws SQLServerException
getType in interface java.sql.ResultSetSQLServerExceptionpublic int getConcurrency()
throws SQLServerException
getConcurrency in interface java.sql.ResultSetSQLServerExceptionpublic java.io.InputStream getAsciiStream(int columnIndex)
throws SQLServerException
getAsciiStream in interface java.sql.ResultSetSQLServerExceptionpublic java.io.InputStream getAsciiStream(java.lang.String columnName)
throws SQLServerException
getAsciiStream in interface java.sql.ResultSetSQLServerException@Deprecated
public java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws SQLServerException
getBigDecimal in interface java.sql.ResultSetSQLServerException@Deprecated
public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
int scale)
throws SQLServerException
getBigDecimal in interface java.sql.ResultSetSQLServerExceptionpublic java.io.InputStream getBinaryStream(int columnIndex)
throws SQLServerException
getBinaryStream in interface java.sql.ResultSetSQLServerExceptionpublic java.io.InputStream getBinaryStream(java.lang.String columnName)
throws SQLServerException
getBinaryStream in interface java.sql.ResultSetSQLServerExceptionpublic boolean getBoolean(int columnIndex)
throws SQLServerException
getBoolean in interface java.sql.ResultSetSQLServerExceptionpublic boolean getBoolean(java.lang.String columnName)
throws SQLServerException
getBoolean in interface java.sql.ResultSetSQLServerExceptionpublic byte getByte(int columnIndex)
throws SQLServerException
getByte in interface java.sql.ResultSetSQLServerExceptionpublic byte getByte(java.lang.String columnName)
throws SQLServerException
getByte in interface java.sql.ResultSetSQLServerExceptionpublic byte[] getBytes(int columnIndex)
throws SQLServerException
getBytes in interface java.sql.ResultSetSQLServerExceptionpublic byte[] getBytes(java.lang.String columnName)
throws SQLServerException
getBytes in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Date getDate(int columnIndex)
throws SQLServerException
getDate in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Date getDate(java.lang.String columnName)
throws SQLServerException
getDate in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Date getDate(int columnIndex,
java.util.Calendar cal)
throws SQLServerException
getDate in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Date getDate(java.lang.String colName,
java.util.Calendar cal)
throws SQLServerException
getDate in interface java.sql.ResultSetSQLServerExceptionpublic double getDouble(int columnIndex)
throws SQLServerException
getDouble in interface java.sql.ResultSetSQLServerExceptionpublic double getDouble(java.lang.String columnName)
throws SQLServerException
getDouble in interface java.sql.ResultSetSQLServerExceptionpublic float getFloat(int columnIndex)
throws SQLServerException
getFloat in interface java.sql.ResultSetSQLServerExceptionpublic float getFloat(java.lang.String columnName)
throws SQLServerException
getFloat in interface java.sql.ResultSetSQLServerExceptionpublic int getInt(int columnIndex)
throws SQLServerException
getInt in interface java.sql.ResultSetSQLServerExceptionpublic int getInt(java.lang.String columnName)
throws SQLServerException
getInt in interface java.sql.ResultSetSQLServerExceptionpublic long getLong(int columnIndex)
throws SQLServerException
getLong in interface java.sql.ResultSetSQLServerExceptionpublic long getLong(java.lang.String columnName)
throws SQLServerException
getLong in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.ResultSetMetaData getMetaData()
throws SQLServerException
getMetaData in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.Object getObject(int columnIndex)
throws SQLServerException
getObject in interface java.sql.ResultSetSQLServerExceptionpublic <T> T getObject(int columnIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String columnName)
throws SQLServerException
getObject in interface java.sql.ResultSetSQLServerExceptionpublic <T> T getObject(java.lang.String columnName,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic short getShort(int columnIndex)
throws SQLServerException
getShort in interface java.sql.ResultSetSQLServerExceptionpublic short getShort(java.lang.String columnName)
throws SQLServerException
getShort in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.String getString(int columnIndex)
throws SQLServerException
getString in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.String getString(java.lang.String columnName)
throws SQLServerException
getString in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.String getNString(int columnIndex)
throws java.sql.SQLException
getNString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.lang.String getNString(java.lang.String columnLabel)
throws java.sql.SQLException
getNString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.lang.String getUniqueIdentifier(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - when an error occurspublic java.lang.String getUniqueIdentifier(java.lang.String columnLabel)
throws java.sql.SQLException
columnLabel - the name of the columnjava.sql.SQLException - when an error occurspublic java.sql.Time getTime(int columnIndex)
throws SQLServerException
getTime in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Time getTime(java.lang.String columnName)
throws SQLServerException
getTime in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Time getTime(int columnIndex,
java.util.Calendar cal)
throws SQLServerException
getTime in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Time getTime(java.lang.String colName,
java.util.Calendar cal)
throws SQLServerException
getTime in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Timestamp getTimestamp(int columnIndex)
throws SQLServerException
getTimestamp in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String columnName)
throws SQLServerException
getTimestamp in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar cal)
throws SQLServerException
getTimestamp in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String colName,
java.util.Calendar cal)
throws SQLServerException
getTimestamp in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Timestamp getDateTime(int columnIndex)
throws SQLServerException
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
columnName - is the name of the columnSQLServerException - If any errors occur.public java.sql.Timestamp getDateTime(int columnIndex,
java.util.Calendar cal)
throws SQLServerException
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
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
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
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
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
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 java.sql.SQLException
ISQLServerResultSetgetDateTimeOffset in interface ISQLServerResultSetcolumnIndex - The zero-based ordinal of a column.java.sql.SQLException - when an error occurspublic DateTimeOffset getDateTimeOffset(java.lang.String columnName) throws java.sql.SQLException
ISQLServerResultSetgetDateTimeOffset in interface ISQLServerResultSetcolumnName - The name of a column.java.sql.SQLException - when an error occurs@Deprecated
public java.io.InputStream getUnicodeStream(int columnIndex)
throws SQLServerException
getUnicodeStream in interface java.sql.ResultSetSQLServerException@Deprecated
public java.io.InputStream getUnicodeStream(java.lang.String columnName)
throws SQLServerException
getUnicodeStream in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.Object getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws SQLServerException
getObject in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Ref getRef(int i)
throws SQLServerException
getRef in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Blob getBlob(int i)
throws SQLServerException
getBlob in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Blob getBlob(java.lang.String colName)
throws SQLServerException
getBlob in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Clob getClob(int columnIndex)
throws SQLServerException
getClob in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Clob getClob(java.lang.String colName)
throws SQLServerException
getClob in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.NClob getNClob(int columnIndex)
throws java.sql.SQLException
getNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.NClob getNClob(java.lang.String columnLabel)
throws java.sql.SQLException
getNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Array getArray(int i)
throws SQLServerException
getArray in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.Object getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws SQLServerException
getObject in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Ref getRef(java.lang.String colName)
throws SQLServerException
getRef in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Array getArray(java.lang.String colName)
throws SQLServerException
getArray in interface java.sql.ResultSetSQLServerExceptionpublic java.lang.String getCursorName()
throws SQLServerException
getCursorName in interface java.sql.ResultSetSQLServerExceptionpublic java.io.Reader getCharacterStream(int columnIndex)
throws SQLServerException
getCharacterStream in interface java.sql.ResultSetSQLServerExceptionpublic java.io.Reader getCharacterStream(java.lang.String columnName)
throws SQLServerException
getCharacterStream in interface java.sql.ResultSetSQLServerExceptionpublic java.io.Reader getNCharacterStream(int columnIndex)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.io.Reader getNCharacterStream(java.lang.String columnLabel)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int columnIndex)
throws SQLServerException
getBigDecimal in interface java.sql.ResultSetSQLServerExceptionpublic java.math.BigDecimal getBigDecimal(java.lang.String columnName)
throws SQLServerException
getBigDecimal in interface java.sql.ResultSetSQLServerExceptionpublic java.math.BigDecimal getMoney(int columnIndex)
throws SQLServerException
columnIndex - The zero-based ordinal of a column.SQLServerException - when an error occurspublic java.math.BigDecimal getMoney(java.lang.String columnName)
throws SQLServerException
columnName - is the name of a column.SQLServerException - If any errors occur.public java.math.BigDecimal getSmallMoney(int columnIndex)
throws SQLServerException
columnIndex - The zero-based ordinal of a column.SQLServerException - If any errors occur.public java.math.BigDecimal getSmallMoney(java.lang.String columnName)
throws SQLServerException
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.ResultSetjava.sql.SQLExceptionpublic java.sql.RowId getRowId(java.lang.String columnLabel)
throws java.sql.SQLException
getRowId in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.SQLXML getSQLXML(int columnIndex)
throws java.sql.SQLException
getSQLXML in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
throws java.sql.SQLException
getSQLXML in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean rowUpdated()
throws SQLServerException
rowUpdated in interface java.sql.ResultSetSQLServerExceptionpublic boolean rowInserted()
throws SQLServerException
rowInserted in interface java.sql.ResultSetSQLServerExceptionpublic boolean rowDeleted()
throws SQLServerException
rowDeleted in interface java.sql.ResultSetSQLServerExceptionpublic void updateNull(int index)
throws SQLServerException
updateNull in interface java.sql.ResultSetSQLServerExceptionpublic void updateBoolean(int index,
boolean x)
throws SQLServerException
updateBoolean in interface java.sql.ResultSetSQLServerExceptionpublic void updateBoolean(int index,
boolean x,
boolean forceEncrypt)
throws SQLServerException
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.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 SQLServerException
updateByte in interface java.sql.ResultSetSQLServerExceptionpublic void updateByte(int index,
byte x,
boolean forceEncrypt)
throws SQLServerException
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.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 SQLServerException
updateShort in interface java.sql.ResultSetSQLServerExceptionpublic void updateShort(int index,
short x,
boolean forceEncrypt)
throws SQLServerException
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.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 SQLServerException
updateInt in interface java.sql.ResultSetSQLServerExceptionpublic void updateInt(int index,
int x,
boolean forceEncrypt)
throws SQLServerException
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.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 SQLServerException
updateLong in interface java.sql.ResultSetSQLServerExceptionpublic void updateLong(int index,
long x,
boolean forceEncrypt)
throws SQLServerException
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.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 SQLServerException
updateFloat in interface java.sql.ResultSetSQLServerExceptionpublic void updateFloat(int index,
float x,
boolean forceEncrypt)
throws SQLServerException
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.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 SQLServerException
updateDouble in interface java.sql.ResultSetSQLServerExceptionpublic void updateDouble(int index,
double x,
boolean forceEncrypt)
throws SQLServerException
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.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
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.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
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.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
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.columnName - is 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
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.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
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.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
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.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
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.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
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.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.ResultSetSQLServerExceptionpublic void updateBigDecimal(int index,
java.math.BigDecimal x,
java.lang.Integer precision,
java.lang.Integer scale)
throws SQLServerException
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.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
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.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.ResultSetSQLServerExceptionpublic void updateString(int columnIndex,
java.lang.String stringValue,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetjava.sql.SQLExceptionpublic void updateNString(int columnIndex,
java.lang.String nString,
boolean forceEncrypt)
throws java.sql.SQLException
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.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.java.sql.SQLException - when an error occurspublic void updateNString(java.lang.String columnLabel,
java.lang.String nString)
throws java.sql.SQLException
updateNString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNString(java.lang.String columnLabel,
java.lang.String nString,
boolean forceEncrypt)
throws java.sql.SQLException
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.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.java.sql.SQLException - when an error occurspublic void updateBytes(int index,
byte[] x)
throws SQLServerException
updateBytes in interface java.sql.ResultSetSQLServerExceptionpublic void updateBytes(int index,
byte[] x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateDate(int index,
java.sql.Date x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateTime(int index,
java.sql.Time x,
java.lang.Integer scale)
throws SQLServerException
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.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
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.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.ResultSetSQLServerExceptionpublic void updateTimestamp(int index,
java.sql.Timestamp x,
int scale)
throws SQLServerException
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.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
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.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
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.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
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.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
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.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
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.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
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.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
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.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 java.sql.SQLException
ISQLServerResultSetupdateDateTimeOffset in interface ISQLServerResultSetindex - The zero-based ordinal of a column.x - A DateTimeOffset Class object.java.sql.SQLException - when an error occurspublic void updateDateTimeOffset(int index,
DateTimeOffset x,
java.lang.Integer scale)
throws java.sql.SQLException
index - The zero-based ordinal of a column.x - A DateTimeOffset Class object.scale - scale of the columnjava.sql.SQLException - when an error occurspublic void updateDateTimeOffset(int index,
DateTimeOffset x,
java.lang.Integer scale,
boolean forceEncrypt)
throws java.sql.SQLException
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.java.sql.SQLException - when an error occurspublic void updateUniqueIdentifier(int index,
java.lang.String x)
throws java.sql.SQLException
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.index - The zero-based ordinal of a column.x - the new column valuejava.sql.SQLException - when an error occurspublic void updateUniqueIdentifier(int index,
java.lang.String x,
boolean forceEncrypt)
throws java.sql.SQLException
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.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.java.sql.SQLException - when an error occurspublic void updateAsciiStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateAsciiStream(int index,
java.io.InputStream x,
int length)
throws SQLServerException
updateAsciiStream in interface java.sql.ResultSetSQLServerExceptionpublic void updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws SQLServerException
updateAsciiStream in interface java.sql.ResultSetSQLServerExceptionpublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream streamValue,
long length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(int columnIndex,
java.io.InputStream streamValue,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(java.lang.String columnName,
java.io.InputStream streamValue,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateCharacterStream(int columnIndex,
java.io.Reader readerValue,
int length)
throws SQLServerException
updateCharacterStream in interface java.sql.ResultSetSQLServerExceptionpublic void updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateCharacterStream(java.lang.String columnName,
java.io.Reader readerValue,
int length)
throws SQLServerException
updateCharacterStream in interface java.sql.ResultSetSQLServerExceptionpublic void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateObject(int index,
java.lang.Object obj)
throws SQLServerException
updateObject in interface java.sql.ResultSetSQLServerExceptionpublic void updateObject(int index,
java.lang.Object x,
int scale)
throws SQLServerException
updateObject in interface java.sql.ResultSetSQLServerExceptionpublic void updateObject(int index,
java.lang.Object x,
int precision,
int scale)
throws SQLServerException
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.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
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.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
SQLServerExceptionpublic void updateNull(java.lang.String columnName)
throws SQLServerException
updateNull in interface java.sql.ResultSetSQLServerExceptionpublic void updateBoolean(java.lang.String columnName,
boolean x)
throws SQLServerException
updateBoolean in interface java.sql.ResultSetSQLServerExceptionpublic void updateBoolean(java.lang.String columnName,
boolean x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateByte(java.lang.String columnName,
byte x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateShort(java.lang.String columnName,
short x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateInt(java.lang.String columnName,
int x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateLong(java.lang.String columnName,
long x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateFloat(java.lang.String columnName,
float x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateDouble(java.lang.String columnName,
double x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x,
boolean forceEncrypt)
throws SQLServerException
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.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
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.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
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.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.ResultSetSQLServerExceptionpublic void updateString(java.lang.String columnName,
java.lang.String x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateBytes(java.lang.String columnName,
byte[] x,
boolean forceEncrypt)
throws SQLServerException
updateRow or insertRow methods are called to update the database.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.ResultSetSQLServerExceptionpublic void updateDate(java.lang.String columnName,
java.sql.Date x,
boolean forceEncrypt)
throws SQLServerException
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.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.ResultSetSQLServerExceptionpublic void updateTime(java.lang.String columnName,
java.sql.Time x,
int scale)
throws SQLServerException
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.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
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.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.ResultSetSQLServerExceptionpublic void updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x,
int scale)
throws SQLServerException
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.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
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.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
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.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
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.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
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.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
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.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
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.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
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.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 java.sql.SQLException
ISQLServerResultSetupdateDateTimeOffset in interface ISQLServerResultSetcolumnName - The name of a column.x - A DateTimeOffset Class object.java.sql.SQLException - when an error occurspublic void updateDateTimeOffset(java.lang.String columnName,
DateTimeOffset x,
int scale)
throws java.sql.SQLException
columnName - The name of a column.x - A DateTimeOffset Class object.scale - the scale of the columnSQLServerException - If any errors occur.java.sql.SQLExceptionpublic void updateDateTimeOffset(java.lang.String columnName,
DateTimeOffset x,
int scale,
boolean forceEncrypt)
throws java.sql.SQLException
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.java.sql.SQLException - If any errors occur.public void updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x)
throws java.sql.SQLException
Stringvalue. 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.columnName - The name of a column.x - the new column valuejava.sql.SQLException - If any errors occur.public void updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x,
boolean forceEncrypt)
throws java.sql.SQLException
Stringvalue. 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.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.java.sql.SQLException - If any errors occur.public void updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
throws SQLServerException
updateObject in interface java.sql.ResultSetSQLServerExceptionpublic void updateObject(java.lang.String columnName,
java.lang.Object x,
int precision,
int scale)
throws SQLServerException
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.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
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.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.ResultSetSQLServerExceptionpublic void updateRowId(int columnIndex,
java.sql.RowId x)
throws java.sql.SQLException
updateRowId in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
throws java.sql.SQLException
updateRowId in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
updateSQLXML in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML x)
throws java.sql.SQLException
updateSQLXML in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getHoldability()
throws java.sql.SQLException
getHoldability in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void insertRow()
throws SQLServerException
insertRow in interface java.sql.ResultSetSQLServerExceptionpublic void updateRow()
throws SQLServerException
updateRow in interface java.sql.ResultSetSQLServerExceptionpublic void deleteRow()
throws SQLServerException
deleteRow in interface java.sql.ResultSetSQLServerExceptionpublic void refreshRow()
throws SQLServerException
refreshRow in interface java.sql.ResultSetSQLServerExceptionpublic void cancelRowUpdates()
throws SQLServerException
cancelRowUpdates in interface java.sql.ResultSetSQLServerExceptionpublic void moveToInsertRow()
throws SQLServerException
moveToInsertRow in interface java.sql.ResultSetSQLServerExceptionpublic void moveToCurrentRow()
throws SQLServerException
moveToCurrentRow in interface java.sql.ResultSetSQLServerExceptionpublic java.sql.Statement getStatement()
throws SQLServerException
getStatement in interface java.sql.ResultSetSQLServerExceptionpublic void updateClob(int columnIndex,
java.sql.Clob clobValue)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateClob(int columnIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateClob(java.lang.String columnName,
java.sql.Clob clobValue)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(int columnIndex,
java.sql.NClob nClob)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(int columnIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(int columnIndex,
java.sql.Blob blobValue)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(int columnIndex,
java.io.InputStream inputStream)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(java.lang.String columnName,
java.sql.Blob blobValue)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateArray(int columnIndex,
java.sql.Array x)
throws SQLServerException
updateArray in interface java.sql.ResultSetSQLServerExceptionpublic void updateArray(java.lang.String columnName,
java.sql.Array x)
throws SQLServerException
updateArray in interface java.sql.ResultSetSQLServerExceptionpublic void updateRef(int columnIndex,
java.sql.Ref x)
throws SQLServerException
updateRef in interface java.sql.ResultSetSQLServerExceptionpublic void updateRef(java.lang.String columnName,
java.sql.Ref x)
throws SQLServerException
updateRef in interface java.sql.ResultSetSQLServerExceptionpublic java.net.URL getURL(int columnIndex)
throws SQLServerException
getURL in interface java.sql.ResultSetSQLServerExceptionpublic java.net.URL getURL(java.lang.String sColumn)
throws SQLServerException
getURL in interface java.sql.ResultSetSQLServerExceptionCopyright © 2018 Microsoft Corporation. All rights reserved.