Are you an LLM? You can read better optimized documentation at /zh/docs/7.0.0/ograc/developer_guide/jdbc/java_sql_connection.md for this page in Markdown format
java.sql.Connection
java.sql.Connection是数据库连接接口。
表 1 对java.sql.Connection接口的支持情况
方法名 | 返回值类型 | 支持JDBC 4 |
|---|
close() | void | Yes |
commit() | void | 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 |
getNetworkTimeout() | int | Yes |
getTransactionIsolation() | int | Yes |
isClosed() | Boolean | Yes |
isReadOnly() | Boolean | Yes |
isValid(int timeout) | boolean | 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 |
rollback() | void | Yes |
setAutoCommit(boolean autoCommit) | void | Yes |
setReadOnly(boolean readOnly) | void | Yes |
须知
接口内部默认使用自动提交模式,若通过setAutoCommit(false)关闭自动提交,将会导致后面执行的语句都受到显式事务包裹,数据库中不支持事务中执行的语句不能在此模式下执行。