public List<Monster> zoekAlleMonsters()
    {
        List<Monster> monsters = new ArrayList<>();

        try (Connection conn = DriverManager.getConnection(JDBC_URL)) {
            PreparedStatement queryAlleMonsters = conn.prepareStatement("SELECT * FROM MONSTER");
            try (ResultSet rs = queryAlleMonsters.executeQuery()) {
                while (rs.next()) {
                   int idmonster = rs.getInt("IDMONSTER");
                    int kracht = rs.getInt("KRACHT");
                    int verdediging = rs.getInt("VERDEDIGING");
                    int snelheid = rs.getInt("SNELHEID");
                    int alertheid = rs.getInt("ALERTHEID");
                    String naam = rs.getString("NAAM");
                    int idschat = rs.getInt("IDSCHAT");
                    monsters.add(new Monster (idmonster, kracht, verdediging , snelheid , alertheid, naam, idschat));
                }
            }
        } catch (SQLException ex) {
            for (Throwable t : ex) {
                t.printStackTrace();
            }
        }

        return monsters;
    }