Postgre SQL Connection Testing with Java

PostgreConnectionTest.java

/*
 * This Java source file was to test the database connection.
 */

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

public class Library {
	public static void main(String args[]) {
		String url = "jdbc:postgresql://localhost:5432/testdb";
		String user = "postgres";
		String password = "123*";
		try {
			Class.forName("org.postgresql.Driver");

			Connection con = DriverManager.getConnection(url, user, password);
			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery("SELECT VERSION()");

			if (rs.next()) {
				System.out.println(rs.getString(1));
			}

		} catch (SQLException | ClassNotFoundException ex) {
			System.out.println("Exception: " + ex.getMessage());
		}
	}
}

Connect to the Postgre SQL Database and test connection