Simple JDBC Java examples

DatabaseConnectionDemo.java

/*
This example shows how to connect to PostgreSQL database server using the `DriverManager` class.
It is recommended to use `DataSource` class instead because of connection pooling.

compile: javac DatabaseConnectionDemo.java
execute: java -cp .;lib\postgresql-X.X.XXXX.jar DatabaseConnectionDemo
*/

//package io.uetoyo.gists;

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

class DatabaseConnectionDemo {

    public static void main(String[] args) {
        
        Connection connection = null;
        String url = "jdbc:postgresql://SERVER_NAME/DATABASE_NAME";
        
        try {
            connection = DriverManager.getConnection(url, "USER", "PASSWORD");
            System.out.println("Success");
        } catch (SQLException ex) {
            System.out.println("Error");
        } finally {
            if (connection != null) {
                try {
                    connection.close();
                } catch (SQLException ex) {
                    // Handle or ignore the exception.
                }
            }
        }
    }
}