Package org.strassburger.lifestealz.util.storage.connectionPool

Class MySQLConnectionPool

java.lang.Object

org.strassburger.lifestealz.util.storage.connectionPool.MySQLConnectionPool

All Implemented Interfaces:

ConnectionPool

public class MySQLConnectionPool
extends Object
implements ConnectionPool

A MySQL connection pool that manages connections to a MySQL database.

Constructor Summary

Constructors

Constructor	Description
MySQLConnectionPool(String host, String port, String database, String username, String password)	Constructs a MySQL connection pool with the specified host, port, database, username, and password.

Method Summary

Modifier and Type	Method	Description
Connection	getConnection()	Returns a connection to the MySQL database from the connection pool.
void	releaseConnection(Connection connection)	Releases a connection back to the MySQL connection pool.
void	shutdown()	Shuts down the MySQL connection pool and releases all resources.

Methods inherited from class java.lang.Object

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

Constructor Details

MySQLConnectionPool

public MySQLConnectionPool(String host,
 String port,
 String database,
 String username,
 String password)

Constructs a MySQL connection pool with the specified host, port, database, username, and password.

Parameters:

host - the host of the MySQL database

port - the port of the MySQL database

database - the name of the MySQL database

username - the username to connect to the MySQL database

password - the password to connect to the MySQL database

Method Details

getConnection

public Connection getConnection()
                         throws SQLException

Returns a connection to the MySQL database from the connection pool.

Specified by:

getConnection in interface ConnectionPool

Returns:

a connection to the MySQL database

Throws:

SQLException - if an error occurs while getting a connection

releaseConnection

public void releaseConnection(Connection connection)
                       throws SQLException

Releases a connection back to the MySQL connection pool.

Specified by:

releaseConnection in interface ConnectionPool

Parameters:

connection - the connection to release

Throws:

SQLException - if an error occurs while releasing the connection

shutdown

public void shutdown()

Shuts down the MySQL connection pool and releases all resources.

Specified by:

shutdown in interface ConnectionPool