java.sql
public interface Connection
Modifier and Type | Field and Description |
---|---|
static int |
TRANSACTION_NONE
This transaction isolation level indicates that transactions are not
supported.
|
static int |
TRANSACTION_READ_COMMITTED
This transaction isolation level indicates that only committed data from
other transactions will be read.
|
static int |
TRANSACTION_READ_UNCOMMITTED
This transaction isolation level indicates that one transaction can
read modifications by other transactions before the other transactions
have committed their changes.
|
static int |
TRANSACTION_REPEATABLE_READ
This transaction isolation level indicates that only committed data from
other transactions will be read.
|
static int |
TRANSACTION_SERIALIZABLE
This transaction isolation level indicates that only committed data from
other transactions will be read.
|
Modifier and Type | Method and Description |
---|---|
void |
clearWarnings()
This method clears all warnings that have occurred on this connection.
|
void |
close()
This method immediately closes this database connection.
|
void |
commit()
This method commits any SQL statements executed on this connection since
the last commit or rollback.
|
Statement |
createStatement()
This method creates a new SQL statement.
|
Statement |
createStatement(int resultSetType,
int resultSetConcurrency)
This method creates a new SQL statement with the specified type and
concurrency.
|
Statement |
createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
This method creates a new SQL statement with the specified type,
concurrency and holdability, instead of using the defaults.
|
boolean |
getAutoCommit()
This method tests whether or not auto commit mode is currently enabled.
|
String |
getCatalog()
This method returns the name of the catalog in use by this connection,
if any.
|
int |
getHoldability()
Gets the default holdability of
ResultSet S that are created
from Statement S using this Connection . |
DatabaseMetaData |
getMetaData()
This method returns the meta data for this database connection.
|
int |
getTransactionIsolation()
This method returns the current transaction isolation mode.
|
Map<String,Class<?>> |
getTypeMap()
This method returns the mapping of SQL types to Java classes
currently in use by this connection.
|
SQLWarning |
getWarnings()
This method returns the first warning that occurred on this connection,
if any.
|
boolean |
isClosed()
This method tests whether or not this connection has been closed.
|
boolean |
isReadOnly()
This method tests whether or not this connection is in read only mode.
|
String |
nativeSQL(String sql)
This method converts the specified generic SQL statement into the
native grammer of the database this object is connected to.
|
CallableStatement |
prepareCall(String sql)
This method creates a new
CallableStatement for the
specified SQL string. |
CallableStatement |
prepareCall(String sql,
int resultSetType,
int resultSetConcurrency)
This method creates a new
CallableStatement for the
specified SQL string. |
CallableStatement |
prepareCall(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
This method creates a new
CallableStatement for the
specified SQL string. |
PreparedStatement |
prepareStatement(String sql)
This method creates a new
PreparedStatement for the specified
SQL string. |
PreparedStatement |
prepareStatement(String sql,
int autoGeneratedKeys) |
PreparedStatement |
prepareStatement(String sql,
int[] columnIndexes) |
PreparedStatement |
prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
This method creates a new
PreparedStatement for the specified
SQL string. |
PreparedStatement |
prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
This method creates a new
PreparedStatement for the specified
SQL string. |
PreparedStatement |
prepareStatement(String sql,
String[] columnNames) |
void |
releaseSavepoint(Savepoint savepoint)
Removes the specified savepoint from this
Connection . |
void |
rollback()
This method rolls back any SQL statements executed on this connection
since the last commit or rollback.
|
void |
rollback(Savepoint savepoint)
Undoes all changes made after the specified savepoint was set.
|
void |
setAutoCommit(boolean autoCommit)
This method turns auto commit mode on or off.
|
void |
setCatalog(String catalog)
This method sets the name of the catalog in use by this connection.
|
void |
setHoldability(int holdability)
Sets the default holdability of
ResultSet S that are created
from Statement S using this Connection . |
void |
setReadOnly(boolean readOnly)
This method turns read only mode on or off.
|
Savepoint |
setSavepoint()
Creates a new unnamed savepoint for this
Connection |
Savepoint |
setSavepoint(String name)
Creates a new savepoint with the specifiend name for this
Connection . |
void |
setTransactionIsolation(int level)
This method sets the current transaction isolation mode.
|
void |
setTypeMap(Map<String,Class<?>> map)
This method sets the mapping table for SQL types to Java classes.
|
static final int TRANSACTION_NONE
static final int TRANSACTION_READ_UNCOMMITTED
static final int TRANSACTION_READ_COMMITTED
static final int TRANSACTION_REPEATABLE_READ
static final int TRANSACTION_SERIALIZABLE
Statement createStatement() throws SQLException
Statement
object.SQLException
- If an error occurs.Statement
PreparedStatement prepareStatement(String sql) throws SQLException
PreparedStatement
for the specified
SQL string. This method is designed for use with parameterized
statements. The default result set type and concurrency will be used.sql
- The SQL statement to use in creating this
PreparedStatement
.PreparedStatement
.SQLException
- If an error occurs.PreparedStatement
CallableStatement prepareCall(String sql) throws SQLException
CallableStatement
for the
specified SQL string. Thie method is designed to be used with
stored procedures. The default result set type and concurrency
will be used.sql
- The SQL statement to use in creating this
CallableStatement
.CallableStatement
.SQLException
- If an error occurs.CallableStatement
String nativeSQL(String sql) throws SQLException
sql
- The JDBC generic SQL statement.SQLException
- If an error occurs.void setAutoCommit(boolean autoCommit) throws SQLException
autoCommit
- true
to enable auto commit mode,
false
to disable it.SQLException
- If an error occurs.commit()
,
rollback()
boolean getAutoCommit() throws SQLException
true
if auto commit mode is enabled,
false
otherwise.SQLException
- If an error occurs.commit()
,
rollback()
void commit() throws SQLException
SQLException
- If an error occurs.void rollback() throws SQLException
SQLException
- If an error occurs.void close() throws SQLException
SQLException
- If an error occurs.boolean isClosed() throws SQLException
true
if the connection is closed, false
otherwise.SQLException
- If an error occurs.DatabaseMetaData getMetaData() throws SQLException
SQLException
- If an error occurs.DatabaseMetaData
void setReadOnly(boolean readOnly) throws SQLException
readOnly
- true
if this connection is read only,
false
otherwise.SQLException
- If an error occurs.boolean isReadOnly() throws SQLException
true
if the connection is read only false
otherwise.SQLException
- If an error occurs.void setCatalog(String catalog) throws SQLException
catalog
- The name of the catalog to use for this connection.SQLException
- If an error occurs.String getCatalog() throws SQLException
null
if none
exists or catalogs are not supported by this database.SQLException
- If an error occurs.void setTransactionIsolation(int level) throws SQLException
level
- The transaction isolation level.SQLException
- If an error occurs.int getTransactionIsolation() throws SQLException
SQLException
- If an error occurs.SQLWarning getWarnings() throws SQLException
SQLWarning
that occurred, or
null
if there have been no warnings.SQLException
- If an error occurs.void clearWarnings() throws SQLException
SQLException
- If an error occurs.Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException
ResultSet
class.resultSetType
- The type of result set to use for this statement.resultSetConcurrency
- The type of concurrency to be used in
the result set for this statement.Statement
object.SQLException
- If an error occurs.Statement
,
ResultSet
PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
PreparedStatement
for the specified
SQL string. This method is designed for use with parameterized
statements. The specified result set type and concurrency will be used.
Valid values for these parameters are specified in the
ResultSet
class.sql
- The SQL statement to use in creating this
PreparedStatement
.resultSetType
- The type of result set to use for this statement.resultSetConcurrency
- The type of concurrency to be used in
the result set for this statement.PreparedStatement
.SQLException
- If an error occurs.PreparedStatement
,
ResultSet
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
CallableStatement
for the
specified SQL string. Thie method is designed to be used with
stored procedures. The specified result set type and concurrency
will be used. Valid values for these parameters are specified in the
ResultSet
class.sql
- The SQL statement to use in creating this
PreparedStatement
.resultSetType
- The type of result set to use for this statement.resultSetConcurrency
- The type of concurrency to be used in
the result set for this statement.CallableStatement
.SQLException
- If an error occurs.CallableStatement
,
ResultSet
Map<String,Class<?>> getTypeMap() throws SQLException
SQLException
- If an error occurs.void setTypeMap(Map<String,Class<?>> map) throws SQLException
map
- The new SQL mapping table.SQLException
- If an error occurs.void setHoldability(int holdability) throws SQLException
ResultSet
S that are created
from Statement
S using this Connection
.holdability
- The default holdability value to set, this must be one
of ResultSet.HOLD_CURSORS_OVER_COMMIT
or
ResultSet.CLOSE_CURSORS_AT_COMMIT
.SQLException
- If an error occurs.ResultSet
int getHoldability() throws SQLException
ResultSet
S that are created
from Statement
S using this Connection
.ResultSet.HOLD_CURSORS_OVER_COMMIT
or
ResultSet.CLOSE_CURSORS_AT_COMMIT
.SQLException
- If an error occurs.ResultSet
Savepoint setSavepoint() throws SQLException
Connection
Savepoint
object representing the savepoint.SQLException
- If an error occurs.Savepoint setSavepoint(String name) throws SQLException
Connection
.name
- The name of the savepoint.Savepoint
object representing the savepoint.SQLException
- If an error occurs.void rollback(Savepoint savepoint) throws SQLException
savepoint
- The safepoint to roll back to.SQLException
- If an error occurs.void releaseSavepoint(Savepoint savepoint) throws SQLException
Connection
.
Refering to a savepoint after it was removed is an error and will throw an
SQLException.savepoint
- The savepoint to release.SQLException
- If an error occurs.Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
ResultSet
class.resultSetType
- The type of result set to use for this statement.resultSetConcurrency
- The type of concurrency to be used in
the result set for this statement.resultSetHoldability
- The type of holdability to be usd in the
result set for this statement.Statement
SQLException
- If an error occurs.ResultSet
PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
PreparedStatement
for the specified
SQL string. This method is designed for use with parameterized
statements. The specified result set type, concurrency and holdability
will be used. Valid values for these parameters are specified in the
ResultSet
class.sql
- The SQL statement to use in creating this
PreparedStatement
.resultSetType
- The type of result set to use for this statement.resultSetConcurrency
- The type of concurrency to be used in
the result set for this statement.resultSetHoldability
- The type of holdability to be usd in the
result set for this statement.PreparedStatement
.SQLException
- If an error occurs.PreparedStatement
,
ResultSet
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
CallableStatement
for the
specified SQL string. Thie method is designed to be used with
stored procedures. The specified result set type, concurrency and
holdability will be used. Valid values for these parameters are specified
in the ResultSet
class.sql
- The SQL statement to use in creating this
PreparedStatement
.resultSetType
- The type of result set to use for this statement.resultSetConcurrency
- The type of concurrency to be used in
the result set for this statement.resultSetHoldability
- The type of holdability to be used in the
result set for this statement.CallableStatement
.SQLException
- If an error occurs.CallableStatement
,
ResultSet
PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException
SQLException
PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException
SQLException
PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException
SQLException