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(
)
|
Retruns 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. |
registerOutParamter(
)
|
Used to explicitly register the sql type of out paramters 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. |