Wednesday 1 October 2014

Update column value using index number of the column

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.


Prevoius                                                 Next                                                 Home

No comments:

Post a Comment