import java.sql.*;

public class connector {

    public static void main(String[] args) throws SQLException{
        DriverManager.registerDriver(new org.postgresql.Driver());
        Connection con = DriverManager.getConnection(
                "jdbc:postgresql://psql.hci.cs.kuleuven.be:5432/gegevensbanken",
                "r0254193",
                "naq05cig"
                );

        Statement stat = con.createStatement();
        stat.executeUpdate("SET search_path TO r0254193");

        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM Department");

        while (rs.next()) {
                String name = rs.getString("Dname");
                int number = rs.getInt ("Dnumber");
                System.out.println(name + "(" + number + ")");
            }
        rs.close();

        PreparedStatement prstmt = con.prepareStatement(
                "SELECT * FROM Department WHERE Dname=? and Dnumber=?"
        );
        prstmt.setString(1, "Research");
        prstmt.setInt(2, 5);
        rs = prstmt.executeQuery();

        while (rs.next()) {
            String name = rs.getString("Dname");
            int number = rs.getInt ("Dnumber");
            System.out.println(name + "(" + number + ")");
        }
        rs.close();

        rs = stmt.executeQuery("SELECT Dname, Dnumber FROM Department");
        ResultSetMetaData meta = rs.getMetaData();
        int numberOfColumns = meta.getColumnCount();
        for (int i=1; i <= numberOfColumns; i++) {
         System.out.println(meta.getColumnLabel(i));
         int type = meta.getColumnType(i);
         String name = meta.getColumnTypeName(i);
         System.out.println(" of jdbc type " + type + " which the dbms calls " + name);
        }
        rs.close();

    }
}