java.sql.Connection
java.sql.Connection是数据库连接接口。
|
方法名 |
返回值类型 |
支持JDBC 4 |
|---|---|---|
|
abort(Executor executor) |
void |
Yes |
|
clearWarnings() |
void |
Yes |
|
close() |
void |
Yes |
|
commit() |
void |
Yes |
|
createArrayOf(String typeName, Object[] elements) |
Array |
Yes |
|
createBlob() |
Blob |
Yes |
|
createClob() |
Clob |
Yes |
|
createSQLXML() |
SQLXML |
Yes |
|
createStatement() |
Statement |
Yes |
|
createStatement(int resultSetType, int resultSetConcurrency) |
Statement |
Yes |
|
createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
Statement |
Yes |
|
getAutoCommit() |
Boolean |
Yes |
|
getCatalog() |
String |
Yes |
|
getClientInfo() |
Properties |
Yes |
|
getClientInfo(String name) |
String |
Yes |
|
getHoldability() |
int |
Yes |
|
getMetaData() |
DatabaseMetaData |
Yes |
|
getNetworkTimeout() |
int |
Yes |
|
getSchema() |
String |
Yes |
|
getTransactionIsolation() |
int |
Yes |
|
getTypeMap() |
Map<String,Class<?>> |
Yes |
|
getWarnings() |
SQLWarning |
Yes |
|
isClosed() |
Boolean |
Yes |
|
isReadOnly() |
Boolean |
Yes |
|
isValid(int timeout) |
boolean |
Yes |
|
nativeSQL(String sql) |
String |
Yes |
|
prepareCall(String sql) |
CallableStatement |
Yes |
|
prepareCall(String sql, int resultSetType, int resultSetConcurrency) |
CallableStatement |
Yes |
|
prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
CallableStatement |
Yes |
|
prepareStatement(String sql) |
PreparedStatement |
Yes |
|
prepareStatement(String sql, int autoGeneratedKeys) |
PreparedStatement |
Yes |
|
prepareStatement(String sql, int[] columnIndexes) |
PreparedStatement |
Yes |
|
prepareStatement(String sql, int resultSetType, int resultSetConcurrency) |
PreparedStatement |
Yes |
|
prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
PreparedStatement |
Yes |
|
prepareStatement(String sql, String[] columnNames) |
PreparedStatement |
Yes |
|
releaseSavepoint(Savepoint savepoint) |
void |
Yes |
|
rollback() |
void |
Yes |
|
rollback(Savepoint savepoint) |
void |
Yes |
|
setAutoCommit(boolean autoCommit) |
void |
Yes |
|
setClientInfo(Properties properties) |
void |
Yes |
|
setClientInfo(String name,String value) |
void |
Yes |
|
setHoldability(int holdability) |
void |
Yes |
|
setNetworkTimeout(Executor executor, int milliseconds) |
void |
Yes |
|
setReadOnly(boolean readOnly) |
void |
Yes |
|
setSavepoint() |
Savepoint |
Yes |
|
setSavepoint(String name) |
Savepoint |
Yes |
|
setSchema(String schema) |
void |
Yes |
|
setTransactionIsolation(int level) |
void |
Yes |
|
setTypeMap(Map<String,Class<?>> map) |
void |
Yes |
接口内部默认使用自动提交模式,若通过setAutoCommit(false)关闭自动提交,将会导致后面执行的语句都受到显式事务包裹,数据库中不支持事务中执行的语句不能在此模式下执行。