Connection接口用于建立JDBC客户端到数据库的连接，通过DriverManager.getConnection(url, user, password) 方法获取。

YashanDB JDBC驱动对connection接口已支持功能（单机部署/共享集群部署）：

返回类型	方法	备注
Statement	createStatement()	-
Clob	createClob()	-
Blob	createBlob()	-
Statement	createStatement(int resultSetType, int resultSetConcurrency)	-
Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)	-
PreparedStatement	prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)	-
PreparedStatement	prepareStatement(String sql)	-
PreparedStatement	prepareStatement(String sql, int resultSetType,int resultSetConcurrency)	-
PreparedStatement	prepareStatement(String sql, int autoGeneratedKeys)	-
PreparedStatement	PreparedStatement prepareStatement(String sql, int columnIndexes[])	-
PreparedStatement	PreparedStatement prepareStatement(String sql, String columnNames[])	-
CallableStatement	prepareCall(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	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)	-
SQLXML	createSQLXML()	-
void	releaseSavepoint(Savepoint savepoint)	-

YashanDB JDBC驱动对connection接口已支持功能（分布式部署）：

返回类型	方法	备注
Statement	createStatement()	-
Statement	createStatement(int resultSetType, int resultSetConcurrency)	-
Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)	-
PreparedStatement	prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)	-
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)	-
PreparedStatement	prepareStatement(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()	-
Clob	createClob()	-
Blob	createBlob()	-
Savepoint	setSavepoint()	-
Savepoint	setSavepoint(String name)	-
void	rollback(Savepoint savepoint)	-
SQLXML	createSQLXML()	-
void	setHoldability(int holdability)	-
void	setTransactionIsolation(int level)	只支持一个取值：Connection.TRANSACTION_READ_COMMITTED = 2
int	getTransactionIsolation()	-
void	releaseSavepoint(Savepoint savepoint)	-

未支持功能（单机部署/共享集群部署）：

返回类型	方法
String	nativeSQL(String sql)
void	setReadOnly(boolean readOnly)
SQLWarning	getWarnings()
void	clearWarnings()
void	setHoldability(int holdability)
NClob	createNClob()
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()

未支持功能（分布式部署）：

返回类型	方法
void	setReadOnly(boolean readOnly)
String	nativeSQL(String sql)
SQLWarning	getWarnings()
void	clearWarnings()
PreparedStatement	prepareStatement(String sql, int autoGeneratedKeys)
PreparedStatement	prepareStatement(String sql, int columnIndexes[])
PreparedStatement	prepareStatement(String sql, String columnNames[])
NClob	createNClob()
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命令然后发送绑定参数执行；若开启，则会将prepareStatement的SQL语句和要绑定的参数一次性发给服务端，减少交互次数。 示例： Connection conn = getConnection("sales", "sales"); ((YasConnection)conn).setClientPrepare(true);
boolean	getClientPrepare();	是否开启直接执行。
int	getDefaultFetchSize()	-
void	setDefaultFetchSize(int fetchSize)	-