repicea.io.javasql

Class DatabaseConnectionManager

java.lang.Object

repicea.io.javasql.DatabaseConnectionManager

public class DatabaseConnectionManager
extends java.lang.Object

The DatabaseConnectionManager ensures that only one connection is made to a particular database. It handles the closing of the connection as well.

Constructor Summary

Constructors

Constructor and Description
DatabaseConnectionManager()

Method Summary

Modifier and Type	Method and Description
static java.sql.Connection	getUserConnection(java.lang.Object user) This method retrieves the connection associated with a particular user.
static void	registerConnectionUser(java.lang.Object user, java.lang.String dataBaseUrl) This method first checks if the connection exists through its url.
static void	removeUser(java.lang.Object user) This method removes the user from the ConnectionUsers Map and eventually closes the connection if there is no user left.

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseConnectionManager

public DatabaseConnectionManager()

Method Detail

registerConnectionUser

public static void registerConnectionUser(java.lang.Object user,
                                          java.lang.String dataBaseUrl)
                                   throws java.io.IOException

This method first checks if the connection exists through its url. If it does not, it creates the connection. Secondly, the method register the object as a user of the connection.

Parameters:

user - the object instance that uses the database connection

dataBaseUrl - the database url

Throws:

java.io.IOException - if there is a connection problem

getUserConnection

public static java.sql.Connection getUserConnection(java.lang.Object user)

This method retrieves the connection associated with a particular user.

Parameters:

user - the Object instance that uses this connection

Returns:

a Connection instance

removeUser

public static void removeUser(java.lang.Object user)
                       throws java.sql.SQLException

This method removes the user from the ConnectionUsers Map and eventually closes the connection if there is no user left.

Parameters:

user - the Object instance that uses this connection

Throws:

java.sql.SQLException