Package storage

Class DatabaseConnection

java.lang.Object

storage.DatabaseConnection

public class DatabaseConnection
extends Object

Singleton class for managing database connections to MySQL Ensures only one instance exists and provides connection pooling

Author:

TAMIL MUGHILAN

Field Summary

Fields

Modifier and Type	Field	Description
private static DatabaseConnection	instance
private final String	PASSWORD
private final String	url
private final String	USER

Constructor Summary

Constructors

Modifier	Constructor	Description
private	DatabaseConnection()	Private constructor to prevent direct instantiation.

Method Summary

Modifier and Type	Method	Description
Connection	getConnection()	Creates and returns a new database connection.
static DatabaseConnection	getInstance()	Gets the singleton instance of DatabaseConnection.

Methods inherited from class java.lang.Object

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

Field Details

instance

private static DatabaseConnection instance

url

private final String url

See Also:

• Constant Field Values

USER

private final String USER

See Also:

• Constant Field Values

PASSWORD

private final String PASSWORD

See Also:

• Constant Field Values

Constructor Details

DatabaseConnection

private DatabaseConnection()
                    throws SQLException

Private constructor to prevent direct instantiation. Loads MySQL JDBC driver when instance is created.

Throws:

SQLException - if JDBC driver is not found

Method Details

getInstance

public static DatabaseConnection getInstance()
                                      throws SQLException

Gets the singleton instance of DatabaseConnection. Uses double-checked locking for thread safety.

Returns:

the singleton DatabaseConnection instance

Throws:

SQLException - if instance creation fails

getConnection

public Connection getConnection()
                         throws SQLException

Creates and returns a new database connection.

Returns:

a new Connection object to the database

Throws:

SQLException - if connection fails