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