bit.io JDBC connection test

Query.java

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

public class Query {
  // Note that the 'username/db_name' must use a '.' instead of a '/' for JDBC
  private static final String url =
      "jdbc:postgresql://db.bit.io/dliden.2020_Census_Reapportionment";

  public static void main(String[] args) {
    Properties props = new Properties();
    props.setProperty("sslmode", "require");
    props.setProperty("user", "doss");
    props.setProperty("password", "<redacted>");

    Connection conn = null;
    try {
      conn = DriverManager.getConnection(url, props);
    } catch (SQLException e) {
      System.out.println(e.getMessage());
    }

    try {
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery(
        "SELECT COUNT(*) FROM \"dliden/2020_Census_Reapportionment\".\"Historical Apportionment\" WHERE \"Name\" ='Alabama';"
        );
        rs.next();
        System.out.println(rs.getInt(1));
        rs.close();
        st.close();
    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }

  }
}