import java.io.*;
import java.sql.*;
public class Studie1DB {
  public static void main(String[] args) throws SQLException {
    Connection   db;            // The connection to the database
    Statement    st;            // Our statement to run queries with
    
    String url = "jdbc:postgresql://ellemose.dina.kvl.dk/gp";
    String usr = "gp";
    String pwd = "e2000";
    
    try { 
      Class.forName("postgresql.Driver");
    } catch (ClassNotFoundException e) { 
      System.out.println("Cannot find the Postgresql driver"); 
    }
    
    // Connect to database
    db = DriverManager.getConnection(url, usr, pwd); 

    st = db.createStatement();

    // Read from database
    String query = "SELECT efternavn, fornavn, student.studienummer, " +
      "karakter FROM student,eksamen " +
      "WHERE student.studienummer = eksamen.studienummer " +
      "ORDER BY karakter";
    boolean resultset = st.execute(query);
    if (resultset) {		// Results were produced by a SELECT statement
      ResultSet rs = st.getResultSet();
      while (rs.next()) {
	String enavn = rs.getString("efternavn");
	String fnavn = rs.getString("fornavn");
	String stdnr = rs.getString("studienummer");
	String karnr = rs.getString("karakter");
	System.out.println(fnavn + " " + enavn + " (" + stdnr + ", " + karnr + ")");
      }
    }
    st.close();
    db.close();
  }
}