package com.citizenme.shared.db.util;

import java.sql.*;
import java.util.Properties;

public class ConnectionTestJava {
    private static String user = "";
    private static String password = "";

    private static final String connectionString
            = "***.cluster-***.eu-west-1.rds.amazonaws.com:3306/db";

    public static void main(String[] args) {
        Properties properties = new Properties();
        properties.setProperty("user", user);
        properties.setProperty("password", password);
        DriverManager.setLoginTimeout(10);
        try (Connection conn = DriverManager.getConnection(connectionString, properties)) {
            Statement statement = conn.createStatement();
            try (ResultSet resultSet = statement.executeQuery("select * from exchange limit 1")) {
                resultSet.next();
                System.out.println(resultSet.getString(1));
            }

        } catch (SQLException exception) {
            exception.printStackTrace();
        }
    }
}