#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)
pdf-btn 下载文档
copy-btn 复制链接