#java.sql.Connection
Connection接口用于建立JDBC客户端到数据库的连接,通过 DriverManager.getConnection(url, user, password) 方法获取。
YashanDB JDBC驱动对connection接口已支持功能(单机部署):
| 返回类型 | 方法 | 备注 |
|---|---|---|
| Statement | createStatement() | |
| Clob | createClob() | |
| Blob | createBlob() | |
| Statement | createStatement(int resultSetType, int resultSetConcurrency) | |
| PreparedStatement | prepareStatement(String sql) | |
| PreparedStatement | prepareStatement(String sql, int resultSetType,int resultSetConcurrency) | |
| PreparedStatement | prepareStatement(String sql, int autoGeneratedKeys) | |
| PreparedStatement | prepareStatement(String sql, int columnIndexes[]) | |
| PreparedStatement | prepareStatement(String sql, String columnNames[]) | |
| CallableStatement | prepareCall(String sql) | |
| String | nativeSQL(String sql) | |
| void | setAutoCommit(boolean autoCommit) | |
| boolean | getAutoCommit() | |
| void | commit() | |
| void | rollback() | |
| void | close() | |
| boolean | isClosed() | |
| DatabaseMetaData | getMetaData() | |
| boolean | isReadOnly() | |
| void | setTransactionIsolation(int level) | 支持以下三个值: Connection.TRANSACTION_READ_COMMITTED = 2 Connection.TRANSACTION_SERIALIZABLE = 8 YasConnection.TRANSACTION_READ_CURRENT_COMMITTED = 3. |
| int | getTransactionIsolation() | |
| java.util.Map<String,Class<?>> | getTypeMap() | |
| void | setTypeMap(java.util.Map<String,Class<?>> map) | |
| int | getHoldability() | |
| Savepoint | setSavepoint() | |
| Savepoint | setSavepoint(String name) | |
| void | releaseSavepoint(Savepoint savepoint) | |
| void | rollback(Savepoint savepoint) | |
| boolean | isValid(int timeout) | |
| void | setSchema(String schema) | |
| String | getSchema() | |
| void | abort(Executor executor) | |
| void | setNetworkTimeout(Executor executor, int milliseconds) | |
| int | getNetworkTimeout() | |
| CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency) | |
| CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency,int resultSetHoldability) |
YashanDB JDBC驱动对connection接口已支持功能(分布式部署):
| 返回类型 | 方法 | 备注 |
|---|---|---|
| Statement | createStatement() | |
| PreparedStatement | prepareStatement(String sql) | |
| String | nativeSQL(String sql) | |
| void | setAutoCommit(boolean autoCommit) | |
| boolean | getAutoCommit() | |
| void | commit() | |
| void | rollback() | |
| void | close() | |
| boolean | isClosed() | |
| DatabaseMetaData | getMetaData() | |
| boolean | isReadOnly() | |
| java.util.Map<String,Class<?>> | getTypeMap() | |
| void | setTypeMap(java.util.Map<String,Class<?>> map) | |
| int | getHoldability() | |
| boolean | isValid(int timeout) | |
| void | setSchema(String schema) | |
| String | getSchema() | |
| void | abort(Executor executor) | |
| void | setNetworkTimeout(Executor executor, int milliseconds) | |
| int | getNetworkTimeout() | |
| void | setTransactionIsolation(int level) | 只支持一个取值:Connection.TRANSACTION_READ_COMMITTED = 2。 |
| int | getTransactionIsolation() | |
| void | releaseSavepoint(Savepoint savepoint) | |
| Savepoint | setSavepoint() | |
| Savepoint | setSavepoint(String name) |
未支持功能(单机部署):
| 返回类型 | 方法 |
|---|---|
| void | setReadOnly(boolean readOnly) |
| SQLWarning | getWarnings() |
| void | clearWarnings() |
| Statement | createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
| PreparedStatement | prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
| void | setHoldability(int holdability) |
| NClob | createNClob() |
| SQLXML | createSQLXML() |
| void | setClientInfo(String name, String value) |
| void | setClientInfo(Properties properties) |
| String | getClientInfo(String name) |
| Properties | getClientInfo() |
| Array | createArrayOf(String typeName, Object[] elements) |
| Struct | createStruct(String typeName, Object[] attributes) |
| void | setCatalog(String catalog) |
| String | getCatalog() |
未支持功能(分布式部署):
| 返回类型 | 方法 |
|---|---|
| Statement | createStatement(int resultSetType, int resultSetConcurrency) |
| CallableStatement | prepareCall(String sql) |
| CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency) |
| CallableStatement | prepareCall(String sql, int resultSetType, int resultSetConcurrency,int resultSetHoldability) |
| PreparedStatement | prepareStatement(String sql, int resultSetType,int resultSetConcurrency) |
| void | setReadOnly(boolean readOnly) |
| SQLWarning | getWarnings() |
| void | clearWarnings() |
| void | rollback(Savepoint savepoint) |
| Statement | createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
| PreparedStatement | prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) |
| PreparedStatement | prepareStatement(String sql, int autoGeneratedKeys) |
| PreparedStatement | prepareStatement(String sql, int columnIndexes[]) |
| PreparedStatement | prepareStatement(String sql, String columnNames[]) |
| void | setHoldability(int holdability) |
| Clob | createClob() |
| Blob | createBlob() |
| NClob | createNClob() |
| SQLXML | createSQLXML() |
| void | setClientInfo(String name, String value) |
| void | setClientInfo(Properties properties) |
| String | getClientInfo(String name) |
| Properties | getClientInfo() |
| Array | createArrayOf(String typeName, Object[] elements) |
| Struct | createStruct(String typeName, Object[] attributes) |
| void | setCatalog(String catalog) |
| String | getCatalog() |
YashanDB JDBC驱动 YasConnection扩展接口功能:
| 返回类型 | 方法 | 说明 |
|---|---|---|
| void | setClientPrepare(boolean clientPrepare) | 表示对于绑定参数执行场景,是否开启直接执行;默认不开启,JDBC客户端会先向服务端发送prepare命令然后发送绑定参数执行;若开启,则会将prepare sql和绑定参数一起发给服务端,减少网络交互。 示例: Connection conn = getConnection("sales", "sales"); ((YasConnection)conn).setClientPrepare(true); |
| boolean | getClientPrepare() | 是否开启直接执行。 |
| int | getDefaultFetchSize() | |
| void | setDefaultFetchSize(int fetchSize) |