Minimum required implementation of JDBC drivers

Owned by Former user (Deleted)
Last updated: Aug 26, 2014Version comment
9 min read

The list below covers all of the required objects and methods from the java.sql.* package. These methods are invoked by either one of the Pentaho projects and must be implemented correctly and according to the specifications in order to be fully supported by the Pentaho platform and user tools.

This list was compiled against version 5.1.0-752 of the platform.

Interface

Method

Description

Link

java.sql.Blob

getBinaryStream

Retrieves the BLOB value designated by this Blob instance as a stream.

http://docs.oracle.com/javase/7/docs/api/java/sql/Blob.html#getBinaryStream()

java.sql.Blob

getBytes

Retrieves all or part of the BLOB value that this Blob object represents, as an array of bytes.

http://docs.oracle.com/javase/7/docs/api/java/sql/Blob.html#getBytes(long,%20int)

java.sql.Blob

length

Returns the number of bytes in the BLOB value designated by this Blob object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Blob.html#length()

java.sql.CallableStatement

close

Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#close()

java.sql.CallableStatement

execute

Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#execute()

java.sql.CallableStatement

getBigDecimal

Retrieves the value of the designated JDBC NUMERIC parameter as ajava.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getBigDecimal(int)

java.sql.CallableStatement

getBlob

Retrieves the value of the designated JDBC BLOB parameter as a object in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getBlob(int)

java.sql.CallableStatement

getBoolean

Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getBoolean(int)

java.sql.CallableStatement

getBytes

Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array ofbyte values in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getBytes(int)

java.sql.CallableStatement

getDate

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getDate(int)

java.sql.CallableStatement

getDouble

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getDouble(int)

java.sql.CallableStatement

getLong

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getLong(int)

java.sql.CallableStatement

getMoreResults

Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getMoreResults()

java.sql.CallableStatement

getResultSet

Retrieves the current result as a ResultSet object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getResultSet()

java.sql.CallableStatement

getString

Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getString(int)

java.sql.CallableStatement

getTimestamp

Retrieves the value of the designated JDBC TIMESTAMP parameter as ajava.sql.Timestamp object.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#getTimestamp(int)

java.sql.CallableStatement

getUpdateCount

Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getUpdateCount()

java.sql.CallableStatement

registerOutParameter

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

http://docs.oracle.com/javase/7/docs/api/java/sql/CallableStatement.html#registerOutParameter(int,%20int)

java.sql.Clob

getCharacterStream

Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).

http://docs.oracle.com/javase/7/docs/api/java/sql/Clob.html#getCharacterStream()

java.sql.Connection

close

Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#close()

java.sql.Connection

commit

Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#commit()

java.sql.Connection

createStatement

Creates a Statement object for sending SQL statements to the database.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#createStatement()

java.sql.Connection

createStatement

Creates a Statement object that will generate ResultSet objects with the given type and concurrency.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#createStatement(int,%20int)

java.sql.Connection

getAutoCommit

Retrieves the current auto-commit mode for this Connection object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#getAutoCommit()

java.sql.Connection

getCatalog

Retrieves this Connection object's current catalog name.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#getCatalog()

java.sql.Connection

getMetaData

Retrieves a DatabaseMetaData object that contains metadata about the database to which this Connection object represents a connection.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#getMetaData()

java.sql.Connection

isClosed

Retrieves whether this Connection object has been closed.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#isClosed()

java.sql.Connection

prepareCall

Creates a CallableStatement object for calling database stored procedures.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareCall(java.lang.String)

java.sql.Connection

prepareCall

Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareCall(java.lang.String,%20int,%20int,%20int)

java.sql.Connection

prepareStatement

Creates a PreparedStatement object for sending parameterized SQL statements to the database.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareStatement(java.lang.String)

java.sql.Connection

prepareStatement

Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareStatement(java.lang.String,%20int)

java.sql.Connection

prepareStatement

Creates a PreparedStatement object that will generate ResultSet objects with the given type and concurrency.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareStatement(java.lang.String,%20int,%20int)

java.sql.Connection

releaseSavepoint

Removes the specified Savepoint and subsequent Savepoint objects from the current transaction.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#releaseSavepoint(java.sql.Savepoint)

java.sql.Connection

rollback

Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#rollback()

java.sql.Connection

setAutoCommit

Sets this connection's auto-commit mode to the given state.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setAutoCommit(boolean)

java.sql.Connection

setSavepoint

Creates an unnamed savepoint in the current transaction and returns the newSavepoint object that represents it.

http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setSavepoint()

java.sql.DatabaseMetaData

getCatalogs

Retrieves the catalog names available in this database.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getCatalogs()

java.sql.DatabaseMetaData

getColumns

Retrieves a description of table columns available in the specified catalog.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)

java.sql.DatabaseMetaData

getConnection

Retrieves the connection that produced this metadata object.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getConnection()

java.sql.DatabaseMetaData

getDatabaseProductName

Retrieves the name of this database product.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getDatabaseProductName()

java.sql.DatabaseMetaData

getDatabaseProductVersion

Retrieves the version number of this database product.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getDatabaseProductVersion()

java.sql.DatabaseMetaData

getIdentifierQuoteString

Retrieves the string used to quote SQL identifiers.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getIdentifierQuoteString()

java.sql.DatabaseMetaData

getDriverMajorVersion

Retrieves this JDBC driver's major version number.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getDriverMajorVersion()

java.sql.DatabaseMetaData

getDriverName

Retrieves the name of this JDBC driver.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getDriverName()

java.sql.DatabaseMetaData

getExtraNameCharacters

Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getExtraNameCharacters()

java.sql.DatabaseMetaData

getMaxColumnNameLength

Retrieves the maximum number of characters this database allows for a column name.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getMaxColumnNameLength()

java.sql.DatabaseMetaData

getImportedKeys

Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getImportedKeys(java.lang.String,%20java.lang.String,%20java.lang.String)

java.sql.DatabaseMetaData

getIndexInfo

Retrieves a description of the given table's indices and statistics.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getIndexInfo(java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean,%20boolean)

java.sql.DatabaseMetaData

getPrimaryKeys

Retrieves a description of the given table's primary key columns.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getPrimaryKeys(java.lang.String,%20java.lang.String,%20java.lang.String)

java.sql.DatabaseMetaData

getProcedures

Retrieves a description of the stored procedures available in the given catalog.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getProcedures(java.lang.String,%20java.lang.String,%20java.lang.String)

java.sql.DatabaseMetaData

getSchemas

Retrieves the schema names available in this database.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas()

java.sql.DatabaseMetaData

getTables

Retrieves a description of the tables available in the given catalog.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String\[\]\)

java.sql.DatabaseMetaData

getTableTypes

Retrieves the table types available in this database.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTableTypes()

java.sql.DatabaseMetaData

isReadOnly

Retrieves whether this database is in read-only mode.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#isReadOnly()

java.sql.DatabaseMetaData

storesLowerCasedentifiers

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#storesLowerCaseIdentifiers()

java.sql.DatabaseMetaData

storesLowerCaseQuoteddentifiers

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#storesLowerCaseQuotedIdentifiers()

java.sql.DatabaseMetaData

storesMixedCasedentifiers

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#storesMixedCaseIdentifiers()

java.sql.DatabaseMetaData

storesMixedCaseQuoteddentifiers

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#storesMixedCaseQuotedIdentifiers()

java.sql.DatabaseMetaData

storesUpperCasedentifiers

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#storesUpperCaseIdentifiers()

java.sql.DatabaseMetaData

storesUpperCaseQuoteddentifiers

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#storesUpperCaseQuotedIdentifiers()

java.sql.DatabaseMetaData

supportsBatchUpdates

Retrieves whether this database supports batch updates.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsBatchUpdates()

java.sql.DatabaseMetaData

supportsCatalogsInTableDefinitions

Retrieves whether a catalog name can be used in a table definition statement.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsCatalogsInTableDefinitions()

java.sql.DatabaseMetaData

supportsMixedCaseIdentifiers

Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsMixedCaseIdentifiers()

java.sql.DatabaseMetaData

supportsMixedCaseQuotedIdentifiers

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsMixedCaseQuotedIdentifiers()

java.sql.DatabaseMetaData

supportsResultSetConcurrency

Retrieves whether this database supports the given concurrency type in combination with the given result set type.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsResultSetConcurrency(int,%20int)

java.sql.DatabaseMetaData

supportsResultSetType

Retrieves whether this database supports the given result set type.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsResultSetType(int)

java.sql.DatabaseMetaData

supportsSchemasInTableDefinitions

Retrieves whether a schema name can be used in a table definition statement.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsSchemasInTableDefinitions()

java.sql.DatabaseMetaData

supportsTransactions

Retrieves whether this database supports transactions.

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#supportsTransactions()

java.sql.Driver

acceptsURL

Retrieves whether the driver thinks that it can open a connection to the given URL.

http://docs.oracle.com/javase/7/docs/api/java/sql/Driver.html#acceptsURL(java.lang.String)

java.sql.Driver

connect

Attempts to make a database connection to the given URL.

http://docs.oracle.com/javase/7/docs/api/java/sql/Driver.html#connect(java.lang.String,%20java.util.Properties)

java.sql.Driver

getMajorVersion

Retrieves the driver's major version number.

http://docs.oracle.com/javase/7/docs/api/java/sql/Driver.html#getMajorVersion()

java.sql.Driver

getMinorVersion

Gets the driver's minor version number.

http://docs.oracle.com/javase/7/docs/api/java/sql/Driver.html#getMinorVersion()

java.sql.Driver

getPropertyInfo

Gets information about the possible properties for this driver.

http://docs.oracle.com/javase/7/docs/api/java/sql/Driver.html#getPropertyInfo(java.lang.String,%20java.util.Properties)

java.sql.Driver

jdbcCompliant

Reports whether this driver is a genuine JDBC CompliantTM driver.

http://docs.oracle.com/javase/7/docs/api/java/sql/Driver.html#jdbcCompliant()

java.sql.ParameterMetaData

getParameterCount

Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object contains information.

http://docs.oracle.com/javase/7/docs/api/java/sql/ParameterMetaData.html#getParameterCount()

java.sql.ParameterMetaData

getParameterType

Retrieves the designated parameter's SQL type.

http://docs.oracle.com/javase/7/docs/api/java/sql/ParameterMetaData.html#getParameterType(int)

java.sql.ParameterMetaData

getPrecision

Retrieves the designated parameter's specified column size.

http://docs.oracle.com/javase/7/docs/api/java/sql/ParameterMetaData.html#getPrecision(int)

java.sql.ParameterMetaData

getScale

Retrieves the designated parameter's number of digits to right of the decimal point.

http://docs.oracle.com/javase/7/docs/api/java/sql/ParameterMetaData.html#getScale(int)

java.sql.PreparedStatement

addBatch

Adds a set of parameters to this PreparedStatement object's batch of commands.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#addBatch()

java.sql.PreparedStatement

clearBatch

Empties this Statement object's current list of SQL commands.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#clearBatch()

java.sql.PreparedStatement

clearParameters

Clears the current parameter values immediately.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#clearParameters()

java.sql.PreparedStatement

close

Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#close()

java.sql.PreparedStatement

execute

Executes the given SQL statement, which may return multiple results.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute(java.lang.String)

java.sql.PreparedStatement

executeBatch

Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeBatch()

java.sql.PreparedStatement

executeQuery

Executes the given SQL statement, which returns a single ResultSet object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeQuery(java.lang.String)

java.sql.PreparedStatement

executeUpdate

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETEstatement or an SQL statement that returns nothing, such as an SQL DDL statement.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String)

java.sql.PreparedStatement

getGeneratedKeys

Retrieves any auto-generated keys created as a result of executing this Statementobject.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getGeneratedKeys()

java.sql.PreparedStatement

getMaxRows

Retrieves the maximum number of rows that a ResultSet object produced by thisStatement object can contain.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getMaxRows()

java.sql.PreparedStatement

getMetaData

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when thisPreparedStatement object is executed.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#getMetaData()

java.sql.PreparedStatement

getParameterMetaData

Retrieves the number, types and properties of this PreparedStatement object's parameters.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#getParameterMetaData()

java.sql.PreparedStatement

getUpdateCount

Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getUpdateCount()

java.sql.PreparedStatement

getWarnings

Retrieves the first warning reported by calls on this Statement object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getWarnings()

java.sql.PreparedStatement

setBigDecimal

Sets the designated parameter to the given java.math.BigDecimal value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setBigDecimal(int,%20java.math.BigDecimal)

java.sql.PreparedStatement

setBoolean

Sets the designated parameter to the given Java boolean value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setBoolean(int,%20boolean)

java.sql.PreparedStatement

setBytes

Sets the designated parameter to the given Java array of bytes.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setBytes(int,%20byte\[\]\)

java.sql.PreparedStatement

setCharacterStream

Sets the designated parameter to the given Reader object.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setCharacterStream(int,%20java.io.Reader)

java.sql.PreparedStatement

setDate

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setDate(int,%20java.sql.Date)

java.sql.PreparedStatement

setDate

Sets the designated parameter to the given java.sql.Date value, using the given Calendarobject.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setDate(int,%20java.sql.Date,%20java.util.Calendar)

java.sql.PreparedStatement

setDouble

Sets the designated parameter to the given Java double value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setDouble(int,%20double)

java.sql.PreparedStatement

setFetchDirection

Gives the driver a hint as to the direction in which rows will be processed inResultSet objects created using this Statement object.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setFetchDirection(int)

java.sql.PreparedStatement

setFetchSize

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 ResultSet objects genrated by thisStatement.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setFetchSize(int)

java.sql.PreparedStatement

setLong

Sets the designated parameter to the given Java long value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setLong(int,%20long)

java.sql.PreparedStatement

setMaxRows

Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setMaxRows(int)

java.sql.PreparedStatement

setInt

Sets the designated parameter to the given Java int value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setInt(int,%20int)

java.sql.PreparedStatement

setNull

Sets the designated parameter to SQL NULL.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setNull(int,%20int)

java.sql.PreparedStatement

setObject

Sets the value of the designated parameter using the given object.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setObject(int,%20java.lang.Object)

java.sql.PreparedStatement

setObject

Sets the value of the designated parameter with the given object.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setObject(int,%20java.lang.Object,%20int)

java.sql.PreparedStatement

setString

Sets the designated parameter to the given Java String value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setString(int,%20java.lang.String)

java.sql.PreparedStatement

setTimestamp

Sets the designated parameter to the given java.sql.Timestamp value.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setTimestamp(int,%20java.sql.Timestamp)

java.sql.PreparedStatement

setTimestamp

Sets the designated parameter to the given java.sql.Timestamp value, using the givenCalendar object.

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setTimestamp(int,%20java.sql.Timestamp,%20java.util.Calendar)

java.sql.ResultSet

absolute

Moves the cursor to the given row number in this ResultSet object.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#absolute(int)

java.sql.ResultSet

afterLast

Moves the cursor to the end of this ResultSet object, just after the last row.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#afterLast()

java.sql.ResultSet

close

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#close()

java.sql.ResultSet

first

Moves the cursor to the first row in this ResultSet object.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#first()

java.sql.ResultSet

getBigDecimal

Retrieves the value of the designated column in the current row of this ResultSetobject as a java.math.BigDecimal with full precision.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getBigDecimal(int)

java.sql.ResultSet

getBlob

Retrieves the value of the designated column in the current row of this ResultSet object as aBlob object in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getBlob(int)

java.sql.ResultSet

getBoolean

Retrieves the value of the designated column in the current row of this ResultSet object as aboolean in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getBoolean(int)

java.sql.ResultSet

getBytes

Retrieves the value of the designated column in the current row of this ResultSet object as abyte array in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getBytes(int)

java.sql.ResultSet

getDate

Retrieves the value of the designated column in the current row of this ResultSet object as ajava.sql.Date object in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getDate(int)

java.sql.ResultSet

getDouble

Retrieves the value of the designated column in the current row of this ResultSet object as adouble in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getDouble(int)

java.sql.ResultSet

getDouble

Retrieves the value of the designated column in the current row of this ResultSet object as adouble in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getDouble(java.lang.String)

java.sql.ResultSet

getLong

Retrieves the value of the designated column in the current row of this ResultSet object as along in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getLong(int)

java.sql.ResultSet

getMetaData

Retrieves the number, types and properties of this ResultSet object's columns.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getMetaData()

java.sql.ResultSet

getInt

Retrieves the value of the designated column in the current row of this ResultSet object as anint in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getInt(int)

java.sql.ResultSet

getObject

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

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getObject(int)

java.sql.ResultSet

getObject

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

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getObject(java.lang.String)

java.sql.ResultSet

getRow

Retrieves the current row number.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getRow()

java.sql.ResultSet

getStatement

Retrieves the Statement object that produced this ResultSet object.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getStatement()

java.sql.ResultSet

getString

Retrieves the value of the designated column in the current row of this ResultSet object as aString in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getString(int)

java.sql.ResultSet

getString

Retrieves the value of the designated column in the current row of this ResultSet object as aString in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getString(java.lang.String)

java.sql.ResultSet

getTime

Retrieves the value of the designated column in the current row of this ResultSet object as ajava.sql.Time object in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getTime(int)

java.sql.ResultSet

getTimestamp

Retrieves the value of the designated column in the current row of this ResultSet object as ajava.sql.Timestamp object in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getTimestamp(int)

java.sql.ResultSet

getTimestamp

Retrieves the value of the designated column in the current row of this ResultSet object as ajava.sql.Timestamp object in the Java programming language.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getTimestamp(java.lang.String)