java.lang.AutoCloseable
, java.sql.ResultSet
, java.sql.Wrapper
SQLServerResultSet
public interface ISQLServerResultSet
extends java.sql.ResultSet
SQLServerResultSet
class.Modifier and Type | Field | Description |
---|---|---|
static int |
CONCUR_SS_OPTIMISTIC_CC |
|
static int |
CONCUR_SS_OPTIMISTIC_CCVAL |
|
static int |
CONCUR_SS_SCROLL_LOCKS |
|
static int |
TYPE_SS_DIRECT_FORWARD_ONLY |
|
static int |
TYPE_SS_SCROLL_DYNAMIC |
|
static int |
TYPE_SS_SCROLL_KEYSET |
|
static int |
TYPE_SS_SCROLL_STATIC |
|
static int |
TYPE_SS_SERVER_CURSOR_FORWARD_ONLY |
Modifier and Type | Method | Description |
---|---|---|
java.sql.Timestamp |
getDateTime(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getDateTime(int columnIndex,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getDateTime(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getDateTime(java.lang.String colName,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
DateTimeOffset |
getDateTimeOffset(int columnIndex) |
Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column
ordinal.
|
DateTimeOffset |
getDateTimeOffset(java.lang.String columnName) |
Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.
|
Geography |
getGeography(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.
|
Geography |
getGeography(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.
|
Geometry |
getGeometry(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.
|
Geometry |
getGeometry(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a
com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.
|
java.math.BigDecimal |
getMoney(int columnIndex) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getMoney(java.lang.String columnName) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
SensitivityClassification |
getSensitivityClassification() |
Returns the Data Classification information for the current ResultSet For SQL Servers that do not support Data
Classification or results that do not fetch any classified columns, this data can be null.
|
java.sql.Timestamp |
getSmallDateTime(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getSmallDateTime(int columnIndex,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getSmallDateTime(java.lang.String columnName) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.sql.Timestamp |
getSmallDateTime(java.lang.String colName,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
java.math.BigDecimal |
getSmallMoney(int columnIndex) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getSmallMoney(java.lang.String columnName) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.lang.String |
getUniqueIdentifier(int columnIndex) |
Returns the value of the designated column in the current row of this ResultSet object as a String object in the
Java programming language.
|
java.lang.String |
getUniqueIdentifier(java.lang.String columnLabel) |
Returns the value of the designated column in the current row of this ResultSet object as a String object in the
Java programming language.
|
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,
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 |
updateBoolean(int index,
boolean x,
boolean forceEncrypt) |
Updates the designated column with a
boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean x,
boolean forceEncrypt) |
Updates the designated column with a
boolean value. |
void |
updateByte(int index,
byte x,
boolean forceEncrypt) |
Updates the designated column with a
byte value. |
void |
updateByte(java.lang.String columnName,
byte x,
boolean forceEncrypt) |
Updates the designated column with a
byte value. |
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,
boolean forceEncrypt) |
Updates the designated column with a byte array value.
|
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,
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,
boolean forceEncrypt) |
Updates the designated column with a
double value. |
void |
updateDouble(java.lang.String columnName,
double x,
boolean forceEncrypt) |
Updates the designated column with a
double value. |
void |
updateFloat(int index,
float x,
boolean forceEncrypt) |
Updates the designated column with a
float value. |
void |
updateFloat(java.lang.String columnName,
float x,
boolean forceEncrypt) |
Updates the designated column with a
float value. |
void |
updateInt(int index,
int x,
boolean forceEncrypt) |
Updates the designated column with an
int value. |
void |
updateInt(java.lang.String columnName,
int x,
boolean forceEncrypt) |
Updates the designated column with an
int value. |
void |
updateLong(int index,
long x,
boolean forceEncrypt) |
Updates the designated column with a
long value. |
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 |
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,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
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. |
void |
updateObject(int index,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scale,
boolean forceEncrypt) |
Updates the designated column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int precision,
int scale) |
Updates the designated column with an
Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int precision,
int scale,
boolean forceEncrypt) |
Updates the designated column with an
Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scale,
boolean forceEncrypt) |
Updates the designated column with an Object value.
|
void |
updateShort(int index,
short x,
boolean forceEncrypt) |
Updates the designated column with a
short value. |
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 |
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,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
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,
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,
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,
int scale) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x,
int scale,
boolean forceEncrypt) |
Updates the designated column with a
java.sql.Timestamp value. |
void |
updateUniqueIdentifier(int index,
java.lang.String x) |
Updates the designated column with a
String value. |
void |
updateUniqueIdentifier(int index,
java.lang.String x,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
void |
updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x) |
Updates the designated column with a
String value. |
void |
updateUniqueIdentifier(java.lang.String columnName,
java.lang.String x,
boolean forceEncrypt) |
Updates the designated column with a
String value. |
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
static final int TYPE_SS_DIRECT_FORWARD_ONLY
static final int TYPE_SS_SERVER_CURSOR_FORWARD_ONLY
static final int TYPE_SS_SCROLL_STATIC
static final int TYPE_SS_SCROLL_KEYSET
static final int TYPE_SS_SCROLL_DYNAMIC
static final int CONCUR_SS_OPTIMISTIC_CC
static final int CONCUR_SS_SCROLL_LOCKS
static final int CONCUR_SS_OPTIMISTIC_CCVAL
Geometry getGeometry(int columnIndex) throws SQLServerException
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occursGeometry getGeometry(java.lang.String columnName) throws SQLServerException
columnName
- the name of the columnSQLServerException
- when an error occursGeography getGeography(int columnIndex) throws SQLServerException
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occursGeography getGeography(java.lang.String columnName) throws SQLServerException
columnName
- the name of the columnSQLServerException
- when an error occursjava.lang.String getUniqueIdentifier(int columnIndex) throws SQLServerException
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occursjava.lang.String getUniqueIdentifier(java.lang.String columnLabel) throws SQLServerException
columnLabel
- the name of the columnSQLServerException
- when an error occursjava.sql.Timestamp getDateTime(int columnIndex) throws SQLServerException
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occursjava.sql.Timestamp getDateTime(java.lang.String columnName) throws SQLServerException
columnName
- is the name of the columnSQLServerException
- If any errors occur.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.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.java.sql.Timestamp getSmallDateTime(int columnIndex) throws SQLServerException
columnIndex
- the first column is 1, the second is 2, ...SQLServerException
- when an error occursjava.sql.Timestamp getSmallDateTime(java.lang.String columnName) throws SQLServerException
columnName
- is the name of a column.SQLServerException
- If any errors occur.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.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.DateTimeOffset getDateTimeOffset(int columnIndex) throws SQLServerException
columnIndex
- The zero-based ordinal of a column.SQLServerException
- when an error occursDateTimeOffset getDateTimeOffset(java.lang.String columnName) throws SQLServerException
columnName
- The name of a column.SQLServerException
- when an error occursjava.math.BigDecimal getMoney(int columnIndex) throws SQLServerException
columnIndex
- The zero-based ordinal of a column.SQLServerException
- when an error occursjava.math.BigDecimal getMoney(java.lang.String columnName) throws SQLServerException
columnName
- is the name of a column.SQLServerException
- If any errors occur.java.math.BigDecimal getSmallMoney(int columnIndex) throws SQLServerException
columnIndex
- The zero-based ordinal of a column.SQLServerException
- If any errors occur.java.math.BigDecimal getSmallMoney(java.lang.String columnName) throws SQLServerException
columnName
- is the name of a column.SQLServerException
- If any errors occur.void updateDateTimeOffset(int index, DateTimeOffset x) throws SQLServerException
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.SQLServerException
- when an error occursvoid updateDateTimeOffset(java.lang.String columnName, DateTimeOffset x) throws SQLServerException
columnName
- The name of a column.x
- A DateTimeOffset Class object.SQLServerException
- when an error occursvoid 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 occursvoid updateObject(int index, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale, boolean forceEncrypt) throws SQLServerException
index
- the first column is 1, the second is 2, ...obj
- the new column valuetargetSqlType
- the SQL type to be sent to the databasescale
- for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java
Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other
types, this value will be ignored.forceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.void updateObject(java.lang.String columnName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale, boolean forceEncrypt) throws SQLServerException
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then
the label is the name of the columnobj
- the new column valuetargetSqlType
- the SQL type to be sent to the databasescale
- for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java
Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other
types, this value will be ignored.forceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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
- the column namex
- the new column valueSQLServerException
- If any errors occur.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.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 occursvoid 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 occursvoid 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.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.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 occursvoid 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 occursvoid 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 occursvoid updateNString(int columnIndex, java.lang.String nString, boolean forceEncrypt) throws SQLServerException
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.SQLServerException
- when an error occursvoid updateNString(java.lang.String columnLabel, java.lang.String nString, boolean forceEncrypt) throws SQLServerException
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.SQLServerException
- when an error occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid 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 occursvoid updateDateTimeOffset(int index, DateTimeOffset x, java.lang.Integer scale) throws SQLServerException
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.scale
- scale of the columnSQLServerException
- when an error occursvoid updateDateTimeOffset(int index, DateTimeOffset x, java.lang.Integer scale, boolean forceEncrypt) throws SQLServerException
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.scale
- scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occursvoid updateUniqueIdentifier(int index, java.lang.String x) 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.index
- The zero-based ordinal of a column.x
- the new column valueSQLServerException
- when an error occursvoid updateUniqueIdentifier(int index, 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.index
- The zero-based ordinal of a column.x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- when an error occursvoid 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 occursvoid 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 occursvoid 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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.void updateDateTimeOffset(java.lang.String columnName, DateTimeOffset x, int scale) throws SQLServerException
columnName
- The name of a column.x
- A DateTimeOffset Class object.scale
- the scale of the columnSQLServerException
- If any errors occur.void updateDateTimeOffset(java.lang.String columnName, DateTimeOffset x, int scale, boolean forceEncrypt) throws SQLServerException
columnName
- The name of a column.x
- A DateTimeOffset Class object.scale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.void updateUniqueIdentifier(java.lang.String columnName, java.lang.String x) 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
- The name of a column.x
- the new column valueSQLServerException
- If any errors occur.void updateUniqueIdentifier(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
- The name of a column.x
- the new column valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- If any errors occur.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.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.SensitivityClassification getSensitivityClassification()
Copyright © 2018 Microsoft Corporation. All rights reserved.