لطفا منتظر باشید ...
Connection Methods
The connection methods require a valid connection, returned from the getConnection() method.
clearWarnings
connection.clearWarnings()
Clears all warnings for the connection, returning a void.
close
connection.close()
Closes the database connection and frees all connection resources, returning a void.
commit
connection.commit()
Commits open transactions.
createStatement
connection.createStatement([int resultSetType, int resultSetConcurrency])
Returns a Statement object, which is a mechanism for passing queries to the database, and receives results back, through its connection object. With the optional arguments, the generated ResultSet objects will have the specified type and concurrency.
getAutoCommit
connection.getAutoCommit()
Returns true if AutoCommit mode is set for the connection and false if it is not.
getMetaData
connection.getMetaData()
Returns a database metadata object containing metadata about the database with which the connection has been made.
getTransactionIsolation
connection.getTransactionIsolation()
Returns an integer containing the transaction isolation level for the connection. The transaction isolation levels can be one of the following: TRANSACTION_READ_ UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE, or TRANSACTION_NONE.
getTypeMap
connection.getTypeMap
Returns a Map object associated with the connection.
isClosed
connection.isClosed()
Returns true if the connection has been closed and false if it's still open.
isReadOnly
connection.isReadOnly()
Returns true if the connection is read only and false if not.
nativeSQL
connection.nativeSQL(String sql)
Returns a string with the supplied string converted to the system's native SQL.
prepareStatement
connection.prepareStatement(String sql)
Prepares the statement to be sent to the database, which means you can make use of placeholders (or parameters). Use the setInt() and setString() methods to set the values of the parameters.
rollback
connection.rollback()
Undoes all changes in the current transaction.
setAutoCommit
connection.setAutoCommit(boolean mode)
Sets the connection's AutoCommit mode (true if set, false if not).
setReadOnly
connection.setReadOnly(boolean mode)
Passing the method true sets the connection to read-only mode.
setTransactionIsolation
connection.setTransactionIsolation(int level)
The level can be one of the following: connection.TRANSACTION_READ_UNCOMMITTED, connection.TRANSACTION_READ_COMMITTED, connection.TRANSACTION_REPEATABLE_READ, or connection.TRANSACTION_SERIALIZABLE.
setTypeMap
connection.setTypeMap(Map map)
Sets the type Map object for the connection.
