ConnectionManager (onecode-database 1.0.2 API)

java.lang.Object
- com.ds.common.database.ConnectionManager

```
public class ConnectionManager
extends Object
```
Title: 常用代码打包

Description: Central manager of database connections. All methods are static so that they can be easily accessed throughout the classes in the database package.

This class also provides a set of utility methods that abstract out operations that may not work on all databases such as setting the max number or rows that a query should return.

Copyright: Copyright (c) 2006

Company: www.justdos.net

版本:

1.0

作者:

wenzhang li

另请参阅:

ConnectionProvider

字段概要

字段
限定符和类型字段和说明

ProviderConfig providerConfig

字段
限定符和类型	字段和说明
`ProviderConfig`	`providerConfig`

构造器概要

构造器
限定符构造器和说明

protected ConnectionManager(ProviderConfig providerConfig)

protected ConnectionManager(String configKey)

构造器
限定符	构造器和说明
`protected`	`ConnectionManager(ProviderConfig providerConfig)`
`protected`	`ConnectionManager(String configKey)`

方法概要

所有方法实例方法具体方法
限定符和类型	方法和说明
`void`	`clearRecordedConnection()`
`void`	`closeTransactionConnection(Connection con, boolean abortTransaction)` Closes a Connection.
`PreparedStatement`	`createScrollablePreparedStatement(Connection con, String sql)` Creates a scroll insensitive PreparedStatement if the JDBC driver supports it, or a normal PreparedStatement otherwise.
`Statement`	`createScrollableStatement(Connection con)` Creates a scroll insensitive Statement if the JDBC driver supports it, or a normal Statement otherwise.
`void`	`destroy()` Proxy method for ConnectionProvider
`Connection`	`getConnection()` Returns a database connection from the currently active connection provider.
`ConnectionProvider`	`getConnectionProvider()` Returns the current connection provider.
`String`	`getLargeTextField(ResultSet rs, int columnIndex)` Retrives a large text column from a result set, automatically performing streaming if the JDBC driver requires it.
`List`	`getRecordedConnction()`
`Connection`	`getTransactionConnection()` Returns a Connection from the currently active connection provider that is ready to participate in transactions (auto commit is set to false).
`boolean`	`isBatchUpdatesSupported()`
`boolean`	`isFetchSizeSupported()`
`boolean`	`isMaxRowsSupported()`
`boolean`	`isPooled()` Proxy method for ConnectionProvider
`boolean`	`isProfilingEnabled()` Returns true if connection profiling is turned on.
`boolean`	`isRecordConnectionEnabled()`
`boolean`	`isScrollResultsSupported()`
`boolean`	`isStreamTextRequired()`
`boolean`	`isSubqueriesSupported()`
`boolean`	`isTransactionsSupported()`
`void`	`restart()` Proxy method for ConnectionProvider
`void`	`scrollResultSet(ResultSet rs, int rowNumber)` Scrolls forward in a result set to the specified row number.
`void`	`setConnectionProvider(ConnectionProvider provider)` Sets the connection provider.
`void`	`setFetchSize(ResultSet rs, int fetchSize)` Sets the number of rows that the JDBC driver should buffer at a time.
`void`	`setLargeTextField(PreparedStatement pstmt, int parameterIndex, String value)` Sets a large text column in a result set, automatically performing streaming if the JDBC driver requires it.
`void`	`setMaxRows(Statement stmt, int maxRows)` Sets the max number of rows that should be returned from executing a statement.
`void`	`setProfilingEnabled(boolean enable)` Turns connection profiling on or off.
`void`	`setRecordConnectionEnabled(boolean recordConnectionEnabled)`
`void`	`start()` Proxy method for ConnectionProvider

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 字段详细资料
  - providerConfig
```
public ProviderConfig providerConfig
```
- 构造器详细资料
  - ConnectionManager
```
protected ConnectionManager(String configKey)
```
  - ConnectionManager
```
protected ConnectionManager(ProviderConfig providerConfig)
```
- 方法详细资料
  - getConnection
```
public Connection getConnection()
                         throws SQLException
```
    Returns a database connection from the currently active connection provider. (auto commit is set to true).
    
    抛出:
    
    SQLException
  - getRecordedConnction
```
public List getRecordedConnction()
```
  - clearRecordedConnection
```
public void clearRecordedConnection()
```
  - getTransactionConnection
```
public Connection getTransactionConnection()
                                    throws SQLException
```
    Returns a Connection from the currently active connection provider that is ready to participate in transactions (auto commit is set to false).
    
    抛出:
    
    SQLException
  - closeTransactionConnection
```
public void closeTransactionConnection(Connection con,
                                       boolean abortTransaction)
```
    Closes a Connection. However, it first rolls back the transaction or commits it depending on the value of abortTransaction.
  - createScrollableStatement
```
public Statement createScrollableStatement(Connection con)
                                    throws SQLException
```
    Creates a scroll insensitive Statement if the JDBC driver supports it, or a normal Statement otherwise.
    
    参数:
    
    con - the database connection.
    
    返回:
    
    a Statement
    
    抛出:
    
    SQLException - if an error occurs.
  - createScrollablePreparedStatement
```
public PreparedStatement createScrollablePreparedStatement(Connection con,
                                                           String sql)
                                                    throws SQLException
```
    Creates a scroll insensitive PreparedStatement if the JDBC driver supports it, or a normal PreparedStatement otherwise.
    
    参数:
    
    con - the database connection.
    
    sql - the SQL to create the PreparedStatement with.
    
    返回:
    
    a PreparedStatement
    
    抛出:
    
    SQLException - if an error occurs.
  - scrollResultSet
```
public void scrollResultSet(ResultSet rs,
                            int rowNumber)
                     throws SQLException
```
    Scrolls forward in a result set to the specified row number. If the JDBC driver supports the feature, the cursor will be moved directly. Otherwise, we scroll through results one by one manually by calling rs.next().
    
    参数:
    
    rs - the ResultSet object to scroll.
    
    rowNumber - the row number to scroll forward to.
    
    抛出:
    
    SQLException - if an error occurs.
  - getConnectionProvider
```
public ConnectionProvider getConnectionProvider()
```
    Returns the current connection provider. The only case in which this method should be called is if more information about the current connection provider is needed. Database connections should always be obtained by calling the getConnection method of this class.
  - setConnectionProvider
```
public void setConnectionProvider(ConnectionProvider provider)
```
    Sets the connection provider. The old provider (if it exists) is shut down before the new one is started. A connection provider should not be started before being passed to the connection manager because the manager will call the start() method automatically.
    
    参数:
    
    provider - the ConnectionProvider that the manager should obtain connections from.
  - getLargeTextField
```
public String getLargeTextField(ResultSet rs,
                                int columnIndex)
                         throws SQLException
```
    Retrives a large text column from a result set, automatically performing streaming if the JDBC driver requires it. This is necessary because different JDBC drivers have different capabilities and methods for retrieving large text values.
    
    参数:
    
    rs - the ResultSet to retrieve the text field from.
    
    columnIndex - the column in the ResultSet of the text field.
    
    返回:
    
    the String value of the text field.
    
    抛出:
    
    SQLException
  - setLargeTextField
```
public void setLargeTextField(PreparedStatement pstmt,
                              int parameterIndex,
                              String value)
                       throws SQLException
```
    Sets a large text column in a result set, automatically performing streaming if the JDBC driver requires it. This is necessary because different JDBC drivers have different capabilities and methods for setting large text values.
    
    参数:
    
    pstmt - the PreparedStatement to set the text field in.
    
    parameterIndex - the index corresponding to the text field.
    
    value - the String to set.
    
    抛出:
    
    SQLException
  - setMaxRows
```
public void setMaxRows(Statement stmt,
                       int maxRows)
```
    Sets the max number of rows that should be returned from executing a statement. The operation is automatically bypassed if Jive knows that the the JDBC driver or database doesn't support it.
    
    参数:
    
    stmt - the Statement to set the max number of rows for.
    
    maxRows - the max number of rows to return.
  - setFetchSize
```
public void setFetchSize(ResultSet rs,
                         int fetchSize)
```
    Sets the number of rows that the JDBC driver should buffer at a time. The operation is automatically bypassed if Jive knows that the the JDBC driver or database doesn't support it.
    
    参数:
    
    rs - the ResultSet to set the fetch size for.
    
    fetchSize - the fetchSize.
  - isProfilingEnabled
```
public boolean isProfilingEnabled()
```
    Returns true if connection profiling is turned on. You can collect profiling statistics by using the static methods of the ProfiledConnection class.
    
    返回:
    
    true if connection profiling is enabled.
  - isTransactionsSupported
```
public boolean isTransactionsSupported()
```
  - isStreamTextRequired
```
public boolean isStreamTextRequired()
```
  - isMaxRowsSupported
```
public boolean isMaxRowsSupported()
```
  - isFetchSizeSupported
```
public boolean isFetchSizeSupported()
```
  - isSubqueriesSupported
```
public boolean isSubqueriesSupported()
```
  - isScrollResultsSupported
```
public boolean isScrollResultsSupported()
```
  - isBatchUpdatesSupported
```
public boolean isBatchUpdatesSupported()
```
  - isPooled
```
public boolean isPooled()
```
    Proxy method for ConnectionProvider
    
    返回:
    
    true if the Connection objects are pooled.
    
    另请参阅:
    
    ConnectionProvider
  - start
```
public void start()
```
    Proxy method for ConnectionProvider
    
    另请参阅:
    
    ConnectionProvider
  - restart
```
public void restart()
```
    Proxy method for ConnectionProvider
    
    另请参阅:
    
    ConnectionProvider
  - destroy
```
public void destroy()
```
    Proxy method for ConnectionProvider
    
    另请参阅:
    
    ConnectionProvider
  - isRecordConnectionEnabled
```
public boolean isRecordConnectionEnabled()
```
    返回:
    
    Returns the recordConnectionEnabled.
  - setRecordConnectionEnabled
```
public void setRecordConnectionEnabled(boolean recordConnectionEnabled)
```
    参数:
    
    recordConnectionEnabled - The recordConnectionEnabled to set.
  - setProfilingEnabled
```
public void setProfilingEnabled(boolean enable)
```
    Turns connection profiling on or off. You can collect profiling statistics by using the static methods of the ProfiledConnection class.
    
    参数:
    
    enable - true to enable profiling; false to disable.

类 ConnectionManager

字段概要

构造器概要

方法概要

从类继承的方法 java.lang.Object

字段详细资料

providerConfig

构造器详细资料

ConnectionManager

ConnectionManager

方法详细资料

getConnection

getRecordedConnction

clearRecordedConnection

getTransactionConnection

closeTransactionConnection

createScrollableStatement

createScrollablePreparedStatement

scrollResultSet

getConnectionProvider

setConnectionProvider

getLargeTextField

setLargeTextField

setMaxRows

setFetchSize

isProfilingEnabled

isTransactionsSupported

isStreamTextRequired

isMaxRowsSupported

isFetchSizeSupported

isSubqueriesSupported

isScrollResultsSupported

isBatchUpdatesSupported

isPooled

start

restart

destroy

isRecordConnectionEnabled

setRecordConnectionEnabled

setProfilingEnabled