java.sql.Connection
java.sql.Connection is an API for connecting to a database.
Method Name |
Return Type |
Support 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 |
- The autocommit mode is used by default within the API. If you disable it by running setAutoCommit(false), all the statements executed later will be packaged in explicit transactions, and you cannot execute statements that cannot be executed within transactions.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot