import java.sql.*;
import java.io.Console;

public class JDBCTest {
  public static void main(String[] args) {
    // Connect to the database
    // You can put a database name before the ? in the connection URL.
    Connection conn = null;
    String url = "jdbc:mysql://sql.cs.oberlin.edu/?";
    String parms = "user=alice&password=tiger&useSSL=false";
    
    try {
      conn = DriverManager.getConnection(url+parms);
		    
      Statement stmt = conn.createStatement();
      
      String s = "select * from studentdb.student";
      
      ResultSet r = stmt.executeQuery(s);
      
      System.out.println("Student data retrieved.");

      System.out.println("sid  sname  majorid  gradyear");
      while(r.next()){
	  String sid = r.getString("sid");
	  String sname = r.getString("sname");
	  String major = r.getString("majorid");
	  int gradyear = r.getInt("gradyear");
	  System.out.printf(" %s\t%s\t%s\t%d\n",sid,sname,major,gradyear);
      }
    }
    catch(SQLException e) {
	e.printStackTrace();
    }
    catch(Exception ee){
	ee.printStackTrace();
    }
    finally {
	try {
	    if (conn != null)
		conn.close();
	}
	catch (SQLException e) {
	    e.printStackTrace();
	}
    }
  }
}