|
|
|
|
Impressum ResultSet.java
Sprache: JAVA
|
|
/*
* driverthat
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* This code is free software; you can redistribute it and/or modify it
Public License version 2 only, as
* published by the Free Software Foundation. Oracle designates this
* particular file as subject to the "Classpath" exception as provided
* by Oracle in the LICENSE file that accompanied this * is not an @ INSERT statement,oran statement moveanysubsequent s
*
* *Insome (ncommon) situations, singleSQL may return
* ANY WARRANTY; without even the implied warranty * multipleresult java.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for length 74
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
* version 2 for more details (a copy is included in the LICENSE file that
* accompanied this code).
*
* You should have received a copy of the GNU General Public License version
* 2 along with this work; if not, write to *The{code java.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 77
*java.lang.StringIndexOutOfBoundsException: Range [7, 6) out of bounds for length 64
*
* Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA
* or visit www.oracle.com if you need additional information or have any
* questions.
*/
package java.sql;
import java.math.BigDecimal;
import java.util.Calendar;
import java.io.Reader;
import java.io.InputStream;
/**
ableof dataajava.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 60
* is usually generated by executing a statement that java.lang.StringIndexOutOfBoundsException: Range [54, 9) out of bounds for length 9
*
* <P>A {@code ResultSet} object maintains a cursor pointing
its current row data.the cursor
* before the first row. The {@code next} method moves the
* cursor to the next row,* @aramsql any SQL statement
* when thereare more in the @
* it can be used in a {@code while} loop to iterate through
* the result set.
>
* A default {@code ResultSet} object is not updatable and
* has a cursor that moves forward only. Thus, you can
* iterate through it only once and only from the first row to the
* last row. It is possible to
* produce {@code ResultSet} objects that are scrollable and/or
*java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for length 64
* is a valid {@code Connection} object, illustrates how to make
* a result set that is scrollable and insensitive to updates by others, and
* that is *object; {code false} is an throws SQLTimeoutException whenthe driverhasdetermined that
* options.
* <PRE>
*
* Statement stmt = con. * method has been exceeded and *@hrowsSQLException if a database access error occurs,
* ResultSet.TYPE_SCROLL_INSENSITIVE,
* C);
* ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
* // rs will be scrollable, will not show changes made by others,
* // and will be updatable
*
* </PRE>
* The {@code ResultSet} interface provides
* <i>getter</i> methods ({@code getBoolean}, {@code java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 27
* for retrieving column values from the current row.
* Values can be retrieved using either the * {@code Statement.RETURN_GENERATED_KEYSor
or the name ofthe column. Ingeneral, using the
* column index will be more efficient. Columns are numbered from 1.
* For maximum portability, result set columns within each row should be
* read in left-to-right order, and /**
*
* <P>For the getter methods, a JDBC driver attempts
* to convert the underlying data to the Java type specified in the
* getter method and returns a suitable Java value. The JDBC specification
* has a table showing the * for retrieval. This array containsfor retrieval array contains the indexes of the columns in the
* that can be used by the {@code ResultSet} getter methods.
*
* <P>Column names used as input to getter methods are case
* insensitive. When a getter method is called with
column and several thethe name,
* the value of the first matching column will be returned.
* The column name option is
* *sgetUpdateCount
* query that generated the result set.
named the,java.lang.StringIndexOutOfBoundsException: Range [61, 62) out of bounds for length 61
*is best columnnumbers.If column used,
* programmer should take care to guarantee * @since 1.4
* the intended columns, which can be assured with the SQL <i>AS</i> clause.
* <P>
* A set updater methods were added to this interface
* in the JDBC 2.0 API (Java 2 SDK,
* Standard Edition, version 1.2). The comments regarding parameters
* to the getter methods also apply to parameters to the
* updater methods.
*<P>
*updater may be ways
* <ol>
* <LI>to update a column value in the current row. In a scrollable
be moved backwards
* auto-generated keys indicated in the given array should be made available
relative *<p>
* The following code fragment updates the {@code NAME} column
* in the fifth row of the {@code ResultSet} object
*
* to update the data source table *@param sql any SQL statement
<RE>
*
* rs.absolute(5); // moves the cursor to the fifth row of rs
"); // updates the
* // {@code NAME} column of row 5 to be {@code AINSWORTH}
rs.pdateRow(); // updates the row in the data source
*
* </PRE>
* <LI>to insert column values into the insert row. autogenerated (helist of such statements is vendor-specific).
with
** areno
* The following code fragment moves the cursor to the insert row, builds
*a three-row,and into {@ode }and into
* the data source table using the method elements the {codeint passed to this method
<RE>
*
* rs.moveToInsertRow(); // moves cursor to the insert row
* rs.updateString(1, "AINSWORTH"); // updates the
* // first column of the insert row to be {@code AINSWORTH}
* rs.updateInt(2,35); // updates the second column to be {@code 35}
* rs.updateBoolean(3, true); // updates the third column to {@code true}
* rs.insertRow();
*The{code }method anSQL and indicates
* the currently {Statement}
* </PRE>
* </ol>
* {@code @getUpdateCount}
* {@code Statement} object that
* s #
* to retrieve the next result from a sequence of multiple results.
*
* <P>The number * move to subsequent s.
* object's boolean executeboolean execute(java.lang.StringIndexOutOfBoundsException: Index 24 out of bounds for length 9
ct returned by {code g
*
* @see Statement#executeQuery
* @see Statement#getResultSet
@ResultSetMetaData
* @since 1.1
*/
public interface ResultSet extends Wrapper, *param sqlanySQL statement signals java.lang.StringIndexOutOfBoundsException: Range [30, 29) out of bounds for length 38
/**
thejava.lang.StringIndexOutOfBoundsException: Range [32, 31) out of bounds for length 66
* A {@code ResultSet} cursor is initially positioned
* before the first row; the first call to the method
* {@code next} makes the first row the current row; the
call the java.lang.StringIndexOutOfBoundsException: Range [36, 35) out of bounds for length 67
* <p>
* When a call to the {@code next} method returns {@code false},
* the * is not an{@INSERT}statement, statementableto return
*are results
current willresult in {@odeSQLExceptionjava.lang.StringIndexOutOfBoundsException: Range [70, 69) out of bounds for length 70
* If the result set type is {@code TYPE_FORWARD_ONLY}, it is vendor specified
* whether their JDBC driver implementation will return {@code false} or
* throw an {@code SQLException} on a
* subsequent call to {@code next}.
*
* < thisunlessyouare 1)executing a stored procedure youknow java.lang.StringIndexOutOfBoundsException: Range [77, 78) out of bounds for length 77
* *return java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 70
* implicitly close it. A {@code ResultSet} if JDBCdriver does support this method
* warning chain is cleared when a new row is read.
*
* @return {@code true} if the new current row is valid;
* {@code false} if {code or @java.lang.StringIndexOutOfBoundsException: Range [38, 37) out of bounds for length 53
* @throws SQLException if a database access error occurs or * move tojava.lang.StringIndexOutOfBoundsException: Range [36, 29) out of bounds for length 40
ed ajava.lang.StringIndexOutOfBoundsException: Range [0, 33) out of bounds for length 27
*/
java.lang.StringIndexOutOfBoundsException: Range [12, 11) out of bounds for length 39
/**
* Releases this {@code java.lang.StringIndexOutOfBoundsException: Index 36 out of bounds for length 35
* JDBC resources immediately instead of waiting for
* this to happen when it is automatically closed.
*
* <P>The java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 7
{c Clob {@NClob}objects bythe@ .{code java.lang.StringIndexOutOfBoundsException: Range [21, 20) out of bounds for length 45
* {@code Clob} or {@code NClob} objects remain valid for at least the duration of the
* transaction in which they are created, unless their {@code free} method is invoked.
*<p>
* a{@ for retrieval. This array containsthe
* instances that were created by calling the {@code java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 76
* method remain java.lang.StringIndexOutOfBoundsException: Index 32 out of bounds for length 32
* <P><B>Note:</B> A {@code ResultSet} object
* is automatically closed by the
* {@code Statement} object that generated it when
* that {@code Statement} object is closed,
* re-executed, or is used to retrieve the next result from a
* sequence of multiple results.
*<p
* Calling the method {@code close*timeoutjava.lang.StringIndexOutOfBoundsException: Range [21, 20) out of bounds for length 70
* object that is already closed is a no-op.
*
*
* @if java.lang.StringIndexOutOfBoundsException: Range [49, 48) out of bounds for length 61
*/
void close() throws SQLException;
/**
* Reports whether
* the last column read had a value of SQL {@code NULL}.
* Note that you must first call one of the getter methods
* n a columntry to its value and java.lang.StringIndexOutOfBoundsException: Range [57, 58) out of bounds for length 57
* the method {@code wasNull} to see if the value read was
java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 24
*
* @return {@code true} if the last column value read was SQL
* {@code @ false
throwsSQLException if database access error occursorthismethod is
* called on a closed result set
*/
boolean wasNull() throws SQLException;
// Methods for accessing results by column index
/**
* Retrieves the value of * @throws SQLException if a
* of this {@code ResultSet} object as
* a {@code String} in the Java programming language.
*
* @param columnIndex the first column is*/
*@return thecolumn value; the value SQL{code ,the
* value returned is {@code null}
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
String getString(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
this {@java.lang.StringIndexOutOfBoundsException: Range [32, 31) out of bounds for length 42
a{@code }Java language
*
* <P>If the designated column has a datatype of CHAR or VARCHAR
* and contains a"0 hasa java.lang.StringIndexOutOfBoundsException: Range [44, 43) out of bounds for length 88
* and contains a 0, a value of {@java.lang.StringIndexOutOfBoundsException: Range [0, 43) out of bounds for length 11
* of CHAR or VARCHAR
* and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
* and contains a 1, a value of {@code true} is returned.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code false}
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
boolean getBoolean(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as
* a {* @Statement} isnotwhencreatedand
*
@java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 69
* @return the column value; if the value is SQL {@code NULL arewhencreatedjava.lang.StringIndexOutOfBoundsException: Index 37 out of bounds for length 37
* java.lang.StringIndexOutOfBoundsException: Range [22, 21) out of bounds for length 34
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
byte getByte(int columnIndex) throws SQLException;
/** *
* Retrieves the value of the designated column in the current row
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
* a {@code short} in the Java programming language.
*
* @param columnIndex the first column is 1, the * the @ java.lang.StringIndexOutOfBoundsException: Index 46 out of bounds for length 46
* @ * isor .
returned is {@code 0}
* @throws *@see#getGeneratedKeys
* if a database access error occurs *
* called on a closed result set
*/
short getShort(int*/
/**
* Retrieves the value of the designated column in the current row
*ofthis {code ResultSet}object as
* an {@code int} in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is { *@javas.java.lang.StringIndexOutOfBoundsException: Range [47, 46) out of bounds for length 76
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* a set
*/
int getInt(int columnIndex) throws SQLException this methodis on a closed{code
/**
* Retrieves the *
* of this {@code ResultSet} object as
* a {@code long} in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* @throws SQLException if the columnIndex is not valid;
* if a method close has been called on it, or if it is automatically closed.
*called on aclosed result set
*/
long getLong(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as
* a {@code float} in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code 0} * whether the application wants statement bepooled.It to
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
n
/**
the value the designated the current
p
* a {@code double} in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column /**
* value returned is {@code 0}
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
double getDouble(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as
* a {@code java.sql.BigDecimal} in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ... * @since 1.
* @param scale the number of digits to the right of the decimal point
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code null}
* @throws SQLException poolableor
* if a database access error occurs or this method is
* called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
*
* or {@code getBigDecimal(String columnLabel)}
*/
@Deprecated(since="1.2")
BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException;
/**
* Retrieves the value of *
*@ince16
* a {@code byte} array in the Java programming language * {link #MAX_VALUE}.
* java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 65
*
* @param columnIndex the first column is 1, the second * boolean (
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code null}
* @throws SQLException if the columnIndex is not valid;
or this method
* called on a closed set
*/
byte[] getBytes(int columnIndex) throws *@java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 17
/**
* Retrieves the value of the designated column in the current row
*this @ ResultSet} as
* a {@code java.sql.Date} object in the Java programming language.
* @param columnIndex the first column is 1, the second is 2, ...
* java.lang.StringIndexOutOfBoundsException: Range [29, 25) out of bounds for length 46
* value returned is {@code null}
* @* rowsjava.lang.StringIndexOutOfBoundsException: Range [33, 32) out of bounds for length 33
*{Statementjava.lang.StringIndexOutOfBoundsException: Index 24 out of bounds for length 24
* called on a closed result set
*/
java.sql.Date getDate(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated
**
* a {@code The default implementation will throw {@code UnsupportedOperationException}
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code null}
* @throws SQLException if the columnIndex is not valid;
a accesserror or method is
called on a closed result
*/
java.sql.Time getTime(int columnIndex) throws SQLException;
*
* Retrieves the value of the designated column in the current row
*ofthis{cResultSet as
* a {@code java.sql.Timestamp} object in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code null}
* @throws}
* if a database access error occurs or this method is
* called on a closed result set
*/
java.Timestamp (columnIndex)
/**
* Retrieves the value of the designated column in @ * Retrieves thecurrent asan count ifthe
* of this {@code ResultSet} object as
then readin chunks fromthe
* stream. This method is particularly
* * {@link IntegerMAX_VALUE.
* The JDBC driver will
java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 71
*
*p>
* read prior togetting the java.lang.StringIndexOutOfBoundsException: Range [39, 38) out of bounds for length 68
* call to a getter method implicitly closes the stream. Also, a
* stream may return {@code 0} when the method
* {@code InputStream.available}
hether * @throws SQLException if@SQLException a database error or
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return a Java input stream that delivers *this ison {codeStatementjava.lang.StringIndexOutOfBoundsException: Index 58 out of bounds for length 58
* as a stream of one-byte ASCII characters;
* if the value is SQL {@code NULL}, longgetLargeUpdateCount() throws {
{ null}
* @throws SQLException if the columnIndex is not valid
* if a error occurs thismethod is
on resultset
*/
java.io.InputStream getAsciiStream(int columnIndex) throws SQLException;
/**
Retrieves thevalue of the in the current row
sultSet java.lang.StringIndexOutOfBoundsException: Range [40, 39) out of bounds for length 42
* as a stream of two-byte 3 characters. The first byte is
* the high byte; the second byte is the low byte.
*
from the
* stream. This method is particularly
* java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
* JDBC driver will do any necessary conversion from the database
.
*
*<P><>:/>thedata in returned stream must be
* read prior to getting the value of any other column. The next
* call to a getter method implicitly closes the stream.
* Also, a stream may return {@code 0} when the method
* {@code InputStream.available}
* is called, whether there is data available or not.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return a Java input stream that delivers the database column value
* as a stream of two-byte Unicode characters;
java.lang.StringIndexOutOfBoundsException: Range [22, 21) out of bounds for length 70
* {@code null}
java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
* @throws * to execute successfullyand occurs only if adriver continues to
* aaccess error occurs or this method is
*</OL>
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @deprecated use {@code getCharacterStream} in place of
*}
*/
@Deprecated(since="1.2")
* @return ofupdatecounts containing element
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a stream of
* this method *@SQLException adatabase error or
stream.This method is particularly
* suitable for retrieving large {@code LONGVARBINARY} values.
*
* <P><B>Note:</B *@since 1.
* read prior to getting the value of any other column. The next
* call to a getter method implicitly closes the stream. Also, a
* stream may return {@code 0} when the method
* {@code InputStream.available}
* is called whether there is data available or not.
*
* @param columnIndex the first column is 1, the second is 2, ...
*@eturn a Java input stream that delivers the database column value
* as a stream of uninterpreted bytes;
* if the value is SQL {@code NULL}, the value returned is
* {@code null*{@ ,or{code statement an
* @throws SQLException *<Anumber than equalequal tozero -- indicates thatthe
* if a database access error occurs or this method is
* called on a closed result set
*/
java.io.InputStream getBinaryStream(int*<>Aof @codeSUCCESS_NO_INFO}- indicatesthatthe command code}}java.lang.StringIndexOutOfBoundsException: Index 62 out of bounds for length 62
throws SQLException;
// Methods for accessing results by column label
/
* Retrieves the value of the designated column in the java.lang.StringIndexOutOfBoundsException: Index 66 out of bounds for length 10
* of this * {@codeDELETE;or an java.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 64
*a{code programming java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
* @param columnLabel the label for the column specified with the SQL*()(2)0 forSQLjava.lang.StringIndexOutOfBoundsException: Range [52, 51) out of bounds for length 71
* @return the column value; if the value is SQL {@code NULL}, the
* @throws SQLException if the columnLabel is not valid;
* if a database access error * {@code BatchUpdateException.getLargeUpdateCounts
called closed set
*/
String getString(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in*the currently running {@code Statement}
* of this {@code ResultSet} object as
* a {@code boolean} in the Java programming language * process commandsafter fails
*
PI designated hasa }
* and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
* and contains a 0, a value of {@code false} is returned. If the designated column has a datatype
* ifif SQL
java.lang.StringIndexOutOfBoundsException: Range [20, 19) out of bounds for length 88
* and contains a 1, a value of {@code true} is returned.* to the orderin commands wereaddedtothe batch.
*
* @param columnLabel *@throws ifajava.lang.StringIndexOutOfBoundsException: Index 62 out of bounds for length 62
* @return the column value; if the value is SQL {@ * <strong>Note:</strong>This method cannot be calleda
*value is @code false}
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
boolean getBoolean(String columnLabel) throws SQLException;
/**
thethe designated column in the current row
* of this {@code ResultSet} object as
* a {@code byte} in *
*
* @param columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, *@seeDatabaseMetaData#supportsBatchUpdates * should made available for retrieval;
* @return the column value; if the value
* value returned is {@code 0}
* @throws SQLException if the columnLabel is not valid;
* if a database access* statementthat java.lang.StringIndexOutOfBoundsException: Range [34, 33) out of bounds for length 72
* called on a closed result set
*/
byte getByte(String columnLabel) throws SQLException;
/**
* *<strong>Note:/strongThis java.lang.StringIndexOutOfBoundsException: Range [41, 40) out of bounds for length 62
this{code as
* a {@code short} in the Java programming language.
*
* @param columnLabel the label for the column specified with the SQL AS clause.
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code 0}
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
*on closed set
*/
java.lang.StringIndexOutOfBoundsException: Range [38, 37) out of bounds for length 59
/**
* Retrieves the value of the designated column in the current row
* of this {@code Executes the given SQL statement and signals the driver that the
*{codejava.lang.StringIndexOutOfBoundsException: Range [21, 20) out of bounds for length 55
*
* @param columnLabel *{@code @CallableStatement}
thevalueis{code NULL}, the
* value returned is {@code 0}
thecolumnLabel not valid;
* if a database access error occurs or this method is
* called on a closed result set
*/
t
/**
* Retrieves the value of the designated column java.lang.StringIndexOutOfBoundsException: Range [5, 1) out of bounds for length 7
* @ode java.lang.StringIndexOutOfBoundsException: Range [40, 39) out of bounds for length 42
* a {@code long} in the Java programming language.
*
* @param columnLabel the label for the column specified with the **
*@the columnvalue; thethevalueis NULL,the
* value returned is {@code 0}
@java.lang.StringIndexOutOfBoundsException: Range [15, 14) out of bounds for length 60
* if a database access error occurs or this method is
* called on a closed result set
*/
*java.lang.StringIndexOutOfBoundsException: Range [12, 11) out of bounds for length 76
/**
*pjava.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length 10
* of this*This * such as {@code,{ java.lang.StringIndexOutOfBoundsException: Range [48, 49) out of bounds for length 48
* } the programming language.
*
* * <>
* @return the column value; if the value is SQL {@code NULL}, the <><strong> cannot a
* The throw {@ode }
* @throws SQLException if the columnLabel is not valid;
* database access error occurs or this method is
* called on a closed result set
*/
float getFloat(String columnLabel) throws SQLException;
*
* Retrieves the value of the designated column in the current row
* ofthis { ResultSet}object as
* a{@code double} in the Java programming languagejava.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
thecolumn specifiedwith theSQL clause If theSQL AS wasnotspecified, thelabel thename of
* @return the column value;* {@ode PreparedStatement @code @ java.lang.StringIndexOutOfBoundsException: Range [22, 21) out of bounds for length 91
* value returned is {@code 0}
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
* @ SQLExceptionifa database access error ,
*/
double getDouble(String *@SQLTimeoutExceptionwhen the has the
/**
* Retrieves the value of the designated column in the current row
{ @ode {code
a {code ..igDecimal}in the .
*
* @param columnLabel the label for the column specified with the SQL @ SQLTimeoutException whendriverhas determinedthat
* @param scale the number of digits to the right of the decimal point
* @return/**
* value returned is {@*Executes given java.lang.StringIndexOutOfBoundsException: Range [52, 51) out of bounds for length 71
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
* called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
this method
* @deprecated* <p>
@ScolumnLabel)java.lang.StringIndexOutOfBoundsException: Index 63 out of bounds for length 63
*/
@Deprecated(since="1.2")
BigDecimal getBigDecimal(String
/**
* Retrieves the value of {@code PreparedStatement} or {@code CallableStatement}.
* of this {@code ResultSet} object as
* a {@code *
* java.lang.StringIndexOutOfBoundsException: Range [31, 30) out of bounds for length 65
* @param columnLabel the label for the column specified with the SQL AS clause. *{code DELETE} an statement that returns nothing,
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is or {codeDELETE}java.lang.StringIndexOutOfBoundsException: Index 43 out of bounds for length 10
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
*calledon a result set
*/
byte[] getBytes(String columnLabel) throws SQLException;
/**
* Retrieves the value of the * The default implementation will throw@if theJDBC notthis method
* of *timeout that specified on (ML statement,
* a {@code java.sql.Date} object*method exceeded hashasat cancel
*
*
* @return the column default executeLargeUpdate(String sql, String columnNames[])
* value returned is {@code null}
@java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 5
* if a database access error occurs or this method is
* called on a closed result set
*/
java.sql.Date getDate(String columnLabel) throws SQLException;
/**
Retrieves thevalue of the columnin row
* of this {@code ResultSet} object as
* a {codejava..Time} object theJava language.
*
* @param columnLabel the * <aption>of conversion<caption>
* @return the column value;
* if the value is SQL {@code NULL},
* the value returned is {@code *{@code PreparedStatementor {@code CallableStatement}
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
on closed result set
*/
TStringcolumnLabel)java.lang.StringIndexOutOfBoundsException: Range [53, 52) out of bounds for length 66
/**
the
* of this {@code ResultSet} object as
* a {@code java.sql.Timestamp} object in the Java java.lang.StringIndexOutOfBoundsException: Index 59 out of bounds for length 7
*
the label columnSQLAS.Ifthe thelabelistheof column
* @return the column value; if the value is SQL {@code NULL}, the
* returned {code null}
* @throws SQLException if the columnLabel is not valid;
** not @ INSERT}statement,or SQL able return
on a closed result set
*/
java.sql.Timestamp getTimestamp(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a stream of
* ASCII characters. The value can then be read in chunks from the
* stream. This method is particularly
* suitable for retrieving large {@code LONGVARCHAR} values.
* The JDBC driver will
* return "' +val.('" '") +""java.lang.StringIndexOutOfBoundsException: Index 52 out of bounds for length 52
*
* <P><B>Note:</B> All the data in the returned stream must be
* read prior to getting the value of any other column. The next
* call to a getter method implicitly closes the stream. Also, a
* *<java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11
* is called whether there is data available or not.
*
* <Return a delimitedidentifier @ode is
* @return a Java input stream that delivers the database column value
* as a stream of one-byte ASCII characters.
* If *If @ }isnot asimple SQLidentifier,{code identifier be
* the value returned is {@code * *enclosed indoublequotes if already the does
* throws SQLException if columnLabel is not valid;
* if a database access error occurs or this method is
on closed result
*/
*whosearevalid column names, the method is called on a
/**
* Retrieves the value of the designated column in the current row
* * <p
cond
* byte is the low byte.
*
* The value can then be read in chunks from the
* stream. This method is particularly
* suitable for retrieving large {@code LONGVARCHAR} values.
JDBCtechnology-driver
* do any necessary conversion from the database format into Unicode.
*
* <P><B>Note:</B> All the data in the returned stream must be
* read prior to getting the value of any other column. The next
* call to a getter method implicitly closes the stream.
* Also, a stream may return {@code 0} when the method
* {@code InputStream.available} is called, whether there
* * li>*Returns {code java.lang.StringIndexOutOfBoundsException: Range [41, 40) out of bounds for length 78
*
* @param columnLabel *
* @return a Java input java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 19
* as a stream of two-byte Unicode characters.
* If the value is SQL {@code NULL}, the value returned
* is {@code null}.
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
* called on a closed result set
* @ *<tbody style="text-align:center">
method
* @deprecated use {@code getCharacterStream} instead
*/
@Deprecated(since="1.2")
java.io.InputStream getUnicodeStream(String columnLabel) throws'<
/**
*<head>
* of this {@code ResultSet} object as a stream of uninterpreted
* {@code byte}s.
* The value can then be read in chunks from the
* stream. This method is particularly
@code LONGVARBINARY}
* values.
*
data inthe returned stream must be
* read prior to getting the value of any other column. The next
* call to a getter *</blockquote>
* * @implNjava.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 16
* is called whether there is data available or not.
*
* @param 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 column
* @return a Java input stream that delivers the database column value
* as a stream of uninterpreted bytes;
* if the value is SQL {@code NULL}, the result is {@code null}
*<tr
* if a database access error occurs or this method is
* called on a closed result set
*/
java.io.InputStream getBinaryStream(String columnLabel)
throws SQLException;
// Advanced features:
/
* Retrieves the first warning reported by java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 11
* {@code ResultSet} object.
* Subsequent warnings on this {@code ResultSet} object
* will be chained to the {@code SQLWarning} object that
* this method returns.
*
* <P>The * enclosed in doubleifnot already .If datasource
* isis read.This maynotbe a@ }
* object that has been closed; doing so will cause an
*@ java.lang.StringIndexOutOfBoundsException: Range [34, 33) out of bounds for length 41
* <P>
* <B>Note:</B> This warning chain only covers warnings caused
* by {@code ResultSet} methods. Any warning caused by
* {@code Statement} methods
* (such as reading OUT parameters) will be chained on the
* {@code Statement} object.
*
* @return the first {@code SQLWarning} object reported or *
* {@code null} if there are none
* @throws SQLException if a database access error occurs or this method is
*onclosed
*/
SQLWarning getWarnings() throws SQLException;
/**
* Clears all warnings reported on this {@code ResultSet} object.
* is ,the method {@ getWarnings}
*returns {code }a warning
* reported for this {@code ResultSet} object.
*
* @throws SQLException if a database access error * tdfalse<tdjava.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21
* java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 12
*/
void clearWarnings() throws*The defaultimplementationa{@SQLException:
/**
* *<uljava.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11
* *@implNote
*
* <P>In SQL, a result table is retrieved through a cursor that is
* named. The current row of a result set can be updated or *<li>The length of {code identifier 128
statementthat java.lang.StringIndexOutOfBoundsException: Range [66, 65) out of bounds for length 69
* cursor name. To insure that the cursor has the proper isolation
* level to support update, the cursor's {@code SELECT} statement
* should be of the form {@code SELECT FOR UPDATE}. If
* {@code FOR UPDATE} is omitted, the positioned updates may fail.
*
*<>JDBC supportsthis feature providingthe ofthe
* SQL cursor used by a {@code ResultSet} object.
The current row of a{code } object
* is also the current row of this SQL cursor.
*
* @return the SQL name for this {@code ResultSet} object's cursor
* @throws SQLException if a database access error occurs or this method is called on a closed result set
* if theJDBCdriverdoes not
* t><
*
String getCursorName() throws SQLException;(,-1;
* the andpropertiesof
* this theterms the GeneralPublicLicense version2 only, as
*
* @return the description of this {@ * <d>GDay<td
r occurs orthismethod is
* called on a closed result set
*/
}
/**
* <p>Gets the java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 2
* of this {@code ResultSet} object as
* an {@code Object} in the Java programming language.
*
*T methodwill java.lang.StringIndexOutOfBoundsException: Range [0, 37) out of bounds for length 26
* Java object. The type of the Java object will be the default
* Java object type corresponding to the column's SQL type,
* following the * . Franklin St, Fifth , MA02110
* specification. If the value is an SQL {@code NULL},
iver returnsa {}.
*
p>Thismethod may also usedto read specific
* tscope=row>Bruce "<>
*
* In the JDBC 2.0 API, the behavior of method
*
defined types.
* <p>
* If {@code Connection.getTypeMap} does not throw a
*@SQLFeatureNotSupportedException,
* then when a column contains a structured or *object represents.
* the behavior of this method is as
* if it were a call to: {@code getObject(columnIndex,
*this.getStatement().getConnection().getTypeMap())}.
*
* If {@code Connection.getTypeMap} does *
* {@code SQLFeatureNotSupportedException},
* then structured values are not supported, and distinct values
* are mapped to the default Java class as determined by the
* underlying SQL type of the DISTINCT type.
*
* @param columnIndex the first column is 1, the second is 2, ...
*@return a {@code java.lang.Object}holding *</r>
* @throws SQLException if the columnIndex is not valid;
access error occurs or this method is
* called on a closed result set
*/
Object*>
/**
* <p>Gets the value of the designated column in the current row
* of this {@code ResultSet} object as
* an {@code Object} in the Java programming language.
*
* <p>This method will return the value of the given column as a
* Java object. The type of the Java object will be the default
* Java object type corresponding to the column's SQL type,
*following the mapping for built- types specified inthe
* * @throws*@throws SQLFeatureNotSupportedException if the datasource does not support
* the driver returns a Java { * delimitedjava.lang.StringIndexOutOfBoundsException: Index 24 out of bounds for length 20
* <P>
* This method may also be used to read database-specific
* abstract data types.
* <P>
* In the JDBC 2.0 API, the behavior of the method
* {@code getObject} is extended to materialize
* data of SQL user-defined types. When a column contains
* a structured or distinct value, the behavior of this method is as
it were a to @ getObjectcolumnIndex,
* this.getStatement().getConnection().getTypeMap())}.
return len >= 1& len <=128
* @param columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label
* @return a {@code java.lang.Object} holding the column value
throws if * Retrieves whether {@code identifier
* *
* called on a closed result set
*/
Object getObject(String columnLabel) throws SQLException;
<
/**
* Maps the given {@code ResultSet} column label to its
* {@code ResultSet} column index.
*
*columnLabelthelabelfor with AS IftheSQL th scope=col>java.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for length 32
columnindex of columnname
* @throws SQLException if the {@code ResultSet} object
* does not contain a column labeled {@code columnLabel}, a database access error occurs
* or this method is called on a closed result set
*/
int findColumn(String columnLabel) throws SQLException;
//--------------------------JDBC 2.0-----------------------------------
//---------------------------------------------------------------------
// Getters and Setters
//---------------------------------------------------------------------
/**
* Retrieves the value of the *<true
<tr
* {@code java.io.Reader} object.
* @return a {@code java.io * <thscope=row"G'Day<th>
* value; if the value is SQL {@code NULL}, the value returned is
* {@code null} in the Java <>
* @param columnIndex the first column is 1, the second java.lang.StringIndexOutOfBoundsException: Range [0, 62) out of bounds for length 41
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
<>/
java.io.Reader getCharacterStream(int columnIndex) throws SQLException;
/**
* Retrieves return "N'" + val.replace("'", "''") + "'";
* of this {@code ResultSet} object as a
* {@code java.io.Reader} object.
*
* @param 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
* @return a {@code java.io.Reader} object that contains the column
* value; if the value is SQL {@code NULL}, the value returned is
* {@code null} in the Java programming language
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs or this method is
* called on a closed result set
* @since 1.2
*/
java.io.Reader getCharacterStream(String columnLabel) throws SQLException;
/** * by .
* Retrieves the value of the designated java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 5
* of this {@code ResultSet} object as a
* {@code java.math.BigDecimal} with full precision.
*
* t java.lang.StringIndexOutOfBoundsException: Range [27, 20) out of bounds for length 32
* @return the column value (full precision);
* if the value is SQL {@code NULL}, the value returned is
* {@code null} in the Java programming language.
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs or this method is
* called on a closed result set
* @since 1.2
*/
BigDecimal getBigDecimal(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated''''/
* @ode ResultSet}object as a
* {@code java.math.BigDecimal} with full precision.
*
* @param columnLabel the label for the column specified with the SQL AS clause. If the SQL AS </>
* @return the column value (full precision);
* if the value JDBC driver implementationsmayneed to provide their own implementation
* {@code null} in the Java programming language.
@throws SQLException if the columnLabel not valid;
* if a database access error occurs or accept
* called on a closed result set
* @since 1.2
*
*/
BigDecimal getBigDecimal(String columnLabel) throws SQLException;
//---------------------------------------------------------------------
// Traversal/Positioning
//---------------------------------------------------------------------throws java.lang.StringIndexOutOfBoundsException: Range [35, 34) out of bounds for length 57
/**
* Retrieves whether the cursor is before the first row in
* this {@code ResultSet} object.
*p>
* <strong>Note:</strong>Support for the {@code isBeforeFirst} method
* is optional for {@code ResultSet}s with a result
* set type of {@code TYPE_FORWARD_ONLY}
*
* @return {@code true} if the cursor is before the first row;
* {@code false} if the cursor is at any other position or the
* result set contains no rows
* @throws SQLException if a database access error occurs or this method is
* called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean isBeforeFirst() throws SQLException;
/**
* Retrieves whether the cursor is after the last row in
* this {@code ResultSet} object.
* <p>
* <strong>Note:</strong>Support for the {@code isAfterLast} method
* is optional for {@code ResultSet}s with a result
* set type of {@code TYPE_FORWARD_ONLY}
*
* @return {@code true} if the cursor is after the last row;
* {@code false} if the cursor is at any other position or the
* result set contains no rows
* @throws SQLException if a database access error occurs or this method is
* called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean isAfterLast() throws SQLException;
/**
* Retrieves whether the cursor is on the first row of
* this {@code ResultSet} object.
* <p>
* <strong>Note:</strong>Support for the {@code isFirst} method
* is optional for {@code ResultSet}s with a result
* set type of {@code TYPE_FORWARD_ONLY}
*
* @return {@code true} if the cursor is on the first row;
* {@code false} otherwise
* @throws SQLException if a database access error occurs or this method is
* called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean isFirst() throws SQLException;
/**
* Retrieves whether the cursor is on the last row of
* this {@code ResultSet} object.
* <strong>Note:</strong> Calling the method {@code isLast} may be expensive
* because the JDBC driver
* might need to fetch ahead one row in order to determine
* whether the current row is the last row in the result set.
* <p>
* <strong>Note:</strong> Support for the {@code isLast} method
* is optional for {@code ResultSet}s with a result
* set type of {@code TYPE_FORWARD_ONLY}
* @return {@code true} if the cursor is on the last row;
* {@code false} otherwise
* @throws SQLException if a database access error occurs or this method is
* called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean isLast() throws SQLException;
/**
* Moves the cursor to the front of
* this {@code ResultSet} object, just before the
* first row. This method has no effect if the result set contains no rows.
*
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set or the
* result set type is {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void beforeFirst() throws SQLException;
/**
* Moves the cursor to the end of
* this {@code ResultSet} object, just after the
* last row. This method has no effect if the result set contains no rows.
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set
* or the result set type is {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void afterLast() throws SQLException;
/**
* Moves the cursor to the first row in
* this {@code ResultSet} object.
*
* @return {@code true} if the cursor is on a valid row;
* {@code false} if there are no rows in the result set
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set
* or the result set type is {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean first() throws SQLException;
/**
* Moves the cursor to the last row in
* this {@code ResultSet} object.
*
* @return {@code true} if the cursor is on a valid row;
* {@code false} if there are no rows in the result set
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set
* or the result set type is {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean last() throws SQLException;
/**
* Retrieves the current row number. The first row is number 1, the
* second number 2, and so on.
* <p>
* <strong>Note:</strong>Support for the {@code getRow} method
* is optional for {@code ResultSet}s with a result
* set type of {@code TYPE_FORWARD_ONLY}
*
* @return the current row number; {@code 0} if there is no current row
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
int getRow() throws SQLException;
/**
* Moves the cursor to the given row number in
* this {@code ResultSet} object.
*
* <p>If the row number is positive, the cursor moves to
* the given row number with respect to the
* beginning of the result set. The first row is row 1, the second
* is row 2, and so on.
*
* <p>If the given row number is negative, the cursor moves to
* an absolute row position with respect to
* the end of the result set. For example, calling the method
* {@code absolute(-1)} positions the
* cursor on the last row; calling the method {@code absolute(-2)}
* moves the cursor to the next-to-last row, and so on.
*
* <p>If the row number specified is zero, the cursor is moved to
* before the first row.
*
* <p>An attempt to position the cursor beyond the first/last row in
* the result set leaves the cursor before the first row or after
* the last row.
*
* <p><B>Note:</B> Calling {@code absolute(1)} is the same
* as calling {@code first()}. Calling {@code absolute(-1)}
* is the same as calling {@code last()}.
*
* @param row the number of the row to which the cursor should move.
* A value of zero indicates that the cursor will be positioned
* before the first row; a positive number indicates the row number
* counting from the beginning of the result set; a negative number
* indicates the row number counting from the end of the result set
* @return {@code true} if the cursor is moved to a position in this
* {@code ResultSet} object;
* {@code false} if the cursor is before the first row or after the
* last row
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set
* or the result set type is {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean absolute( int row ) throws SQLException;
/**
* Moves the cursor a relative number of rows, either positive or negative.
* Attempting to move beyond the first/last row in the
* result set positions the cursor before/after the
* the first/last row. Calling {@code relative(0)} is valid, but does
* not change the cursor position.
*
* <p>Note: Calling the method {@code relative(1)}
* is identical to calling the method {@code next()} and
* calling the method {@code relative(-1)} is identical
* to calling the method {@code previous()}.
*
* @param rows an {@code int} specifying the number of rows to
* move from the current row; a positive number moves the cursor
* forward; a negative number moves the cursor backward
* @return {@code true} if the cursor is on a row;
* {@code false} otherwise
* @throws SQLException if a database access error occurs; this method
* is called on a closed result set or the result set type is
* {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean relative( int rows ) throws SQLException;
/**
* Moves the cursor to the previous row in this
* {@code ResultSet} object.
*<p>
* When a call to the {@code previous} method returns {@code false},
* the cursor is positioned before the first row. Any invocation of a
* {@code ResultSet} method which requires a current row will result in a
* {@code SQLException} being thrown.
*<p>
* If an input stream is open for the current row, a call to the method
* {@code previous} will implicitly close it. A {@code ResultSet}
* object's warning change is cleared when a new row is read.
*
* @return {@code true} if the cursor is now positioned on a valid row;
* {@code false} if the cursor is positioned before the first row
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set
* or the result set type is {@code TYPE_FORWARD_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
boolean previous() throws SQLException;
//---------------------------------------------------------------------
// Properties
//---------------------------------------------------------------------
/**
* The constant indicating that the rows in a result set will be
* processed in a forward direction; first-to-last.
* This constant is used by the method {@code setFetchDirection}
* as a hint to the driver, which the driver may ignore.
* @since 1.2
*/
int FETCH_FORWARD = 1000;
/**
* The constant indicating that the rows in a result set will be
* processed in a reverse direction; last-to-first.
* This constant is used by the method {@code setFetchDirection}
* as a hint to the driver, which the driver may ignore.
* @since 1.2
*/
int FETCH_REVERSE = 1001;
/**
* The constant indicating that the order in which rows in a
* result set will be processed is unknown.
* This constant is used by the method {@code setFetchDirection}
* as a hint to the driver, which the driver may ignore.
*/
int FETCH_UNKNOWN = 1002;
/**
* Gives a hint as to the direction in which the rows in this
* {@code ResultSet} object will be processed.
* The initial value is determined by the
* {@code Statement} object
* that produced this {@code ResultSet} object.
* The fetch direction may be changed at any time.
*
* @param direction an {@code int} specifying the suggested
* fetch direction; one of {@code ResultSet.FETCH_FORWARD},
* {@code ResultSet.FETCH_REVERSE}, or
* {@code ResultSet.FETCH_UNKNOWN}
* @throws SQLException if a database access error occurs; this
* method is called on a closed result set or
* the result set type is {@code TYPE_FORWARD_ONLY} and the fetch
* direction is not {@code FETCH_FORWARD}
* @since 1.2
* @see Statement#setFetchDirection
* @see #getFetchDirection
*/
void setFetchDirection(int direction) throws SQLException;
/**
* Retrieves the fetch direction for this
* {@code ResultSet} object.
*
* @return the current fetch direction for this {@code ResultSet} object
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
* @see #setFetchDirection
*/
int getFetchDirection() throws SQLException;
/**
* Gives the JDBC driver a hint as to the number of rows that should
* be fetched from the database when more rows are needed for this
* {@code ResultSet} object.
* If the fetch size specified is zero, the JDBC driver
* ignores the value and is free to make its own best guess as to what
* the fetch size should be. The default value is set by the
* {@code Statement} object
* that created the result set. The fetch size may be changed at any time.
*
* @param rows the number of rows to fetch
* @throws SQLException if a database access error occurs; this method
* is called on a closed result set or the
* condition {@code rows >= 0} is not satisfied
* @since 1.2
* @see #getFetchSize
*/
void setFetchSize(int rows) throws SQLException;
/**
* Retrieves the fetch size for this
* {@code ResultSet} object.
*
* @return the current fetch size for this {@code ResultSet} object
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
* @see #setFetchSize
*/
int getFetchSize() throws SQLException;
/**
* The constant indicating the type for a {@code ResultSet} object
* whose cursor may move only forward.
* @since 1.2
*/
int TYPE_FORWARD_ONLY = 1003;
/**
* The constant indicating the type for a {@code ResultSet} object
* that is scrollable but generally not sensitive to changes to the data
* that underlies the {@code ResultSet}.
* @since 1.2
*/
int TYPE_SCROLL_INSENSITIVE = 1004;
/**
* The constant indicating the type for a {@code ResultSet} object
* that is scrollable and generally sensitive to changes to the data
* that underlies the {@code ResultSet}.
* @since 1.2
*/
int TYPE_SCROLL_SENSITIVE = 1005;
/**
* Retrieves the type of this {@code ResultSet} object.
* The type is determined by the {@code Statement} object
* that created the result set.
*
* @return {@code ResultSet.TYPE_FORWARD_ONLY},
* {@code ResultSet.TYPE_SCROLL_INSENSITIVE},
* or {@code ResultSet.TYPE_SCROLL_SENSITIVE}
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
int getType() throws SQLException;
/**
* The constant indicating the concurrency mode for a
* {@code ResultSet} object that may NOT be updated.
* @since 1.2
*/
int CONCUR_READ_ONLY = 1007;
/**
* The constant indicating the concurrency mode for a
* {@code ResultSet} object that may be updated.
* @since 1.2
*/
int CONCUR_UPDATABLE = 1008;
/**
* Retrieves the concurrency mode of this {@code ResultSet} object.
* The concurrency used is determined by the
* {@code Statement} object that created the result set.
*
* @return the concurrency type, either
* {@code ResultSet.CONCUR_READ_ONLY}
* or {@code ResultSet.CONCUR_UPDATABLE}
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
int getConcurrency() throws SQLException;
//---------------------------------------------------------------------
// Updates
//---------------------------------------------------------------------
/**
* Retrieves whether the current row has been updated. The value returned
* depends on whether or not the result set can detect updates.
* <p>
* <strong>Note:</strong> Support for the {@code rowUpdated} method is optional with a result set
* concurrency of {@code CONCUR_READ_ONLY}
* @return {@code true} if the current row is detected to
* have been visibly updated by the owner or another; {@code false} otherwise
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @see DatabaseMetaData#updatesAreDetected
* @since 1.2
*/
boolean rowUpdated() throws SQLException;
/**
* Retrieves whether the current row has had an insertion.
* The value returned depends on whether or not this
* {@code ResultSet} object can detect visible inserts.
* <p>
* <strong>Note:</strong> Support for the {@code rowInserted} method is optional with a result set
* concurrency of {@code CONCUR_READ_ONLY}
* @return {@code true} if the current row is detected to
* have been inserted; {@code false} otherwise
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
*
* @see DatabaseMetaData#insertsAreDetected
* @since 1.2
*/
boolean rowInserted() throws SQLException;
/**
* Retrieves whether a row has been deleted. A deleted row may leave
* a visible "hole" in a result set. This method can be used to
* detect holes in a result set. The value returned depends on whether
* or not this {@code ResultSet} object can detect deletions.
* <p>
* <strong>Note:</strong> Support for the {@code rowDeleted} method is optional with a result set
* concurrency of {@code CONCUR_READ_ONLY}
* @return {@code true} if the current row is detected to
* have been deleted by the owner or another; {@code false} otherwise
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
*
* @see DatabaseMetaData#deletesAreDetected
* @since 1.2
*/
boolean rowDeleted() throws SQLException;
/**
* Updates the designated column with a {@code null} 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 {@code updateRow}
* or {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateNull(int columnIndex) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBoolean(int columnIndex, boolean x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateByte(int columnIndex, byte x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateShort(int columnIndex, short x) throws SQLException;
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateInt(int columnIndex, int x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateLong(int columnIndex, long x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateFloat(int columnIndex, float x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateDouble(int columnIndex, double x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateString(int columnIndex, String x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBytes(int columnIndex, byte x[]) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateDate(int columnIndex, java.sql.Date x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateTime(int columnIndex, java.sql.Time x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateTimestamp(int columnIndex, java.sql.Timestamp x)
throws SQLException;
/**
* Updates the designated column with an ascii stream value, which will have
* the specified number of bytes.
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length) throws SQLException;
/**
* Updates the designated column with a binary stream value, which will have
* the specified number of bytes.
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length) throws SQLException;
/**
* Updates the designated column with a character stream value, which will have
* the specified number of bytes.
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length) throws SQLException;
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*<p>
* If the second argument is an {@code InputStream} then the stream must contain
* the number of bytes specified by scaleOrLength. If the second argument is a
* {@code Reader} then the reader must contain the number of characters specified
* by scaleOrLength. If these conditions are not true the driver will generate a
* {@code SQLException} when the statement is executed.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param scaleOrLength for an object of {@code java.math.BigDecimal} ,
* this is the number of digits after the decimal point. For
* Java Object types {@code InputStream} and {@code Reader},
* this is the length
* of the data in the stream or reader. For all other types,
* this value will be ignored.
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateObject(int columnIndex, Object x, int scaleOrLength)
throws SQLException;
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateObject(int columnIndex, Object x) throws SQLException;
/**
* Updates the designated column with a {@code null} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateNull(String columnLabel) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBoolean(String columnLabel, boolean x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateByte(String columnLabel, byte x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateShort(String columnLabel, short x) throws SQLException;
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateInt(String columnLabel, int x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateLong(String columnLabel, long x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateFloat(String columnLabel, float x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateDouble(String columnLabel, double x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBigDecimal(String columnLabel, BigDecimal x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateString(String columnLabel, String x) throws SQLException;
/**
* Updates the designated column with a 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 {@code updateRow}
* or {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBytes(String columnLabel, byte x[]) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateDate(String columnLabel, java.sql.Date x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateTime(String columnLabel, java.sql.Time x) throws SQLException;
/**
* Updates the designated column with a {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateTimestamp(String columnLabel, java.sql.Timestamp x)
throws SQLException;
/**
* Updates the designated column with an ascii stream value, which will have
* the specified number of bytes.
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateAsciiStream(String columnLabel,
java.io.InputStream x,
int length) throws SQLException;
/**
* Updates the designated column with a binary stream value, which will have
* the specified number of bytes.
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateBinaryStream(String columnLabel,
java.io.InputStream x,
int length) throws SQLException;
/**
* Updates the designated column with a character stream value, which will have
* the specified number of bytes.
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param reader the {@code java.io.Reader} object containing
* the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateCharacterStream(String columnLabel,
java.io.Reader reader,
int length) throws SQLException;
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*<p>
* If the second argument is an {@code InputStream} then the stream must contain
* the number of bytes specified by scaleOrLength. If the second argument is a
* {@code Reader} then the reader must contain the number of characters specified
* by scaleOrLength. If these conditions are not true the driver will generate a
* {@code SQLException} when the statement is executed.
*
* @param 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 column
* @param x the new column value
* @param scaleOrLength for an object of {@code java.math.BigDecimal} ,
* this is the number of digits after the decimal point. For
* Java Object types {@code InputStream} and {@code Reader},
* this is the length
* of the data in the stream or reader. For all other types,
* this value will be ignored.
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateObject(String columnLabel, Object x, int scaleOrLength)
throws SQLException;
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateObject(String columnLabel, Object x) throws SQLException;
/**
* Inserts the contents of the insert row into this
* {@code ResultSet} object and into the database.
* The cursor must be on the insert row when this method is called.
*
* @throws SQLException if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY},
* this method is called on a closed result set,
* if this method is called when the cursor is not on the insert row,
* or if not all of non-nullable columns in
* the insert row have been given a non-null value
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void insertRow() throws SQLException;
/**
* Updates the underlying database with the new contents of the
* current row of this {@code ResultSet} object.
* This method cannot be called when the cursor is on the insert row.
*
* @throws SQLException if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY};
* this method is called on a closed result set or
* if this method is called when the cursor is on the insert row
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void updateRow() throws SQLException;
/**
* Deletes the current row from this {@code ResultSet} object
* and from the underlying database. This method cannot be called when
* the cursor is on the insert row.
*
* @throws SQLException if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY};
* this method is called on a closed result set
* or if this method is called when the cursor is on the insert row
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void deleteRow() throws SQLException;
/**
* Refreshes the current row with its most recent value in
* the database. This method cannot be called when
* the cursor is on the insert row.
*
* <P>The {@code refreshRow} method provides a way for an
* application to
* explicitly tell the JDBC driver to refetch a row(s) from the
* database. An application may want to call {@code refreshRow} when
* caching or prefetching is being done by the JDBC driver to
* fetch the latest value of a row from the database. The JDBC driver
* may actually refresh multiple rows at once if the fetch size is
* greater than one.
*
* <P> All values are refetched subject to the transaction isolation
* level and cursor sensitivity. If {@code refreshRow} is called after
* calling an updater method, but before calling
* the method {@code updateRow}, then the
* updates made to the row are lost. Calling the method
* {@code refreshRow} frequently will likely slow performance.
*
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set;
* the result set type is {@code TYPE_FORWARD_ONLY} or if this
* method is called when the cursor is on the insert row
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method or this method is not supported for the specified result
* set type and result set concurrency.
* @since 1.2
*/
void refreshRow() throws SQLException;
/**
* Cancels the updates made to the current row in this
* {@code ResultSet} object.
* This method may be called after calling an
* updater method(s) and before calling
* the method {@code updateRow} to roll back
* the updates made to a row. If no updates have been made or
* {@code updateRow} has already been called, this method has no
* effect.
*
* @throws SQLException if a database access error
* occurs; this method is called on a closed result set;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or if this method is called when the cursor is
* on the insert row
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void cancelRowUpdates() throws SQLException;
/**
* Moves the cursor to the insert row. The current cursor position is
* remembered while the cursor is positioned on the insert row.
*
* The insert row is a special row associated with an updatable
* result set. It is essentially a buffer where a new row may
* be constructed by calling the updater methods prior to
* inserting the row into the result set.
*
* Only the updater, getter,
* and {@code insertRow} methods may be
* called when the cursor is on the insert row. All of the columns in
* a result set must be given a value each time this method is
* called before calling {@code insertRow}.
* An updater method must be called before a
* getter method can be called on a column value.
*
* @throws SQLException if a database access error occurs; this
* method is called on a closed result set
* or the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void moveToInsertRow() throws SQLException;
/**
* Moves the cursor to the remembered cursor position, usually the
* current row. This method has no effect if the cursor is not on
* the insert row.
*
* @throws SQLException if a database access error occurs; this
* method is called on a closed result set
* or the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
void moveToCurrentRow() throws SQLException;
/**
* Retrieves the {@code Statement} object that produced this
* {@code ResultSet} object.
* If the result set was generated some other way, such as by a
* {@code DatabaseMetaData} method, this method may return
* {@code null}.
*
* @return the {@code Statement} object that produced
* this {@code ResultSet} object or {@code null}
* if the result set was produced some other way
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
Statement getStatement() throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as an {@code Object}
* in the Java programming language.
* If the value is an SQL {@code NULL},
* the driver returns a Java {@code null}.
* This method uses the given {@code Map} object
* for the custom mapping of the
* SQL structured or distinct type that is being retrieved.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param map a {@code java.util.Map} object that contains the mapping
* from SQL type names to classes in the Java programming language
* @return an {@code Object} in the Java programming language
* representing the SQL value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Object getObject(int columnIndex, java.util.Map<String,Class<?>> map)
throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code Ref} object
* in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return a {@code Ref} object representing an SQL {@code REF}
* value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Ref getRef(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code Blob} object
* in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return a {@code Blob} object representing the SQL
* {@code BLOB} value in the specified column
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Blob getBlob(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code Clob} object
* in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return a {@code Clob} object representing the SQL
* {@code CLOB} value in the specified column
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Clob getClob(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as an {@code Array} object
* in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return an {@code Array} object representing the SQL
* {@code ARRAY} value in the specified column
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Array getArray(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as an {@code Object}
* in the Java programming language.
* If the value is an SQL {@code NULL},
* the driver returns a Java {@code null}.
* This method uses the specified {@code Map} object for
* custom mapping if appropriate.
*
* @param 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 column
* @param map a {@code java.util.Map} object that contains the mapping
* from SQL type names to classes in the Java programming language
* @return an {@code Object} representing the SQL value in the
* specified column
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Object getObject(String columnLabel, java.util.Map<String,Class<?>> map)
throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code Ref} object
* in the Java programming language.
*
* @param 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 column
* @return a {@code Ref} object representing the SQL {@code REF}
* value in the specified column
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Ref getRef(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code Blob} object
* in the Java programming language.
*
* @param 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 column
* @return a {@code Blob} object representing the SQL {@code BLOB}
* value in the specified column
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Blob getBlob(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code Clob} object
* in the Java programming language.
*
* @param 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 column
* @return a {@code Clob} object representing the SQL {@code CLOB}
* value in the specified column
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Clob getClob(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as an {@code Array} object
* in the Java programming language.
*
* @param 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 column
* @return an {@code Array} object representing the SQL {@code ARRAY} value in
* the specified column
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.2
*/
Array getArray(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.sql.Date} object
* in the Java programming language.
* This method uses the given calendar to construct an appropriate millisecond
* value for the date if the underlying database does not store
* timezone information.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param cal the {@code java.util.Calendar} object
* to use in constructing the date
* @return the column value as a {@code java.sql.Date} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.sql.Date} object
* in the Java programming language.
* This method uses the given calendar to construct an appropriate millisecond
* value for the date if the underlying database does not store
* timezone information.
*
* @param 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 column
* @param cal the {@code java.util.Calendar} object
* to use in constructing the date
* @return the column value as a {@code java.sql.Date} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
java.sql.Date getDate(String columnLabel, Calendar cal) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.sql.Time} object
* in the Java programming language.
* This method uses the given calendar to construct an appropriate millisecond
* value for the time if the underlying database does not store
* timezone information.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param cal the {@code java.util.Calendar} object
* to use in constructing the time
* @return the column value as a {@code java.sql.Time} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.sql.Time} object
* in the Java programming language.
* This method uses the given calendar to construct an appropriate millisecond
* value for the time if the underlying database does not store
* timezone information.
*
* @param 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 column
* @param cal the {@code java.util.Calendar} object
* to use in constructing the time
* @return the column value as a {@code java.sql.Time} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
java.sql.Time getTime(String columnLabel, Calendar cal) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.sql.Timestamp} object
* in the Java programming language.
* This method uses the given calendar to construct an appropriate millisecond
* value for the timestamp if the underlying database does not store
* timezone information.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param cal the {@code java.util.Calendar} object
* to use in constructing the timestamp
* @return the column value as a {@code java.sql.Timestamp} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal)
throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.sql.Timestamp} object
* in the Java programming language.
* This method uses the given calendar to construct an appropriate millisecond
* value for the timestamp if the underlying database does not store
* timezone information.
*
* @param 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 column
* @param cal the {@code java.util.Calendar} object
* to use in constructing the date
* @return the column value as a {@code java.sql.Timestamp} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnLabel is not valid or
* if a database access error occurs
* or this method is called on a closed result set
* @since 1.2
*/
java.sql.Timestamp getTimestamp(String columnLabel, Calendar cal)
throws SQLException;
//-------------------------- JDBC 3.0 ----------------------------------------
/**
* The constant indicating that open {@code ResultSet} objects with this
* holdability will remain open when the current transaction is committed.
*
* @since 1.4
*/
int HOLD_CURSORS_OVER_COMMIT = 1;
/**
* The constant indicating that open {@code ResultSet} objects with this
* holdability will be closed when the current transaction is committed.
*
* @since 1.4
*/
int CLOSE_CURSORS_AT_COMMIT = 2;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.net.URL}
* object in the Java programming language.
*
* @param columnIndex the index of the column 1 is the first, 2 is the second,...
* @return the column value as a {@code java.net.URL} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs; this method
* is called on a closed result set or if a URL is malformed
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
java.net.URL getURL(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code java.net.URL}
* object in the Java programming language.
*
* @param 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 column
* @return the column value as a {@code java.net.URL} object;
* if the value is SQL {@code NULL},
* the value returned is {@code null} in the Java programming language
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs; this method
* is called on a closed result set or if a URL is malformed
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
java.net.URL getURL(String columnLabel) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.Ref} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateRef(int columnIndex, java.sql.Ref x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.Ref} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateRef(String columnLabel, java.sql.Ref x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.Blob} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateBlob(int columnIndex, java.sql.Blob x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.Blob} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateBlob(String columnLabel, java.sql.Blob x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.Clob} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateClob(int columnIndex, java.sql.Clob x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.Clob} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateClob(String columnLabel, java.sql.Clob x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateArray(int columnIndex, java.sql.Array x) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.4
*/
void updateArray(String columnLabel, java.sql.Array x) throws SQLException;
//------------------------- JDBC 4.0 -----------------------------------
/**
* Retrieves the value of the designated column in the current row of this
* {@code ResultSet} object as a {@code java.sql.RowId} object in the Java
* programming language.
*
* @param columnIndex the first column is 1, the second 2, ...
* @return the column value; if the value is a SQL {@code NULL} the
* value returned is {@code null}
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
RowId getRowId(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row of this
* {@code ResultSet} object as a {@code java.sql.RowId} object in the Java
* programming language.
*
* @param 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 column
* @return the column value ; if the value is a SQL {@code NULL} the
* value returned is {@code null}
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
RowId getRowId(String columnLabel) throws SQLException;
/**
* Updates the designated column with a {@code RowId} 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 {@code updateRow} or {@code insertRow} methods are called
* to update the database.
*
* @param columnIndex the first column is 1, the second 2, ...
* @param x the column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateRowId(int columnIndex, RowId x) throws SQLException;
/**
* Updates the designated column with a {@code RowId} 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 {@code updateRow} or {@code insertRow} methods are called
* to update the database.
*
* @param 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 column
* @param x the column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateRowId(String columnLabel, RowId x) throws SQLException;
/**
* Retrieves the holdability of this {@code ResultSet} object
* @return either {@code ResultSet.HOLD_CURSORS_OVER_COMMIT} or {@code ResultSet.CLOSE_CURSORS_AT_COMMIT}
* @throws SQLException if a database access error occurs
* or this method is called on a closed result set
* @since 1.6
*/
int getHoldability() throws SQLException;
/**
* Retrieves whether this {@code ResultSet} object has been closed. A {@code ResultSet} is closed if the
* method close has been called on it, or if it is automatically closed.
*
* @return true if this {@code ResultSet} object is closed; false if it is still open
* @throws SQLException if a database access error occurs
* @since 1.6
*/
boolean isClosed() throws SQLException;
/**
* Updates the designated column with a {@code String} value.
* It is intended for use when updating {@code NCHAR},{@code NVARCHAR}
* and {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second 2, ...
* @param nString the value for the column to be updated
* @throws SQLException if the columnIndex is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or if a database access error occurs
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNString(int columnIndex, String nString) throws SQLException;
/**
* Updates the designated column with a {@code String} value.
* It is intended for use when updating {@code NCHAR},{@code NVARCHAR}
* and {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param nString the value for the column to be updated
* @throws SQLException if the columnLabel is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or if a database access error occurs
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNString(String columnLabel, String nString) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.NClob} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second 2, ...
* @param nClob the value for the column to be updated
* @throws SQLException if the columnIndex is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set;
* if a database access error occurs or
* the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNClob(int columnIndex, NClob nClob) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.NClob} 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param nClob the value for the column to be updated
* @throws SQLException if the columnLabel is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set;
* if a database access error occurs or
* the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNClob(String columnLabel, NClob nClob) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code NClob} object
* in the Java programming language.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return a {@code NClob} object representing the SQL
* {@code NCLOB} value in the specified column
* @throws SQLException if the columnIndex is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set
* or if a database access error occurs
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
NClob getNClob(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a {@code NClob} object
* in the Java programming language.
*
* @param 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 column
* @return a {@code NClob} object representing the SQL {@code NCLOB}
* value in the specified column
* @throws SQLException if the columnLabel is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set
* or if a database access error occurs
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
NClob getNClob(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row of
* this {@code ResultSet} as a
* {@code java.sql.SQLXML} object in the Java programming language.
* @param columnIndex the first column is 1, the second is 2, ...
* @return a {@code SQLXML} object that maps an {@code SQL XML} value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
SQLXML getSQLXML(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row of
* this {@code ResultSet} as a
* {@code java.sql.SQLXML} object in the Java programming language.
* @param 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 column
* @return a {@code SQLXML} object that maps an {@code SQL XML} value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
SQLXML getSQLXML(String columnLabel) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.SQLXML} 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 {@code updateRow} or {@code insertRow} methods are called
* to update the database.
*
* @param columnIndex the first column is 1, the second 2, ...
* @param xmlObject the value for the column to be updated
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs; this method
* is called on a closed result set;
* the {@code java.xml.transform.Result},
* {@code Writer} or {@code OutputStream} has not been closed
* for the {@code SQLXML} object;
* if there is an error processing the XML value or
* the result set concurrency is {@code CONCUR_READ_ONLY}. The {@code getCause} method
* of the exception may provide a more detailed exception, for example, if the
* stream does not contain valid XML.
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException;
/**
* Updates the designated column with a {@code java.sql.SQLXML} 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 {@code updateRow} or {@code insertRow} methods are called
* to update the database.
*
* @param 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 column
* @param xmlObject the column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs; this method
* is called on a closed result set;
* the {@code java.xml.transform.Result},
* {@code Writer} or {@code OutputStream} has not been closed
* for the {@code SQLXML} object;
* if there is an error processing the XML value or
* the result set concurrency is {@code CONCUR_READ_ONLY}. The {@code getCause} method
* of the exception may provide a more detailed exception, for example, if the
* stream does not contain valid XML.
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as
* a {@code String} in the Java programming language.
* It is intended for use when
* accessing {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code null}
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
String getNString(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as
* a {@code String} in the Java programming language.
* It is intended for use when
* accessing {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
*
* @param 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 column
* @return the column value; if the value is SQL {@code NULL}, the
* value returned is {@code null}
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
String getNString(String columnLabel) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a
* {@code java.io.Reader} object.
* It is intended for use when
* accessing {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
*
* @return a {@code java.io.Reader} object that contains the column
* value; if the value is SQL {@code NULL}, the value returned is
* {@code null} in the Java programming language.
* @param columnIndex the first column is 1, the second is 2, ...
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
java.io.Reader getNCharacterStream(int columnIndex) throws SQLException;
/**
* Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object as a
* {@code java.io.Reader} object.
* It is intended for use when
* accessing {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
*
* @param 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 column
* @return a {@code java.io.Reader} object that contains the column
* value; if the value is SQL {@code NULL}, the value returned is
* {@code null} in the Java programming language
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
java.io.Reader getNCharacterStream(String columnLabel) throws SQLException;
/**
* Updates the designated column with a character stream value, which will have
* the specified number of bytes. The
* driver does the necessary conversion from Java character format to
* the national character set in the database.
* It is intended for use when
* updating {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY} or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length) throws SQLException;
/**
* Updates the designated column with a character stream value, which will have
* the specified number of bytes. The
* driver does the necessary conversion from Java character format to
* the national character set in the database.
* It is intended for use when
* updating {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param reader the {@code java.io.Reader} object containing
* the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY} or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNCharacterStream(String columnLabel,
java.io.Reader reader,
long length) throws SQLException;
/**
* Updates the designated column with an ascii stream value, which will have
* the specified number of bytes.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length) throws SQLException;
/**
* Updates the designated column with a binary stream value, which will have
* the specified number of bytes.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length) throws SQLException;
/**
* Updates the designated column with a character stream value, which will have
* the specified number of bytes.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateCharacterStream(int columnIndex,
java.io.Reader x,
long length) throws SQLException;
/**
* Updates the designated column with an ascii stream value, which will have
* the specified number of bytes.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateAsciiStream(String columnLabel,
java.io.InputStream x,
long length) throws SQLException;
/**
* Updates the designated column with a binary stream value, which will have
* the specified number of bytes.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param x the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBinaryStream(String columnLabel,
java.io.InputStream x,
long length) throws SQLException;
/**
* Updates the designated column with a character stream value, which will have
* the specified number of bytes.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param reader the {@code java.io.Reader} object containing
* the new column value
* @param length the length of the stream
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateCharacterStream(String columnLabel,
java.io.Reader reader,
long length) throws SQLException;
/**
* Updates the designated column using the given input stream, which
* will have the specified number of bytes.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param inputStream An object that contains the data to set the parameter
* value to.
* @param length the number of bytes in the parameter data.
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException;
/**
* Updates the designated column using the given input stream, which
* will have the specified number of bytes.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param inputStream An object that contains the data to set the parameter
* value to.
* @param length the number of bytes in the parameter data.
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException;
/**
* Updates the designated column using the given {@code Reader}
* object, which is the given number of characters long.
* When a very large UNICODE value is input to a {@code LONGVARCHAR}
* parameter, it may be more practical to send it via a
* {@code java.io.Reader} object. The JDBC driver will
* do any necessary conversion from UNICODE to the database char format.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param reader An object that contains the data to set the parameter value to.
* @param length the number of characters in the parameter data.
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateClob(int columnIndex, Reader reader, long length) throws SQLException;
/**
* Updates the designated column using the given {@code Reader}
* object, which is the given number of characters long.
* When a very large UNICODE value is input to a {@code LONGVARCHAR}
* parameter, it may be more practical to send it via a
* {@code java.io.Reader} object. The JDBC driver will
* do any necessary conversion from UNICODE to the database char format.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param reader An object that contains the data to set the parameter value to.
* @param length the number of characters in the parameter data.
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateClob(String columnLabel, Reader reader, long length) throws SQLException;
/**
* Updates the designated column using the given {@code Reader}
* object, which is the given number of characters long.
* When a very large UNICODE value is input to a {@code LONGVARCHAR}
* parameter, it may be more practical to send it via a
* {@code java.io.Reader} object. The JDBC driver will
* do any necessary conversion from UNICODE to the database char format.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param columnIndex the first column is 1, the second 2, ...
* @param reader An object that contains the data to set the parameter value to.
* @param length the number of characters in the parameter data.
* @throws SQLException if the columnIndex is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set,
* if a database access error occurs or
* the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNClob(int columnIndex, Reader reader, long length) throws SQLException;
/**
* Updates the designated column using the given {@code Reader}
* object, which is the given number of characters long.
* When a very large UNICODE value is input to a {@code LONGVARCHAR}
* parameter, it may be more practical to send it via a
* {@code java.io.Reader} object. The JDBC driver will
* do any necessary conversion from UNICODE to the database char format.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* @param 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 column
* @param reader An object that contains the data to set the parameter value to.
* @param length the number of characters in the parameter data.
* @throws SQLException if the columnLabel is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set;
* if a database access error occurs or
* the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNClob(String columnLabel, Reader reader, long length) throws SQLException;
//---
/**
* Updates the designated column with a character stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached. The
* driver does the necessary conversion from Java character format to
* the national character set in the database.
* It is intended for use when
* updating {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateNCharacterStream} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY} or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNCharacterStream(int columnIndex,
java.io.Reader x) throws SQLException;
/**
* Updates the designated column with a character stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached. The
* driver does the necessary conversion from Java character format to
* the national character set in the database.
* It is intended for use when
* updating {@code NCHAR},{@code NVARCHAR}
* and {@code LONGNVARCHAR} columns.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateNCharacterStream} which takes a length parameter.
*
* @param 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 column
* @param reader the {@code java.io.Reader} object containing
* the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY} or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNCharacterStream(String columnLabel,
java.io.Reader reader) throws SQLException;
/**
* Updates the designated column with an ascii stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateAsciiStream} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateAsciiStream(int columnIndex,
java.io.InputStream x) throws SQLException;
/**
* Updates the designated column with a binary stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateBinaryStream} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBinaryStream(int columnIndex,
java.io.InputStream x) throws SQLException;
/**
* Updates the designated column with a character stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateCharacterStream} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateCharacterStream(int columnIndex,
java.io.Reader x) throws SQLException;
/**
* Updates the designated column with an ascii stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateAsciiStream} which takes a length parameter.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateAsciiStream(String columnLabel,
java.io.InputStream x) throws SQLException;
/**
* Updates the designated column with a binary stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateBinaryStream} which takes a length parameter.
*
* @param 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 column
* @param x the new column value
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBinaryStream(String columnLabel,
java.io.InputStream x) throws SQLException;
/**
* Updates the designated column with a character stream value.
* The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateCharacterStream} which takes a length parameter.
*
* @param 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 column
* @param reader the {@code java.io.Reader} object containing
* the new column value
* @throws SQLException if the columnLabel is not valid; if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateCharacterStream(String columnLabel,
java.io.Reader reader) throws SQLException;
/**
* Updates the designated column using the given input stream. The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateBlob} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param inputStream An object that contains the data to set the parameter
* value to.
* @throws SQLException if the columnIndex is not valid; if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBlob(int columnIndex, InputStream inputStream) throws SQLException;
/**
* Updates the designated column using the given input stream. The data will be read from the stream
* as needed until end-of-stream is reached.
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateBlob} which takes a length parameter.
*
* @param 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 column
* @param inputStream An object that contains the data to set the parameter
* value to.
* @throws SQLException if the columnLabel is not valid; if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateBlob(String columnLabel, InputStream inputStream) throws SQLException;
/**
* Updates the designated column using the given {@code Reader}
* object.
* The data will be read from the stream
* as needed until end-of-stream is reached. The JDBC driver will
* do any necessary conversion from UNICODE to the database char format.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateClob} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param reader An object that contains the data to set the parameter value to.
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateClob(int columnIndex, Reader reader) throws SQLException;
/**
*java.lang.StringIndexOutOfBoundsException: Range [15, 14) out of bounds for length 67
* object.
* The data be read from the stream
* as needed until end-of-stream is reached. The JDBC driver will
*
* <p>
Theupdater java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 66
* current row or the insert row. The updater methods do not
* update the underlying database; instead the {@code updateRow} or
* {@code insertRow} methods are called to java.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 53
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
it might bemore use version
* {@code updateClob} which takes a length parameter.
*
*int s.()
* @param readerjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
* @throws SQLException if the columnLabel is not valid; java.lang.StringIndexOutOfBoundsException: Range [5, 1) out of bounds for length 7
*}
* or this method is called on a closed result set
* @throws * @param len length ofjava.lang.StringIndexOutOfBoundsException: Range [36, 35) out of bounds for length 41
* this method
@since 16
*/
voidseesetMinutes
/**
* )
*
*datawill from the stream
* as needed until end-of-stream is reached. The JDBC driver java.lang.StringIndexOutOfBoundsException: Index 68 out of bounds for length 17
format.
*
* <p>
* The updater methods are used to update column values in the
* current row or the insert row. The updater methods do not
* update underlying database; instead the {code updateRow}
* {@code insertRow} methods @return {code the datevalue
*
P<><B Consult your JDBC driver documentation todetermine if
* it might be more efficient to use a version of
* {@code updateNClob} which takes a length parameter.
*
* @param columnIndex the first column is 1, the second 2, ...
* @param reader An object that contains the data to set the parameter value to.
* @throws SQLException if the columnIndex is not valid;
* if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set,
* if a database access error occurs or
* the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNClob(int columnIndex, Reader reader) throws SQLException;
/**
* Updates the designated column using the given {@code Reader}
* object.
* The data will be read from the stream
* as needed until end-of-stream is reached. The JDBC driver will
* do any necessary conversion from UNICODE to the database char format.
*
* <p>
* 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*
* <P><B>Note:</B> Consult your JDBC driver documentation to determine if
* it might be more efficient to use a version of
* {@code updateNClob} which takes a length parameter.
*
* @param 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 column
* @param reader An object that contains the data to set the parameter value to.
* @throws SQLException if the columnLabel is not valid; if the driver does not support national
* character sets; if the driver can detect that a data conversion
* error could occur; this method is called on a closed result set;
* if a database access error occurs or
* the result set concurrency is {@code CONCUR_READ_ONLY}
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.6
*/
void updateNClob(String columnLabel, Reader reader) throws SQLException;
//------------------------- JDBC 4.1 -----------------------------------
/**
*<p>Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object and will convert from the
* SQL type of the column to the requested Java data type, if the
* conversion is supported. If the conversion is not
* supported or null is specified for the type, a
* {@code SQLException} is thrown.
*<p>
* At a minimum, an implementation must support the conversions defined in
* Appendix B, Table B-3 and conversion of appropriate user defined SQL
* types to a Java type which implements {@code SQLData}, or {@code Struct}.
* Additional conversions may be supported and are vendor defined.
* @param <T> the type of the class modeled by this Class object
* @param columnIndex the first column is 1, the second is 2, ...
* @param type Class representing the Java data type to convert the designated
* column to.
* @return an instance of {@code type} holding the column value
* @throws SQLException if conversion is not supported, type is null or
* another error occurs. The getCause() method of the
* exception may provide a more detailed exception, for example, if
* a conversion error occurs
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.7
*/
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException;
/**
*<p>Retrieves the value of the designated column in the current row
* of this {@code ResultSet} object and will convert from the
* SQL type of the column to the requested Java data type, if the
* conversion is supported. If the conversion is not
* supported or null is specified for the type, a
* {@code SQLException} is thrown.
*<p>
* At a minimum, an implementation must support the conversions defined in
* Appendix B, Table B-3 and conversion of appropriate user defined SQL
* types to a Java type which implements {@code SQLData}, or {@code Struct}.
* Additional conversions may be supported and are vendor defined.
*
* @param 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 column
* @param type Class representing the Java data type to convert the designated
* column to.
* @param <T> the type of the class modeled by this Class object
* @return an instance of {@code type} holding the column value
* @throws SQLException if conversion is not supported, type is null or
* another error occurs. The getCause() method of the
* exception may provide a more detailed exception, for example, if
* a conversion error occurs
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support
* this method
* @since 1.7
*/
public <T> T getObject(String columnLabel, Class<T> type) throws SQLException;
//------------------------- JDBC 4.2 -----------------------------------
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* *
*<p>
*thesecond argument is an {@code InputStream} then the stream must contain
* the number of bytes specified by scaleOrLength. If the second argument is a
* {@code Reader} then the reader must contain the number of characters specified
*byscaleOrLength. not true the driver will generate a
*{SQLException}when executed.
*<p>
* The default implementation will throw {@code SQLFeatureNotSupportedException}
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param targetSqlType the SQL type to be sent to the database
* @param scaleOrLength for an object of {@code java.math.BigDecimal} ,
* this is the number of digits after the decimal point. For
* Java Object types {@code InputStream} and {@code Reader},
* this is the length
* of the data in the stream or reader. For all other types,
* this value will be ignored.
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not
* support this method; if the JDBC driver does not support the specified targetSqlType
* @see JDBCType
* @see SQLType
* @since 1.8
*/
default void updateObject(int columnIndex, Object x,
SQLType targetSqlType, int scaleOrLength) throws SQLException {
throw new SQLFeatureNotSupportedException("updateObject not implemented");
}
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*<p>
* If the second argument is an {@code InputStream} then the stream must
* contain number of bytes specified by scaleOrLength. If the second
* argument is a {@code Reader} then the reader must contain the number
* of characters specified by scaleOrLength. If these conditions are not
* true the driver will generate a
* {@code SQLException} when the statement is executed.
*<p>
* The default implementation will throw {@code SQLFeatureNotSupportedException}
*
* @param 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 column
* @param x the new column value
* @param targetSqlType the SQL type to be sent to the database
* @param scaleOrLength for an object of {@code java.math.BigDecimal} ,
* this is the number of digits after the decimal point. For
* Java Object types {@code InputStream} and {@code Reader},
* this is the length
* of the data in the stream or reader. For all other types,
* this value will be ignored.
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not
* support this method; if the JDBC driver does not support the specified targetSqlType
* @see JDBCType
* @see SQLType
* @since 1.8
*/
default void updateObject(String columnLabel, Object x,
SQLType targetSqlType, int scaleOrLength) throws SQLException {
throw new SQLFeatureNotSupportedException("updateObject not implemented");
}
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*<p>
* The default implementation will throw {@code SQLFeatureNotSupportedException}
*
* @param columnIndex the first column is 1, the second is 2, ...
* @param x the new column value
* @param targetSqlType the SQL type to be sent to the database
* @throws SQLException if the columnIndex is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not
* support this method; if the JDBC driver does not support the specified targetSqlType
* @see JDBCType
* @see SQLType
* @since 1.8
*/
default void updateObject(int columnIndex, Object x, SQLType targetSqlType)
throws SQLException {
throw new SQLFeatureNotSupportedException("updateObject not implemented");
}
/**
* Updates the designated column with an {@code 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 {@code updateRow} or
* {@code insertRow} methods are called to update the database.
*<p>
* The default implementation will throw {@code SQLFeatureNotSupportedException}
*
* @param 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 column
* @param x the new column value
* @param targetSqlType the SQL type to be sent to the database
* @throws SQLException if the columnLabel is not valid;
* if a database access error occurs;
* the result set concurrency is {@code CONCUR_READ_ONLY}
* or this method is called on a closed result set
* @throws SQLFeatureNotSupportedException if the JDBC driver does not
* support this method; if the JDBC driver does not support the specified targetSqlType
* @see JDBCType
* @see SQLType
* @since 1.8
*/
default void updateObject(String columnLabel, Object x,
SQLType targetSqlType) throws SQLException {
throw new SQLFeatureNotSupportedException("updateObject not implemented");
}
}
¤ Die Informationen auf dieser Webseite wurden
nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit,
noch Qualität der bereit gestellten Informationen zugesichert.0.721Bemerkung:
¤
*Bot Zugriff
|
|
2026-11-01
|
|
|
|
|
Neuigkeiten |
| Aktuelles |
| Motto des Tages |
|
Open Source Software |
|
|
|
Jenseits des Üblichen ....
|
|
Besucherstatistik |
|
|
| Statistik |
| #Sources=1104856 |
| #Domains=417810 |
|
|