// Udtræk fra database på Postgres-server

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

public class StudierDB {
  public static void main(String[] args) throws SQLException {
    Connection   db;            // The connection to the database
    Statement    st;            // A 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 * FROM student ORDER BY fornavn";
    st.execute(query);
    ResultSet rs = st.getResultSet();
    while (rs.next()) {
      String enavn = rs.getString("efternavn");
      String fnavn = rs.getString("fornavn");
      String stdnr = rs.getString("studienummer");
      System.out.println(fnavn + " " + enavn + " (" + stdnr + ")");
    }
    st.close();
    db.close();
  }
}