import java.io.*;
import java.util.*;

import java.sql.*;


public class DBTest {


  public DBTest() {

    Connection cx = openDBConnection(FILL_THIS_IN);
    Statement st = openStatement(cx);

    try {
      String query = "";
      boolean brc = st.execute(query);
      ResultSet rs = st.getResultSet();
      while (rs.next()) {
        // each row
      }
    } catch (Exception e) {
      e.printStackTrace();
    }

    closeStatement(st);
    closeDBConnection(cx);
  }


  private Connection openDBConnection(String password) {

    Connection cx = null;

    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      DriverManager.registerDriver(new com.mysql.jdbc.Driver());

      String url = "jdbc:mysql://led.cs.columbia.edu:3306/w31013?user=w31013&password=" + password;
      cx = DriverManager.getConnection(url);
    } catch(Exception e) {
      System.err.println("Unable to open DB Connection: " + e.getMessage());
    }

    return cx;
  }


  private void closeDBConnection(Connection cx) {

    try {
      cx.close();
    } catch(Exception e) {
      System.err.println("Unable to close DB Connection: " + e.getMessage());
    }
  }


  private Statement openStatement(Connection cx) {

    Statement st = null;

    try {
      st = cx.createStatement();
    } catch(Exception e) {
      System.err.println("Unable to create Statement: " + e.getMessage());
    }

    return st;
  }


  private void closeStatement(Statement st) {

    try {
      st.close();
    } catch(Exception e) {
      System.err.println("Unable to close Statement: " + e.getMessage());
    }
  }


  public static void main(String args[]) {

    DBTest dbTest = new DBTest();
  }
}