import java.sql.*;

class ViseKonekcija {

    static
    {
        try
        {
            Class.forName("com.ibm.db2.jcc.DB2Driver");
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }

    public static void main (String argv[])
    {
        String naziv=null;

        try
        {
            String url1 = "jdbc:db2://localhost:50001/mstud";
            String url2 = "jdbc:db2://localhost:50001/vstud";
            Connection con1 = DriverManager.getConnection(url1,"student","abcdef");
            Connection con2 = DriverManager.getConnection(url2,"student","abcdef");

            Statement stmt1 = con1.createStatement();
            ResultSet rs1= stmt1.executeQuery("SELECT naziv " +
                            " FROM predmet " );

            PreparedStatement stmt2;
            stmt2 = con2.prepareStatement("SELECT ime, prezime, ocena " +
                               "FROM dosije d join ispit i " +
                                " on d.indeks=i.indeks " +
                                 "join predmet p " +
                                " on i.id_predmeta=p.id_predmeta " +
                            "WHERE ocena>5 and status_prijave='o' " +
                                   " and p.naziv=? ");

            while ( rs1.next() )
            {
                naziv=rs1.getString(1);
                stmt2.setString (1, naziv);
                ResultSet rs2 = stmt2.executeQuery();

                System.out.println("Predmet: " + naziv + "\n");
                while(rs2.next())
                {
                    System.out.println("Ime: " + rs2.getString(1) + " Prezime: " + rs2.getString(2) + " ocena: " +rs2.getInt(3));
                }

                rs2.close();
                System.out.println("\n\n\n\n\n");

            }

            rs1.close();
            stmt1.close();
            stmt2.close();
            con1.close();
            con1.close();

        }
        catch (SQLException e)
        {
            System.out.println("SQLCODE: " +e.getErrorCode() + "SQLSTATE: " + e.getSQLState() + "PORUKA: " + e.getMessage());
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}