10133 lines · 431.3 KB · Java
RawDownload
        }    }     /**     * Goes to the page number passed as the parameter     * @param page , the page loaded on a call to this function     * @return true if the page exists false otherwise     * @throws SQLException if an error occurs     */    /*    public boolean absolutePage(int page) throws SQLException{         boolean isAbs = true, retVal = true;        int counter;         if( page <= 0 ){            throw new SQLException("Absolute positoin is invalid");        }        counter = 0;         firstPage();        counter++;        while((counter < page) && isAbs) {            isAbs = nextPage();            counter ++;        }         if( !isAbs && counter < page){            retVal = false;        }        else if(counter == page){            retVal = true;        }        return retVal;    }    */      /**     * Goes to the page number passed as the parameter  from the current page.     * The parameter can take postive or negative value accordingly.     * @param page , the page loaded on a call to this function     * @return true if the page exists false otherwise     * @throws SQLException if an error occurs     */    /*    public boolean relativePage(int page) throws SQLException {         boolean isRel = true,retVal = true;        int counter;         if(page > 0){           counter  = 0;           while((counter < page) && isRel){              isRel = nextPage();              counter++;           }            if(!isRel && counter < page){               retVal = false;           }           else if( counter == page){               retVal = true;           }           return retVal;        }        else {            counter = page;            isRel = true;            while((counter < 0) && isRel){                isRel = previousPage();                counter++;            }             if( !isRel && counter < 0){                retVal = false;            }            else if(counter == 0){                retVal = true;            }            return retVal;        }    }    */      /**     * Retrieves the first page of data as specified by the page size.     * @return boolean value true if present on first page, false otherwise     * @throws SQLException if it called before populate or ResultSet is of     *         type <code>ResultSet.TYPE_FORWARD_ONLY</code> or an error occurs     */    /*    public boolean firstPage() throws SQLException {           if (populatecallcount == 0){             throw new SQLException("Populate the data before calling ");           }           if( !callWithCon){              if(resultSet.getType() == ResultSet.TYPE_FORWARD_ONLY) {                  throw new SQLException("Result of type forward only");              }           }           endPos = 0;           maxRowsreached = 0;           pagenotend = true;           if(callWithCon){               crsReader.setStartPosition(startPos);               crsReader.readData((RowSetInternal)this);               resultSet = null;           }           else {              populate(resultSet,startPos);           }           onFirstPage = true;           return onFirstPage;    }    */     /**     * Retrives the last page of data as specified by the page size.     * @return boolean value tur if present on the last page, false otherwise     * @throws SQLException if called before populate or if an error occurs.     */     /*    public boolean lastPage() throws SQLException{          int pS;          int mR;          int quo;          int rem;           pS = getPageSize();          mR = getMaxRows();           if(pS == 0){              onLastPage = true;              return onLastPage;          }           if(getMaxRows() == 0){              mR = totalRows;          }           if (populatecallcount == 0){             throw new SQLException("Populate the data before calling ");         }          onFirstPage = false;          if((mR % pS) == 0){             quo = mR / pS;             int start = startPos + (pS * (quo - 1));             maxRowsreached = mR - pS;             if(callWithCon){                 crsReader.setStartPosition(start);                 crsReader.readData((RowSetInternal)this);                 resultSet = null;             }             else {                populate(resultSet,start);             }             onLastPage = true;             return onLastPage;         }        else {              quo = mR /pS;              rem = mR % pS;              int start = startPos + (pS * quo);             maxRowsreached = mR - (rem);             if(callWithCon){                 crsReader.setStartPosition(start);                 crsReader.readData((RowSetInternal)this);                 resultSet = null;             }             else {                populate(resultSet,start);             }             onLastPage = true;             return onLastPage;         }    }    */    /**     * Sets the status for the row on which the cursor is positioned. The insertFlag is used     * to mention the toggle status for this row     * @param insertFlag if it is true  - marks this row as inserted     *                   if it is false - marks it as not a newly inserted row     * @throws SQLException if an error occurs while doing this operation     */    public void setRowInserted(boolean insertFlag) throws SQLException {         checkCursor();         if(onInsertRow == true)          throw new SQLException(resBundle.handleGetObject("cachedrowsetimpl.invalidop").toString());         if( insertFlag ) {          ((Row)getCurrentRow()).setInserted();        } else {          ((Row)getCurrentRow()).clearInserted();        }    }     /**     * Retrieves the value of the designated <code>SQL XML</code> parameter as a     * <code>SQLXML</code> object in the Java programming language.     * @param columnIndex the first column is 1, the second is 2, ...     * @return a SQLXML object that maps an SQL XML value     * @throws SQLException if a database access error occurs     * @since 6.0     */    public SQLXML getSQLXML(int columnIndex) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves the value of the designated <code>SQL XML</code> parameter as a     * <code>SQLXML</code> object in the Java programming language.     * @param colName the name of the column from which to retrieve the value     * @return a SQLXML object that maps an SQL XML value     * @throws SQLException if a database access error occurs     */    public SQLXML getSQLXML(String colName) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves the value of the designated column in the current row of this     * <code>ResultSet</code> object as a java.sql.RowId object in the Java     * programming language.     *     * @param columnIndex the first column is 1, the second 2, ...     * @return the column value if the value is a SQL <code>NULL</code> the     *     value returned is <code>null</code>     * @throws SQLException if a database access error occurs     * @since 6.0     */    public RowId getRowId(int columnIndex) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves the value of the designated column in the current row of this     * <code>ResultSet</code> object as a java.sql.RowId object in the Java     * programming language.     *     * @param columnName the name of the column     * @return the column value if the value is a SQL <code>NULL</code> the     *     value returned is <code>null</code>     * @throws SQLException if a database access error occurs     * @since 6.0     */    public RowId getRowId(String columnName) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Updates the designated column with a <code>RowId</code> value. The updater     * methods are used to update column values in the current row or the insert     * row. The updater methods do not update the underlying database; instead     * the <code>updateRow<code> or <code>insertRow</code> methods are called     * to update the database.     *     * @param columnIndex the first column is 1, the second 2, ...     * @param x the column value     * @throws SQLException if a database access occurs     * @since 6.0     */    public void updateRowId(int columnIndex, RowId x) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Updates the designated column with a <code>RowId</code> value. The updater     * methods are used to update column values in the current row or the insert     * row. The updater methods do not update the underlying database; instead     * the <code>updateRow<code> or <code>insertRow</code> methods are called     * to update the database.     *     * @param columnName the name of the column     * @param x the column value     * @throws SQLException if a database access occurs     * @since 6.0     */    public void updateRowId(String columnName, RowId x) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves the holdability of this ResultSet object     * @return  either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT     * @throws SQLException if a database error occurs     * @since 6.0     */    public int getHoldability() throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves whether this ResultSet object has been closed. A ResultSet is closed if the     * method close has been called on it, or if it is automatically closed.     * @return true if this ResultSet object is closed; false if it is still open     * @throws SQLException if a database access error occurs     * @since 6.0     */    public boolean isClosed() throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * This method is used for updating columns that support National Character sets.     * It can be used for updating NCHAR,NVARCHAR and LONGNVARCHAR columns.     * @param columnIndex the first column is 1, the second 2, ...     * @param nString the value for the column to be updated     * @throws SQLException if a database access error occurs     * @since 6.0     */    public void updateNString(int columnIndex, String nString) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * This method is used for updating columns that support National Character sets.     * It can be used for updating NCHAR,NVARCHAR and LONGNVARCHAR columns.     * @param columnName name of the Column     * @param nString the value for the column to be updated     * @throws SQLException if a database access error occurs     * @since 6.0     */    public void updateNString(String columnName, String nString) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }      /*o     * This method is used for updating SQL <code>NCLOB</code>  type that maps     * to <code>java.sql.Types.NCLOB</code>     * @param columnIndex the first column is 1, the second 2, ...     * @param nClob the value for the column to be updated     * @throws SQLException if a database access error occurs     * @since 6.0     */    public void updateNClob(int columnIndex, NClob nClob) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * This method is used for updating SQL <code>NCLOB</code>  type that maps     * to <code>java.sql.Types.NCLOB</code>     * @param columnName name of the column     * @param nClob the value for the column to be updated     * @throws SQLException if a database access error occurs     * @since 6.0     */    public void updateNClob(String columnName, NClob nClob) throws SQLException {       throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves the value of the designated column in the current row     * of this <code>ResultSet</code> object as a <code>NClob</code> object     * in the Java programming language.     *     * @param i the first column is 1, the second is 2, ...     * @return a <code>NClob</code> object representing the SQL     *         <code>NCLOB</code> value in the specified column     * @exception SQLException if a database access error occurs     * @since 6.0     */    public NClob getNClob(int i) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     /**     * Retrieves the value of the designated column in the current row     * of this <code>ResultSet</code> object as a <code>NClob</code> object     * in the Java programming language.     *     * @param colName the name of the column from which to retrieve the value     * @return a <code>NClob</code> object representing the SQL <code>NCLOB</code>     * value in the specified column     * @exception SQLException if a database access error occurs     * @since 6.0     */    public NClob getNClob(String colName) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());    }     public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException {        return null;    }     public boolean isWrapperFor(Class<?> interfaces) throws SQLException {        return false;    }     /**      * Sets the designated parameter to the given <code>java.sql.SQLXML</code> object. The driver converts this to an      * SQL <code>XML</code> value when it sends it to the database.      * @param parameterIndex index of the first parameter is 1, the second is 2, ...      * @param xmlObject a <code>SQLXML</code> object that maps an SQL <code>XML</code> value      * @throws SQLException if a database access error occurs      * @since 1.6      */     public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException {         throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());     }    /**     * Sets the designated parameter to the given <code>java.sql.SQLXML</code> object. The driver converts this to an     * <code>SQL XML</code> value when it sends it to the database.     * @param parameterName the name of the parameter     * @param xmlObject a <code>SQLXML</code> object that maps an <code>SQL XML</code> value     * @throws SQLException if a database access error occurs     * @since 1.6     */    public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException {         throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());     }      /**     * Sets the designated parameter to the given <code>java.sql.RowId</code> object. The     * driver converts this to a SQL <code>ROWID</code> value when it sends it     * to the database     *     * @param parameterIndex the first parameter is 1, the second is 2, ...     * @param x the parameter value     * @throws SQLException if a database access error occurs     *     * @since 1.6     */    public void setRowId(int parameterIndex, RowId x) throws SQLException {         throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());     }      /**    * Sets the designated parameter to the given <code>java.sql.RowId</code> object. The    * driver converts this to a SQL <code>ROWID</code> when it sends it to the    * database.    *    * @param parameterName the name of the parameter    * @param x the parameter value    * @throws SQLException if a database access error occurs    * @since 1.6    */   public void setRowId(String parameterName, RowId x) throws SQLException {         throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());     }      /**     * Sets the designated parameter to a <code>Reader</code> object. The     * <code>Reader</code> reads the data till end-of-file is reached. The     * driver does the necessary conversion from Java character format to     * the national character set in the database.      * <P><B>Note:</B> This stream object can either be a standard     * Java stream object or your own subclass that implements the     * standard interface.     * <P><B>Note:</B> Consult your JDBC driver documentation to determine if     * it might be more efficient to use a version of     * <code>setNCharacterStream</code> which takes a length parameter.     *     * @param parameterIndex of the first parameter is 1, the second is 2, ...     * @param value the parameter value     * @throws SQLException if the driver does not support national     *         character sets;  if the driver can detect that a data conversion     *  error could occur ; if a database access error occurs; or     * this method is called on a closed <code>PreparedStatement</code>     * @throws SQLFeatureNotSupportedException  if the JDBC driver does not support this method     * @since 1.6     */     public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException {        throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.featnotsupp").toString());     }      /**    * Sets the designated parameter to a <code>java.sql.NClob</code> object. The object    * implements the <code>java.sql.NClob</code> interface. This <code>NClob</code>    * object maps to a SQL <code>NCLOB</code>.    * @param parameterName the name of the column to be set    * @param value the parameter value    * @throws SQLException if the driver does not support national    *         character sets;  if the driver can detect that a data conversion    *  error could occur; or if a database access error occurs    * @since 1.6    */    public void setNClob(String parameterName, NClob value) throws SQLException {         throw new SQLFeatureNotSupportedException(resBundle.handleGetObject("cachedrowsetimpl.opnotysupp").toString());     }    /**     * Retrieves the value of the designated column in the current row     * of this <code>ResultSet</code> object as a

Lines 7501–8000 of 10133. Previous lines