All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.sun.gjc.spi.base.ResultSetWrapper Maven / Gradle / Ivy

There is a newer version: 7.2024.1.Alpha1
Show newest version
/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright (c) 1997-2012 Oracle and/or its affiliates. All rights reserved.
 *
 * The contents of this file are subject to the terms of either the GNU
 * General Public License Version 2 only ("GPL") or the Common Development
 * and Distribution License("CDDL") (collectively, the "License").  You
 * may not use this file except in compliance with the License.  You can
 * obtain a copy of the License at
 * https://glassfish.dev.java.net/public/CDDL+GPL_1_1.html
 * or packager/legal/LICENSE.txt.  See the License for the specific
 * language governing permissions and limitations under the License.
 *
 * When distributing the software, include this License Header Notice in each
 * file and include the License file at packager/legal/LICENSE.txt.
 *
 * GPL Classpath Exception:
 * Oracle designates this particular file as subject to the "Classpath"
 * exception as provided by Oracle in the GPL Version 2 section of the License
 * file that accompanied this code.
 *
 * Modifications:
 * If applicable, add the following below the License Header, with the fields
 * enclosed by brackets [] replaced by your own identifying information:
 * "Portions Copyright [year] [name of copyright owner]"
 *
 * Contributor(s):
 * If you wish your version of this file to be governed by only the CDDL or
 * only the GPL Version 2, indicate your decision by adding "[Contributor]
 * elects to include this software in this distribution under the [CDDL or GPL
 * Version 2] license."  If you don't indicate a single choice of license, a
 * recipient has the option to distribute your version of this file under
 * either the CDDL, the GPL Version 2 or to extend the choice of license to
 * its licensees as provided above.  However, if you add GPL Version 2 code
 * and therefore, elected the GPL Version 2 license, then the option applies
 * only if the new code is made subject to such option by the copyright
 * holder.
 */

package com.sun.gjc.spi.base;

import com.sun.gjc.util.MethodExecutor;
import com.sun.gjc.util.ResultSetClosedEventListener;
import com.sun.logging.LogDomains;
import java.io.InputStream;
import java.io.Reader;
import java.math.BigDecimal;
import java.net.URL;
import java.sql.*;
import java.util.Calendar;
import java.util.Map;
import java.util.logging.Logger;


/**
 * Abstract class for ResultSet Wrapper 
*/ public abstract class ResultSetWrapper implements ResultSet { protected ResultSet resultSet = null; protected Statement statement = null; private MethodExecutor executor = null; protected final static Logger _logger; private ResultSetClosedEventListener eventListener = null; static { _logger = LogDomains.getLogger(MethodExecutor.class, LogDomains.RSR_LOGGER); } /** * Abstract class for wrapping Statement
* * @param stmt Statement that is to be wrapped
* @param rs ResultSet that is to be wraped
*/ public ResultSetWrapper(Statement stmt, ResultSet rs) { resultSet = rs; statement = stmt; executor = new MethodExecutor(); if(stmt instanceof ResultSetClosedEventListener) { eventListener = (ResultSetClosedEventListener) stmt; } } /** * Moves the cursor down one row from its current position. * A ResultSet cursor is initially positioned * before the first row; the first call to the method * next makes the first row the current row; the * second call makes the second row the current row, and so on. *

*

If an input stream is open for the current row, a call * to the method next will * implicitly close it. A ResultSet object's * warning chain is cleared when a new row is read. * * @return true if the new current row is valid; * false if there are no more rows * @throws java.sql.SQLException if a database access error occurs */ public boolean next() throws SQLException { return resultSet.next(); } /** * Releases this ResultSet object's database and * JDBC resources immediately instead of waiting for * this to happen when it is automatically closed. *

*

Note: A ResultSet object * is automatically closed by the * Statement object that generated it when * that Statement object is closed, * re-executed, or is used to retrieve the next result from a * sequence of multiple results. A ResultSet object * is also automatically closed when it is garbage collected. * * @throws java.sql.SQLException if a database access error occurs */ public void close() throws SQLException { resultSet.close(); if (eventListener != null) { eventListener.resultSetClosed(); } } /** * Reports whether * the last column read had a value of SQL NULL. * Note that you must first call one of the getter methods * on a column to try to read its value and then call * the method wasNull to see if the value read was * SQL NULL. * * @return true if the last column value read was SQL * NULL and false otherwise * @throws java.sql.SQLException if a database access error occurs */ public boolean wasNull() throws SQLException { return resultSet.wasNull(); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a String 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 NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public String getString(int columnIndex) throws SQLException { return resultSet.getString(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a boolean 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 NULL, the * value returned is false * @throws java.sql.SQLException if a database access error occurs */ public boolean getBoolean(int columnIndex) throws SQLException { return resultSet.getBoolean(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte 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 NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public byte getByte(int columnIndex) throws SQLException { return resultSet.getByte(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a short 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 NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public short getShort(int columnIndex) throws SQLException { return resultSet.getShort(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * an 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 NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public int getInt(int columnIndex) throws SQLException { return resultSet.getInt(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a 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 NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public long getLong(int columnIndex) throws SQLException { return resultSet.getLong(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a 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 NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public float getFloat(int columnIndex) throws SQLException { return resultSet.getFloat(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a double 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 NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public double getDouble(int columnIndex) throws SQLException { return resultSet.getDouble(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.BigDecimal in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @param scale the number of digits to the right of the decimal point * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs * @deprecated */ @Deprecated public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException { return resultSet.getBigDecimal(columnIndex, scale); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte array in the Java programming language. * The bytes represent the raw values returned by the driver. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public byte[] getBytes(int columnIndex) throws SQLException { return resultSet.getBytes(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Date 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 NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public Date getDate(int columnIndex) throws SQLException { return resultSet.getDate(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Time 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 NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public Time getTime(int columnIndex) throws SQLException { return resultSet.getTime(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Timestamp object in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public Timestamp getTimestamp(int columnIndex) throws SQLException { return resultSet.getTimestamp(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this 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 LONGVARCHAR values. * The JDBC driver will * do any necessary conversion from the database format into ASCII. *

*

Note: 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 0 when the method * 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 one-byte ASCII characters; * if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public InputStream getAsciiStream(int columnIndex) throws SQLException { return resultSet.getAsciiStream(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * as a stream of two-byte Unicode characters. The first byte is * the high byte; the second byte is the low byte. *

* The value can then be read in chunks from the * stream. This method is particularly * suitable for retrieving large LONGVARCHARvalues. The * JDBC driver will do any necessary conversion from the database * format into Unicode. *

*

Note: 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 0 when the method * 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; * if the value is SQL NULL, the value returned is * null * @throws java.sql.SQLException if a database access error occurs * @deprecated use getCharacterStream in place of * getUnicodeStream */ @Deprecated public InputStream getUnicodeStream(int columnIndex) throws SQLException { return resultSet.getUnicodeStream(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a binary stream of * uninterpreted bytes. The value can then be read in chunks from the * stream. This method is particularly * suitable for retrieving large LONGVARBINARY values. *

*

Note: 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 0 when the method * 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 uninterpreted bytes; * if the value is SQL NULL, the value returned is * null * @throws java.sql.SQLException if a database access error occurs */ public InputStream getBinaryStream(int columnIndex) throws SQLException { return resultSet.getBinaryStream(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a String in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public String getString(String columnName) throws SQLException { return resultSet.getString(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a boolean in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is false * @throws java.sql.SQLException if a database access error occurs */ public boolean getBoolean(String columnName) throws SQLException { return resultSet.getBoolean(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public byte getByte(String columnName) throws SQLException { return resultSet.getByte(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a short in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public short getShort(String columnName) throws SQLException { return resultSet.getShort(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * an int in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public int getInt(String columnName) throws SQLException { return resultSet.getInt(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a long in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public long getLong(String columnName) throws SQLException { return resultSet.getLong(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a float in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public float getFloat(String columnName) throws SQLException { return resultSet.getFloat(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a double in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is 0 * @throws java.sql.SQLException if a database access error occurs */ public double getDouble(String columnName) throws SQLException { return resultSet.getDouble(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.math.BigDecimal in the Java programming language. * * @param columnName the SQL name of the column * @param scale the number of digits to the right of the decimal point * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs * @deprecated */ @Deprecated public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException { return resultSet.getBigDecimal(columnName, scale); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte array in the Java programming language. * The bytes represent the raw values returned by the driver. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public byte[] getBytes(String columnName) throws SQLException { return resultSet.getBytes(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Date object in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public Date getDate(String columnName) throws SQLException { return resultSet.getDate(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Time object in the Java programming language. * * @param columnName the SQL name of the column * @return the column value; * if the value is SQL NULL, * the value returned is null * @throws java.sql.SQLException if a database access error occurs */ public Time getTime(String columnName) throws SQLException { return resultSet.getTime(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Timestamp object. * * @param columnName the SQL name of the column * @return the column value; if the value is SQL NULL, the * value returned is null * @throws java.sql.SQLException if a database access error occurs */ public Timestamp getTimestamp(String columnName) throws SQLException { return resultSet.getTimestamp(columnName); } /** * Retrieves the value of the designated column in the current row * of this 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 LONGVARCHAR values. * The JDBC driver will * do any necessary conversion from the database format into ASCII. *

*

Note: 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 0 when the method available * is called whether there is data available or not. * * @param columnName the SQL name of the column * @return a Java input stream that delivers the database column value * as a stream of one-byte ASCII characters. * If the value is SQL NULL, * the value returned is null. * @throws java.sql.SQLException if a database access error occurs */ public InputStream getAsciiStream(String columnName) throws SQLException { return resultSet.getAsciiStream(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a stream of two-byte * Unicode characters. The first byte is the high byte; the second * byte is the low byte. *

* The value can then be read in chunks from the * stream. This method is particularly * suitable for retrieving large LONGVARCHAR values. * The JDBC technology-enabled driver will * do any necessary conversion from the database format into Unicode. *

*

Note: 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 0 when the method * InputStream.available is called, whether there * is data available or not. * * @param columnName the SQL name of the column * @return a Java input stream that delivers the database column value * as a stream of two-byte Unicode characters. * If the value is SQL NULL, the value returned * is null. * @throws java.sql.SQLException if a database access error occurs * @deprecated use getCharacterStream instead */ @Deprecated public InputStream getUnicodeStream(String columnName) throws SQLException { return resultSet.getUnicodeStream(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a stream of uninterpreted * bytes. * The value can then be read in chunks from the * stream. This method is particularly * suitable for retrieving large LONGVARBINARY * values. *

*

Note: 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 0 when the method available * is called whether there is data available or not. * * @param columnName the SQL 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 NULL, the result is null * @throws java.sql.SQLException if a database access error occurs */ public InputStream getBinaryStream(String columnName) throws SQLException { return resultSet.getBinaryStream(columnName); } /** * Retrieves the first warning reported by calls on this * ResultSet object. * Subsequent warnings on this ResultSet object * will be chained to the SQLWarning object that * this method returns. *

*

The warning chain is automatically cleared each time a new * row is read. This method may not be called on a ResultSet * object that has been closed; doing so will cause an * SQLException to be thrown. *

* Note: This warning chain only covers warnings caused * by ResultSet methods. Any warning caused by * Statement methods * (such as reading OUT parameters) will be chained on the * Statement object. * * @return the first SQLWarning object reported or * null if there are none * @throws java.sql.SQLException if a database access error occurs or this method is * called on a closed result set */ public SQLWarning getWarnings() throws SQLException { return resultSet.getWarnings(); } /** * Clears all warnings reported on this ResultSet object. * After this method is called, the method getWarnings * returns null until a new warning is * reported for this ResultSet object. * * @throws java.sql.SQLException if a database access error occurs */ public void clearWarnings() throws SQLException { resultSet.clearWarnings(); } /** * Retrieves the name of the SQL cursor used by this ResultSet * object. *

*

In SQL, a result table is retrieved through a cursor that is * named. The current row of a result set can be updated or deleted * using a positioned update/delete statement that references the * cursor name. To insure that the cursor has the proper isolation * level to support update, the cursor's SELECT statement * should be of the form SELECT FOR UPDATE. If * FOR UPDATE is omitted, the positioned updates may fail. *

*

The JDBC API supports this SQL feature by providing the name of the * SQL cursor used by a ResultSet object. * The current row of a ResultSet object * is also the current row of this SQL cursor. *

*

Note: If positioned update is not supported, a * SQLException is thrown. * * @return the SQL name for this ResultSet object's cursor * @throws java.sql.SQLException if a database access error occurs */ public String getCursorName() throws SQLException { return resultSet.getCursorName(); } /** * Retrieves the number, types and properties of * this ResultSet object's columns. * * @return the description of this ResultSet object's columns * @throws java.sql.SQLException if a database access error occurs */ public ResultSetMetaData getMetaData() throws SQLException { return resultSet.getMetaData(); } /** *

Gets the value of the designated column in the current row * of this ResultSet object as * an Object in the Java programming language. *

*

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-in types specified in the JDBC * specification. If the value is an SQL NULL, * the driver returns a Java null. *

*

This method may also be used to read database-specific * abstract data types. *

* In the JDBC 2.0 API, the behavior of method * 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 * if it were a call to: getObject(columnIndex, * this.getStatement().getConnection().getTypeMap()). * * @param columnIndex the first column is 1, the second is 2, ... * @return a java.lang.Object holding the column value * @throws java.sql.SQLException if a database access error occurs */ public Object getObject(int columnIndex) throws SQLException { return resultSet.getObject(columnIndex); } /** *

Gets the value of the designated column in the current row * of this ResultSet object as * an Object in the Java programming language. *

*

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-in types specified in the JDBC * specification. If the value is an SQL NULL, * the driver returns a Java null. *

* This method may also be used to read database-specific * abstract data types. *

* In the JDBC 2.0 API, the behavior of the method * 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 * if it were a call to: getObject(columnIndex, * this.getStatement().getConnection().getTypeMap()). * * @param columnName the SQL name of the column * @return a java.lang.Object holding the column value * @throws java.sql.SQLException if a database access error occurs */ public Object getObject(String columnName) throws SQLException { return resultSet.getObject(columnName); } /** * Maps the given ResultSet column name to its * ResultSet column index. * * @param columnName the name of the column * @return the column index of the given column name * @throws java.sql.SQLException if the ResultSet object * does not contain columnName or a database access error occurs */ public int findColumn(String columnName) throws SQLException { return resultSet.findColumn(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.io.Reader object. * * @param columnIndex the first column is 1, the second is 2, ... * @return a java.io.Reader object that contains the column * value; if the value is SQL NULL, the value returned is * null in the Java programming language. * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Reader getCharacterStream(int columnIndex) throws SQLException { return resultSet.getCharacterStream(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.io.Reader object. * * @param columnName the name of the column * @return a java.io.Reader object that contains the column * value; if the value is SQL NULL, the value returned is * null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Reader getCharacterStream(String columnName) throws SQLException { return resultSet.getCharacterStream(columnName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.math.BigDecimal with full precision. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value (full precision); * if the value is SQL NULL, the value returned is * null in the Java programming language. * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public BigDecimal getBigDecimal(int columnIndex) throws SQLException { return resultSet.getBigDecimal(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.math.BigDecimal with full precision. * * @param columnName the column name * @return the column value (full precision); * if the value is SQL NULL, the value returned is * null in the Java programming language. * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public BigDecimal getBigDecimal(String columnName) throws SQLException { return resultSet.getBigDecimal(columnName); } /** * Retrieves whether the cursor is before the first row in * this ResultSet object. * * @return true if the cursor is before the first row; * false if the cursor is at any other position or the * result set contains no rows * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public boolean isBeforeFirst() throws SQLException { return resultSet.isBeforeFirst(); } /** * Retrieves whether the cursor is after the last row in * this ResultSet object. * * @return true if the cursor is after the last row; * false if the cursor is at any other position or the * result set contains no rows * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public boolean isAfterLast() throws SQLException { return resultSet.isAfterLast(); } /** * Retrieves whether the cursor is on the first row of * this ResultSet object. * * @return true if the cursor is on the first row; * false otherwise * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public boolean isFirst() throws SQLException { return resultSet.isFirst(); } /** * Retrieves whether the cursor is on the last row of * this ResultSet object. * Note: Calling the method 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. * * @return true if the cursor is on the last row; * false otherwise * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public boolean isLast() throws SQLException { return resultSet.isLast(); } /** * Moves the cursor to the front of * this ResultSet object, just before the * first row. This method has no effect if the result set contains no rows. * * @throws java.sql.SQLException if a database access error * occurs or the result set type is TYPE_FORWARD_ONLY * @since 1.2 */ public void beforeFirst() throws SQLException { resultSet.beforeFirst(); } /** * Moves the cursor to the end of * this ResultSet object, just after the * last row. This method has no effect if the result set contains no rows. * * @throws java.sql.SQLException if a database access error * occurs or the result set type is TYPE_FORWARD_ONLY * @since 1.2 */ public void afterLast() throws SQLException { resultSet.afterLast(); } /** * Moves the cursor to the first row in * this ResultSet object. * * @return true if the cursor is on a valid row; * false if there are no rows in the result set * @throws java.sql.SQLException if a database access error * occurs or the result set type is TYPE_FORWARD_ONLY * @since 1.2 */ public boolean first() throws SQLException { return resultSet.first(); } /** * Moves the cursor to the last row in * this ResultSet object. * * @return true if the cursor is on a valid row; * false if there are no rows in the result set * @throws java.sql.SQLException if a database access error * occurs or the result set type is TYPE_FORWARD_ONLY * @since 1.2 */ public boolean last() throws SQLException { return resultSet.last(); } /** * Retrieves the current row number. The first row is number 1, the * second number 2, and so on. * * @return the current row number; 0 if there is no current row * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public int getRow() throws SQLException { return resultSet.getRow(); } /** * Moves the cursor to the given row number in * this ResultSet object. *

*

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. *

*

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 * absolute(-1) positions the * cursor on the last row; calling the method absolute(-2) * moves the cursor to the next-to-last row, and so on. *

*

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. *

*

Note: Calling absolute(1) is the same * as calling first(). Calling absolute(-1) * is the same as calling last(). * * @param row the number of the row to which the cursor should move. * 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 true if the cursor is on the result set; * false otherwise * @throws java.sql.SQLException if a database access error * occurs, or the result set type is TYPE_FORWARD_ONLY * @since 1.2 */ public boolean absolute(int row) throws SQLException { return resultSet.absolute(row); } /** * 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 relative(0) is valid, but does * not change the cursor position. *

*

Note: Calling the method relative(1) * is identical to calling the method next() and * calling the method relative(-1) is identical * to calling the method previous(). * * @param rows an 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 true if the cursor is on a row; * false otherwise * @throws java.sql.SQLException if a database access error occurs, * there is no current row, or the result set type is * TYPE_FORWARD_ONLY * @since 1.2 */ public boolean relative(int rows) throws SQLException { return resultSet.relative(rows); } /** * Moves the cursor to the previous row in this * ResultSet object. * * @return true if the cursor is on a valid row; * false if it is off the result set * @throws java.sql.SQLException if a database access error * occurs or the result set type is TYPE_FORWARD_ONLY * @since 1.2 */ public boolean previous() throws SQLException { return resultSet.previous(); } /** * Gives a hint as to the direction in which the rows in this * ResultSet object will be processed. * The initial value is determined by the * Statement object * that produced this ResultSet object. * The fetch direction may be changed at any time. * * @param direction an int specifying the suggested * fetch direction; one of ResultSet.FETCH_FORWARD, * ResultSet.FETCH_REVERSE, or * ResultSet.FETCH_UNKNOWN * @throws java.sql.SQLException if a database access error occurs or * the result set type is TYPE_FORWARD_ONLY and the fetch * direction is not FETCH_FORWARD * @see java.sql.Statement#setFetchDirection * @see #getFetchDirection * @since 1.2 */ public void setFetchDirection(int direction) throws SQLException { resultSet.setFetchDirection(direction); } /** * Retrieves the fetch direction for this * ResultSet object. * * @return the current fetch direction for this ResultSet object * @throws java.sql.SQLException if a database access error occurs * @see #setFetchDirection * @since 1.2 */ public int getFetchDirection() throws SQLException { return resultSet.getFetchDirection(); } /** * 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 * 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 * 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 java.sql.SQLException if a database access error occurs or the * condition 0 <= rows <= Statement.getMaxRows() is not satisfied * @see #getFetchSize * @since 1.2 */ public void setFetchSize(int rows) throws SQLException { resultSet.setFetchSize(rows); } /** * Retrieves the fetch size for this * ResultSet object. * * @return the current fetch size for this ResultSet object * @throws java.sql.SQLException if a database access error occurs * @see #setFetchSize * @since 1.2 */ public int getFetchSize() throws SQLException { return resultSet.getFetchSize(); } /** * Retrieves the type of this ResultSet object. * The type is determined by the Statement object * that created the result set. * * @return ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, * or ResultSet.TYPE_SCROLL_SENSITIVE * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public int getType() throws SQLException { return resultSet.getType(); } /** * Retrieves the concurrency mode of this ResultSet object. * The concurrency used is determined by the * Statement object that created the result set. * * @return the concurrency type, either * ResultSet.CONCUR_READ_ONLY * or ResultSet.CONCUR_UPDATABLE * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public int getConcurrency() throws SQLException { return resultSet.getConcurrency(); } /** * Retrieves whether the current row has been updated. The value returned * depends on whether or not the result set can detect updates. * * @return true if both (1) the row has been visibly updated * by the owner or another and (2) updates are detected * @throws java.sql.SQLException if a database access error occurs * @see java.sql.DatabaseMetaData#updatesAreDetected * @since 1.2 */ public boolean rowUpdated() throws SQLException { return resultSet.rowUpdated(); } /** * Retrieves whether the current row has had an insertion. * The value returned depends on whether or not this * ResultSet object can detect visible inserts. * * @return true if a row has had an insertion * and insertions are detected; false otherwise * @throws java.sql.SQLException if a database access error occurs * @see java.sql.DatabaseMetaData#insertsAreDetected * @since 1.2 */ public boolean rowInserted() throws SQLException { return resultSet.rowInserted(); } /** * 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 ResultSet object can detect deletions. * * @return true if a row was deleted and deletions are detected; * false otherwise * @throws java.sql.SQLException if a database access error occurs * @see java.sql.DatabaseMetaData#deletesAreDetected * @since 1.2 */ public boolean rowDeleted() throws SQLException { return resultSet.rowDeleted(); } /** * Gives a nullable column a 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 updateRow * or insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateNull(int columnIndex) throws SQLException { resultSet.updateNull(columnIndex); } /** * Updates the designated column with a boolean value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBoolean(int columnIndex, boolean x) throws SQLException { resultSet.updateBoolean(columnIndex, x); } /** * Updates the designated column with a byte value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateByte(int columnIndex, byte x) throws SQLException { resultSet.updateByte(columnIndex, x); } /** * Updates the designated column with a short value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateShort(int columnIndex, short x) throws SQLException { resultSet.updateShort(columnIndex, x); } /** * Updates the designated column with an int value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateInt(int columnIndex, int x) throws SQLException { resultSet.updateInt(columnIndex, x); } /** * Updates the designated column with a long value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateLong(int columnIndex, long x) throws SQLException { resultSet.updateLong(columnIndex, x); } /** * Updates the designated column with a float value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateFloat(int columnIndex, float x) throws SQLException { resultSet.updateFloat(columnIndex, x); } /** * Updates the designated column with a double value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateDouble(int columnIndex, double x) throws SQLException { resultSet.updateDouble(columnIndex, x); } /** * Updates the designated column with a java.math.BigDecimal * value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException { resultSet.updateBigDecimal(columnIndex, x); } /** * Updates the designated column with a String value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateString(int columnIndex, String x) throws SQLException { resultSet.updateString(columnIndex, x); } /** * 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 updateRow or * 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 java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBytes(int columnIndex, byte x[]) throws SQLException { resultSet.updateBytes(columnIndex, x); } /** * Updates the designated column with a java.sql.Date value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateDate(int columnIndex, Date x) throws SQLException { resultSet.updateDate(columnIndex, x); } /** * Updates the designated column with a java.sql.Time value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateTime(int columnIndex, Time x) throws SQLException { resultSet.updateTime(columnIndex, x); } /** * Updates the designated column with a java.sql.Timestamp * value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException { resultSet.updateTimestamp(columnIndex, x); } /** * Updates the designated column with an ascii stream value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @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 java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException { resultSet.updateAsciiStream(columnIndex, x, length); } /** * Updates the designated column with a binary stream value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @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 java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException { resultSet.updateBinaryStream(columnIndex, x, length); } /** * Updates the designated column with a character stream value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @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 java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException { resultSet.updateCharacterStream(columnIndex, x, length); } /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param scale for java.sql.Types.DECIMA * or java.sql.Types.NUMERIC types, * this is the number of digits after the decimal point. For all other * types this value will be ignored. * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateObject(int columnIndex, Object x, int scale) throws SQLException { resultSet.updateObject(columnIndex, x, scale); } /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateObject(int columnIndex, Object x) throws SQLException { resultSet.updateObject(columnIndex, x); } /** * Updates the designated column with a 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 updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateNull(String columnName) throws SQLException { resultSet.updateNull(columnName); } /** * Updates the designated column with a boolean value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBoolean(String columnName, boolean x) throws SQLException { resultSet.updateBoolean(columnName, x); } /** * Updates the designated column with a byte value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateByte(String columnName, byte x) throws SQLException { resultSet.updateByte(columnName, x); } /** * Updates the designated column with a short value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateShort(String columnName, short x) throws SQLException { resultSet.updateShort(columnName, x); } /** * Updates the designated column with an int value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateInt(String columnName, int x) throws SQLException { resultSet.updateInt(columnName, x); } /** * Updates the designated column with a long value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateLong(String columnName, long x) throws SQLException { resultSet.updateLong(columnName, x); } /** * Updates the designated column with a float value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateFloat(String columnName, float x) throws SQLException { resultSet.updateFloat(columnName, x); } /** * Updates the designated column with a double value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateDouble(String columnName, double x) throws SQLException { resultSet.updateDouble(columnName, x); } /** * Updates the designated column with a java.sql.BigDecimal * value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException { resultSet.updateBigDecimal(columnName, x); } /** * Updates the designated column with a String value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateString(String columnName, String x) throws SQLException { resultSet.updateString(columnName, x); } /** * 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 updateRow * or insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBytes(String columnName, byte x[]) throws SQLException { resultSet.updateBytes(columnName, x); } /** * Updates the designated column with a java.sql.Date value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateDate(String columnName, Date x) throws SQLException { resultSet.updateDate(columnName, x); } /** * Updates the designated column with a java.sql.Time value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateTime(String columnName, Time x) throws SQLException { resultSet.updateTime(columnName, x); } /** * Updates the designated column with a java.sql.Timestamp * value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateTimestamp(String columnName, Timestamp x) throws SQLException { resultSet.updateTimestamp(columnName, x); } /** * Updates the designated column with an ascii stream value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @param length the length of the stream * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException { resultSet.updateAsciiStream(columnName, x, length); } /** * Updates the designated column with a binary stream value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @param length the length of the stream * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException { resultSet.updateBinaryStream(columnName, x, length); } /** * Updates the designated column with a character stream value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param reader the java.io.Reader object containing * the new column value * @param length the length of the stream * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException { resultSet.updateCharacterStream(columnName, reader, length); } /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @param scale for java.sql.Types.DECIMAL * or java.sql.Types.NUMERIC types, * this is the number of digits after the decimal point. For all other * types this value will be ignored. * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateObject(String columnName, Object x, int scale) throws SQLException { resultSet.updateObject(columnName, x, scale); } /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public void updateObject(String columnName, Object x) throws SQLException { resultSet.updateObject(columnName, x); } /** * Inserts the contents of the insert row into this * ResultSet object and into the database. * The cursor must be on the insert row when this method is called. * * @throws java.sql.SQLException if a database access error occurs, * 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 value * @since 1.2 */ public void insertRow() throws SQLException { resultSet.insertRow(); } /** * Updates the underlying database with the new contents of the * current row of this ResultSet object. * This method cannot be called when the cursor is on the insert row. * * @throws java.sql.SQLException if a database access error occurs or * if this method is called when the cursor is on the insert row * @since 1.2 */ public void updateRow() throws SQLException { resultSet.updateRow(); } /** * Deletes the current row from this ResultSet object * and from the underlying database. This method cannot be called when * the cursor is on the insert row. * * @throws java.sql.SQLException if a database access error occurs * or if this method is called when the cursor is on the insert row * @since 1.2 */ public void deleteRow() throws SQLException { resultSet.deleteRow(); } /** * 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. *

*

The 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 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. *

*

All values are refetched subject to the transaction isolation * level and cursor sensitivity. If refreshRow is called after * calling an updater method, but before calling * the method updateRow, then the * updates made to the row are lost. Calling the method * refreshRow frequently will likely slow performance. * * @throws java.sql.SQLException if a database access error * occurs or if this method is called when the cursor is on the insert row * @since 1.2 */ public void refreshRow() throws SQLException { resultSet.refreshRow(); } /** * Cancels the updates made to the current row in this * ResultSet object. * This method may be called after calling an * updater method(s) and before calling * the method updateRow to roll back * the updates made to a row. If no updates have been made or * updateRow has already been called, this method has no * effect. * * @throws java.sql.SQLException if a database access error * occurs or if this method is called when the cursor is * on the insert row * @since 1.2 */ public void cancelRowUpdates() throws SQLException { resultSet.cancelRowUpdates(); } /** * 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 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 insertRow. * An updater method must be called before a * getter method can be called on a column value. * * @throws java.sql.SQLException if a database access error occurs * or the result set is not updatable * @since 1.2 */ public void moveToInsertRow() throws SQLException { resultSet.moveToInsertRow(); } /** * 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 java.sql.SQLException if a database access error occurs * or the result set is not updatable * @since 1.2 */ public void moveToCurrentRow() throws SQLException { resultSet.moveToCurrentRow(); } /** * Retrieves the Statement object that produced this * ResultSet object. * If the result set was generated some other way, such as by a * DatabaseMetaData method, this method returns * null. * * @return the Statment object that produced * this ResultSet object or null * if the result set was produced some other way * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Statement getStatement() throws SQLException { return statement; } /** * Returns the actual statement that produced this resultset
* * @return Statement * @throws SQLException */ public Statement getActualStatement() throws SQLException { return resultSet.getStatement(); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Object * in the Java programming language. * If the value is an SQL NULL, * the driver returns a Java null. * This method uses the given Map object * for the custom mapping of the * SQL structured or distinct type that is being retrieved. * * @param i the first column is 1, the second is 2, ... * @param map a java.util.Map object that contains the mapping * from SQL type names to classes in the Java programming language * @return an Object in the Java programming language * representing the SQL value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Object getObject(int i, Map> map) throws SQLException { return resultSet.getObject(i, map); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Ref object * in the Java programming language. * * @param i the first column is 1, the second is 2, ... * @return a Ref object representing an SQL REF * value * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Ref getRef(int i) throws SQLException { return resultSet.getRef(i); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Blob object * in the Java programming language. * * @param i the first column is 1, the second is 2, ... * @return a Blob object representing the SQL * BLOB value in the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Blob getBlob(int i) throws SQLException { return resultSet.getBlob(i); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Clob object * in the Java programming language. * * @param i the first column is 1, the second is 2, ... * @return a Clob object representing the SQL * CLOB value in the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Clob getClob(int i) throws SQLException { return resultSet.getClob(i); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Array object * in the Java programming language. * * @param i the first column is 1, the second is 2, ... * @return an Array object representing the SQL * ARRAY value in the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Array getArray(int i) throws SQLException { return resultSet.getArray(i); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Object * in the Java programming language. * If the value is an SQL NULL, * the driver returns a Java null. * This method uses the specified Map object for * custom mapping if appropriate. * * @param colName the name of the column from which to retrieve the value * @param map a java.util.Map object that contains the mapping * from SQL type names to classes in the Java programming language * @return an Object representing the SQL value in the * specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Object getObject(String colName, Map> map) throws SQLException { return resultSet.getObject(colName, map); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Ref object * in the Java programming language. * * @param colName the column name * @return a Ref object representing the SQL REF * value in the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Ref getRef(String colName) throws SQLException { return resultSet.getRef(colName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Blob object * in the Java programming language. * * @param colName the name of the column from which to retrieve the value * @return a Blob object representing the SQL BLOB * value in the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Blob getBlob(String colName) throws SQLException { return resultSet.getBlob(colName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Clob object * in the Java programming language. * * @param colName the name of the column from which to retrieve the value * @return a Clob object representing the SQL CLOB * value in the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Clob getClob(String colName) throws SQLException { return resultSet.getClob(colName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Array object * in the Java programming language. * * @param colName the name of the column from which to retrieve the value * @return an Array object representing the SQL ARRAY value in * the specified column * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Array getArray(String colName) throws SQLException { return resultSet.getArray(colName); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a 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 java.util.Calendar object * to use in constructing the date * @return the column value as a java.sql.Date object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Date getDate(int columnIndex, Calendar cal) throws SQLException { return resultSet.getDate(columnIndex, cal); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a 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 columnName the SQL name of the column from which to retrieve the value * @param cal the java.util.Calendar object * to use in constructing the date * @return the column value as a java.sql.Date object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Date getDate(String columnName, Calendar cal) throws SQLException { return resultSet.getDate(columnName, cal); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a 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 java.util.Calendar object * to use in constructing the time * @return the column value as a java.sql.Time object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Time getTime(int columnIndex, Calendar cal) throws SQLException { return resultSet.getTime(columnIndex, cal); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a 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 columnName the SQL name of the column * @param cal the java.util.Calendar object * to use in constructing the time * @return the column value as a java.sql.Time object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Time getTime(String columnName, Calendar cal) throws SQLException { return resultSet.getTime(columnName, cal); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Timestamp object * in the Java programming language. * 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 java.util.Calendar object * to use in constructing the timestamp * @return the column value as a java.sql.Timestamp object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException { return resultSet.getTimestamp(columnIndex, cal); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Timestamp object * in the Java programming language. * 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 columnName the SQL name of the column * @param cal the java.util.Calendar object * to use in constructing the date * @return the column value as a java.sql.Timestamp object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * @since 1.2 */ public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException { return resultSet.getTimestamp(columnName, cal); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a 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 java.net.URL object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs, * or if a URL is malformed * @since 1.4 */ public URL getURL(int columnIndex) throws SQLException { return resultSet.getURL(columnIndex); } /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.net.URL * object in the Java programming language. * * @param columnName the SQL name of the column * @return the column value as a java.net.URL object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @throws java.sql.SQLException if a database access error occurs * or if a URL is malformed * @since 1.4 */ public URL getURL(String columnName) throws SQLException { return resultSet.getURL(columnName); } /** * Updates the designated column with a 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 updateRow or * 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 java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateRef(int columnIndex, Ref x) throws SQLException { resultSet.updateRef(columnIndex, x); } /** * Updates the designated column with a 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 updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateRef(String columnName, Ref x) throws SQLException { resultSet.updateRef(columnName, x); } /** * Updates the designated column with a 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 updateRow or * 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 java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateBlob(int columnIndex, Blob x) throws SQLException { resultSet.updateBlob(columnIndex, x); } /** * Updates the designated column with a 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 updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateBlob(String columnName, Blob x) throws SQLException { resultSet.updateBlob(columnName, x); } /** * Updates the designated column with a 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 updateRow or * 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 java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateClob(int columnIndex, Clob x) throws SQLException { resultSet.updateClob(columnIndex, x); } /** * Updates the designated column with a 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 updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateClob(String columnName, Clob x) throws SQLException { resultSet.updateClob(columnName, x); } /** * Updates the designated column with a 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 updateRow or * 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 java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateArray(int columnIndex, Array x) throws SQLException { resultSet.updateArray(columnIndex, x); } /** * Updates the designated column with a 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 updateRow or * insertRow methods are called to update the database. * * @param columnName the name of the column * @param x the new column value * @throws java.sql.SQLException if a database access error occurs * @since 1.4 */ public void updateArray(String columnName, Array x) throws SQLException { resultSet.updateArray(columnName, x); } protected MethodExecutor getMethodExecutor() { return executor; } }





© 2015 - 2024 Weber Informatics LLC | Privacy Policy