Wednesday 1 October 2014

Update column value using the name of the column

Below table shows various methods of ResultSet interface, that you can update column value using name of the column.

Method
Description
updateArray(int columnLabel, Array x)
Update the column with the array 'x'.
updateAsciiStream(int columnLabel, InputStream x)
Update the column with an ascii stream value.
updateAsciiStream(int columnLabel, InputStream x, int length)
Update the column with an ascii stream value, which will have the specified number of bytes.
updateAsciiStream(int columnLabel, InputStream x, long length)
Update the column with an ascii stream value, which will have the specified number of bytes.
updateBigDecimal(int columnLabel, BigDecimal x)
Update the column with a java.math.BigDecimal value.
updateBinaryStream(int columnLabel, InputStream x)
Update the column with a binary stream value.
updateBinaryStream(int columnLabel, InputStream x, int length)
Update the column with a binary stream value, which will have the specified number of bytes.
updateBinaryStream(int columnLabel, InputStream x, long length)
Update the column with a binary stream value, which will have the specified number of bytes.
updateBlob(int columnLabel, Blob x)
Update the column with a java.sql.Blob value.
updateBlob(int columnLabel, InputStream inputStream)
Update the column with the given input stream.
updateBlob(int columnLabel, InputStream inputStream, long length)
Update the column with the given input stream, which will have the specified number of bytes.
updateBoolean(int columnLabel, boolean x)
Update the column with a boolean value.
updateByte(int columnLabel, byte x)
Update the column with a byte value.
updateBytes(int columnLabel, byte[] x)
Update the column with a byte array value.
updateCharacterStream(int columnLabel, Reader x)
Update the column with a character stream value.
updateCharacterStream(int columnLabel, Reader x, int length)
Update the column with a character stream value, which will have the specified number of bytes.
updateCharacterStream(int columnLabel, Reader x, long length)
Update the column with a character stream value, which will have the specified number of bytes.
updateClob(int columnLabel, Clob x)
Update the column with a java.sql.Clob value.
updateClob(int columnLabel, Reader reader)
Update the column with the given Reader object.
updateClob(int columnLabel, Reader reader, long length)
Update the column with the given Reader object, which is the given number of characters long.
updateDate(int columnLabel, Date x)
Update the column with a java.sql.Date value.
updateDouble(int columnLabel, double x)
Update the column with a double value.
updateFloat(int columnLabel, float x)
Update the column with a float value.
updateInt(int columnLabel, int x)
Update the column with an int value.
updateLong(int columnLabel, long x)
Update the column with a long value.
updateNCharacterStream(int columnLabel, Reader x)
Update the column with a character stream value.
updateNCharacterStream(int columnLabel, Reader x, long length)
Update the column with a character stream value, which will have the specified number of bytes.
updateNClob(int columnLabel, NClob nClob)
Update the column with a java.sql.NClob value.
updateNClob(int columnLabel, 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 columnLabel, Reader reader, long length)
Update the column with the given Reader object, which is the given number of characters long.
updateNString(int columnLabel, String nString)
Update the column with a String value.
updateNull(int columnLabel)
Update the column with a null value.
updateObject(int columnLabel, Object x)
Update the column with an Object value.
updateObject(int columnLabel, Object x, int scaleOrLength)
Update the column with an Object value.
updateObject(int columnLabel, Object x, SQLType targetSqlType)
Update the column with an Object value.
updateObject(int columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)
Update the column with an Object value.
updateRef(int columnLabel, Ref x)
Update the column with a java.sql.Ref value.
updateRowId(int columnLabel, RowId x)
Update the column with a RowId value.
updateShort(int columnLabel, short x)
Update the column with a short value.
updateSQLXML(int columnLabel, SQLXML xmlObject)
Update the column with a java.sql.SQLXML value.
updateString(int columnLabel, String x)
Update the column with a String value.
updateTime(int columnLabel, Time x)
Update the column with a java.sql.Time value.
updateTimestamp(int columnLabel, Timestamp x)
Update the column with a java.sql.Timestamp value.




Prevoius                                                 Next                                                 Home

No comments:

Post a Comment