Condividi tramite


SQLServerConnection Methods

The following tables list the methods that are exposed by the SQLServerConnection class.

Methods

Name Description

clearWarnings

Clears all warnings that are reported for this SQLServerConnection object.

close

Releases this SQLServerConnection object's database and JDBC resources immediately instead of waiting for them to be automatically released.

commit

Makes all changes made since the previous commit or rollback permanent, and releases any database locks currently held by this SQLServerConnection object.

createBlob

Creates a java.sql.Blob object without any data.

createClob

Creates a java.sql.Clob object without any data.

createNClob

Creates a java.sql.NClob object without any data.

createStatement

Creates a SQLServerStatement object for sending SQL statements to the database.

createSQLXML

Creates a java.sql.SQLXML object without any data.

getAutoCommit

Retrieves the current auto-commit mode for this SQLServerConnection object.

getCatalog

Retrieves this SQLServerConnection object's current catalog name.

getClientInfo

Retrieves information regarding the client information properties supported by the JDBC driver.

getHoldability

Retrieves the current holdability of SQLServerResultSet objects that are created by using this SQLServerConnection object.

getMetaData

Retrieves a SQLServerDatabaseMetaData object that contains metadata about the database to which this SQLServerConnection object represents a connection.

getTransactionIsolation

Retrieves the current transaction isolation level for this SQLServerConnection object.

getTypeMap

Retrieves the Map object that is associated with this SQLServerConnection object.

getWarnings

Retrieves the first warning that is reported by calls on this SQLServerConnection object.

isClosed

Indicates whether this SQLServerConnection object has been closed.

isReadOnly

Indicates whether this SQLServerConnection object is in read-only mode.

isValid

Indicates whether this SQLServerConnection object has not been closed and is still valid.

nativeSQL

Converts the given SQL statement into the native SQL grammar of the database server.

prepareCall

Creates a SQLServerCallableStatement object for calling database stored procedures.

prepareStatement

Creates a SQLServerPreparedStatement object for sending parameterized SQL statements to the database.

releaseSavepoint

Removes the given SQLServerSavepoint object from the current transaction.

rollback

Undoes all changes made in the current transaction and releases any database locks currently held by this SQLServerConnection object.

setAutoCommit

Sets the auto-commit mode for this SQLServerConnection object to the given state.

setCatalog

Sets the specified catalog name to select a subspace of this SQLServerConnection object's database in which to work.

setClientInfo

Sets the value of the client information properties.

setHoldability

Changes the holdability of SQLServerResultSet objects that are created by using this SQLServerSavepoint object to the given holdability.

setReadOnly

Puts this SQLServerConnection object in read-only mode as a hint to the JDBC driver to enable database optimizations.

setSavepoint

Creates an unnamed savepoint in the current transaction and returns the new SQLServerSavepoint object that represents it.

setTransactionIsolation

Attempts to change the transaction isolation level for this SQLServerConnection object to the one given.

setTypeMap

Installs the specified TypeMap object as the type map for this SQLServerConnection object.

Inherited Methods

Class inherited from: Methods

java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait

java.sql.Wrapper

isWrapperFor, unwrap

Vedere anche

Riferimento

SQLServerConnection Class

Concetti

SQLServerConnection Members