Method |
Description |
clearParameters( )
|
Clears set parameters on the specified prepared statement object. |
clearWarnings( )
|
Clears any sql warning objects on the specified connection, result set or statement object. |
close( )
|
Used to close a connection, result set or statement object. |
commit( )
|
Makes changes to the database permanent for the specified connection object. |
createStatement( )
|
Returns a statement object on the specified connection object. |
execute( )
|
Returns a result set object using the specified prepared statement or statement object. |
executeQuery( )
|
Returns a result set object using the specified statement or prepared statement object and SQL SELECT statement. |
executeUpdate( )
|
Returns a result set object using the specified statement or prepared statement object and SQL INSERT, UPDATE or DELETE statement. |
findColumn( )
|
Returns the given column's index for the specified result set object. |
getAutoCommit( )
|
Returns whether the specified connection object is in auto-commit mode. |
getColumnCount( )
|
Returns the number of columns in the specified meta data result set object. |
getColumnName( )
|
Returns the name of column for the given column index in the specified meta data result set object. |
getColumnType( )
|
Returns the column's type for the given column index in the specified meta data result set object. |
getColumnTypeName( )
|
Returns the column's type name for the given column index in the specified meta data result set object. |
getConnection( )
|
Returns a connection object to the given database URL. |
getDate( )
|
Returns a date object for the named column in the given result set or callable statement object. |
getDouble( )
|
Returns a real value for the named column in the specified result set callable statement object. |
getInt( )
|
Returns a whole number for the named column in the specified result set callable statement object. |
getInteger( )
|
Returns a whole number for the named column in the specified result set callable statement object. |
getLong( )
|
Returns a whole number for the named column in the specified result set callable statement object. |
getMaxRows( )
|
Returns the maximum number of rows a result set object can contain for the specified statement object. |
getMetaData( )
|
Returns the meta data for the specified connection or result set object. |
getMoreResults( )
|
Moves the specified statement to the next result set object and returns whether there is a next result set object. |
getNextWarning( )
|
Returns the next sql warning object for the specified sql warning object. |
getPrecision( )
|
Returns the given column's number of decimal digits for the specified result set meta data object. |
getResultSet( )
|
Returns the current result set for the specified statement's object. |
getScale( )
|
Returns the given column's number of digits to the right of the decimal point for the specified result set meta data object. |
getSchemaName( )
|
Returns the given column's table schema for the specified result set meta data object. |
getString( )
|
Returns a string value for the named column in the given result set callable statement object. |
getTableName( )
|
Returns the given column's table name for the specified result set meta data object. |
getTransactionIsolation( )
|
Returns the current transaction isolation for the specified connection object. |
getUpdateCount( )
|
Returns the number of rows updated for the specified statement object. |
getWarnings( )
|
Returns the first sql warning object on the specified connection, result set or statement object. |
isCaseSensitive( )
|
Returned whether the given column is case sensitive for the specified result set meta data. |
isClosed( )
|
Returned whether the specified connect object is already closed. |
isDefinitelyWritable( )
|
Returned whether the given column is writable for the specified result set meta data. |
isNullable( )
|
Returned whether the given column can be set to NULL for the specified result set meta data. |
isReadOnly( )
|
Returned whether the specified connect object is read only or whether the given column is read-only for the specified result set meta data. |
isSearchable( )
|
Returned whether the given column can be used in a where clause for the specified result set meta data. |
isSigned( )
|
Returned whether the given column is a signed number for the specified result set meta data. |
isWritable( )
|
Returned whether the given column is writable for the specified result set meta data. |
loadDriver( )
|
Used to load the specified JDBC class driver. |
next( )
|
Moves the specified result set to the next row and returns whether there is a next row. |
prepareCall( )
|
Returns a callable statement object for the given SQL statement on the specified connection object. |
prepareStatement( )
|
Returns a prepared statement object for the given SQL statement on the specified connection object. |
registerOutParameter( )
|
Used to explicitly register the sql type of out parameters for the specified callable statement object. |
rollback( )
|
Drops all changes to the database on the given connection object. |
setAutoCommit( )
|
Sets whether auto-commit is enabled or disabled on the specified connection object. |
setCursorName( )
|
Defines an SQL cursor using the given name in the specified statement object. |
setDate( )
|
Sets the specified parameter to the given date object in the specified prepared statement object. |
setDouble( )
|
Sets the specified parameter to the given real number in the specified prepared statement object. |
setInt( )
|
Sets the specified parameter to the given whole number in the specified prepared statement object. |
setInteger( )
|
Sets the specified parameter to the given whole number in the specified prepared statement object. |
setLong( )
|
Sets the specified parameter to the given whole number in the specified prepared statement object. |
setMaxRows( )
|
Sets the maximum number of rows a result set object can contains for the specified statement object. |
setNull( )
|
Sets the specified parameter to NULL in the specified prepared statement object. |
setReadOnly( )
|
Sets whether the on the specified connection object is in read-only mode. |
setString( )
|
Sets the specified parameter to the given string value in the specified prepared statement object. |
setTransactionIsolation( )
|
Sets the transaction isolation to specified value on the given connection object. |
_TRANSACTION _NONE( )
|
Returns the value used to indicate that transactions are not supported for the specified connection object. |
_TRANSACTION _READ _COMMITTED( )
|
Returns the value used to indicate that dirty reads are prevented for the specified connection object. |
_TRANSACTION _READ _UNCOMMITTED( )
|
Returns the value used to indicate that reads can occur for the specified connection object. |
_TRANSACTION _REPEATABLE _READ( )
|
Returns the value used to indicate that dirty and non-repeatable reads are prevented on the specified connection object. |
_TRANSACTION _SERIALIZABLE( )
|
Returns the value used to indicate that dirty, non-repeatable and phantom reads are prevented on the specified connection object. |
wasNull( )
|
Returns whether the last value read was NULL for the specified result set or callable statement object. |