|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.codestudio.util.PoolManager | +--com.codestudio.util.SQLManager
Fields inherited from class com.codestudio.util.PoolManager |
defaultpool, pools |
Method Summary | |
void |
checkCredentials(java.lang.String dbname,
java.lang.String user,
java.lang.String passwd)
|
static void |
closeResources(java.sql.Statement statement,
java.sql.ResultSet resultSet)
Static method that closes the statement and result sets in one place; this is here as a convenience to shorten the finally block in statements. |
static void |
closeResultSet(java.sql.ResultSet rs)
This method closes the given resultset. |
static void |
closeStatement(java.sql.Statement statement)
Closes the given statement. |
void |
collectResources(java.sql.Statement s,
java.sql.ResultSet r)
|
JDBCPool |
createPool(PoolMetaData metad)
|
java.util.Enumeration |
getAllPoolnames()
Overridden implementation ensures the config is loaded. |
java.lang.String |
getConfigFile()
|
static SQLManager |
getInstance()
This method retrieves the singleton SQLManager instance created when the class was first loaded. |
static SQLManager |
getInstance(java.lang.String confFile)
If a configuration file other than the default is specified, then the singleton instance will be recreated using the new file. |
ObjectPool |
getPool(java.lang.String name)
Overridden implementation ensures the config is loaded. |
ObjectPool |
getPoolByJNDIName(java.lang.String name)
|
java.sql.Connection |
requestConnection()
Get a connection from the first (default) database connection pool. |
java.sql.Connection |
requestConnection(java.lang.String dbname)
Get a connection from a particular database pool. |
void |
returnConnection(java.sql.Connection con)
Return a connection to the default pool. |
void |
returnConnection(java.lang.String dbname,
java.sql.Connection con)
Return a connection to a particular database pool. |
void |
setConfigFile(java.lang.String filename)
|
Methods inherited from class com.codestudio.util.PoolManager |
addPool, destroyPools, removePool, requestObject, requestObject, returnObject, returnObject |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
public static SQLManager getInstance()
public static SQLManager getInstance(java.lang.String confFile)
public JDBCPool createPool(PoolMetaData metad)
public void setConfigFile(java.lang.String filename)
public java.lang.String getConfigFile()
public ObjectPool getPool(java.lang.String name)
getPool
in class PoolManager
public ObjectPool getPoolByJNDIName(java.lang.String name)
public java.util.Enumeration getAllPoolnames()
getAllPoolnames
in class PoolManager
public void checkCredentials(java.lang.String dbname, java.lang.String user, java.lang.String passwd) throws java.sql.SQLException
public java.sql.Connection requestConnection() throws java.sql.SQLException
public void returnConnection(java.sql.Connection con)
public java.sql.Connection requestConnection(java.lang.String dbname) throws java.sql.SQLException
public void returnConnection(java.lang.String dbname, java.sql.Connection con)
public static void closeResources(java.sql.Statement statement, java.sql.ResultSet resultSet)
statement
- the statement to be closedresultSet
- the resultSet to be closedpublic void collectResources(java.sql.Statement s, java.sql.ResultSet r)
public static void closeStatement(java.sql.Statement statement)
statement
- the statement to be closed. May be null.public static void closeResultSet(java.sql.ResultSet rs)
rs
- the ResultSet to be closed. May be null.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |