java.sql.Connection
java.sql.Connection是数据库连接接口，本节将介绍对此接口的支持情况。
该接口中的方法都不是线程安全的。
返回值类型 |
方法名 |
|---|---|
void |
close() |
boolean |
isReadOnly() |
boolean |
isClosed() |
boolean |
isValid(int) |
DatabaseMetaData |
getMetaData() |
void |
clearWarnings() |
void |
commit() |
Blob |
createBlob() |
Clob |
createClob() |
boolean |
getAutoCommit() |
String |
getCatalog() |
Properties |
getClientInfo() |
String |
getClientInfo(String) |
int |
getTransactionIsolation() |
Map |
getTypeMap() |
CallableStatement |
prepareCall(String) |
PreparedStatement |
prepareStatement(String, int) |
PreparedStatement |
prepareStatement(String) |
void |
rollback() |
void |
setAutoCommit(boolean) |
void |
setCatalog(String) |
void |
setClientInfo(Properties) |
void |
setClientInfo(String, String) |
void |
setSchema(String) |
Statement |
createStatement() |
void |
setReadOnly(boolean) |
int |
getHoldability() |
CallableStatement |
prepareCall(String, int, int) |
CallableStatement |
prepareCall(String, int, int, int) |
PreparedStatement |
prepareStatement(String, int, int) |
PreparedStatement |
prepareStatement(String, int, int, int) |
void |
setHoldability(int) |
void |
setTransactionIsolation(int) |
Statement |
createStatement(int, int) |
Statement |
createStatement(int, int, int) |
- 接口内部默认使用自动提交模式，若通过setAutoCommit(false)关闭自动提交，将会导致后面执行的语句都受到显式事务（明确指定事务的开始）包裹，此时需要手动调用commit()方法提交事务。
- 不支持设置savepoints。
