JDBC connection pool test connection

SampleProgram.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SampleProgram {
    public static void main(String[] args) throws SQLException {
        DataSourceConfig ds = configureConnection();
        String statement = "SELECT id FROM test_tbl";
        try (Connection con = ds.getConnection()) {
            try (PreparedStatement stmt = con.prepareStatement(statement)) {
                ResultSet rs = stmt.executeQuery();
                while (rs.next()) {
                    int id = rs.getInt("id");
                    System.out.println("Id is : " + id);
                }
                rs.close();
            }
        }
    }

    private static DataSourceConfig configureConnection() {
        DataSourceConfig ds = new DataSourceConfig();
        ds.setHostName("localhost");
        ds.setPortNumber("2222");
        ds.setUserName("test");
        ds.setPassword("test");
        ds.setDbName("testDB");
        ds.setupPool();
        return ds;
    }
}