Columns
are numbered from 1 onwards. Retrieving the column data using index
number is efficient.
Below
table shows various methods that you can update column value using
index number of the column.
Method
|
Description
|
updateArray(int
columnIndex, Array x)
|
Update the column
with the array 'x'
|
updateAsciiStream(int
columnIndex, InputStream x)
|
Update the column
with an ascii stream value.
|
updateAsciiStream(int
columnIndex, InputStream x, int length)
|
Update the column
with an ascii stream value, which will have the specified number
of bytes.
|
updateAsciiStream(int
columnIndex, InputStream x, long length)
|
Update the column
with an ascii stream value, which will have the specified number
of bytes.
|
updateBigDecimal(int
columnIndex, BigDecimal x)
|
Update the column
with a java.math.BigDecimal value.
|
updateBinaryStream(int
columnIndex, InputStream x)
|
Update the column
with a binary stream value.
|
updateBinaryStream(int
columnIndex, InputStream x, int length)
|
Update the column
with a binary stream value, which will have the specified number
of bytes.
|
updateBinaryStream(int
columnIndex, InputStream x, long length)
|
Update the column
with a binary stream value, which will have the specified number
of bytes.
|
updateBlob(int
columnIndex, Blob x)
|
Update the column
with a java.sql.Blob value.
|
updateBlob(int
columnIndex, InputStream inputStream)
|
Update the column
with the given input stream.
|
updateBlob(int
columnIndex, InputStream inputStream, long length)
|
Update the column
with the given input stream, which will have the specified number
of bytes.
|
updateBoolean(int
columnIndex, boolean x)
|
Update the column
with a boolean value.
|
updateByte(int
columnIndex, byte x)
|
Update the column
with a byte value.
|
updateBytes(int
columnIndex, byte[] x)
|
Update the column
with a byte array value.
|
updateCharacterStream(int
columnIndex, Reader x)
|
Update the column
with a character stream value.
|
updateCharacterStream(int
columnIndex, Reader x, int length)
|
Update the column
with a character stream value, which will have the specified
number of bytes.
|
updateCharacterStream(int
columnIndex, Reader x, long length)
|
Update the column
with a character stream value, which will have the specified
number of bytes.
|
updateClob(int
columnIndex, Clob x)
|
Update the column
with a java.sql.Clob value.
|
updateClob(int
columnIndex, Reader reader)
|
Update the column
with the given Reader object.
|
updateClob(int
columnIndex, Reader reader, long length)
|
Update the column
with the given Reader object, which is the given number of
characters long.
|
updateDate(int
columnIndex, Date x)
|
Update the column
with a java.sql.Date value.
|
updateDouble(int
columnIndex, double x)
|
Update the column
with a double value.
|
updateFloat(int
columnIndex, float x)
|
Update the column
with a float value.
|
updateInt(int
columnIndex, int x)
|
Update the column
with an int value.
|
updateLong(int
columnIndex, long x)
|
Update the column
with a long value.
|
updateNCharacterStream(int
columnIndex, Reader x)
|
Update the column
with a character stream value.
|
updateNCharacterStream(int
columnIndex, Reader x, long length)
|
Update the column
with a character stream value, which will have the specified
number of bytes.
|
updateNClob(int
columnIndex, NClob nClob)
|
Update the column
with a java.sql.NClob value.
|
updateNClob(int
columnIndex, Reader reader)
|
Update the column
with the given Reader The data will be read from the stream as
needed until end-of-stream is reached.
|
updateNClob(int
columnIndex, Reader reader, long length)
|
Update the column
with the given Reader object, which is the given number of
characters long.
|
updateNString(int
columnIndex, String nString)
|
Update the column
with a String value.
|
updateNull(int
columnIndex)
|
Update the column
with a null value.
|
updateObject(int
columnIndex, Object x)
|
Update the column
with an Object value.
|
updateObject(int
columnIndex, Object x, int scaleOrLength)
|
Update the column
with an Object value.
|
updateObject(int
columnIndex, Object x, SQLType targetSqlType)
|
Update the column
with an Object value.
|
updateObject(int
columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)
|
Update the column
with an Object value.
|
updateRef(int
columnIndex, Ref x)
|
Update the column
with a java.sql.Ref value.
|
updateRowId(int
columnIndex, RowId x)
|
Update the column
with a RowId value.
|
updateShort(int
columnIndex, short x)
|
Update the column
with a short value.
|
updateSQLXML(int
columnIndex, SQLXML xmlObject)
|
Update the column
with a java.sql.SQLXML value.
|
updateString(int
columnIndex, String x)
|
Update the column
with a String value.
|
updateTime(int
columnIndex, Time x)
|
Update the column
with a java.sql.Time value.
|
updateTimestamp(int
columnIndex, Timestamp x)
|
Update the column
with a java.sql.Timestamp value.
|
No comments:
Post a Comment