IT. Expert System.

Android Reference

RowSet


javax.sql

Interface RowSet

  • All Superinterfaces:
    AutoCloseable, ResultSet, Wrapper


    public interface RowSet
    extends ResultSet
    An interface which provides means to access data which persists on a database. It extends the functionality of ResultSet into a form that it can be used as a JavaBean component, suited for a visual programming environment.

    RowSet provides getters and setters for properties relating to the general database environment together with the getters and setters for distinct data values which constitute the row set. The RowSet class supports JavaBean events so that other components in an application can be informed when changes happen such as changes in data values.

    RowSet is a facility implemented on top of the remainder of the JDBC API. It may be connected, maintaining a connection to the database throughout its lifecycle. The changes made on a disconnected RowSet on the other hand can be persisted only establishing a new connection with the database each time.

    Disconnected RowSets make use of RowSetReaders to populate the RowSet with data, possibly from a non-relational database source. They may also use RowSetWriters to send data back to the underlying data store. There is considerable freedom in the way that RowSetReaders and RowSetWriters may be implemented to retrieve and store data.

    See Also:
    RowSetReader, RowSetWriter
    • Method Detail

      • addRowSetListener

        void addRowSetListener(RowSetListener theListener)
        Registers the supplied RowSetListener with this RowSet. Once registered, the RowSetListener is notified of events generated by the RowSet.
        Parameters:
        theListener - an object which implements the rowSetListener interface.
      • clearParameters

        void clearParameters()
                             throws SQLException
        Clears the parameters previously set for this RowSet.

        The RowSet object retains its value until either a new value for a parameter is set or its value is actively reset. clearParameters provides a facility to clear the values for all parameters with one method call.

        Throws:
        SQLException - if a problem occurs accessing the database.
      • execute

        void execute()
                     throws SQLException
        Fetches data for this RowSet from the database. If successful, any existing data for the RowSet is discarded and its metadata is overwritten.

        Data is retrieved connecting to the database and executing an according SQL statement. This requires some or all of the following properties to be set: URL, database name, user name, password, transaction isolation, type map; plus some or all of the properties: command, read only, maximum field size, maximum rows, escape processing, and query timeout.

        The RowSet may use a RowSetReader to access the database it will then invoke the RowSetReader.readData(javax.sql.RowSetInternal) method on the reader to fetch the data. When the new data is fetched all the listeners are notified to take appropriate measures.

        Throws:
        SQLException - if a problem occurs accessing the database or if the properties needed to access the database have not been set.
        See Also:
        RowSetMetaData, RowSetReader
      • getCommand

        String getCommand()
        Gets the RowSet's command property.
        Returns:
        a string containing the RowSet's command property. A command is a SQL statement which is executed to fetch required data into the RowSet.
      • getDataSourceName

        String getDataSourceName()
        Gets the ODBC Data Source Name property associated with this RowSet. The database name can be used to find a DataSource which has been registered with a naming service - the DataSource can then be used to create a connection to the database.
        Returns:
        the name of the database.
      • getEscapeProcessing

        boolean getEscapeProcessing()
                                    throws SQLException
        Reports if escape processing is enabled for this RowSet. If escape processing is on, the driver performs a substitution of the escape syntax with the applicable code before sending an SQL command to the database. The default value for escape processing is true.
        Returns:
        true if escape processing is enabled, false otherwise.
        Throws:
        SQLException - if a problem occurs accessing the database.
      • getMaxFieldSize

        int getMaxFieldSize()
                            throws SQLException
        Gets the maximum number of bytes that can be returned for column values which are of type BINARY, VARBINARY, LONGVARBINARYBINARY, CHAR, VARCHAR, or LONGVARCHAR. Excess data is silently discarded if the number is exceeded.
        Returns:
        the current maximum size in bytes. 0 implies no size limit.
        Throws:
        SQLException - if a problem occurs accessing the database.
      • getMaxRows

        int getMaxRows()
                       throws SQLException
        Gets the maximum number of rows for this RowSet. Excess rows are discarded silently if the limit is exceeded.
        Returns:
        the previous maximum number of rows. 0 implies no row limit.
        Throws:
        SQLException - if a problem occurs accessing the database.
      • getPassword

        String getPassword()
        Gets the value of the password property for this RowSet. This property is used when a connection to the database is established. Therefore it should be set prior to invoking the execute() method.
        Returns:
        the value of the password property.
      • getQueryTimeout

        int getQueryTimeout()
                            throws SQLException
        Gets the timeout for the driver when a query operation is executed. If a query takes longer than the timeout then a SQLException is thrown.
        Returns:
        the timeout value in seconds.
        Throws:
        SQLException - if an error occurs accessing the database.
      • getTransactionIsolation

        int getTransactionIsolation()
        Gets the transaction isolation level property set for this RowSet. The transaction isolation level defines the policy implemented on the database for maintaining the data values consistent.
        Returns:
        the current transaction isolation level. Must be one of:
        • Connection.TRANSACTION_READ_UNCOMMITTED
        • Connection.TRANSACTION_READ_COMMITTED
        • Connection.TRANSACTION_REPEATABLE_READ
        • Connection.TRANSACTION_SERIALIZABLE
        See Also:
        Connection
      • getTypeMap

        Map<String,Class<?>> getTypeMap()
                                        throws SQLException
        Gets the custom mapping of SQL User-Defined Types (UDTs) and Java classes for this RowSet, if applicable.
        Returns:
        the custom mappings of SQL types to Java classes.
        Throws:
        SQLException - if an error occurs accessing the database.
      • getUrl

        String getUrl()
                      throws SQLException
        Gets the URL property value for this RowSet. If there is no DataSource object specified, the RowSet uses the URL to establish a connection to the database. The default value for the URL is null.
        Returns:
        a String holding the value of the URL property.
        Throws:
        SQLException - if an error occurs accessing the database.
      • getUsername

        String getUsername()
        Gets the value of the username property for this RowSet. The username is used when establishing a connection to the database and should be set before the execute method is invoked.
        Returns:
        a String holding the value of the username property.
      • isReadOnly

        boolean isReadOnly()
        Indicates if this RowSet is read-only.
        Returns:
        true if this RowSet is read-only, false if it is updatable.
      • removeRowSetListener

        void removeRowSetListener(RowSetListener theListener)
        Removes a specified RowSetListener object from the set of listeners which will be notified of events by this RowSet.
        Parameters:
        theListener - the RowSetListener to remove from the set of listeners for this RowSet.
      • setArray

        void setArray(int parameterIndex,
                    Array theArray)
                      throws SQLException
        Sets the specified ARRAY parameter in the RowSet command with the supplied java.sql.Array value.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theArray - the Array data value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setAsciiStream

        void setAsciiStream(int parameterIndex,
                          InputStream theInputStream,
                          int length)
                            throws SQLException
        Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theInputStream - the ASCII data value to which the parameter is set.
        length - the length of the data in bytes.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setAsciiStream

        void setAsciiStream(int parameterIndex,
                          InputStream theInputStream)
                            throws SQLException
        Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theInputStream - an InputStream containing the ASCII data to set into the parameter value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setAsciiStream

        void setAsciiStream(String parameterName,
                          InputStream theInputStream)
                            throws SQLException
        Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterName - the name for parameter
        theInputStream - an InputStream containing the ASCII data to set into the parameter value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setAsciiStream

        void setAsciiStream(String parameterName,
                          InputStream theInputStream,
                          int length)
                            throws SQLException
        Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterName - the name for parameter
        theInputStream - an InputStream containing the ASCII data to set into the parameter value
        length - the length of the data in bytes
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBigDecimal

        void setBigDecimal(int parameterIndex,
                         BigDecimal theBigDecimal)
                           throws SQLException
        Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theBigDecimal - the big decimal value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBigDecimal

        void setBigDecimal(String parameterName,
                         BigDecimal theBigDecimal)
                           throws SQLException
        Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.
        Parameters:
        parameterName - the name for parameter
        theBigDecimal - the BigDecimal containing the value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBinaryStream

        void setBinaryStream(int parameterIndex,
                           InputStream theInputStream,
                           int length)
                             throws SQLException
        Sets the value of the specified parameter in the RowSet command to the binary data in the supplied input stream. Data is read from the input stream until end-of-file is reached.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theInputStream - the binary data stream to which the parameter is set.
        length - the length of the data in bytes.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBinaryStream

        void setBinaryStream(int parameterIndex,
                           InputStream theInputStream)
                             throws SQLException
        Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theInputStream - an InputStream containing the binary data to set into the parameter value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBinaryStream

        void setBinaryStream(String parameterName,
                           InputStream theInputStream)
                             throws SQLException
        Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterName - the name for parameter
        theInputStream - an InputStream containing the binary data to set into the parameter value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBinaryStream

        void setBinaryStream(String parameterName,
                           InputStream theInputStream,
                           int length)
                             throws SQLException
        Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterName - the name for parameter
        theInputStream - an InputStream containing the binary data to set into the parameter value
        length - the length of the data in bytes
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBlob

        void setBlob(int parameterIndex,
                   Blob theBlob)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied Blob value.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theBlob - the Blob value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBlob

        void setBlob(int parameterIndex,
                   InputStream theInputStream)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theInputStream - an InputStream containing the binary data to set into the parameter value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBlob

        void setBlob(int parameterIndex,
                   InputStream theInputStream,
                   long length)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theInputStream - an InputStream containing the binary data to set into the parameter value
        length - the length of the data in bytes
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBlob

        void setBlob(String parameterName,
                   InputStream theInputStream)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterName - the name for parameter
        theInputStream - an InputStream containing the binary data to set into the parameter value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBlob

        void setBlob(String parameterName,
                   InputStream theInputStream,
                   long length)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
        Parameters:
        parameterName - the name for parameter
        theInputStream - an InputStream containing the binary data to set into the parameter value
        length - the length of the data in bytes
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBlob

        void setBlob(String parameterName,
                   Blob theBlob)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Blob.
        Parameters:
        parameterName - the name for parameter
        theBlob - the Blob value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBoolean

        void setBoolean(int parameterIndex,
                      boolean theBoolean)
                        throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied boolean.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theBoolean - the boolean value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBoolean

        void setBoolean(String parameterName,
                      boolean theBoolean)
                        throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied boolean.
        Parameters:
        parameterName - name for parameter
        theBoolean - the boolean value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setByte

        void setByte(int parameterIndex,
                   byte theByte)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied byte value.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theByte - the byte value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setByte

        void setByte(String parameterName,
                   byte theByte)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied byte value.
        Parameters:
        parameterName - name for parameter
        theByte - the byte value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBytes

        void setBytes(int parameterIndex,
                    byte[] theByteArray)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied byte array value.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theByteArray - the Array of bytes to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setBytes

        void setBytes(String parameterName,
                    byte[] theByteArray)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied byte array value.
        Parameters:
        parameterName - name for parameter
        theByteArray - the array of bytes to set into the parameter.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setCharacterStream

        void setCharacterStream(int parameterIndex,
                              Reader theReader,
                              int length)
                                throws SQLException
        Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theReader - the Reader which contains the Unicode data to set the parameter.
        length - the length of the data in the Reader in characters.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setCharacterStream

        void setCharacterStream(int parameterIndex,
                              Reader theReader)
                                throws SQLException
        Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setCharacterStream

        void setCharacterStream(String parameterName,
                              Reader theReader)
                                throws SQLException
        Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setCharacterStream

        void setCharacterStream(String parameterName,
                              Reader theReader,
                              int length)
                                throws SQLException
        Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setClob

        void setClob(int parameterIndex,
                   Clob theClob)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theClob - the Clob value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setClob

        void setClob(int parameterIndex,
                   Reader theReader)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setClob

        void setClob(int parameterIndex,
                   Reader theReader,
                   long length)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setClob

        void setClob(String parameterName,
                   Clob theClob)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.
        Parameters:
        parameterName - name for parameter
        theClob - the specific Clob object
        Throws:
        SQLException - if an error occurs accessing the database.
      • setClob

        void setClob(String parameterName,
                   Reader theReader)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setClob

        void setClob(String parameterName,
                   Reader theReader,
                   long length)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setCommand

        void setCommand(String cmd)
                        throws SQLException
        Sets the Command property for this RowSet - the command is an SQL query which runs when the execute method is invoked. This property is optional for databases that do not support commands.
        Parameters:
        cmd - the SQL query. Can be null.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setConcurrency

        void setConcurrency(int concurrency)
                            throws SQLException
        Sets the concurrency property of this RowSet. The default value is ResultSet.CONCUR_READ_ONLY.
        Parameters:
        concurrency - the concurrency value. One of:
        • ResultSet.CONCUR_READ_ONLY
        • ResultSet.CONCUR_UPDATABLE
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        ResultSet
      • setDataSourceName

        void setDataSourceName(String name)
                               throws SQLException
        Sets the database name property for the RowSet.

        The database name can be used to find a DataSource which has been registered with a naming service - the DataSource can then be used to create a connection to the database.

        Parameters:
        name - the database name.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setDate

        void setDate(int parameterIndex,
                   Date theDate)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theDate - the date value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setDate

        void setDate(int parameterIndex,
                   Date theDate,
                   Calendar theCalendar)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the date to an SQL DATE value is calculated using a supplied Calendar.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theDate - the date to which the parameter is set.
        theCalendar - the Calendar to use in converting the Date to an SQL DATE value.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setDate

        void setDate(String parameterName,
                   Date theDate)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
        Parameters:
        parameterName - name for parameter
        theDate - the Date to use
        Throws:
        SQLException - if an error occurs accessing the database.
      • setDate

        void setDate(String parameterName,
                   Date theDate,
                   Calendar theCalendar)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
        Parameters:
        parameterName - name for parameter
        theDate - the Date to use
        theCalendar - the Calendar to use in converting the Date to an SQL DATE value
        Throws:
        SQLException - if an error occurs accessing the database.
      • setDouble

        void setDouble(int parameterIndex,
                     double theDouble)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied double.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theDouble - the double value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setDouble

        void setDouble(String parameterName,
                     double theDouble)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied double.
        Parameters:
        parameterName - name for parameter
        theDouble - the double value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setEscapeProcessing

        void setEscapeProcessing(boolean enable)
                                 throws SQLException
        Sets the escape processing status for this RowSet. If escape processing is on, the driver performs a substitution of the escape syntax with the applicable code before sending an SQL command to the database. The default value for escape processing is true.
        Parameters:
        enable - true to enable escape processing, false to turn it off.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setFloat

        void setFloat(int parameterIndex,
                    float theFloat)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied float.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theFloat - the float value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setFloat

        void setFloat(String parameterName,
                    float theFloat)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied float.
        Parameters:
        parameterName - name for parameter
        theFloat - the float value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setInt

        void setInt(int parameterIndex,
                  int theInteger)
                    throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied integer.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theInteger - the integer value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setInt

        void setInt(String parameterName,
                  int theInteger)
                    throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied integer.
        Parameters:
        parameterName - name for parameter
        theInteger - the integer value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setLong

        void setLong(int parameterIndex,
                   long theLong)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied long.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theLong - the long value value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setLong

        void setLong(String parameterName,
                   long theLong)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command with the supplied long.
        Parameters:
        parameterName - name for parameter
        theLong - the long value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setMaxFieldSize

        void setMaxFieldSize(int max)
                             throws SQLException
        Sets the maximum number of bytes which can be returned for a column value where the column type is one of BINARY, VARBINARY, LONGVARBINARYBINARY, CHAR, VARCHAR, or LONGVARCHAR. Data which exceeds this limit is silently discarded. For portability, a value greater than 256 is recommended.
        Parameters:
        max - the maximum size of the returned column value in bytes. 0 implies no size limit.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setMaxRows

        void setMaxRows(int max)
                        throws SQLException
        Sets the maximum number of rows which can be held by the RowSet. Any additional rows are silently discarded.
        Parameters:
        max - the maximum number of rows which can be held in the RowSet. 0 means no limit.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNCharacterStream

        void setNCharacterStream(int parameterIndex,
                               Reader theReader)
                                 throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNCharacterStream

        void setNCharacterStream(int parameterIndex,
                               Reader theReader,
                               long length)
                                 throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNCharacterStream

        void setNCharacterStream(String parameterName,
                               Reader theReader)
                                 throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNCharacterStream

        void setNCharacterStream(String parameterName,
                               Reader theReader,
                               long length)
                                 throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNClob

        void setNClob(int parameterIndex,
                    NClob theNClob)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theNClob - the NClob value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNClob

        void setNClob(int parameterIndex,
                    Reader theReader)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNClob

        void setNClob(int parameterIndex,
                    Reader theReader,
                    long length)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNClob

        void setNClob(String parameterName,
                    NClob theNClob)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
        Parameters:
        parameterName - name for parameter
        theNClob - the NClob value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNClob

        void setNClob(String parameterName,
                    Reader theReader)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNClob

        void setNClob(String parameterName,
                    Reader theReader,
                    long length)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
        Parameters:
        parameterName - name for parameter
        theReader - the Reader which contains the Unicode data to set into the parameter
        length - the length of the data in the Reader in characters
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNString

        void setNString(int parameterIndex,
                      String theNString)
                        throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied NString
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theNString - the NString value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNString

        void setNString(String parameterName,
                      String theNString)
                        throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied NString.
        Parameters:
        parameterName - name for parameter
        theNString - the NString value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNull

        void setNull(int parameterIndex,
                   int sqlType)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to SQL NULL.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        sqlType - the type of the parameter, as defined by java.sql.Types.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNull

        void setNull(int parameterIndex,
                   int sqlType,
                   String typeName)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        sqlType - the type of the parameter, as defined by java.sql.Types.
        typeName - the fully qualified name of an SQL user defined type or the name of the SQL structured type referenced by a REF type. Ignored if the sqlType is not a UDT or REF type.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNull

        void setNull(String parameterName,
                   int sqlType)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.
        Parameters:
        parameterName - name for parameter
        sqlType - the type of the parameter, as defined by java.sql.Types.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setNull

        void setNull(String parameterName,
                   int sqlType,
                   String typeName)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.
        Parameters:
        parameterName - name for parameter
        sqlType - the type of the parameter, as defined by java.sql.Types.
        typeName - the fully qualified name of an SQL User Defined Type or the name of the SQL structured type referenced by a REF type. Ignored if the sqlType is not a UDT or REF type.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setObject

        void setObject(int parameterIndex,
                     Object theObject)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied Java object.

        The JDBC specification provides a standard mapping for Java objects to SQL data types. Database specific types can be mapped by JDBC driver specific Java types.

        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theObject - the Java object containing the data value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setObject

        void setObject(int parameterIndex,
                     Object theObject,
                     int targetSqlType)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied Java object.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theObject - the Java object containing the data value.
        targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setObject

        void setObject(int parameterIndex,
                     Object theObject,
                     int targetSqlType,
                     int scale)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied Java object.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theObject - the Java object containing the data value.
        targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
        scale - the number of digits after the decimal point, for java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types. Ignored for all other types.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setObject

        void setObject(String parameterName,
                     Object theObject)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied Java object.
        Parameters:
        parameterName - name for parameter
        theObject - the Java object containing the data value.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setObject

        void setObject(String parameterName,
                     Object theObject,
                     int targetSqlType)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied Java object.
        Parameters:
        parameterName - name for parameter
        theObject - the Java object containing the data value.
        targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setObject

        void setObject(String parameterName,
                     Object theObject,
                     int targetSqlType,
                     int scale)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied Java object.
        Parameters:
        parameterName - name for parameter
        theObject - the Java object containing the data value.
        targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
        scale - the number of digits after the decimal point, for java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types. Ignored for all other types.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setPassword

        void setPassword(String password)
                         throws SQLException
        Sets the database Password for this RowSet. This property is used when a connection to the database is established. Therefore it should be set prior to invoking the execute() method.
        Parameters:
        password - a String holding the password.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setQueryTimeout

        void setQueryTimeout(int seconds)
                             throws SQLException
        Gets the timeout for the driver when a query operation is executed. If a query takes longer than the timeout, a SQLException is thrown.
        Parameters:
        seconds - the number of seconds for the timeout.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setReadOnly

        void setReadOnly(boolean readOnly)
                         throws SQLException
        Sets whether the RowSet is read-only or updatable.
        Parameters:
        readOnly - true to set the RowSet to read-only state, false to allow updates.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setRef

        void setRef(int parameterIndex,
                  Ref theRef)
                    throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Ref. This is sent to the database as an SQL REF value.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theRef - the value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        Ref
      • setShort

        void setShort(int parameterIndex,
                    short theShort)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied short integer.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theShort - the value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setShort

        void setShort(String parameterName,
                    short theShort)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied short integer.
        Parameters:
        parameterName - name for parameter
        theShort - the short value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setString

        void setString(int parameterIndex,
                     String theString)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied String. The string is placed into the database as a VARCHAR or LONGVARCHAR SQL value, depending on the database limits for the length of VARCHAR values.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theString - the value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setString

        void setString(String parameterName,
                     String theString)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied String. The String is placed into the database as a VARCHAR or LONGVARCHAR SQL value, depending on the database limits for the length of VARCHAR values.
        Parameters:
        parameterName - name for parameter
        theString -
        Throws:
        SQLException - if an error occurs accessing the database.
      • setRowId

        void setRowId(int parameterIndex,
                    RowId theRowId)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied RowId
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theRowId - the RowId value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setRowId

        void setRowId(String parameterName,
                    RowId theRowId)
                      throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied RowId.
        Parameters:
        parameterName - name for parameter
        theRowId - the RowId value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setSQLXML

        void setSQLXML(int parameterIndex,
                     SQLXML theSQLXML)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied SQLXML
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theSQLXML - the SQLXML value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setSQLXML

        void setSQLXML(String parameterName,
                     SQLXML theSQLXML)
                       throws SQLException
        Sets the value of the specified parameter in the RowSet command to the supplied SQLXML.
        Parameters:
        parameterName - name for parameter
        theSQLXML - the SQLXML value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setTime

        void setTime(int parameterIndex,
                   Time theTime)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting it to an SQL TIME value using the system default Calendar.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theTime - the value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        Calendar, Time
      • setTime

        void setTime(int parameterIndex,
                   Time theTime,
                   Calendar theCalendar)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting it to an SQL TIME value using a supplied Calendar.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theTime - the value to which the parameter is set.
        theCalendar - the Calendar to use in the conversion operation.
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        Calendar, Time
      • setTime

        void setTime(String parameterName,
                   Time theTime)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
        Parameters:
        parameterName - name for parameter
        theTime - the Time value to set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setTime

        void setTime(String parameterName,
                   Time theTime,
                   Calendar theCalendar)
                     throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
        Parameters:
        parameterName - name for parameter
        theTime - the Time value to set
        theCalendar - the Calendar to use in the conversion operation
        Throws:
        SQLException - if an error occurs accessing the database.
      • setTimestamp

        void setTimestamp(int parameterIndex,
                        Timestamp theTimestamp)
                          throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp, converting it to an SQL TIMESTAMP value using the system default Calendar.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theTimestamp - the value to which the parameter is set.
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        Calendar, Timestamp
      • setTimestamp

        void setTimestamp(int parameterIndex,
                        Timestamp theTimestamp,
                        Calendar theCalendar)
                          throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp, converting it to an SQL TIMESTAMP value using a supplied Calendar.
        Parameters:
        parameterIndex - the index of the parameter to set; the first parameter's index is 1.
        theTimestamp - the value to which the parameter is set.
        theCalendar - the Calendar to use in the conversion operation
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        Calendar, Timestamp
      • setTimestamp

        void setTimestamp(String parameterName,
                        Timestamp theTimestamp)
                          throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using the system default Calendar.
        Parameters:
        parameterName - name for parameter
        theTimestamp - the value to which the parameter is set
        Throws:
        SQLException - if an error occurs accessing the database.
      • setTimestamp

        void setTimestamp(String parameterName,
                        Timestamp theTimestamp,
                        Calendar theCalendar)
                          throws SQLException
        Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a supplied Calendar.
        Parameters:
        parameterName - name for parameter
        theTimestamp - the value to which the parameter is set
        theCalendar - the Calendar to use in the conversion operation
        Throws:
        SQLException - if an error occurs accessing the database.
      • setTransactionIsolation

        void setTransactionIsolation(int level)
                                     throws SQLException
        Sets the target instance's transaction isolation level to one of a discrete set of possible values. The transaction isolation level defines the policy implemented on the database for maintaining the data values consistent.

        Keep in mind that setting a transaction isolation level has no effect unless your driver and DBMS support it.

        Parameters:
        level - the transaction isolation level. One of:
        • Connection.TRANSACTION_READ_UNCOMMITTED
        • Connection.TRANSACTION_READ_COMMITTED
        • Connection.TRANSACTION_REPEATABLE_READ
        • Connection.TRANSACTION_SERIALIZABLE
        Throws:
        SQLException - if an error occurs accessing the database.
        See Also:
        Connection
      • setType

        void setType(int type)
                     throws SQLException
        Sets the type of this RowSet. By default, the type is non-scrollable.
        Parameters:
        type - the type for the RowSet. One of:
        • ResultSet.TYPE_FORWARD_ONLY
        • ResultSet.TYPE_SCROLL_INSENSITIVE
        • ResultSet.TYPE_SCROLL_SENSITIVE
        Throws:
        SQLException - if an error occurs accessing the database.
      • setTypeMap

        void setTypeMap(Map<String,Class<?>> theTypeMap)
                        throws SQLException
        Sets the mapping of SQL User Defined Types (UDTs) to Java classes. The Java classes must all implement the SQLData interface.
        Parameters:
        theTypeMap - the names of SQL UDTs and the Java classes to which they are mapped.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setUrl

        void setUrl(String theURL)
                    throws SQLException
        Sets the URL used by this RowSet to access the database via a DriverManager. The URL is optional - an alternative is to use a database name to create a connection.
        Parameters:
        theURL - the URL for the database. Can be null.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setURL

        void setURL(int parameterIndex,
                  URL theURL)
                    throws SQLException
        Sets the URL used by this RowSet to access the database via a DriverManager. The URL is optional - an alternative is to use a Data Source Name to create a connection.
        Parameters:
        parameterIndex - index of the parameter to set, where the first parameter has index = 1.
        theURL - a java.net.URL containing the URL for the database.
        Throws:
        SQLException - if an error occurs accessing the database.
      • setUsername

        void setUsername(String theUsername)
                         throws SQLException
        Sets the Username property for the RowSet, used to authenticate a connection to the database.
        Parameters:
        theUsername - the new user name for this row set.
        Throws:
        SQLException - if an error occurs accessing the database.


Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 2015 / . Delta: 0.08502 с