How to connect to a database?

To establish a connection to a database in Java, JDBC API is used. The main steps are as follows:

1. Loading the driver: Ensure the database driver JAR file is available in the application's classpath. Load the driver class.
2. Obtaining a Connection object: Use the DriverManager.getConnection() method to get the connection. This method takes the database URL string, username, and password.
3. Closing the connection: Always close the connection after use, using the close() method of the Connection object. It's best to do this in a finally block or use try-with-resources.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DatabaseConnection {

    private static final String URL = "jdbc:postgresql://localhost:5432/mydatabase"; // Example URL for PostgreSQL
    private static final String USER = "myuser";
    private static final String PASSWORD = "mypassword";

    public static void main(String[] args) {
        Connection connection = null; // Initialize connection as null

        try {
            // Step 1: Load the driver (for older JDBC versions, explicit loading may be required)
            // Class.forName("org.postgresql.Driver"); // Example for PostgreSQL

            // Step 2: Get the Connection object
            connection = DriverManager.getConnection(URL, USER, PASSWORD);

            if (connection != null) {
                System.out.println("Successful connection to the database!");
                // Operations with the database can be performed here
            } else {
                System.out.println("Failed to establish a connection to the database.");
            }

        } catch (SQLException e) {
            e.printStackTrace(); // Handle SQL errors
        } finally {
            // Step 3: Close the connection in the finally block
            if (connection != null) {
                try {
                    connection.close();
                    System.out.println("Database connection closed.");
                } catch (SQLException e) {
                    e.printStackTrace(); // Handle errors during closing
                }
            }
        }
    }
}

Modern approach with try-with-resources:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DatabaseConnectionWithTryResources {

    private static final String URL = "jdbc:postgresql://localhost:5432/mydatabase";
    private static final String USER = "myuser";
    private static final String PASSWORD = "mypassword";

    public static void main(String[] args) {
        // Use try-with-resources for automatic resource management
        try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD)) {

            if (connection != null) {
                System.out.println("Successful connection to the database!");
                // Operations with the database can be performed here
            } else {
                System.out.println("Failed to establish a connection to the database.");
            }

        } catch (SQLException e) {
            e.printStackTrace(); // Handle SQL errors (and errors during closing)
        }
    }
}

Comparison of approaches:

Feature	finally approach	try-with-resources approach
Resource closing	Explicit in finally block	Automatic
Code readability	Less readable	More readable
Exception handling	Explicit handling during close	Automatic (exceptions from try block exclude resource closing exceptions)
Recommended	For legacy code or specific cases	For most new cases

It's important to remember to add the JDBC driver JAR file to your project (via Maven, Gradle, etc.) and correctly specify the URL, username, and password for your specific database.