org.cagrid.tools.database
Class Database

java.lang.Object
  org.cagrid.tools.database.Database

public class Database
extends java.lang.Object

Author:

Stephen Langella , Scott Oster , Shannon Hastings , David Ervin

Constructor Summary

Database(DatabaseConfiguration conf, java.lang.String database)

Database(java.lang.String host, int port, java.lang.String user, java.lang.String password, java.lang.String database)

Method Summary

void	createDatabaseIfNeeded()
void	destroyDatabase()
boolean	exists(java.lang.String table, java.lang.String field, long value)
boolean	exists(java.lang.String table, java.lang.String field, java.lang.String value)
java.sql.Connection	getConnection()
java.lang.String	getDatabaseName()
long	getLastAutoId(java.sql.Connection connection)
int	getRootUsedConnectionCount()
int	getUsedConnectionCount()
long	insertGetId(java.lang.String sql)
void	releaseConnection(java.sql.Connection c)
boolean	tableExists(java.lang.String tableName)
void	update(java.lang.String sql)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Database

public Database(DatabaseConfiguration conf,
                java.lang.String database)
         throws DatabaseException

Throws:

DatabaseException

Database

public Database(java.lang.String host,
                int port,
                java.lang.String user,
                java.lang.String password,
                java.lang.String database)
         throws DatabaseException

Throws:

DatabaseException

Method Detail

createDatabaseIfNeeded

public void createDatabaseIfNeeded()
                            throws DatabaseException

Throws:

DatabaseException

destroyDatabase

public void destroyDatabase()
                     throws DatabaseException

Throws:

DatabaseException

tableExists

public boolean tableExists(java.lang.String tableName)
                    throws DatabaseException

Throws:

DatabaseException

update

public void update(java.lang.String sql)
            throws DatabaseException

Throws:

DatabaseException

getLastAutoId

public long getLastAutoId(java.sql.Connection connection)
                   throws DatabaseException

Throws:

DatabaseException

exists

public boolean exists(java.lang.String table,
                      java.lang.String field,
                      java.lang.String value)
               throws DatabaseException

Throws:

DatabaseException

exists

public boolean exists(java.lang.String table,
                      java.lang.String field,
                      long value)
               throws DatabaseException

Throws:

DatabaseException

insertGetId

public long insertGetId(java.lang.String sql)
                 throws DatabaseException

Throws:

DatabaseException

releaseConnection

public void releaseConnection(java.sql.Connection c)

getConnection

public java.sql.Connection getConnection()
                                  throws DatabaseException

Throws:

DatabaseException

getUsedConnectionCount

public int getUsedConnectionCount()

getRootUsedConnectionCount

public int getRootUsedConnectionCount()

getDatabaseName

public java.lang.String getDatabaseName()